WordPress 显示作者文章数量和评论数量[代码]

1
2
3
4
5
6

<?php
global $wpdb;
$author_id = $current_user->ID;
$comment_count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM $wpdb->comments  WHERE comment_approved='1' AND user_id = '$author_id' AND comment_type not in ('trackback','pingback')" ) ); //查询作者评论数量
$post_count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM $wpdb->posts WHERE post_status IN ('publish','static') AND post_author = '$author_id' AND post_type = 'iask'" ) ); //查询作者文章数量
?>

1
2

文章数量：<?php echo $post_count;?>
点评数量：<?php echo $comment_count;?>