<?php

[0] Fix | Delete

/**

[1] Fix | Delete

* Scripts

[2] Fix | Delete

*

[3] Fix | Delete

* @package WP_Bulk_Delete

[4] Fix | Delete

* @subpackage Delerte API

[5] Fix | Delete

* @copyright Copyright (c) 2016, Dharmesh Patel

[6] Fix | Delete

* @since 1.0

[7] Fix | Delete

*/

[8] Fix | Delete

[9] Fix | Delete

// Exit if accessed directly

[10] Fix | Delete

if ( ! defined( 'ABSPATH' ) ) exit;

[11] Fix | Delete

[12] Fix | Delete

/**

[13] Fix | Delete

* WPBD_Delete_API class

[14] Fix | Delete

*

[15] Fix | Delete

* @since 1.0.0

[16] Fix | Delete

*/

[17] Fix | Delete

class WPBD_Delete_API {

[18] Fix | Delete

[19] Fix | Delete

/**

[20] Fix | Delete

* Get things going

[21] Fix | Delete

*

[22] Fix | Delete

* @since 1.0.0

[23] Fix | Delete

*/

[24] Fix | Delete

public function __construct() { /* */ }

[25] Fix | Delete

[26] Fix | Delete

/**

[27] Fix | Delete

* Get posts Ids.

[28] Fix | Delete

*

[29] Fix | Delete

* @access public

[30] Fix | Delete

* @since 1.0

[31] Fix | Delete

* @param array $data Delete posts form data.

[32] Fix | Delete

* @return array | Posts Id.

[33] Fix | Delete

*/

[34] Fix | Delete

public function get_delete_posts_ids( $data = array() ) {

[35] Fix | Delete

if( wpbd_is_pro() && class_exists('WPBD_Delete_API_Pro', false) ){

[36] Fix | Delete

$wpbdpro = new WPBD_Delete_API_Pro();

[37] Fix | Delete

return $wpbdpro->get_delete_posts_ids( $data );

[38] Fix | Delete

}

[39] Fix | Delete

global $wpdb;

[40] Fix | Delete

if( ! empty( $data['delete_post_type'] ) && ! empty( $data['delete_post_status'] ) ){

[41] Fix | Delete

[42] Fix | Delete

$post_types = isset( $data['delete_post_type'] ) ? $data['delete_post_type'] : array();

[43] Fix | Delete

if( ! is_array( $post_types ) ){

[44] Fix | Delete

$post_types = array( $post_types );

[45] Fix | Delete

}

[46] Fix | Delete

$post_types = array_map('esc_sql', $post_types );

[47] Fix | Delete

[48] Fix | Delete

$post_status = isset( $data['delete_post_status'] ) ? array_map('esc_sql', $data['delete_post_status'] ) : array();

[49] Fix | Delete

$delete_start_date = isset( $data['delete_start_date'] ) ? esc_sql( $data['delete_start_date'] ) : '';

[50] Fix | Delete

$delete_end_date = isset( $data['delete_end_date'] ) ? esc_sql( $data['delete_end_date'] ) : '';

[51] Fix | Delete

$delete_authors = isset( $data['delete_authors'] ) ? array_map( 'intval', $data['delete_authors'] ) : array();

[52] Fix | Delete

$delete_type = isset( $data['delete_type'] ) ? $data['delete_type'] : 'trash';

[53] Fix | Delete

$post_media = isset( $data['post_media'] ) ? $data['post_media'] : 'no';

[54] Fix | Delete

$limit_post = !empty( $data['limit_post'] ) ? absint( $data['limit_post'] ) : '10000';

[55] Fix | Delete

$date_type = isset( $data['date_type'] ) ? esc_sql( $data['date_type'] ) : 'custom_date';

[56] Fix | Delete

$input_days = isset( $data['input_days'] ) ? esc_sql( $data['input_days'] ) : '';

[57] Fix | Delete

if( $date_type === 'older_than') {

[58] Fix | Delete

$delete_start_date = $delete_end_date = '';

[59] Fix | Delete

if( $input_days === "0" || $input_days > 0){

[60] Fix | Delete

$delete_end_date = date('Y-m-d', strtotime("-{$input_days} days", strtotime(current_time('Y-m-d'))));

[61] Fix | Delete

}

[62] Fix | Delete

} else if( $date_type === 'within_last') {

[63] Fix | Delete

$delete_start_date = $delete_end_date = '';

[64] Fix | Delete

if( $input_days === "0" || $input_days > 0){

[65] Fix | Delete

$delete_start_date = date('Y-m-d', strtotime("-{$input_days} days", strtotime(current_time('Y-m-d'))));

[66] Fix | Delete

}

[67] Fix | Delete

}

[68] Fix | Delete

[69] Fix | Delete

$mdelete_start_date = isset( $data['mdelete_start_date'] ) ? esc_sql( $data['mdelete_start_date'] ) : '';

[70] Fix | Delete

$mdelete_end_date = isset( $data['mdelete_end_date'] ) ? esc_sql( $data['mdelete_end_date'] ) : '';

[71] Fix | Delete

$mdate_type = isset( $data['mdate_type'] ) ? esc_sql( $data['mdate_type'] ) : 'mcustom_date';

[72] Fix | Delete

$minput_days = isset( $data['minput_days'] ) ? esc_sql( $data['minput_days'] ) : '';

[73] Fix | Delete

if( $mdate_type === 'molder_than') {

[74] Fix | Delete

$mdelete_start_date = $mdelete_end_date = '';

[75] Fix | Delete

if( $minput_days === "0" || $minput_days > 0){

[76] Fix | Delete

$mdelete_end_date = date('Y-m-d', strtotime("-{$minput_days} days", strtotime(current_time('Y-m-d'))));

[77] Fix | Delete

}

[78] Fix | Delete

} else if( $mdate_type === 'mwithin_last') {

[79] Fix | Delete

$mdelete_start_date = $mdelete_end_date = '';

[80] Fix | Delete

if( $minput_days === "0" || $minput_days > 0){

[81] Fix | Delete

$mdelete_start_date = date('Y-m-d', strtotime("-{$minput_days} days", strtotime(current_time('Y-m-d'))));

[82] Fix | Delete

}

[83] Fix | Delete

}

[84] Fix | Delete

[85] Fix | Delete

// BY Taxonomy.

[86] Fix | Delete

$post_taxonomy = isset( $data['post_taxonomy'] ) ? esc_sql( $data['post_taxonomy'] ) : '';

[87] Fix | Delete

$post_taxonomy_terms = isset( $data['post_taxonomy_terms'] ) ? array_map( 'intval', $data['post_taxonomy_terms'] ) : array();

[88] Fix | Delete

$d_selected_category = isset( $data['delete_selected_category'] ) ? esc_sql( $data['delete_selected_category'] ) : '';

[89] Fix | Delete

[90] Fix | Delete

if( empty( $post_types ) || empty( $post_status ) ){

[91] Fix | Delete

return array();

[92] Fix | Delete

}

[93] Fix | Delete

[94] Fix | Delete

// Query Generation.

[95] Fix | Delete

$query = "SELECT DISTINCT $wpdb->posts.ID FROM $wpdb->posts ";

[96] Fix | Delete

[97] Fix | Delete

if( $post_taxonomy != '' && ! empty( $post_taxonomy_terms ) ) {

[98] Fix | Delete

[99] Fix | Delete

$query .= " LEFT JOIN $wpdb->term_relationships ON( $wpdb->posts.ID = $wpdb->term_relationships.object_id )";

[100] Fix | Delete

$query .= " LEFT JOIN $wpdb->term_taxonomy ON($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)";

[101] Fix | Delete

$query .= " LEFT JOIN $wpdb->terms ON($wpdb->term_taxonomy.term_id = $wpdb->terms.term_id)";

[102] Fix | Delete

}

[103] Fix | Delete

[104] Fix | Delete

$query .= " WHERE $wpdb->posts.post_type IN ( '" . implode( "', '", $post_types ) . "' )";

[105] Fix | Delete

[106] Fix | Delete

if( $post_taxonomy != '' && ! empty( $post_taxonomy_terms ) ) {

[107] Fix | Delete

$query .= " AND ( $wpdb->terms.term_id IN ( " . implode( ", ", $post_taxonomy_terms ). " )";

[108] Fix | Delete

$query .= " AND $wpdb->term_taxonomy.taxonomy = '{$post_taxonomy}' )";

[109] Fix | Delete

}

[110] Fix | Delete

[111] Fix | Delete

if( $post_taxonomy != '' && ! empty( $post_taxonomy_terms ) && !empty( $d_selected_category ) ){

[112] Fix | Delete

$query .= "AND $wpdb->posts.ID NOT IN (

[113] Fix | Delete

SELECT $wpdb->posts.ID

[114] Fix | Delete

FROM $wpdb->posts

[115] Fix | Delete

LEFT JOIN $wpdb->term_relationships ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id)

[116] Fix | Delete

LEFT JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)

[117] Fix | Delete

LEFT JOIN $wpdb->terms ON ($wpdb->term_taxonomy.term_id = $wpdb->terms.term_id )

[118] Fix | Delete

WHERE $wpdb->term_taxonomy.taxonomy = '{$post_taxonomy}' AND $wpdb->terms.term_id NOT IN ( " . implode( ", ", $post_taxonomy_terms ). " ) )";

[119] Fix | Delete

}

