Changeset 3888

Timestamp:

06/19/2006 05:18:19 PM (19 years ago)

Author:

ryan

Message:

wp_update_comment_count() from MarkJaquith. fixes #2836

File:

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

branches/2.0/wp-includes/comment-functions.php

@@ -222 +222 @@
 
     $post_id = $comment->comment_post_ID;
-    if ( $post_id && $comment->comment_approved == 1 )
-        $wpdb->query( "UPDATE $wpdb->posts SET comment_count = comment_count - 1 WHERE ID = '$post_id'" );
+    if ( $post_id && $comment->comment_approved == 1 ) {
+        $count = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_post_ID = '$post_id' AND comment_approved = '1'");
+        $wpdb->query( "UPDATE $wpdb->posts SET comment_count = $count WHERE ID = '$post_id'" );
+    }
 
     do_action('wp_set_comment_status', $comment_id, 'delete');