Changeset 6730

Timestamp:

02/05/2008 07:08:14 PM (17 years ago)

Author:

ryan

Message:

Add wp_count_posts().

Location:

trunk

Files:

• wp-admin/index.php (modified) (1 diff)
• wp-includes/post.php (modified) (1 diff)

trunk/wp-admin/index.php

@@ -38 +38 @@
 
 <?php
-$num_posts = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->posts WHERE post_type = 'post' AND post_status = 'publish'" );
+$num_posts = wp_count_posts('post', 'publish');
 
-$num_pages = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->posts WHERE post_type = 'page' AND post_status = 'publish'" );
+$num_pages = wp_count_posts('page', 'publish');
 
-$num_drafts = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->posts WHERE post_type = 'post' AND post_status = 'draft'" );
+$num_drafts = wp_count_posts('post', 'draft');
 
-$num_future = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->posts WHERE post_type = 'post' AND post_status = 'future'" );
+$num_future = wp_count_posts('post', 'future');
 
 $num_comments = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '1'");

trunk/wp-includes/post.php

@@ -791 +791 @@
 
 /**
+ * wp_count_posts() - Count number of posts with a given type and status
+ *
+ * {@internal Missing Long Description}}
+ *
+ * @package WordPress
+ * @subpackage Post
+ * @since 2.5
+ *
+ * @param string $type Post type
+ * @param string $status Post status
+ * @return int Number of posts
+ */
+function wp_count_posts( $type = 'post', $status = 'publish' ) {
+    global $wpdb;
+
+    return $wpdb->get_var( $wpdb->prepare("SELECT COUNT(*) FROM $wpdb->posts WHERE post_type = %s AND post_status = %s", $type, $status) );
+}
+
+/**
  * wp_delete_post() - Deletes a Post
  *