Changeset 7853

Timestamp:

04/29/2008 06:35:24 PM (17 years ago)

Author:

ryan

Message:

Use wp_count_comments() instead of direct query.

File:

• branches/2.5/wp-admin/includes/dashboard.php (modified) (1 diff)

branches/2.5/wp-admin/includes/dashboard.php

@@ -24 +24 @@
 
     // Recent Comments Widget
-    if ( current_user_can( 'moderate_comments' ) && $mod_comments = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '0'") ) {
+    $mod_comments = wp_count_comments();
+    $mod_comments = $mod_comments->moderated;
+    if ( current_user_can( 'moderate_comments' ) && $mod_comments ) {
         $notice = sprintf( __ngettext( '%d comment awaiting moderation', '%d comments awaiting moderation', $mod_comments ), $mod_comments );
         $notice = "<a href='edit-comments.php?comment_status=moderated'>$notice</a>";