Changeset 6488

Timestamp:

11/05/2012 09:53:25 PM (13 years ago)

Author:

djpaul

Message:

Correct SQL for BP_User_Query for the Member>Friends/Friend Request screens. See #4060

File:

• trunk/bp-core/bp-core-classes.php (modified) (1 diff)

trunk/bp-core/bp-core-classes.php

@@ -303 +303 @@
 
             if ( !empty( $friend_ids ) ) {
-                $sql['where'][] = "u.{$this->uid_name} NOT IN ({$friend_ids})";
-            } else {
-                // If the user has no friends, make sure the query returns null
+                $sql['where'][] = "u.{$this->uid_name} IN ({$friend_ids})";
+
+            // If the user has no friends, and we're not including specific users, make sure the query returns null
+            } elseif ( empty( $include ) ) {
                 $sql['where'][] = $this->no_results['where'];
             }