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

Timestamp:

11/16/2005 06:29:36 AM (20 years ago)

Author:

ryan

Message:

Add comment_count to the posts table. Props donncha. fixes #1860

File:

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

trunk/wp-includes/comment-functions.php

@@ -82 +82 @@
     ");
 
-    return $wpdb->insert_id;
+    $id = $wpdb->insert_id;
+
+    if ( $comment_approved == 1)
+        $wpdb->query( "UPDATE $wpdb->posts SET comment_count = comment_count + 1 WHERE ID = '$comment_post_ID'" );
+    
+    return $id;
 }
 
@@ -177 +182 @@
     $rval = $wpdb->rows_affected;
 
+    $c = $wpdb->get_row( "SELECT count(*) as c FROM {$wpdb->comments} WHERE comment_post_ID = '$comment_post_ID' AND comment_approved = '1'" );
+    if( is_object( $c ) )
+        $wpdb->query( "UPDATE $wpdb->posts SET comment_count = '$c->c' WHERE ID = '$comment_post_ID'" );
+
     do_action('edit_comment', $comment_ID);
 
-    return $rval;   
+    return $rval;
+}
+
+function wp_delete_comment($comment_id) {
+    global $wpdb;
+    do_action('delete_comment', $comment_id);
+
+    $comment = get_comment($comment_id);
+
+    if ( ! $wpdb->query("DELETE FROM $wpdb->comments WHERE comment_ID='$comment_id' LIMIT 1") )
+        return false;
+
+    $post_id = $comment->comment_post_ID;
+    if ( $post_id )
+        $wpdb->query( "UPDATE $wpdb->posts SET comment_count = comment_count - 1 WHERE ID = '$post_id'" );
+
+    do_action('wp_set_comment_status', $comment_id, 'delete');
+    return true;
 }
 
@@ -199 +225 @@
 
     if ( !isset($comment_count_cache[$post_id]) )
-        $comment_count_cache[$post_id] =  $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_post_ID = '$post_id' AND comment_approved = '1'");
+        $comment_count_cache[$id] = $wpdb->get_var("SELECT comment_count FROM $wpdb->posts WHERE ID = '$post_id'");
     
     return apply_filters('get_comments_number', $comment_count_cache[$post_id]);
@@ -743 +769 @@
         break;
         case 'delete':
-            $query = "DELETE FROM $wpdb->comments WHERE comment_ID='$comment_id' LIMIT 1";
+            return wp_delete_comment($comment_id);
         break;
         default:
@@ -751 +777 @@
     if ($wpdb->query($query)) {
         do_action('wp_set_comment_status', $comment_id, $comment_status);
+        
+        $comment = get_comment($comment_id);
+        $comment_post_ID = $comment->comment_post_ID;
+        $c = $wpdb->get_row( "SELECT count(*) as c FROM {$wpdb->comments} WHERE comment_post_ID = '$comment_post_ID' AND comment_approved = '1'" );
+        if( is_object( $c ) )
+            $wpdb->query( "UPDATE $wpdb->posts SET comment_count = '$c->c' WHERE ID = '$comment_post_ID'" );
         return true;
     } else {