count_many_users_posts() – Number of posts written by a list of users.

You appear to be a bot. Output may be restricted

Description

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

Usage

$string[] = count_many_users_posts( $users, $post_type, $public_only );

Parameters

$users
( int[] ) required – Array of user IDs.
$post_type
( string|string[] ) optional default: post – Optional. Single post type or array of post types to check. Defaults to 'post'.
$public_only
( bool ) optional – Optional. Only return counts for public posts. Defaults to false.

Returns

string[] Amount of posts each user has written, as strings, keyed by user ID.

Source

File name: wordpress/wp-includes/user.php
Lines:

1 to 24 of 24
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;
}
 

 View on GitHub View on Trac