W3cubDocs

/WordPress

wp_scheduled_delete()

Permanently delete comments or posts of any type that have held a status of ‘trash’ for the number of days defined in EMPTY_TRASH_DAYS.

Description

The default value of EMPTY_TRASH_DAYS is 30 (days).

Source

File: wp-includes/functions.php 

function wp_scheduled_delete() {
	global $wpdb;

	$delete_timestamp = time() - ( DAY_IN_SECONDS * EMPTY_TRASH_DAYS );

	$posts_to_delete = $wpdb->get_results( $wpdb->prepare( "SELECT post_id FROM $wpdb->postmeta WHERE meta_key = '_wp_trash_meta_time' AND meta_value < %d", $delete_timestamp ), ARRAY_A );

	foreach ( (array) $posts_to_delete as $post ) {
		$post_id = (int) $post['post_id'];
		if ( ! $post_id ) {
			continue;
		}

		$del_post = get_post( $post_id );

		if ( ! $del_post || 'trash' !== $del_post->post_status ) {
			delete_post_meta( $post_id, '_wp_trash_meta_status' );
			delete_post_meta( $post_id, '_wp_trash_meta_time' );
		} else {
			wp_delete_post( $post_id );
		}
	}

	$comments_to_delete = $wpdb->get_results( $wpdb->prepare( "SELECT comment_id FROM $wpdb->commentmeta WHERE meta_key = '_wp_trash_meta_time' AND meta_value < %d", $delete_timestamp ), ARRAY_A );

	foreach ( (array) $comments_to_delete as $comment ) {
		$comment_id = (int) $comment['comment_id'];
		if ( ! $comment_id ) {
			continue;
		}

		$del_comment = get_comment( $comment_id );

		if ( ! $del_comment || 'trash' !== $del_comment->comment_approved ) {
			delete_comment_meta( $comment_id, '_wp_trash_meta_time' );
			delete_comment_meta( $comment_id, '_wp_trash_meta_status' );
		} else {
			wp_delete_comment( $del_comment );
		}
	}
}

Uses

Uses Description
wp-includes/post.php: wp_delete_post()

Trash or delete a post or page.
wp-includes/post.php: delete_post_meta()

Deletes a post meta field for the given post ID.
wp-includes/post.php: get_post()

Retrieves post data given a post ID or post object.
wp-includes/wp-db.php: wpdb::get_results()

Retrieves an entire SQL result set from the database (i.e., many rows).
wp-includes/wp-db.php: wpdb::prepare()

Prepares a SQL query for safe execution.
wp-includes/comment.php: wp_delete_comment()

Trashes or deletes a comment.
wp-includes/comment.php: delete_comment_meta()

Remove metadata matching criteria from a comment.
wp-includes/comment.php: get_comment()

Retrieves comment data given a comment ID or comment object.

Changelog

Version Description
2.9.0 Introduced.

© 2003–2019 WordPress Foundation
Licensed under the GNU GPLv2+ License.
https://developer.wordpress.org/reference/functions/wp_scheduled_delete