Changeset 3193

Timestamp:

11/22/2005 03:45:40 AM (19 years ago)

Author:

ryan

Message:

Instead of incrementing the current comment count, recount all comments to make sure we have a good count. Props Mark Jaquith. fixes #1920

File:

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

trunk/wp-includes/comment-functions.php

@@ -84 +84 @@
     $id = $wpdb->insert_id;
 
-    if ( $comment_approved == 1)
-        $wpdb->query( "UPDATE $wpdb->posts SET comment_count = comment_count + 1 WHERE ID = '$comment_post_ID'" );
-    
+    if ( $comment_approved == 1) {
+        $count = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_post_ID = '$comment_post_ID' AND comment_approved = '1'");
+        $wpdb->query( "UPDATE $wpdb->posts SET comment_count = $count WHERE ID = '$comment_post_ID'" );
+    }
     return $id;
 }