[120] Fix | Delete

[121] Fix | Delete

if( !empty( $post_status ) ){

[122] Fix | Delete

$query .= " AND $wpdb->posts.post_status IN ( '" . implode( "', '", $post_status ) . "' )";

[123] Fix | Delete

}

[124] Fix | Delete

if( $delete_start_date != ''){

[125] Fix | Delete

$query .= " AND $wpdb->posts.post_date >= '{$delete_start_date} 00:00:00'";

[126] Fix | Delete

}

[127] Fix | Delete

if( $delete_end_date != ''){

[128] Fix | Delete

$query .= " AND $wpdb->posts.post_date <= '{$delete_end_date} 23:59:59'";

[129] Fix | Delete

}

[130] Fix | Delete

if( $mdelete_start_date != ''){

[131] Fix | Delete

$query .= " AND $wpdb->posts.post_modified >= '{$mdelete_start_date} 00:00:00'";

[132] Fix | Delete

}

[133] Fix | Delete

if( $mdelete_end_date != ''){

[134] Fix | Delete

$query .= " AND $wpdb->posts.post_modified <= '{$mdelete_end_date} 23:59:59'";

[135] Fix | Delete

}

[136] Fix | Delete

[137] Fix | Delete

if( !empty( $delete_authors ) ){

[138] Fix | Delete

$query .= " AND $wpdb->posts.post_author IN ( " . implode( ",", $delete_authors ). " )";

[139] Fix | Delete

}

