wpseek.com
A WordPress-centric search engine for devs and theme authors



count_many_users_posts › WordPress Function

Since3.0.0
Deprecatedn/a
› count_many_users_posts ( $users, $post_type = 'post', $public_only = false )
Parameters: (3)
  • (int[]) $users Array of user IDs.
    Required: Yes
  • (string|string[]) $post_type Optional. Single post type or array of post types to check. Defaults to 'post'.
    Required: No
    Default: 'post'
  • (bool) $public_only Optional. Only return counts for public posts. Defaults to false.
    Required: No
    Default: false
Returns:
  • (string[]) Amount of posts each user has written, as strings, keyed by user ID.
Defined at:
Codex:

Gets the number of posts written by a list of users.



Related Functions: count_user_posts, count_users, wp_count_posts, get_usernumposts, get_all_user_settings

Source 

function count_many_users_posts( $users, $post_type = 'post', $public_only = false ) {
	global $wpdb;

	$count = array();
	if ( empty( $users ) || ! is_array( $users ) ) {
		return $count;
	}

	$userlist = implode( ',', array_map( 'absint', $users ) );
	$where    = get_posts_by_author_sql( $post_type, true, null, $public_only );

	$result = $wpdb->get_results( "SELECT post_author, COUNT(*) FROM $wpdb->posts $where AND post_author IN ($userlist) GROUP BY post_author", ARRAY_N );
	foreach ( $result as $row ) {
		$count[ $row[0] ] = $row[1];
	}

	foreach ( $users as $id ) {
		if ( ! isset( $count[ $id ] ) ) {
			$count[ $id ] = 0;
		}
	}

	return $count;
}