Changeset 1185 for trunk/wp-includes/template-functions-comment.php

Timestamp:

04/26/2004 11:54:52 PM (21 years ago)

Author:

saxmatt

Message:

Reducing queries and forward thinking database fields.

File:

• trunk/wp-includes/template-functions-comment.php (modified) (1 diff)

trunk/wp-includes/template-functions-comment.php

@@ -31 +31 @@
 
 function comments_number($zero='No Comments', $one='1 Comment', $more='% Comments', $number='') {
-    global $id, $comment, $tablecomments, $wpdb;
-    if ('' == $number) $number = $wpdb->get_var("SELECT COUNT(*) FROM $tablecomments WHERE comment_post_ID = $id AND comment_approved = '1'");
+    global $id, $comment, $tablecomments, $wpdb, $comment_count_cache;
+    if ('' == $comment_count_cache["$id"]) $number = $wpdb->get_var("SELECT COUNT(*) FROM $tablecomments WHERE comment_post_ID = $id AND comment_approved = '1'");
+    else $number = $comment_count_cache["$id"];
     if ($number == 0) {
         $blah = $zero;