我使用下面的函数来计算作者从自定义帖子类型中发表的帖子数量。

<?php
function count_user_posts_by_type($userid, $post_type) {
    global $wpdb;
    $where = get_posts_by_author_sql($post_type, TRUE, $userid);
    $count = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->posts $where" );
    return apply_filters(\'get_usernumposts\', $count, $userid);
}
?>  

以呼应我使用的计数

<?php echo count_user_posts_by_type(wp_get_current_user()->ID, \'custom_post_type_name\'); ?>

从我的测试来看，似乎只有post_status 属于publish. 如何修改该函数，使其同时统计draft ?

我尝试如下修改查询，但似乎没有任何效果：

$count = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->posts $where AND post_status IN (\'publish\',\'draft\')" );

$count = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->posts $where AND (post_status = \'publish\' OR post_status = \'draft\')" );

$querystr = "
    SELECT COUNT(*)  
    FROM $wpdb->posts
    WHERE $wpdb->posts.ID = $wpdb->postmeta.post_id 
    AND $wpdb->posts.post_status = \'draft\' 
    AND $wpdb->posts.post_type = \'post\'
    ORDER BY $wpdb->posts.post_date DESC
 ";

$pageposts = $wpdb->get_results($querystr, OBJECT);