[140] Fix | Delete

[141] Fix | Delete

if( is_numeric( $limit_post ) ){

[142] Fix | Delete

$query .= " LIMIT " . $limit_post;

[143] Fix | Delete

}

[144] Fix | Delete

[145] Fix | Delete

$posts = $wpdb->get_col( $query );

[146] Fix | Delete

return $posts;

[147] Fix | Delete

[148] Fix | Delete

}else{

[149] Fix | Delete

return array();

[150] Fix | Delete

}

[151] Fix | Delete

}

[152] Fix | Delete

[153] Fix | Delete

/**

[154] Fix | Delete

* Do Delete operation on posts.

[155] Fix | Delete

*

[156] Fix | Delete

* @access public

[157] Fix | Delete

* @since 1.0

[158] Fix | Delete

* @param array $data Posts Id.

[159] Fix | Delete

* @return array | deleted posts count.

[160] Fix | Delete

*/

[161] Fix | Delete

public function do_delete_posts( $post_ids = array(), $force_delete = false, $item = array(), $custom_query = null ) {

[162] Fix | Delete

global $wpdb;

[163] Fix | Delete

$post_delete_count = 0;

[164] Fix | Delete

[165] Fix | Delete

set_time_limit(0);

[166] Fix | Delete

$xt_memory_limit = (int)str_replace( 'M', '',ini_get('memory_limit' ) );

[167] Fix | Delete

if( $xt_memory_limit < 512 ){

[168] Fix | Delete

ini_set('memory_limit', '512M');

[169] Fix | Delete

}

[170] Fix | Delete

[171] Fix | Delete

if( ! empty( $post_ids ) && count( $post_ids ) > 0 ) {

[172] Fix | Delete

[173] Fix | Delete

if( $custom_query == 'custom_query' ){

[174] Fix | Delete

[175] Fix | Delete

foreach( $post_ids as $post_id ){

[176] Fix | Delete

if( isset( $item['post_media'] ) && $item['post_media'] === 'yes' ){

[177] Fix | Delete

$post_attachment_id = get_post_meta( $post_id, '_thumbnail_id', true );

[178] Fix | Delete

if( !empty( $post_attachment_id ) ){

[179] Fix | Delete

$attachment_ids = $wpdb->get_col( $wpdb->prepare( "SELECT post_id FROM {$wpdb->postmeta} WHERE meta_value = %d", $post_attachment_id ) );

[180] Fix | Delete

if( !empty( $attachment_ids ) && count( $attachment_ids ) <= 1 ){

[181] Fix | Delete

[182] Fix | Delete

$attachment_metadata = wp_get_attachment_metadata( $post_attachment_id );

[183] Fix | Delete

if ( !empty($attachment_metadata['sizes'] ) ) {

[184] Fix | Delete

//Getting file path

[185] Fix | Delete

$upload_dir = wp_upload_dir();

[186] Fix | Delete

$file_path = $upload_dir['basedir'] . '/' . dirname( $attachment_metadata['file'] ) . '/';

[187] Fix | Delete

[188] Fix | Delete

//Removing all image sizes

[189] Fix | Delete

foreach( $attachment_metadata['sizes'] as $size_info ){

[190] Fix | Delete

$file = $file_path . $size_info['file'];

[191] Fix | Delete

//file check and remove it

[192] Fix | Delete

if ( file_exists( $file ) ) {

[193] Fix | Delete

unlink( $file );

[194] Fix | Delete

}

[195] Fix | Delete

}

[196] Fix | Delete

}

[197] Fix | Delete

[198] Fix | Delete

if ( !empty( $attachment_metadata['file'] ) ) {

[199] Fix | Delete

$file_path = $upload_dir['basedir'] . '/' . $attachment_metadata['file'];

[200] Fix | Delete

//file check and remove it

[201] Fix | Delete

if (file_exists($file_path)) {

[202] Fix | Delete

unlink($file_path);

[203] Fix | Delete

}

[204] Fix | Delete

}

[205] Fix | Delete

[206] Fix | Delete

$wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->posts} WHERE ID = %d", $post_attachment_id ) );

[207] Fix | Delete

$wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->postmeta} WHERE post_id = %d", $post_attachment_id ) );

[208] Fix | Delete

}

[209] Fix | Delete

}

[210] Fix | Delete

}

[211] Fix | Delete

}

[212] Fix | Delete

[213] Fix | Delete

$post_ids_sanitized = array_map( 'intval', $post_ids );

[214] Fix | Delete

$placeholders = implode( ',', array_fill( 0, count( $post_ids_sanitized ), '%d' ) );

[215] Fix | Delete

$query = $wpdb->prepare(

[216] Fix | Delete

"DELETE p, pt, pm FROM {$wpdb->posts} p

[217] Fix | Delete

LEFT JOIN {$wpdb->term_relationships} pt ON pt.object_id = p.ID

[218] Fix | Delete

LEFT JOIN {$wpdb->postmeta} pm ON pm.post_id = p.ID

[219] Fix | Delete

WHERE p.ID IN ( $placeholders )",

[220] Fix | Delete

$post_ids_sanitized

[221] Fix | Delete

);

[222] Fix | Delete

$wpdb->query( $query );

[223] Fix | Delete

[224] Fix | Delete

}else{

[225] Fix | Delete

foreach ($post_ids as $post_id ){

[226] Fix | Delete

if( isset( $item['post_media'] ) && $item['post_media'] === 'yes' ){

[227] Fix | Delete

$post_attachment_id = get_post_meta( $post_id, '_thumbnail_id', true );

[228] Fix | Delete

if( !empty( $post_attachment_id ) ){

[229] Fix | Delete

$attachment_ids = $wpdb->get_col( $wpdb->prepare( "SELECT post_id FROM $wpdb->postmeta WHERE meta_value = %d", $post_attachment_id ) );

[230] Fix | Delete

if( count( $attachment_ids ) <= 1 ){

[231] Fix | Delete

wp_delete_attachment( $post_attachment_id, $force_delete );

[232] Fix | Delete

}

[233] Fix | Delete

}

[234] Fix | Delete

}

[235] Fix | Delete

if( $force_delete === false ){

[236] Fix | Delete

wp_trash_post( $post_id );

[237] Fix | Delete

}else{

[238] Fix | Delete

wp_delete_post( $post_id, true );

[239] Fix | Delete

}

[240] Fix | Delete

}

[241] Fix | Delete

}

