Changeset 7387 for trunk/periodic

Timestamp:

10/31/08 11:35:27 (4 years ago)

Author:

nell

Message:

Changed alerts

File:

• trunk/periodic/cmd.php (modified) (3 diffs)

trunk/periodic/cmd.php

@@ -51 +51 @@
     $db_clean_msg = getParam("db_clean_msg");
     $db_clean_views = getParam("db_clean_views");
+    $iDbCleanAlert = getParam('dbCleanAlert');
 
     // profile_delete
@@ -87 +88 @@
             $db_clean_views_num = mysql_affected_rows();
     }
-
+    
+    if ($iDbCleanAlert > 0) {
+        $iNow = time();
+        // number of seconds from now to clean date
+        $iThen = time() - $iDbCleanAlert*24*60*60;
+        $sqlQuery = "DELETE FROM `alerts` WHERE `actionDate` NOT BETWEEN $iNow AND $iThen";
+        $rRes = db_res($sqlQuery);
+        if ($rRes)
+            $iDbCleanAlertNum = mysql_affected_rows();
+    }
     echo "\n- Database cleaning -\n";
 
@@ -94 +104 @@
     echo "Deleted messages: $db_clean_msg_num\n";
     echo "Deleted profile views: $db_clean_views_num\n";
+    echo "Deleted user alerts: $iDbCleanAlertNum\n";
 }