Skip to:
Content

BuddyPress.org


Ignore:
Timestamp:
04/17/2014 07:08:40 PM (10 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:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/bp-core/bp-core-classes.php

    r8087 r8290  
    884884        $sql = array();
    885885
    886         $sql['select_main'] = "SELECT u.ID as id, u.user_registered, u.user_nicename, u.user_login, u.display_name, u.user_email";
     886        $sql['select_main'] = "SELECT DISTINCT u.ID as id, u.user_registered, u.user_nicename, u.user_login, u.display_name, u.user_email";
    887887
    888888        if ( 'active' == $type || 'online' == $type || 'newest' == $type  ) {
Note: See TracChangeset for help on using the changeset viewer.