[242] Fix | Delete

$post_delete_count = count( $post_ids );

[243] Fix | Delete

[244] Fix | Delete

}

[245] Fix | Delete

return $post_delete_count;

[246] Fix | Delete

}

[247] Fix | Delete

[248] Fix | Delete

/**

[249] Fix | Delete

* Get Post Count by Posttype

[250] Fix | Delete

*

[251] Fix | Delete

* @access public

[252] Fix | Delete

* @since 1.0

[253] Fix | Delete

* @param array $post_type Post type.

[254] Fix | Delete

* @return int | posts count.

[255] Fix | Delete

*/

[256] Fix | Delete

public function get_post_count( $counttype = '' ) {

[257] Fix | Delete

global $wpdb;

[258] Fix | Delete

[259] Fix | Delete

$count = 0;

[260] Fix | Delete

[261] Fix | Delete

switch( $counttype ) {

[262] Fix | Delete

case 'revision':

[263] Fix | Delete

$count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(ID) FROM $wpdb->posts WHERE post_type = %s", 'revision' ) );

[264] Fix | Delete

break;

[265] Fix | Delete

case 'auto_drafts':

[266] Fix | Delete

$count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(ID) FROM $wpdb->posts WHERE post_status = %s", 'auto-draft' ) );

[267] Fix | Delete

break;

[268] Fix | Delete

case 'trash':

[269] Fix | Delete

$count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(ID) FROM $wpdb->posts WHERE post_status = %s", 'trash' ) );

[270] Fix | Delete

break;

[271] Fix | Delete

case 'orphan_postmeta':

[272] Fix | Delete

$count = $wpdb->get_var( "SELECT COUNT(meta_id) FROM $wpdb->postmeta WHERE post_id NOT IN (SELECT ID FROM $wpdb->posts)" );

[273] Fix | Delete

break;

[274] Fix | Delete

case 'orphan_commentmeta':

[275] Fix | Delete

$count = $wpdb->get_var( "SELECT COUNT(meta_id) FROM $wpdb->commentmeta WHERE comment_id NOT IN (SELECT comment_ID FROM $wpdb->comments)" );

[276] Fix | Delete

break;

[277] Fix | Delete

case 'orphan_usermeta':

[278] Fix | Delete

$count = $wpdb->get_var( "SELECT COUNT(umeta_id) FROM $wpdb->usermeta WHERE user_id NOT IN (SELECT ID FROM $wpdb->users)" );

[279] Fix | Delete

break;

[280] Fix | Delete

case 'orphan_termmeta':

[281] Fix | Delete

$count = $wpdb->get_var( "SELECT COUNT(meta_id) FROM $wpdb->termmeta WHERE term_id NOT IN (SELECT term_id FROM $wpdb->terms)" );

[282] Fix | Delete

break;

[283] Fix | Delete

[284] Fix | Delete

case 'duplicated_postmeta':

[285] Fix | Delete

$query = $wpdb->get_col( $wpdb->prepare( "SELECT COUNT(meta_id) AS count FROM $wpdb->postmeta GROUP BY post_id, meta_key, meta_value HAVING count > %d", 1 ) );

[286] Fix | Delete

if( is_array( $query ) ) {

[287] Fix | Delete

$count = array_sum( array_map( 'intval', $query ) );

[288] Fix | Delete

}

[289] Fix | Delete

break;

[290] Fix | Delete

case 'duplicated_commentmeta':

[291] Fix | Delete

$query = $wpdb->get_col( $wpdb->prepare( "SELECT COUNT(meta_id) AS count FROM $wpdb->commentmeta GROUP BY comment_id, meta_key, meta_value HAVING count > %d", 1 ) );

[292] Fix | Delete

if( is_array( $query ) ) {

[293] Fix | Delete

$count = array_sum( array_map( 'intval', $query ) );

[294] Fix | Delete

}

[295] Fix | Delete

break;

[296] Fix | Delete

case 'duplicated_usermeta':

[297] Fix | Delete

$query = $wpdb->get_col( $wpdb->prepare( "SELECT COUNT(umeta_id) AS count FROM $wpdb->usermeta GROUP BY user_id, meta_key, meta_value HAVING count > %d", 1 ) );

[298] Fix | Delete

if( is_array( $query ) ) {

[299] Fix | Delete

$count = array_sum( array_map( 'intval', $query ) );

[300] Fix | Delete

}

[301] Fix | Delete

break;

[302] Fix | Delete

case 'duplicated_termmeta':

[303] Fix | Delete

$query = $wpdb->get_col( $wpdb->prepare( "SELECT COUNT(meta_id) AS count FROM $wpdb->termmeta GROUP BY term_id, meta_key, meta_value HAVING count > %d", 1 ) );

[304] Fix | Delete

if( is_array( $query ) ) {

[305] Fix | Delete

$count = array_sum( array_map( 'intval', $query ) );

[306] Fix | Delete

}

[307] Fix | Delete

break;

[308] Fix | Delete

[309] Fix | Delete

}

[310] Fix | Delete

return $count;

[311] Fix | Delete

}

