Changeset 9967 for trunk/xmlrpc/BxDolXMLRPCFriends.php

Timestamp:

04/06/09 01:55:00 (3 years ago)

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/xmlrpc/BxDolXMLRPCFriends.php (modified) (6 diffs)

trunk/xmlrpc/BxDolXMLRPCFriends.php

@@ -14 +14 @@
             SELECT p.*
             FROM `Profiles` AS p
-            LEFT JOIN `FriendList` AS f1 ON (f1.`ID` = p.`ID` AND f1.`Profile` ='{$iIdProfile}' AND `f1`.`Check` = 1)
-            LEFT JOIN `FriendList` AS f2 ON (f2.`Profile` = p.`ID` AND f2.`ID` ='{$iIdProfile}' AND `f2`.`Check` = 1)
+            LEFT JOIN `sys_friend_list` AS f1 ON (f1.`ID` = p.`ID` AND f1.`Profile` ='{$iIdProfile}' AND `f1`.`Check` = 1)
+            LEFT JOIN `sys_friend_list` AS f2 ON (f2.`Profile` = p.`ID` AND f2.`ID` ='{$iIdProfile}' AND `f2`.`Check` = 1)
             WHERE 1
             AND (f1.`ID` IS NOT NULL OR f2.`ID` IS NOT NULL)
@@ -22 +22 @@
         $r = db_res($sFriendsSQL);
 
-        /*$r = db_res ("SELECT `Profiles`.* FROM `FriendList`
-            LEFT JOIN `Profiles` ON (`Profiles`.`ID` = `FriendList`.`Profile` AND `FriendList`.`ID` = '$iIdProfile' OR `Profiles`.`ID` = `FriendList`.`ID` AND `FriendList`.`Profile` = '$iIdProfile')
-            WHERE (`FriendList`.`Profile` = '$iIdProfile' OR `FriendList`.`ID` = '$iIdProfile') AND `FriendList`.`Check` = '1' 
+        /*$r = db_res ("SELECT `Profiles`.* FROM `sys_friend_list`
+            LEFT JOIN `Profiles` ON (`Profiles`.`ID` = `sys_friend_list`.`Profile` AND `sys_friend_list`.`ID` = '$iIdProfile' OR `Profiles`.`ID` = `sys_friend_list`.`ID` AND `sys_friend_list`.`Profile` = '$iIdProfile')
+            WHERE (`sys_friend_list`.`Profile` = '$iIdProfile' OR `sys_friend_list`.`ID` = '$iIdProfile') AND `sys_friend_list`.`Check` = '1' 
             ORDER BY `Profiles`.`Picture` DESC");*/
 
@@ -42 +42 @@
 
         $r = db_res ("
-            SELECT `Profiles`.* FROM `FriendList`
-            LEFT JOIN `Profiles` ON `Profiles`.`ID` = `FriendList`.`ID`
-            WHERE `FriendList`.`Profile` = $iId AND `Check` = 0
+            SELECT `Profiles`.* FROM `sys_friend_list`
+            LEFT JOIN `Profiles` ON `Profiles`.`ID` = `sys_friend_list`.`ID`
+            WHERE `sys_friend_list`.`Profile` = $iId AND `Check` = 0
             ORDER BY `Profiles`.`NickName` ASC");
 
@@ -64 +64 @@
         $aMembersList = array ($iIdProfile);
         $oCommunicator = &new BxTemplCommunicator('communicator_page', $aCommunicatorSettings);   
-        $oCommunicator->execFunction('_deleteRequest', 'FriendList', $aMembersList);
+        $oCommunicator->execFunction('_deleteRequest', 'sys_friend_list', $aMembersList);
 
         return new xmlrpcval ('ok');
@@ -79 +79 @@
         $aMembersList = array ($iIdProfile);
         $oCommunicator = &new BxTemplCommunicator('communicator_page', $aCommunicatorSettings);   
-        $oCommunicator->execFunction('_acceptFriendInvite', 'FriendList', $aMembersList);
+        $oCommunicator->execFunction('_acceptFriendInvite', 'sys_friend_list', $aMembersList);
 
         return new xmlrpcval ('ok');
@@ -94 +94 @@
         $aMembersList = array ($iIdProfile);
         $oCommunicator = &new BxTemplCommunicator('communicator_page', $aCommunicatorSettings);   
-        $oCommunicator->execFunction( '_deleteRequest', 'FriendList', $aMembersList, array(1, 1));
+        $oCommunicator->execFunction( '_deleteRequest', 'sys_friend_list', $aMembersList, array(1, 1));
 
         return new xmlrpcval ('ok');