From 6a3742bc7837817a786552c9c4f1339aac983c1e Mon Sep 17 00:00:00 2001
From: Marius Cramer <m.cramer@pixcept.de>
Date: Tue, 26 May 2015 02:42:07 -0400
Subject: [PATCH] - fixed monitor cron job not deleting old values from db

---
 server/lib/classes/monitor_tools.inc.php |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/server/lib/classes/monitor_tools.inc.php b/server/lib/classes/monitor_tools.inc.php
index 4e25d38..3432dc1 100644
--- a/server/lib/classes/monitor_tools.inc.php
+++ b/server/lib/classes/monitor_tools.inc.php
@@ -666,7 +666,7 @@
 
 		// $now = time();
 		// $old = $now - (4 * 60); // 4 minutes
-		$old = 'UNIX_TIMESTAMP() - 240';
+		$old = 240; //seconds
 
 		/*
 		 * ATTENTION if i do NOT pay attention of the server id, i delete all data (of the type)
@@ -680,7 +680,7 @@
 			'WHERE ' .
 			'  type = ?' .
 			'AND ' .
-			'  created < ? ' .
+			'  created < UNIX_TIMESTAMP() - ?' . 
 			'AND ' .
 			'  server_id = ?';
 		$app->dbmaster->query($sql, $type, $old, $serverId);

--
Gitblit v1.9.1