Changeset 14650 for trunk/xmlrpc/BxDolXMLRPCFriends.php

Timestamp:

11/17/10 02:56:54 (19 months ago)

Author:

Leonid Sokushev

Message:

ticket #2284

File:

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

trunk/xmlrpc/BxDolXMLRPCFriends.php

@@ -12 +12 @@
 
         $sFriendsSQL = "
-            SELECT p.*
-            FROM `Profiles` AS p
-            INNER JOIN (SELECT IF( '{$iIdProfile}' = f.`ID` , f.`Profile` , f.`ID` ) AS `ID`
-            FROM `sys_friend_list` AS `f`
-            WHERE 1 AND (f.`Profile` = '{$iIdProfile}' OR f.`ID` = '{$iIdProfile}') AND `Check` = 1) AS `f` ON (`f`.`ID` = `p`.`ID`)
+            SELECT `p`.*, `f`.`ID`
+            FROM (
+                SELECT `ID` AS `ID` FROM `sys_friend_list` WHERE `Profile` = '{$iIdProfile}' AND `Check` =1
+                UNION
+                SELECT `Profile` AS `ID` FROM `sys_friend_list` WHERE `ID` = '{$iIdProfile}' AND `Check` =1
+            ) AS `f`
+            INNER JOIN `Profiles` AS `p` ON `p`.`ID` = `f`.`ID`
             ORDER BY p.`Avatar` DESC
         ";