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

Timestamp:

11/16/2005 06:29:36 AM (21 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 {