Changeset 8685

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

Location:

trunk

Files:

• inc/admin.inc.php (modified) (2 diffs)
• install/sql/v61.sql (modified) (2 diffs)
• periodic/cmd.php (modified) (4 diffs)
• profile.php (modified) (1 diff)

trunk/inc/admin.inc.php

@@ -23 +23 @@
 require_once( BX_DIRECTORY_PATH_INC . 'design.inc.php' );
 require_once( BX_DIRECTORY_PATH_INC . 'admin_design.inc.php' );
-// require_once( BX_DIRECTORY_PATH_MODULES . 'boonex/blogs/classes/BxBlogsModule.php');
-// require_once( BX_DIRECTORY_PATH_MODULES . 'boonex/ads/classes/BxAdsModule.php');
-// require_once( BX_DIRECTORY_PATH_CLASSES . 'BxDolEvents.php' );
-// require_once( BX_DIRECTORY_PATH_CLASSES . 'BxDolSharedMedia.php' );
 require_once( BX_DIRECTORY_PATH_CLASSES . 'BxDolEmailTemplates.php' );
 
@@ -1059 +1055 @@
     
     db_res( "DELETE FROM `BlockList` WHERE `ID` = '{$ID}' OR `Profile` = '{$ID}'" );
-    db_res( "DELETE FROM `ProfilesTrack` WHERE `Member` = '{$ID}' OR `Profile` = '{$ID}'" );
+    db_res( "DELETE FROM `ProfilesTrack` WHERE `ID` = '{$ID}' OR `Profile` = '{$ID}'" );
     db_res( "DELETE FROM `Messages` WHERE Recipient = {$ID} " );
     db_res( "DELETE FROM `aff_members` WHERE idProfile = {$ID}" );

trunk/install/sql/v61.sql

@@ -6359 +6359 @@
 INSERT INTO `PQStatistics` VALUES('mgc', 'SELECT COUNT(*) FROM `Greetings` WHERE `ID` = ''__member_id__'' AND New = ''1''');
 INSERT INTO `PQStatistics` VALUES('mbc', 'SELECT COUNT(*) FROM `BlockList` WHERE `ID` = ''__member_id__''');
-INSERT INTO `PQStatistics` VALUES('mvc', 'SELECT COUNT(*) FROM `ProfilesTrack` WHERE `Member` = ''__member_id__''');
+INSERT INTO `PQStatistics` VALUES('mvc', 'SELECT COUNT(*) FROM `ProfilesTrack` WHERE `ID` = ''__member_id__''');
 INSERT INTO `PQStatistics` VALUES('spo', 'SELECT COUNT(*) FROM `ProfilesPolls` WHERE `id_profile` = ''__member_id__'' AND `poll_status`=''active''');
 INSERT INTO `PQStatistics` VALUES('me', 'SELECT COUNT(*) FROM `SDatingEvents` WHERE `ResponsibleID` = ''__member_id__'' AND `Status`=''Active''');
@@ -6992 +6992 @@
 
 CREATE TABLE `ProfilesTrack` (
-  `Member` bigint(8) unsigned NOT NULL default '0',
+  `ID` bigint(8) unsigned NOT NULL default '0',
   `Profile` bigint(8) unsigned NOT NULL default '0',
-  `Arrived` date NOT NULL default '0000-00-00',
+  `When` date NOT NULL default '0000-00-00',
   `Hide` tinyint(4) NOT NULL default '0',
-  UNIQUE KEY `Member_2` (`Member`,`Profile`),
-  KEY `Member` (`Member`),
+  UNIQUE KEY `Member_2` (`ID`,`Profile`),
+  KEY `Member` (`ID`),
   KEY `Profile` (`Profile`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
 
 --

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();

trunk/profile.php

@@ -89 +89 @@
 if ( $track_profile_view && $memberID && !$oProfile -> owner )
 {
-    db_res( "DELETE FROM `ProfilesTrack` WHERE `Member` = {$memberID} AND `Profile` = $profileID", 0);
-    db_res( "INSERT INTO `ProfilesTrack` SET `Arrived` = NOW(), `Member` = {$memberID}, `Profile` = $profileID", 0);
+    db_res( "DELETE FROM `ProfilesTrack` WHERE `ID` = {$memberID} AND `Profile` = $profileID", 0);
+    db_res( "INSERT INTO `ProfilesTrack` SET `When` = NOW(), `ID` = {$memberID}, `Profile` = $profileID", 0);
 }