WordPress at a glance

count_many_users_posts() WP 1.0

Number of posts written by a list of users.

  • Global. wpdb. $wpdb WordPress database abstraction object.

No Hooks.

Return

Array. Amount of posts each user has written.

Usage

count_many_users_posts( $users, $post_type, $public_only );
$users(array) (required)
Array of user IDs.
$post_type(string/array)
Single post type or array of post types to check.
Default: 'post'
$public_only(true/false)
Only return counts for public posts.
Default: false

Code of count_many_users_posts: wp-includes/user.php VER 5.0.1

<?php
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;
}

Related Functions

From category: Other

No comments
    Hello, !     Log In . Register