| '.$row["org"].' '.$row["org_name"].' |
'.$row["alarm_count"].' |
'.get_date($row["last_alarm"]).' |
';
}
$result = mysqli_query($dbconn, "SELECT org_name, alarm_count, DATE_FORMAT(last_alarm, '%Y%m%d%H%i%s') AS last_alarm FROM organisation WHERE org = 'RD' AND alarm_count != 0 ORDER BY alarm_count DESC, last_alarm DESC, org ASC, org_name ASC") or die (mysql_error());
while($row = mysqli_fetch_array($result))
{
if( !isset($row["org"])) $row["org"]="";
$stats_rd .= '
| '.$row["org"].' '.$row["org_name"].' |
'.$row["alarm_count"].' |
'.get_date($row["last_alarm"]).' |
';
}
$result = mysqli_query($dbconn, "SELECT org_name, alarm_count, DATE_FORMAT(last_alarm, '%Y%m%d%H%i%s') AS last_alarm FROM organisation WHERE org = 'THW' AND alarm_count != 0 ORDER BY alarm_count DESC, last_alarm DESC, org ASC, org_name ASC") or die (mysql_error());
while($row = mysqli_fetch_array($result))
{
if( !isset($row["org"])) $row["org"]="";
$stats_thw .= '
| '.$row["org"].' '.$row["org_name"].' |
'.$row["alarm_count"].' |
'.get_date($row["last_alarm"]).' |
';
}
$result = mysqli_query($dbconn, "SELECT org_name, alarm_count, DATE_FORMAT(last_alarm, '%Y%m%d%H%i%s') AS last_alarm FROM organisation WHERE org = 'KAT' AND alarm_count != 0 ORDER BY alarm_count DESC, last_alarm DESC, org ASC, org_name ASC") or die (mysql_error());
while($row = mysqli_fetch_array($result))
{
$stats_kat .= '
| '.$row["org"].' '.$row["org_name"].' |
'.$row["alarm_count"].' |
'.get_date($row["last_alarm"]).' |
';
}
// Seiteninhalt ausgeben
eval ("\$page_middle .= \"".gettemplate($template_dir."body_stats")."\";");
/**************************/
// Ausgabe Rahmen
//
eval ("dooutput(\"".gettemplate($template_dir."rahmen")."\");");
/**************************/
// Datenbank schliessen
//
mysqli_close($dbconn);
?>