Changeset 6808 for trunk/wp-includes/post.php

Timestamp:

02/13/2008 09:30:26 AM (18 years ago)

Author:

ryan

Message:

Reduce queries by wp_count_posts(). Props josephscott. fixes #5820

File:

• trunk/wp-includes/post.php (modified) (2 diffs)

trunk/wp-includes/post.php

@@ -783 +783 @@
 
 /**
- * wp_count_posts() - Count number of posts with a given type and status
+ * wp_count_posts() - Count number of posts with a given type
  *
  * {@internal Missing Long Description}}
@@ -792 +792 @@
  *
  * @param string $type Post type
- * @param string $status Post status
- * @return int Number of posts
- */
-function wp_count_posts( $type = 'post', $status = 'publish' ) {
+ * @return array Number of posts for each status
+ */
+function wp_count_posts( $type = 'post' ) {
     global $wpdb;
 
-    return $wpdb->get_var( $wpdb->prepare("SELECT COUNT(*) FROM $wpdb->posts WHERE post_type = %s AND post_status = %s", $type, $status) );
+    $count = $wpdb->get_results( $wpdb->prepare( "SELECT post_status, COUNT( * ) AS num_posts FROM {$wpdb->posts} WHERE post_type = %s GROUP BY post_status", $type ), ARRAY_A );
+
+    $stats = array( );
+    foreach( (array) $count as $row_num => $row ) {
+        $stats[$row['post_status']] = $row['num_posts'];
+    }
+
+    return (object) $stats;
 }