Changeset 7714

Timestamp:

04/16/2008 11:45:39 PM (18 years ago)

Author:

ryan

Message:

Cache comment count and use count API in menu.php

Location:

trunk

Files:

• wp-admin/menu.php (modified) (1 diff)
• wp-includes/comment.php (modified) (2 diffs)

trunk/wp-admin/menu.php

@@ -21 +21 @@
     $menu[10] = array(__('Manage'), 'edit_posts', 'edit.php');
 
-$awaiting_mod = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '0'");
+$awaiting_mod = wp_count_comments();
+$awaiting_mod = $awaiting_mod->moderated;
 $menu[15] = array(__('Design'), 'switch_themes', 'themes.php');
 $menu[20] = array( sprintf( __('Comments %s'), "<span id='awaiting-mod' class='count-$awaiting_mod'><span class='comment-count'>$awaiting_mod</span></span>" ), 'edit_posts', 'edit-comments.php');

trunk/wp-includes/comment.php

@@ -452 +452 @@
     global $wpdb;
 
+    $count = wp_cache_get('comments', 'counts');
+
+    if ( false !== $count )
+        return $count;
+
     $count = $wpdb->get_results( "SELECT comment_approved, COUNT( * ) AS num_comments FROM {$wpdb->comments} GROUP BY comment_approved", ARRAY_A );
 
@@ -465 +470 @@
     }
 
-    return (object) $stats;
+    $stats = (object) $stats;
+    wp_cache_set('comments', $stats, 'counts');
+
+    return $stats;
 }