Changeset 6091 for trunk/src/includes/admin/tools.php

Timestamp:

09/07/2016 12:16:39 PM (8 years ago)

Author:

netweb

Message:

Tools: Running the "Reset Forums" tool now deletes bbPress' custom post type revisions from the database.

This changeset adds support for deleting forum, topic, and reply post types revisions to bbp_admin_reset_handler().

Fixes #2945.

File:

• trunk/src/includes/admin/tools.php (modified) (1 diff)

trunk/src/includes/admin/tools.php

@@ -2255 +2255 @@
     }
 
+    /** Post Revisions ********************************************************/
+
+    if ( ! empty( $sql_posts ) ) {
+        $sql_meta = array();
+        foreach ( $sql_posts as $key => $value ) {
+            $sql_meta[] = $key;
+        }
+        $statement  = __( 'Deleting Post Revisions… %s', 'bbpress' );
+        $sql_meta   = implode( "', '", $sql_meta );
+        $sql_delete = "DELETE FROM `{$bbp_db->posts}` WHERE `post_parent` IN ('{$sql_meta}') AND `post_type` = 'revision';";
+        $result     = is_wp_error( $bbp_db->query( $sql_delete ) ) ? $failed : $success;
+        $messages[] = sprintf( $statement, $result );
+    }
+
     /** Forum moderators ******************************************************/