count_users

Source code

function count_users($strategy = 'time') {

	global $wpdb, $wp_roles;



	// Initialize

	$id = get_current_blog_id();

	$blog_prefix = $wpdb->get_blog_prefix($id);

	$result = array();



	if ( 'time' == $strategy ) {

		global $wp_roles;



		if ( ! isset( $wp_roles ) )

			$wp_roles = new WP_Roles();



		$avail_roles = $wp_roles->get_names();



		// Build a CPU-intensive query that will return concise information.

		$select_count = array();

		foreach ( $avail_roles as $this_role => $name ) {

			$select_count[] = "COUNT(NULLIF(`meta_value` LIKE '%" . like_escape($this_role) . "%', FALSE))";

		}

		$select_count = implode(', ', $select_count);



		// Add the meta_value index to the selection list, then run the query.

		$row = $wpdb->get_row( "SELECT $select_count, COUNT(*) FROM $wpdb->usermeta WHERE meta_key = '{$blog_prefix}capabilities'", ARRAY_N );



		// Run the previous loop again to associate results with role names.

		$col = 0;

		$role_counts = array();

		foreach ( $avail_roles as $this_role => $name ) {

			$count = (int) $row[$col++];

			if ($count > 0) {

				$role_counts[$this_role] = $count;

			}

		}



		// Get the meta_value index from the end of the result set.

		$total_users = (int) $row[$col];



		$result['total_users'] = $total_users;

		$result['avail_roles'] =& $role_counts;

	} else {