From 942538fcf5adebc8021940d37a1890862b165ffb Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Wed, 03 Mar 2010 05:58:52 -0500
Subject: [PATCH] Improved sys_datalog cleanup: FS#1089 - Clean sys_datalog
---
server/cron_daily.php | 12 +++++++-----
1 files changed, 7 insertions(+), 5 deletions(-)
diff --git a/server/cron_daily.php b/server/cron_daily.php
index f1313ed..74adff9 100644
--- a/server/cron_daily.php
+++ b/server/cron_daily.php
@@ -225,17 +225,19 @@
/* Then delete server by server */
foreach($records as $server) {
- $sql = "DELETE FROM sys_datalog WHERE tstamp < " . $tstamp .
- " AND server_id != 0 " . // to be more secure!
- " AND server_id = " . intval($server['server_id']) .
- " AND datalog_id < " . intval($server['updated']);
+ $tmp_server_id = intval($server['server_id']);
+ if($tmp_server_id > 0) {
+ $sql = "DELETE FROM sys_datalog WHERE tstamp < " . $tstamp .
+ " AND server_id = " . intval($server['server_id']) .
+ " AND datalog_id < " . intval($server['updated']);
+ }
// echo $sql . "\n";
$app->dbmaster->query($sql);
}
}
#######################################################################################################
-// enforce traffic quota (only the "master-server")
+// enforce traffic quota (run only on the "master-server")
#######################################################################################################
if ($app->dbmaster == $app->db) {
--
Gitblit v1.9.1