Context Navigation

← Previous Change
Next Change →

post.php

Timestamp:

11/05/2009 09:03:09 PM (17 years ago)

Author:

ryan

Message:

Trash comments when trashing a post. see #11073

File:

: 1 edited

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

Legend:

: Unmodified
: Added
: Removed

trunk/wp-includes/post.php

-              r12141
+              r12148
         wp_insert_post($post);
+        wp_trash_post_comments($post_id);
         do_action('trashed_post', $post_id);
 …
         wp_insert_post($post);
+        wp_untrash_post_comments($post_id);
         do_action('untrashed_post', $post_id);
         return $post;
+}
+/**
+ * Moves comments for a post to the trash
+ *
+ * @since 2.9.0
+ * @uses do_action() on 'trash_post_comments' before trashing
+ * @uses do_action() on 'trashed_post_comments' after trashing
+ *
+ * @param int $post Post ID or object.
+ * @return mixed False on failure
+ */
+function wp_trash_post_comments($post = null) {
+        global $wpdb;
+        $post = get_post($post);
+        if ( empty($post) )
+                return;
+        $post_id = $post->ID;
+        do_action('trash_post_comments', $post_id);
+        $comments = $wpdb->get_results( $wpdb->prepare("SELECT comment_ID, comment_approved FROM $wpdb->comments WHERE comment_post_ID = %d", $post_id) );
+        if ( empty($comments) )
+                return;
+        // Cache current status for each comment
+        $statuses = array();
+        foreach ( $comments as $comment )
+                $statuses[$comment->comment_ID] = $comment->comment_approved;
+        add_post_meta($post_id, '_wp_trash_meta_comments_status', $statuses);
+        // Set status for all comments to post-trashed
+        $result = $wpdb->update($wpdb->comments, array('comment_approved' => 'post-trashed'), array('comment_post_ID' => $post_id));
+        clean_comment_cache( array_keys($statuses) );
+        do_action('trashed_post_comments', $post_id, $statuses);
+        return $result;
+}
+/**
+ * Restore comments for a post from the trash
+ *
+ * @since 2.9.0
+ * @uses do_action() on 'untrash_post_comments' before trashing
+ * @uses do_action() on 'untrashed_post_comments' after trashing
+ *
+ * @param int $post Post ID or object.
+ * @return mixed False on failure
+ */
+function wp_untrash_post_comments($post = null) {
+        global $wpdb;
+        $post = get_post($post);
+        if ( empty($post) )
+                return;
+        $post_id = $post->ID;
+        $statuses = get_post_meta($post_id, '_wp_trash_meta_comments_status', true);
+        if ( empty($statuses) )
+                return true;
+        do_action('untrash_post_comments', $post_id);
+        // Restore each comment to its original status
+        $group_by_status = array();
+        foreach ( $statuses as $comment_id => $comment_status )
+                $group_by_status[$comment_status][] = $comment_id;
+        foreach ( $group_by_status as $status => $comments ) {
+                // Sanity check. This shouldn't happen.
+                if ( 'post-trashed' == $status )
+                        $status = '0';
+                $comments_in = implode( "', '", $comments );
+                $wpdb->query( "UPDATE $wpdb->comments SET comment_approved = '$status' WHERE comment_ID IN ('" . $comments_in . "')" );
+        }
+        clean_comment_cache( array_keys($statuses) );
+        delete_post_meta($post_id, '_wp_trash_meta_comments_status');
+        do_action('untrashed_post_comments', $post_id);
+}

Note: See TracChangeset for help on using the changeset viewer.

Make WordPress Core

Context Navigation

Changeset 12148 for trunk/wp-includes/post.php

Legend:

trunk/wp-includes/post.php

Download in other formats: