It only took 3.5-years for someone to be put into the position of @robert-andrews to chase down the post count problem. While having the same problem (and misinterpretation), I ran across your post yesterday in my search for answers. Nothing good really turned up. So, I was forced to trace the code and take the … Read more
The elegant way to get posts out of the database is to use wp_query. It has all the filters you need: function wpse70323_count_user_posts_by_type( $userid, $post_type, $year, $month, $day ) { $query = new WP_Query( array( ‘author’ => $userid, ‘post_type’ => $post_type, ‘date_query’ => array( array( ‘year’ => $year, ‘month’ => $month, ‘day’ => $day, ), … Read more
Some ideas for your attachments file: A simplification: $tmp = $post; // Store the current global post object $post = get_post( $post->post_parent ); // Use the post parent post object $media = get_attached_media( ‘audio’ ); if( $media ) { $sc = “”; if( count( $media ) > 1 ) { $ids = join( ‘,’, wp_list_pluck( … Read more
Look what count_user_posts() does inside and change the post type parameter: global $wpdb; // ‘page’ is the important part here $where = get_posts_by_author_sql(‘page’, true, $userid); $count = $wpdb->get_var( “SELECT COUNT(*) FROM $wpdb->posts $where” ); Then you change your snippet to: global $wpdb; $user = wp_get_current_user(); $where = get_posts_by_author_sql( ‘page’, true, $user->ID ); $count = $wpdb->get_var( … Read more
You already have the total post, so in order to get the total post within the last week, it’s better if you do this on your functions.php file: function get_posts_count_from_last_week($post_type=”post”) { global $wpdb; $numposts = $wpdb->get_var( $wpdb->prepare( “SELECT COUNT(ID) “. “FROM {$wpdb->posts} “. “WHERE “. “post_status=”publish” “. “AND post_type= %s “. “AND post_date> %s”, $post_type, … Read more
The function you are using are scrambled and does not make much sense. Also, it is very static in that you cannot return a count according to custom parameters like post type, post status, or custom field. Another thing to note, if a post belongs to a term and one of its child terms, the … Read more
There is no default/native function in wordpress to count posts from a specific meta value. wp_count_posts only counts the amount of posts according to post type It might be useful here to use WP_Query to create a custom query to get all posts with that specific meta value and then use $wp_query->found_posts to get the … Read more
Public API for the rescue category is a Taxonomy that’s already built in. Therefore it’s quite easy to get its term count with get_terms( $tax, array( /* args */ ) ); $terms = get_terms( ‘category’, array( ‘fields’ => ‘count’, ) ); This will do a pretty fast COUNT (*) query so you don’t have to … Read more
You are more or less there already with the code, you just need to change the code slightly. You do not mention how you get the user id, but if you have the user ID you want to check, it is quite easy to do outside the loop. Here is a simple example: $userid=1; $comment_count … Read more
Place this in your functions.php theme file: <?php function ps_count_user_comments() { global $wpdb; $count = $wpdb->get_var( ‘SELECT COUNT(comment_ID) FROM ‘ . $wpdb->comments. ‘ WHERE comment_author_email = “‘ . get_comment_author_email() . ‘” AND comment_approved = “1” AND comment_type IN (“comment”, “”)’ ); return $count . ‘ comments’; } ?> This code will count the author comments … Read more