";
for ($i = 0; $i < $numRows; $i++)
{
$result = $sth->fetchrow_hash();
$nodename = $result["machine"];
$date1 = $result["date1"];
$date2 = explode(" ", $date1);
$priority = $result["priority"];
$message = $result["message"];
if ("$nodename"=="VBOX1") {
$message2 = explode(" ", $message);
$message = str_replace("$message2[0]","ping", "$message");
$nodename = $message2[0];
}
$FINDURL="$USERPREFIX/servers/?field=name&phrasetype=exact&contains=$nodename&sort=name&index=1";
if (preg_match("/host-b/", $nodename)) {
$nodeip=str_replace("host-b-", "", $nodename);
$nodeip=str_replace("-", ".", $nodeip);
$FINDURL="$USERPREFIX/servers/?field=ip&phrasetype=contains&contains=$nodeip&sort=name&index=1";
}
if (is_numeric(str_replace(".", "", $nodename))) {
$FINDURL="$USERPREFIX/servers/?field=ip&phrasetype=exact&contains=$nodename&sort=name&index=1"; }
PRINT "| $nodename |
$date2[1] | ";
$message = str_replace("ping failed","ping failed", "$message");
if ("$priority"=="err") { PRINT "";
PRINT "$message | ";
} else { PRINT "$message"; }
PRINT "";
}
PRINT "
";
} else
{
PRINT "Could not prepare query: ".$sth->errstr."