A WordPress-centric search engine for devs and theme authors



wp_get_users_with_no_role ›

Since4.4.0
Deprecatedn/a
wp_get_users_with_no_role ( $site_id = null )
Parameters:
  • (int|null) $site_id Optional. The site ID to get users with no role for. Defaults to the current site.
    Required: No
    Default: null
Returns:
  • (array) Array of user IDs.
Defined at:
Codex:
Change Log:
  • 4.9.0

Get the user IDs of all users with no role on this site.



Source

function wp_get_users_with_no_role( $site_id = null ) {
	global $wpdb;

	if ( ! $site_id ) {
		$site_id = get_current_blog_id();
	}

	$prefix = $wpdb->get_blog_prefix( $site_id );

	if ( is_multisite() && $site_id != get_current_blog_id() ) {
		switch_to_blog( $site_id );
		$role_names = wp_roles()->get_names();
		restore_current_blog();
	} else {
		$role_names = wp_roles()->get_names();
	}

	$regex = implode( '|', array_keys( $role_names ) );
	$regex = preg_replace( '/[^a-zA-Z_\|-]/', '', $regex );
	$users = $wpdb->get_col(
		$wpdb->prepare(
			"
		SELECT user_id
		FROM $wpdb->usermeta
		WHERE meta_key = '{$prefix}capabilities'
		AND meta_value NOT REGEXP %s
	",
			$regex
		)
	);

	return $users;
}