edwardbeckett
12/21/2014 - 9:02 PM

WP post.php... research info for building a query to manually delete posts...

WP post.php... research info for building a query to manually delete posts...

/**
 * Remove metadata matching criteria from a post.
 *
 * You can match based on the key, or key and value. Removing based on key and
 * value, will keep from removing duplicate metadata with the same key. It also
 * allows removing all metadata matching key, if needed.
 *
 * @since 1.5.0
 *
 * @param int    $post_id    Post ID.
 * @param string $meta_key   Metadata name.
 * @param mixed  $meta_value Optional. Metadata value. Must be serializable if
 *                           non-scalar. Default empty.
 * @return bool True on success, false on failure.
 */
function delete_post_meta( $post_id, $meta_key, $meta_value = '' ) {
        // Make sure meta is added to the post, not a revision.
        if ( $the_post = wp_is_post_revision($post_id) )
                $post_id = $the_post;
        return delete_metadata('post', $post_id, $meta_key, $meta_value);
}
/**
 * Trash or delete a post or page.
 *
 * When the post and page is permanently deleted, everything that is tied to
 * it is deleted also. This includes comments, post meta fields, and terms
 * associated with the post.
 *
 * The post or page is moved to trash instead of permanently deleted unless
 * trash is disabled, item is already in the trash, or $force_delete is true.
 *
 * @since 1.0.0
 *
 * @global wpdb $wpdb WordPress database abstraction object.
 * @see wp_delete_attachment()
 * @see wp_trash_post()
 *
 * @param int  $postid       Optional. Post ID. Default 0.
 * @param bool $force_delete Optional. Whether to bypass trash and force deletion.
 *                           Default false.
 * @return array|bool|WP_Post False on failure.
 */
function wp_delete_post( $postid = 0, $force_delete = false ) {
        global $wpdb;
        if ( !$post = $wpdb->get_row($wpdb->prepare("SELECT * FROM $wpdb->posts WHERE ID = %d", $postid)) )
                return $post;
        if ( !$force_delete && ( $post->post_type == 'post' || $post->post_type == 'page') && get_post_status( $postid ) != 'trash' && EMPTY_TRASH_DAYS )
                        return wp_trash_post($postid);
        if ( $post->post_type == 'attachment' )
                return wp_delete_attachment( $postid, $force_delete );
        /**
         * Fires before a post is deleted, at the start of wp_delete_post().
         *
         * @since 3.2.0
         *
         * @see wp_delete_post()
         *
         * @param int $postid Post ID.
         */
        do_action( 'before_delete_post', $postid );
        delete_post_meta($postid,'_wp_trash_meta_status');
        delete_post_meta($postid,'_wp_trash_meta_time');
        wp_delete_object_term_relationships($postid, get_object_taxonomies($post->post_type));
        $parent_data = array( 'post_parent' => $post->post_parent );
        $parent_where = array( 'post_parent' => $postid );
        if ( is_post_type_hierarchical( $post->post_type ) ) {
                // Point children of this page to its parent, also clean the cache of affected children.
                $children_query = $wpdb->prepare( "SELECT * FROM $wpdb->posts WHERE post_parent = %d AND post_type = %s", $postid, $post->post_type );
                $children = $wpdb->get_results( $children_query );
                $wpdb->update( $wpdb->posts, $parent_data, $parent_where + array( 'post_type' => $post->post_type ) );
        }
        // Do raw query. wp_get_post_revisions() is filtered.
        $revision_ids = $wpdb->get_col( $wpdb->prepare( "SELECT ID FROM $wpdb->posts WHERE post_parent = %d AND post_type = 'revision'", $postid ) );
        // Use wp_delete_post (via wp_delete_post_revision) again. Ensures any meta/misplaced data gets cleaned up.
        foreach ( $revision_ids as $revision_id )
                wp_delete_post_revision( $revision_id );
        // Point all attachments to this post up one level.
        $wpdb->update( $wpdb->posts, $parent_data, $parent_where + array( 'post_type' => 'attachment' ) );
        $comment_ids = $wpdb->get_col( $wpdb->prepare( "SELECT comment_ID FROM $wpdb->comments WHERE comment_post_ID = %d", $postid ));
        foreach ( $comment_ids as $comment_id )
                wp_delete_comment( $comment_id, true );
        $post_meta_ids = $wpdb->get_col( $wpdb->prepare( "SELECT meta_id FROM $wpdb->postmeta WHERE post_id = %d ", $postid ));
        foreach ( $post_meta_ids as $mid )
                delete_metadata_by_mid( 'post', $mid );
        /**
         * Fires immediately before a post is deleted from the database.
         *
         * @since 1.2.0
         *
         * @param int $postid Post ID.
         */
        do_action( 'delete_post', $postid );
        $result = $wpdb->delete( $wpdb->posts, array( 'ID' => $postid ) );
        if ( ! $result ) {
                return false;
        }
        /**
         * Fires immediately after a post is deleted from the database.
         *
         * @since 2.2.0
         *
         * @param int $postid Post ID.
         */
        do_action( 'deleted_post', $postid );
        clean_post_cache( $post );
        if ( is_post_type_hierarchical( $post->post_type ) && $children ) {
                foreach ( $children as $child )
                        clean_post_cache( $child );
        }
        wp_clear_scheduled_hook('publish_future_post', array( $postid ) );
        /**
         * Fires after a post is deleted, at the conclusion of wp_delete_post().
         *
         * @since 3.2.0
         *
         * @see wp_delete_post()
         *
         * @param int $postid Post ID.
         */
        do_action( 'after_delete_post', $postid );
        return $post;
}