/** * Get all uptime/history records for a server * @param string $type * @param int $server_id * @param \DateTime $start_time Lowest DateTime of the graph * @param \DateTime $end_time Highest DateTime of the graph * @return array */ protected function getRecords($type, $server_id, $start_time, $end_time) { if (!in_array($type, array('history', 'uptime'))) { return array(); } $records = $this->db->execute('SELECT * FROM `' . PSM_DB_PREFIX . "servers_{$type}`\n\t\t\t\tWHERE `server_id` = :server_id AND `date` BETWEEN :start_time AND :end_time ORDER BY `date` ASC", array('server_id' => $server_id, 'start_time' => $start_time->format('Y-m-d H:i:s'), 'end_time' => $end_time->format('Y-m-d H:i:s'))); return $records; }
public function cleanup(\DateTime $retention_date, $server_id = null) { $sql_where_server = $server_id !== null ? ' `server_id` = ' . intval($server_id) . ' AND ' : ''; $this->db->execute("DELETE FROM `" . PSM_DB_PREFIX . "log` WHERE {$sql_where_server} `datetime` < :latest_date", array('latest_date' => $retention_date->format('Y-m-d 00:00:00')), false); return true; }
public function cleanup(\DateTime $retention_date, $server_id = null) { $sql_where_server = $this->createSQLWhereServer($server_id); $this->db->execute("DELETE FROM `" . PSM_DB_PREFIX . "servers_history` WHERE {$sql_where_server} `date` < :latest_date", array('latest_date' => $retention_date->format('Y-m-d 00:00:00')), false); return true; }