Changeset 8685 for trunk/periodic

Timestamp:

01/21/09 02:19:54 (3 years ago)

Author:

Alexander Ermashev

Message:

• rename the table's (ProfilesTrack?) fields from Member to ID, and Arrive to When

File:

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

trunk/periodic/cmd.php

@@ -58 +58 @@
     if ( $db_clean_profiles > 0)
     {
-        $res = db_res("SELECT ID FROM Profiles WHERE (TO_DAYS(NOW()) - TO_DAYS(DateLastLogin)) > $db_clean_profiles");
+        $res = db_res("SELECT `ID` FROM Profiles WHERE (TO_DAYS(NOW()) - TO_DAYS(`DateLastLogin`)) > $db_clean_profiles");
         if ( $res )
         {
@@ -72 +72 @@
     if ( $db_clean_vkiss > 0 )
     {
-        $res = db_res("DELETE FROM Greetings WHERE (TO_DAYS(NOW()) - TO_DAYS(Arrived)) > $db_clean_vkiss");
+        $res = db_res("DELETE FROM `Greetings` WHERE (TO_DAYS(NOW()) - TO_DAYS(`When`)) > $db_clean_vkiss");
         if ( $res )
             $db_clean_vkiss_num = mysql_affected_rows();
@@ -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 `Messages` WHERE (TO_DAYS(NOW()) - TO_DAYS(`Date`)) > $db_clean_msg");
         if ( $res )
             $db_clean_msg_num = mysql_affected_rows();
@@ -86 +86 @@
     if ( $db_clean_views > 0 )
     {
-        $res = db_res("DELETE FROM ProfilesTrack WHERE (TO_DAYS(NOW())-TO_DAYS(`Arrived`)) > $db_clean_views");
+        $res = db_res("DELETE FROM `ProfilesTrack` WHERE (TO_DAYS(NOW())-TO_DAYS(`When`)) > $db_clean_views");
         if ( $res )
             $db_clean_views_num = mysql_affected_rows();