[buddypress-trac] [BuddyPress] #5114: BP User Query / Alphabetical sort - All Members tab count and spammers

[buddypress-trac]

#5114: BP User Query / Alphabetical sort - All Members tab count and spammers
-------------------------+------------------
 Reporter:  imath        |       Owner:
     Type:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:  1.9
Component:  Members      |     Version:  1.8
 Severity:  normal       |  Resolution:
 Keywords:               |
-------------------------+------------------
Changes (by boonebgorges):

 * milestone:  Awaiting Review => 1.9


Comment:

 Good catch, imath. We should definitely fix this bug.

 However, for the reasons you suggest, I'm still not keen on joining
 against usermeta - it's really horendous in terms of performance. (This
 was the main reason for developing `BP_User_Query` in the first place.)

 If the problem is that spammed users are showing up, then we might think
 about excluding spam users by looking at the `user_status` and/or `spam`
 columns in the users table. I'm not sure why these checks weren't
 originally included in `BP_User_Query`. My guess is that it's because it
 wasn't present in the legacy queries, because *they* joined against
 last_activity.

 In any case, I'm moving this to 1.9, as it's something that we should fix
 either way.

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/5114#comment:1>
BuddyPress <http://buddypress.org/>
BuddyPress