Changeset 6488

Timestamp:

11/05/2012 09:53:25 PM (14 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'];
                         }