Changeset 9985 for trunk/periodic

Timestamp:

04/06/09 23:30:15 (3 years ago)

Author:

Andrey Prikaznov

Message:

 

File:

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

trunk/periodic/cmd.php

@@ -52 +52 @@
     $iDbCleanAlert = getParam('dbCleanAlert');
 
-    // clear from `messages`
-    db_res("DELETE FROM `Messages` WHERE FIND_IN_SET('sender', `Trash`) AND FIND_IN_SET('recipient', `Trash`)");
+    // clear from `sys_messages`
+    db_res("DELETE FROM `sys_messages` WHERE FIND_IN_SET('sender', `Trash`) AND FIND_IN_SET('recipient', `Trash`)");
 
     // profile_delete
@@ -79 +79 @@
     if ( $db_clean_msg > 0 )
     {
-        $res = db_res("DELETE FROM `Messages` WHERE (TO_DAYS(NOW()) - TO_DAYS(`Date`)) > $db_clean_msg");
+        $res = db_res("DELETE FROM `sys_messages` WHERE (TO_DAYS(NOW()) - TO_DAYS(`Date`)) > $db_clean_msg");
         if ( $res )
             $db_clean_msg_num = mysql_affected_rows();
@@ -95 +95 @@
         // 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";
+        $sqlQuery = "DELETE FROM `sys_notifications` WHERE `actionDate` NOT BETWEEN $iNow AND $iThen";
         $rRes = db_res($sqlQuery);
         if ($rRes)