[312] Fix | Delete

[313] Fix | Delete

/**

[314] Fix | Delete

* Get Comment Count by status

[315] Fix | Delete

*

[316] Fix | Delete

* @access public

[317] Fix | Delete

* @since 1.0

[318] Fix | Delete

* @param array $status status

[319] Fix | Delete

* @return int | posts count.

[320] Fix | Delete

*/

[321] Fix | Delete

public function get_comment_count( $status = '' ) {

[322] Fix | Delete

global $wpdb;

[323] Fix | Delete

[324] Fix | Delete

$count = 0;

[325] Fix | Delete

[326] Fix | Delete

switch( $status ) {

[327] Fix | Delete

[328] Fix | Delete

case 'pending':

[329] Fix | Delete

$count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(comment_ID) FROM $wpdb->comments WHERE comment_approved = %s", '0' ) );

[330] Fix | Delete

break;

[331] Fix | Delete

[332] Fix | Delete

case 'spam':

[333] Fix | Delete

$count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(comment_ID) FROM $wpdb->comments WHERE comment_approved = %s", 'spam' ) );

[334] Fix | Delete

break;

[335] Fix | Delete

[336] Fix | Delete

case 'trash':

[337] Fix | Delete

$count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(comment_ID) FROM $wpdb->comments WHERE (comment_approved = %s OR comment_approved = %s)", 'trash', 'post-trashed' ) );

[338] Fix | Delete

break;

[339] Fix | Delete

[340] Fix | Delete

case 'approved':

[341] Fix | Delete

$count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(comment_ID) FROM $wpdb->comments WHERE comment_approved = %s", '1' ) );

[342] Fix | Delete

break;

[343] Fix | Delete

[344] Fix | Delete

default:

[345] Fix | Delete

$count = 0;

[346] Fix | Delete

break;

[347] Fix | Delete

}

[348] Fix | Delete

[349] Fix | Delete

return $count;

[350] Fix | Delete

}

