Changeset 6730 for trunk/wp-admin/index.php

Timestamp:

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

Author:

ryan

Message:

Add wp_count_posts().

File:

• trunk/wp-admin/index.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'");