| | |
| | | */ |
| | | $html = ''; |
| | | |
| | | $servers = $app->dbmaster->queryAllRecords("SELECT server_id, server_name FROM server order by server_name"); |
| | | $servers = $app->db->queryAllRecords("SELECT server_id, server_name FROM server order by server_name"); |
| | | foreach ($servers as $server) |
| | | { |
| | | $html .= _getServerState($server['server_id'], $server['server_name'], false); |
| | |
| | | * get all monitoring-data from the server als process then |
| | | * (count them and set the server-state) |
| | | */ |
| | | $records = $app->dbmaster->queryAllRecords("SELECT DISTINCT type FROM monitor_data WHERE server_id = " . $serverId); |
| | | $records = $app->db->queryAllRecords("SELECT DISTINCT type FROM monitor_data WHERE server_id = " . $serverId); |
| | | foreach($records as $record){ |
| | | _processDbState($record['type'], $serverId, &$serverState, &$messages); |
| | | } |
| | |
| | | * state |
| | | */ |
| | | // get the State from the DB |
| | | $record = $app->dbmaster->queryOneRecord("SELECT state FROM monitor_data WHERE type = '" . $type . "' and server_id = " . $serverId . " order by created desc"); |
| | | $record = $app->db->queryOneRecord("SELECT state FROM monitor_data WHERE type = '" . $type . "' and server_id = " . $serverId . " order by created desc"); |
| | | // change the new state to the highest state |
| | | $serverState = _setState($serverState, $record['state']); |
| | | // count the states |
| | |
| | | break; |
| | | } |
| | | } |
| | | |
| | | if ($type == 'sys_log'){ |
| | | switch ($record['state']) { |
| | | case 'ok': |
| | | $messages['ok'][] = 'The System-Log is O.K. ' . |
| | | "<a href='#' onclick='loadContent(\"monitor/log_list.php\");'>[more...]</a>"; |
| | | break; |
| | | case 'warning': |
| | | $messages['warning'][] = 'There are some warnings in your System-Log ' . |
| | | "<a href='#' onclick='loadContent(\"monitor/log_list.php\");'>[more...]</a>"; |
| | | break; |
| | | case 'error': |
| | | $messages['error'][] = 'There are errors in your System-Log ' . |
| | | "<a href='#' onclick='loadContent(\"monitor/log_list.php\");'>[more...]</a>"; |
| | | break; |
| | | default: |
| | | $messages['unknown'][] = 'sys-log:??? ' . |
| | | "<a href='#' onclick='loadContent(\"monitor/log_list.php\");'>[more...]</a>"; |
| | | break; |
| | | } |
| | | } |
| | | |
| | | if ($type == 'log_clamav'){ |
| | | /* this type has no state */ |
| | | } |
| | | if ($type == 'log_freshclam'){ |
| | | |
| | | if ($type == 'log_freshclam'){ |
| | | switch ($record['state']) { |
| | | case 'ok': |
| | | $messages['ok'][] = 'Your Virus-protection is ok ' . |
| | |
| | | break; |
| | | } |
| | | } |
| | | |
| | | if ($type == 'log_ispconfig'){ |
| | | /* this type has no state */ |
| | | } |