Changeset 12428

Timestamp:

12/17/2009 05:10:40 PM (15 years ago)

Author:

ryan

Message:

Delete all comment meta when deleting a comment. Props nacin. fixes #11463

File:

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

trunk/wp-includes/comment.php

@@ -823 +823 @@
     do_action('delete_comment', $comment_id);
 
-    delete_comment_meta($comment_id,'_wp_trash_meta_status');
-    delete_comment_meta($comment_id,'_wp_trash_meta_time');
-
     if ( ! $wpdb->query( $wpdb->prepare("DELETE FROM $wpdb->comments WHERE comment_ID = %d LIMIT 1", $comment_id) ) )
         return false;
@@ -834 +831 @@
         $wpdb->update($wpdb->comments, array('comment_parent' => $comment->comment_parent), array('comment_parent' => $comment_id));
         clean_comment_cache($children);
+    }
+
+    // Delete metadata
+    $meta_ids = $wpdb->get_col( $wpdb->prepare( "SELECT meta_id FROM $wpdb->commentmeta WHERE comment_id = %d ", $comment_id ) );
+    if ( !empty($meta_ids) ) {
+        do_action( 'delete_commentmeta', $meta_ids );
+        $in_meta_ids = "'" . implode("', '", $meta_ids) . "'";
+        $wpdb->query( "DELETE FROM $wpdb->commentmeta WHERE meta_id IN ($in_meta_ids)" );
+        do_action( 'deleted_commentmeta', $meta_ids );
     }