Changeset 2522 for trunk/wp-includes/comment-functions.php

Timestamp:

04/09/2005 07:09:26 AM (21 years ago)

Author:

ryan

Message:

Use comment count cache.

File:

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

trunk/wp-includes/comment-functions.php

@@ -43 +43 @@
         global $wpdb, $comment_count_cache;
         $comment_id = (int) $comment_id;
-        if (!isset($comment_count_cache[$comment_id])) 
-                $number =  $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_post_ID = '$comment_id' AND comment_approved = '1'");
-        else 
-                $number =  $comment_count_cache[$comment_id];
-        return apply_filters('get_comments_number', $number);
+        if (!isset($comment_count_cache[$comment_id]))
+                $comment_count_cache[$comment_id] =  $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_post_ID = '$comment_id' AND comment_approved = '1'");
+        
+        return apply_filters('get_comments_number', $comment_count_cache[$comment_id]);
 }
 
@@ -95 +94 @@
 
         if (! is_single() && ! is_page()) {
-    if ('' == $comment_count_cache["$id"]) {
-        $number = $wpdb->get_var("SELECT COUNT(comment_ID) FROM $wpdb->comments WHERE comment_post_ID = $id AND comment_approved = '1';");
-    } else {
-        $number = $comment_count_cache["$id"];
-    }
+    if ( !isset($comment_count_cache[$id]))
+                        $comment_count_cache[$id] = $wpdb->get_var("SELECT COUNT(comment_ID) FROM $wpdb->comments WHERE comment_post_ID = $id AND comment_approved = '1';");
+
+                $number = $comment_count_cache[$id];
+
     if (0 == $number && 'closed' == $post->comment_status && 'closed' == $post->ping_status) {
         echo $none;