Changeset 14414 for trunk/xmlrpc/BxDolXMLRPCFriends.php

Timestamp:

09/16/10 12:26:58 (21 months ago)

Author:

Leonid Sokushev

Message:

ticket #2163

File:

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

trunk/xmlrpc/BxDolXMLRPCFriends.php

@@ -14 +14 @@
             SELECT p.*
             FROM `Profiles` AS p
-            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)
+            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`)
             ORDER BY p.`Avatar` DESC
         ";