Changeset 8290 for trunk/bp-core/bp-core-classes.php

Timestamp:

04/17/2014 07:08:40 PM (11 years ago)

Author:

boonebgorges

Message:

Reintroduce DISTINCT keyword to BP_Core_User::get_users()

The lack of DISTINCT was causing duplicate entries when joining against the
xprofile fields for the purposes of alphabetical sorts.

Reverts part of r7700. See #5303

Fixes #5550

File:

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

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

@@ -884 +884 @@
         $sql = array();
 
-        $sql['select_main'] = "SELECT u.ID as id, u.user_registered, u.user_nicename, u.user_login, u.display_name, u.user_email";
+        $sql['select_main'] = "SELECT DISTINCT u.ID as id, u.user_registered, u.user_nicename, u.user_login, u.display_name, u.user_email";
 
         if ( 'active' == $type || 'online' == $type || 'newest' == $type  ) {