| | |
| | | /* |
| | | * Get all monitoring-data from the server and process then |
| | | */ |
| | | $records = $app->db->queryAllRecords("SELECT DISTINCT type, data FROM monitor_data WHERE server_id = " . $serverId); |
| | | $records = $app->db->queryAllRecords("SELECT DISTINCT type, data FROM monitor_data WHERE server_id = ?", $serverId); |
| | | $osData = null; |
| | | $veInfo = null; |
| | | $ispcData = null; |
| | |
| | | * state |
| | | */ |
| | | // get the State from the DB |
| | | $record = $app->db->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 = ? and server_id = ? order by created desc", $type, $serverId); |
| | | |
| | | // change the new state to the highest state |
| | | /* |