[351] Fix | Delete

[352] Fix | Delete

[353] Fix | Delete

/**

[354] Fix | Delete

* Run Cleanup

[355] Fix | Delete

*

[356] Fix | Delete

* @access public

[357] Fix | Delete

* @since 1.0

[358] Fix | Delete

* @param array $cleanuptype Cleanup type.

[359] Fix | Delete

* @return string | message.

[360] Fix | Delete

*/

[361] Fix | Delete

public function run_cleanup( $cleanuptype = '' ){

[362] Fix | Delete

global $wpdb;

[363] Fix | Delete

$message = '';

[364] Fix | Delete

[365] Fix | Delete

switch( $cleanuptype ) {

[366] Fix | Delete

case 'revision':

[367] Fix | Delete

$posts = $wpdb->get_col( $wpdb->prepare( "SELECT ID FROM $wpdb->posts WHERE post_type = %s", 'revision' ) );

[368] Fix | Delete

if( $posts ) {

[369] Fix | Delete

foreach ( $posts as $id ) {

[370] Fix | Delete

wp_delete_post_revision( intval( $id ) );

[371] Fix | Delete

}

[372] Fix | Delete

[373] Fix | Delete

$message = sprintf( __( '%s Revisions Cleaned up', 'wp-bulk-delete' ), number_format_i18n( sizeof( $posts ) ) );

[374] Fix | Delete

}

[375] Fix | Delete

break;

[376] Fix | Delete

case 'auto_drafts':

[377] Fix | Delete

$posts = $wpdb->get_col( $wpdb->prepare( "SELECT ID FROM $wpdb->posts WHERE post_status = %s", 'auto-draft' ) );

[378] Fix | Delete

if( $posts ) {

[379] Fix | Delete

foreach ( $posts as $id ) {

[380] Fix | Delete

wp_delete_post( intval( $id ), true );

[381] Fix | Delete

}

[382] Fix | Delete

[383] Fix | Delete

$message = sprintf( __( '%s Auto Drafts Cleaned up', 'wp-bulk-delete' ), number_format_i18n( sizeof( $posts ) ) );

[384] Fix | Delete

}

[385] Fix | Delete

break;

[386] Fix | Delete

case 'trash':

[387] Fix | Delete

$posts = $wpdb->get_col( $wpdb->prepare( "SELECT ID FROM $wpdb->posts WHERE post_status = %s", 'trash' ) );

[388] Fix | Delete

if( $posts ) {

[389] Fix | Delete

foreach ( $posts as $id ) {

[390] Fix | Delete

wp_delete_post( $id, true );

[391] Fix | Delete

}

[392] Fix | Delete

[393] Fix | Delete

$message = sprintf( __( '%s Trashed Posts Cleaned up', 'wp-bulk-delete' ), number_format_i18n( sizeof( $posts ) ) );

[394] Fix | Delete

}

[395] Fix | Delete

break;

[396] Fix | Delete

[397] Fix | Delete

case 'orphan_postmeta':

[398] Fix | Delete

$query = $wpdb->get_results( "SELECT post_id, meta_key FROM $wpdb->postmeta WHERE post_id NOT IN (SELECT ID FROM $wpdb->posts)" );

[399] Fix | Delete

if( $query ) {

[400] Fix | Delete

foreach ( $query as $meta ) {

[401] Fix | Delete

$post_id = intval( $meta->post_id );

[402] Fix | Delete

if( $post_id === 0 ) {

[403] Fix | Delete

$wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->postmeta WHERE post_id = %d AND meta_key = %s", $post_id, $meta->meta_key ) );

[404] Fix | Delete

} else {

[405] Fix | Delete

delete_post_meta( $post_id, $meta->meta_key );

[406] Fix | Delete

}

[407] Fix | Delete

}

[408] Fix | Delete

[409] Fix | Delete

$message = sprintf( __( '%s Orphaned Post Meta Cleaned up', 'wp-bulk-delete' ), number_format_i18n( sizeof( $query ) ) );

[410] Fix | Delete

}

[411] Fix | Delete

break;

[412] Fix | Delete

case 'orphan_commentmeta':

[413] Fix | Delete

$query = $wpdb->get_results( "SELECT comment_id, meta_key FROM $wpdb->commentmeta WHERE comment_id NOT IN (SELECT comment_ID FROM $wpdb->comments)" );

[414] Fix | Delete

if( $query ) {

[415] Fix | Delete

foreach ( $query as $meta ) {

[416] Fix | Delete

$comment_id = intval( $meta->comment_id );

[417] Fix | Delete

if( $comment_id === 0 ) {

[418] Fix | Delete

$wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->commentmeta WHERE comment_id = %d AND meta_key = %s", $comment_id, $meta->meta_key ) );

[419] Fix | Delete

} else {

[420] Fix | Delete

delete_comment_meta( $comment_id, $meta->meta_key );

[421] Fix | Delete

}

[422] Fix | Delete

}

[423] Fix | Delete

[424] Fix | Delete

$message = sprintf( __( '%s Orphaned Comment Meta Cleaned up', 'wp-bulk-delete' ), number_format_i18n( sizeof( $query ) ) );

[425] Fix | Delete

}

[426] Fix | Delete

break;

[427] Fix | Delete

case 'orphan_usermeta':

[428] Fix | Delete

$query = $wpdb->get_results( "SELECT user_id, meta_key FROM $wpdb->usermeta WHERE user_id NOT IN (SELECT ID FROM $wpdb->users)" );

[429] Fix | Delete

if( $query ) {

[430] Fix | Delete

foreach ( $query as $meta ) {

[431] Fix | Delete

$user_id = intval( $meta->user_id );

[432] Fix | Delete

if( $user_id === 0 ) {

[433] Fix | Delete

$wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->usermeta WHERE user_id = %d AND meta_key = %s", $user_id, $meta->meta_key ) );

[434] Fix | Delete

} else {

[435] Fix | Delete

delete_user_meta( $user_id, $meta->meta_key );

[436] Fix | Delete

}

[437] Fix | Delete

}

[438] Fix | Delete

[439] Fix | Delete

$message = sprintf( __( '%s Orphaned User Meta Cleaned up', 'wp-bulk-delete' ), number_format_i18n( sizeof( $query ) ) );

[440] Fix | Delete

}

[441] Fix | Delete

break;

[442] Fix | Delete

case 'orphan_termmeta':

[443] Fix | Delete

$query = $wpdb->get_results( "SELECT term_id, meta_key FROM $wpdb->termmeta WHERE term_id NOT IN (SELECT term_id FROM $wpdb->terms)" );

[444] Fix | Delete

if( $query ) {

[445] Fix | Delete

foreach ( $query as $meta ) {

[446] Fix | Delete

$term_id = intval( $meta->term_id );

[447] Fix | Delete

if( $term_id === 0 ) {

[448] Fix | Delete

$wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->termmeta WHERE term_id = %d AND meta_key = %s", $term_id, $meta->meta_key ) );

[449] Fix | Delete

} else {

[450] Fix | Delete

delete_term_meta( $term_id, $meta->meta_key );

[451] Fix | Delete

}

[452] Fix | Delete

}

[453] Fix | Delete

[454] Fix | Delete

$message = sprintf( __( '%s Orphaned Term Meta Cleaned up', 'wp-bulk-delete' ), number_format_i18n( sizeof( $query ) ) );

[455] Fix | Delete

}

[456] Fix | Delete

break;

[457] Fix | Delete

[458] Fix | Delete

case 'duplicated_postmeta':

[459] Fix | Delete

$query = $wpdb->get_results( $wpdb->prepare( "SELECT GROUP_CONCAT(meta_id ORDER BY meta_id DESC) AS ids, post_id, COUNT(*) AS count FROM $wpdb->postmeta GROUP BY post_id, meta_key, meta_value HAVING count > %d", 1 ) );

[460] Fix | Delete

if( $query ) {

[461] Fix | Delete

foreach ( $query as $meta ) {

[462] Fix | Delete

$ids = array_map( 'intval', explode( ',', $meta->ids ) );

[463] Fix | Delete

array_pop( $ids );

[464] Fix | Delete

$wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->postmeta WHERE meta_id IN (" . implode( ',', $ids ) . ") AND post_id = %d", intval( $meta->post_id ) ) );

[465] Fix | Delete

}

[466] Fix | Delete

[467] Fix | Delete

$message = sprintf( __( '%s Duplicated Post Meta Cleaned up', 'wp-bulk-delete' ), number_format_i18n( sizeof( $query ) ) );

[468] Fix | Delete

}

[469] Fix | Delete

break;

[470] Fix | Delete

case 'duplicated_commentmeta':

[471] Fix | Delete

$query = $wpdb->get_results( $wpdb->prepare( "SELECT GROUP_CONCAT(meta_id ORDER BY meta_id DESC) AS ids, comment_id, COUNT(*) AS count FROM $wpdb->commentmeta GROUP BY comment_id, meta_key, meta_value HAVING count > %d", 1 ) );

[472] Fix | Delete

if( $query ) {

[473] Fix | Delete

foreach ( $query as $meta ) {

[474] Fix | Delete

$ids = array_map( 'intval', explode( ',', $meta->ids ) );

[475] Fix | Delete

array_pop( $ids );

[476] Fix | Delete

$wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->commentmeta WHERE meta_id IN (" . implode( ',', $ids ) . ") AND comment_id = %d", intval( $meta->comment_id ) ) );

[477] Fix | Delete

}

[478] Fix | Delete

[479] Fix | Delete

$message = sprintf( __( '%s Duplicated Comment Meta Cleaned up', 'wp-bulk-delete' ), number_format_i18n( sizeof( $query ) ) );

[480] Fix | Delete

}

[481] Fix | Delete

break;

[482] Fix | Delete

case 'duplicated_usermeta':

[483] Fix | Delete

$query = $wpdb->get_results( $wpdb->prepare( "SELECT GROUP_CONCAT(umeta_id ORDER BY umeta_id DESC) AS ids, user_id, COUNT(*) AS count FROM $wpdb->usermeta GROUP BY user_id, meta_key, meta_value HAVING count > %d", 1 ) );

[484] Fix | Delete

if( $query ) {

[485] Fix | Delete

foreach ( $query as $meta ) {

[486] Fix | Delete

$ids = array_map( 'intval', explode( ',', $meta->ids ) );

[487] Fix | Delete

array_pop( $ids );

[488] Fix | Delete

$wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->usermeta WHERE umeta_id IN (" . implode( ',', $ids ) . ") AND user_id = %d", intval( $meta->user_id ) ) );

[489] Fix | Delete

}

[490] Fix | Delete

[491] Fix | Delete

$message = sprintf( __( '%s Duplicated User Meta Cleaned up', 'wp-bulk-delete' ), number_format_i18n( sizeof( $query ) ) );

[492] Fix | Delete

}

[493] Fix | Delete

break;

[494] Fix | Delete

case 'duplicated_termmeta':

[495] Fix | Delete

$query = $wpdb->get_results( $wpdb->prepare( "SELECT GROUP_CONCAT(meta_id ORDER BY meta_id DESC) AS ids, term_id, COUNT(*) AS count FROM $wpdb->termmeta GROUP BY term_id, meta_key, meta_value HAVING count > %d", 1 ) );

[496] Fix | Delete

if( $query ) {

[497] Fix | Delete

foreach ( $query as $meta ) {

[498] Fix | Delete

$ids = array_map( 'intval', explode( ',', $meta->ids ) );

[499] Fix | Delete