Contents

Code Reference Functions bp_core_get_status_sql()

bp_core_get_status_sql( string|bool $prefix = false )

Get SQL chunk for filtering spam users from member queries.

Description

Parameters

$prefix

(Optional) Global table prefix.

Default value: false

Return

(string) SQL chunk.

Source

File: bp-core/bp-core-wpabstraction.php 

function bp_core_get_status_sql( $prefix = false ) {
	if ( !is_multisite() )
		return "{$prefix}user_status = 0";
	else
		return "{$prefix}spam = 0 AND {$prefix}deleted = 0 AND {$prefix}user_status = 0";
}

Expand full source code Collapse full source code

Used By
Used By Description
bp-members/bp-members-functions.php: bp_core_get_total_member_count()

Return the total number of members for the installation.
bp-core/classes/class-bp-user-query.php: BP_User_Query::prepare_user_ids_query()

Prepare the query for user_ids.
bp-core/classes/class-bp-core-user.php: BP_Core_User::get_specific_users()

Get details of specific users from the database.
bp-core/classes/class-bp-core-user.php: BP_Core_User::search_users()

Find users who match on the value of an xprofile data.
bp-core/classes/class-bp-core-user.php: BP_Core_User::get_users()

Get a list of users that match the query parameters.
bp-core/classes/class-bp-core-user.php: BP_Core_User::get_users_by_letter()

Fetch the details for all users whose usernames start with the given letter.
Show 1 more used by Hide more used by

Questions?

We're always happy to help with code or other questions you might have! Search our developer docs, contact support, or connect with our sales team.