Changeset 9901 for trunk/xmlrpc

Timestamp:

04/02/09 00:03:21 (3 years ago)

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/xmlrpc/BxDolXMLRPCFriends.php (modified) (1 diff)

trunk/xmlrpc/BxDolXMLRPCFriends.php

@@ -11 +11 @@
         BxDolXMLRPCUtil::setLanguage ($sLang); 
 
-        $r = db_res ("SELECT `Profiles`.* FROM `FriendList`
+        $sFriendsSQL = "
+            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)
+            WHERE 1
+            AND (f1.`ID` IS NOT NULL OR f2.`ID` IS NOT NULL)
+            ORDER BY p.`Picture` DESC
+        ";
+        $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' 
-            ORDER BY `Profiles`.`Picture` DESC");
+            ORDER BY `Profiles`.`Picture` DESC");*/
 
         $aProfiles = array ();