From 8081dfc524267e6e779303ad15f5224123c02add Mon Sep 17 00:00:00 2001 From: Marius Cramer <m.cramer@pixcept.de> Date: Tue, 26 May 2015 02:55:32 -0400 Subject: [PATCH] - fixed sql query from previous commit --- server/lib/classes/monitor_tools.inc.php | 8 +------- 1 files changed, 1 insertions(+), 7 deletions(-) diff --git a/server/lib/classes/monitor_tools.inc.php b/server/lib/classes/monitor_tools.inc.php index 3432dc1..ce3d4bb 100644 --- a/server/lib/classes/monitor_tools.inc.php +++ b/server/lib/classes/monitor_tools.inc.php @@ -676,13 +676,7 @@ * even though it is the NEWEST data of this server. To avoid this i HAVE to include * the server-id! */ - $sql = 'DELETE FROM monitor_data ' . - 'WHERE ' . - ' type = ?' . - 'AND ' . - ' created < UNIX_TIMESTAMP() - ?' . - 'AND ' . - ' server_id = ?'; + $sql = 'DELETE FROM `monitor_data` WHERE `type` = ? AND `created` < UNIX_TIMESTAMP() - ? AND `server_id` = ?'; $app->dbmaster->query($sql, $type, $old, $serverId); } -- Gitblit v1.9.1