[buddypress-trac] [BuddyPress Trac] #6155: bp_core_get_active_member_count() multisite query does not exclude 'spam' status

[buddypress-trac]

#6155: bp_core_get_active_member_count() multisite query does not exclude 'spam'
status
--------------------------------------------+------------------
 Reporter:  johnjamesjacoby                 |       Owner:
     Type:  defect (bug)                    |      Status:  new
 Priority:  normal                          |   Milestone:  2.3
Component:  Members                         |     Version:
 Severity:  normal                          |  Resolution:
 Keywords:  needs-testing needs-unit-tests  |
--------------------------------------------+------------------
Description changed by johnjamesjacoby:

Old description:

> If multisite, it's possible for spam users to be included in the active
> member count query.
>
> The query was introduced in r.5987:
>
> {{{
> "SELECT ID FROM {$wpdb->users} WHERE (user_status != 0 OR deleted != 0 OR
> user_status != 0)"
> }}}
>
> It should likely be:
>
> {{{
> "SELECT ID FROM {$wpdb->users} WHERE (user_status != 0 OR deleted != 0 OR
> spam != 0)"
> }}}

New description:

 If multisite, it's possible for spam users to be included in the active
 member count query.

 The query was introduced in r5987:

 {{{
 "SELECT ID FROM {$wpdb->users} WHERE (user_status != 0 OR deleted != 0 OR
 user_status != 0)"
 }}}

 It should likely be:

 {{{
 "SELECT ID FROM {$wpdb->users} WHERE (user_status != 0 OR deleted != 0 OR
 spam != 0)"
 }}}

--

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