<?php

[0] Fix | Delete

/**

[1] Fix | Delete

* Twitter Feed Database

[2] Fix | Delete

*

[3] Fix | Delete

* @since 2.0

[4] Fix | Delete

*/

[5] Fix | Delete

[6] Fix | Delete

namespace TwitterFeed\Builder;

[7] Fix | Delete

[8] Fix | Delete

class CTF_Db {

[9] Fix | Delete

[10] Fix | Delete

const RESULTS_PER_PAGE = 20;

[11] Fix | Delete

[12] Fix | Delete

const RESULTS_PER_CRON_UPDATE = 6;

[13] Fix | Delete

[14] Fix | Delete

[15] Fix | Delete

/**

[16] Fix | Delete

* Query the to get feeds list for Elementor

[17] Fix | Delete

*

[18] Fix | Delete

* @return array|bool

[19] Fix | Delete

*

[20] Fix | Delete

* @since 2.0

[21] Fix | Delete

*/

[22] Fix | Delete

public static function elementor_feeds_query() {

[23] Fix | Delete

global $wpdb;

[24] Fix | Delete

$feeds_elementor = [];

[25] Fix | Delete

$feeds_table_name = $wpdb->prefix . 'ctf_feeds';

[26] Fix | Delete

$feeds_list = $wpdb->get_results( "

[27] Fix | Delete

SELECT id, feed_name FROM $feeds_table_name;

[28] Fix | Delete

"

[29] Fix | Delete

);

[30] Fix | Delete

if ( ! empty( $feeds_list ) ) {

[31] Fix | Delete

foreach($feeds_list as $feed) {

[32] Fix | Delete

$feeds_elementor[$feed->id] = $feed->feed_name;

[33] Fix | Delete

}

[34] Fix | Delete

}

[35] Fix | Delete

return $feeds_elementor;

[36] Fix | Delete

}

[37] Fix | Delete

[38] Fix | Delete

[39] Fix | Delete

/**

[40] Fix | Delete

* Count the ctf_feeds table

[41] Fix | Delete

*

[42] Fix | Delete

* @param array $args

[43] Fix | Delete

*

[44] Fix | Delete

* @return array|bool

[45] Fix | Delete

*

[46] Fix | Delete

* @since 2.0

[47] Fix | Delete

*/

[48] Fix | Delete

public static function feeds_count() {

[49] Fix | Delete

global $wpdb;

[50] Fix | Delete

$feeds_table_name = $wpdb->prefix . 'ctf_feeds';

[51] Fix | Delete

$results = $wpdb->get_results(

[52] Fix | Delete

"SELECT COUNT(*) AS num_entries FROM $feeds_table_name", ARRAY_A

[53] Fix | Delete

);

[54] Fix | Delete

return isset($results[0]['num_entries']) ? (int)$results[0]['num_entries'] : 0;

[55] Fix | Delete

}

[56] Fix | Delete

[57] Fix | Delete

[58] Fix | Delete

/**

[59] Fix | Delete

* Query the ctf_feeds table

[60] Fix | Delete

*

[61] Fix | Delete

* @param array $args

[62] Fix | Delete

*

[63] Fix | Delete

* @return array|bool

[64] Fix | Delete

*

[65] Fix | Delete

* @since 2.0

[66] Fix | Delete

*/

[67] Fix | Delete

public static function feeds_query( $args = array() ) {

[68] Fix | Delete

global $wpdb;

[69] Fix | Delete

$feeds_table_name = $wpdb->prefix . 'ctf_feeds';

[70] Fix | Delete

$page = 0;

[71] Fix | Delete

if ( isset( $args['page'] ) ) {

[72] Fix | Delete

$page = (int)$args['page'] - 1;

[73] Fix | Delete

unset( $args['page'] );

[74] Fix | Delete

}

[75] Fix | Delete

[76] Fix | Delete

$offset = max( 0, $page * self::RESULTS_PER_PAGE );

[77] Fix | Delete

[78] Fix | Delete

if ( isset( $args['id'] ) ) {

[79] Fix | Delete

$sql = $wpdb->prepare( "

[80] Fix | Delete

SELECT * FROM $feeds_table_name

[81] Fix | Delete

WHERE id = %d;

[82] Fix | Delete

", $args['id'] );

[83] Fix | Delete

} else {

[84] Fix | Delete

$sql = $wpdb->prepare( "

[85] Fix | Delete

SELECT * FROM $feeds_table_name

[86] Fix | Delete

LIMIT %d

[87] Fix | Delete

OFFSET %d;", self::RESULTS_PER_PAGE, $offset );

[88] Fix | Delete

}

[89] Fix | Delete

[90] Fix | Delete

return $wpdb->get_results( $sql, ARRAY_A );

[91] Fix | Delete

}

[92] Fix | Delete

[93] Fix | Delete

/**

[94] Fix | Delete

* Update feed data in the ctf_feed table

[95] Fix | Delete

*

[96] Fix | Delete

* @param array $to_update

[97] Fix | Delete

* @param array $where_data

[98] Fix | Delete

*

[99] Fix | Delete

* @return false|int

[100] Fix | Delete

*

[101] Fix | Delete

* @since 2.0

[102] Fix | Delete

*/

[103] Fix | Delete

public static function feeds_update( $to_update, $where_data ) {

[104] Fix | Delete

global $wpdb;

[105] Fix | Delete

$feeds_table_name = $wpdb->prefix . 'ctf_feeds';

[106] Fix | Delete

[107] Fix | Delete

$data = array();

[108] Fix | Delete

$where = array();

[109] Fix | Delete

$format = array();

[110] Fix | Delete

foreach ( $to_update as $single_insert ) {

[111] Fix | Delete

if ( $single_insert['key'] ) {

[112] Fix | Delete

$data[ $single_insert['key'] ] = $single_insert['values'][0];

[113] Fix | Delete

$format[] = '%s';

[114] Fix | Delete

}

[115] Fix | Delete

}

[116] Fix | Delete

[117] Fix | Delete

if ( isset( $where_data['id'] ) ) {

[118] Fix | Delete

$where['id'] = $where_data['id'];

[119] Fix | Delete

$where_format = array( '%d' );

[120] Fix | Delete

} elseif ( isset( $where_data['feed_name'] ) ) {

[121] Fix | Delete

$where['feed_name'] = $where_data['feed_name'];

[122] Fix | Delete

$where_format = array( '%s' );

[123] Fix | Delete

} else {

[124] Fix | Delete

return false;

[125] Fix | Delete

}

[126] Fix | Delete

[127] Fix | Delete

$data['last_modified'] = date( 'Y-m-d H:i:s' );

[128] Fix | Delete

$format[] = '%s';

[129] Fix | Delete

[130] Fix | Delete

$affected = $wpdb->update( $feeds_table_name, $data, $where, $format, $where_format );

[131] Fix | Delete

[132] Fix | Delete

return $affected;

[133] Fix | Delete

}

[134] Fix | Delete

[135] Fix | Delete

/**

[136] Fix | Delete

* New feed data is added to the ctf_feeds table and

[137] Fix | Delete

* the new insert ID is returned

[138] Fix | Delete

*

[139] Fix | Delete

* @param array $to_insert

[140] Fix | Delete

*

[141] Fix | Delete

* @return false|int

[142] Fix | Delete

*

[143] Fix | Delete

* @since 2.0

[144] Fix | Delete

*/

[145] Fix | Delete

public static function feeds_insert( $to_insert ) {

[146] Fix | Delete

global $wpdb;

[147] Fix | Delete

$feeds_table_name = $wpdb->prefix . 'ctf_feeds';

[148] Fix | Delete

[149] Fix | Delete

$data = array();

[150] Fix | Delete

$format = array();

[151] Fix | Delete

foreach ( $to_insert as $single_insert ) {

[152] Fix | Delete

if ( $single_insert['key'] ) {

[153] Fix | Delete

$data[ $single_insert['key'] ] = $single_insert['values'][0];

[154] Fix | Delete

$format[] = '%s';

[155] Fix | Delete

}

[156] Fix | Delete

}

[157] Fix | Delete

[158] Fix | Delete

$data['last_modified'] = date( 'Y-m-d H:i:s' );

[159] Fix | Delete

$format[] = '%s';

[160] Fix | Delete

[161] Fix | Delete

$data['author'] = get_current_user_id();

[162] Fix | Delete

$format[] = '%d';

[163] Fix | Delete

[164] Fix | Delete

$wpdb->insert( $feeds_table_name, $data, $format );

[165] Fix | Delete

return $wpdb->insert_id;

[166] Fix | Delete

}

[167] Fix | Delete

[168] Fix | Delete

/**

[169] Fix | Delete

* Query the ctf_feeds table

[170] Fix | Delete

* Porcess to define the name of the feed when adding new

[171] Fix | Delete

*

[172] Fix | Delete

* @param array $args

[173] Fix | Delete

*

[174] Fix | Delete

* @return array|bool

[175] Fix | Delete

*

[176] Fix | Delete

* @since 2.0

[177] Fix | Delete

*/

[178] Fix | Delete

public static function feeds_query_name( $feedname ) {

[179] Fix | Delete

global $wpdb;

[180] Fix | Delete

$feeds_table_name = $wpdb->prefix . 'ctf_feeds';

[181] Fix | Delete

$sql = $wpdb->prepare(

[182] Fix | Delete

"SELECT * FROM $feeds_table_name

[183] Fix | Delete

WHERE feed_name LIKE %s;",

[184] Fix | Delete

$wpdb->esc_like($feedname) . '%'

[185] Fix | Delete

);

[186] Fix | Delete

$count = sizeof($wpdb->get_results( $sql, ARRAY_A ));

[187] Fix | Delete

return ($count == 0) ? $feedname : $feedname .' ('. ($count+1) .')';

[188] Fix | Delete

}

[189] Fix | Delete

[190] Fix | Delete

[191] Fix | Delete

[192] Fix | Delete

/**

[193] Fix | Delete

* Query to Remove Feeds from Database

[194] Fix | Delete

*

[195] Fix | Delete

* @param array $feed_ids_array array of feed IDs to be deleted.

[196] Fix | Delete

*

[197] Fix | Delete

* @since 2.0

[198] Fix | Delete

*/

[199] Fix | Delete

public static function delete_feeds_query($feed_ids_array)

[200] Fix | Delete

{

[201] Fix | Delete

global $wpdb;

[202] Fix | Delete

$feeds_table_name = $wpdb->prefix . 'ctf_feeds';

[203] Fix | Delete

$feed_caches_table_name = $wpdb->prefix . 'ctf_feed_caches';

[204] Fix | Delete

$sanitized_feed_ids_array = array();

[205] Fix | Delete

foreach ($feed_ids_array as $id) {

[206] Fix | Delete

$sanitized_feed_ids_array[] = absint($id);

[207] Fix | Delete

}

[208] Fix | Delete

$feed_ids_array = implode(',', $sanitized_feed_ids_array);

[209] Fix | Delete

$wpdb->query(

[210] Fix | Delete

"DELETE FROM $feeds_table_name WHERE id IN ($feed_ids_array)"

[211] Fix | Delete

);

[212] Fix | Delete

$wpdb->query(

[213] Fix | Delete

"DELETE FROM $feed_caches_table_name WHERE feed_id IN ($feed_ids_array)"

[214] Fix | Delete

);

[215] Fix | Delete

[216] Fix | Delete

echo ctf_json_encode(CTF_Feed_Builder::get_feed_list());

[217] Fix | Delete

wp_die();

[218] Fix | Delete

}

[219] Fix | Delete

[220] Fix | Delete

[221] Fix | Delete

/**

[222] Fix | Delete

* Query to Duplicate a Single Feed

[223] Fix | Delete

*

[224] Fix | Delete

* @param array $args

[225] Fix | Delete

*

[226] Fix | Delete

* @return array|bool

[227] Fix | Delete

*

[228] Fix | Delete

* @since 2.0

[229] Fix | Delete

*/

[230] Fix | Delete

public static function duplicate_feed_query( $feed_id ){

[231] Fix | Delete

global $wpdb;

[232] Fix | Delete

$feeds_table_name = $wpdb->prefix . 'ctf_feeds';

[233] Fix | Delete

$wpdb->query(

[234] Fix | Delete

$wpdb->prepare(

[235] Fix | Delete

"INSERT INTO $feeds_table_name (feed_name, settings, author, status)

[236] Fix | Delete

SELECT CONCAT(feed_name, ' (copy)'), settings, author, status

[237] Fix | Delete

FROM $feeds_table_name

[238] Fix | Delete

WHERE id = %d; ", $feed_id

[239] Fix | Delete

)

[240] Fix | Delete

);

[241] Fix | Delete

[242] Fix | Delete

[243] Fix | Delete

[244] Fix | Delete

echo ctf_json_encode(CTF_Feed_Builder::get_feed_list());

[245] Fix | Delete

wp_die();

[246] Fix | Delete

}

[247] Fix | Delete

[248] Fix | Delete

[249] Fix | Delete

/**

[250] Fix | Delete

* Get cache records in the ctf_feed_caches table

[251] Fix | Delete

*

[252] Fix | Delete

* @param array $args

[253] Fix | Delete

*

[254] Fix | Delete

* @return array|object|null

[255] Fix | Delete

*/

[256] Fix | Delete

public static function feed_caches_query( $args ) {

[257] Fix | Delete

global $wpdb;

[258] Fix | Delete

$feed_cache_table_name = $wpdb->prefix . 'ctf_feed_caches';

[259] Fix | Delete

[260] Fix | Delete

if ( ! isset( $args['cron_update'] ) ) {

[261] Fix | Delete

$sql = "

[262] Fix | Delete

SELECT * FROM $feed_cache_table_name;";

[263] Fix | Delete

} else {

[264] Fix | Delete

if ( ! isset( $args['additional_batch'] ) ) {

[265] Fix | Delete

$sql = $wpdb->prepare( "

[266] Fix | Delete

SELECT * FROM $feed_cache_table_name

[267] Fix | Delete

WHERE cron_update = 'yes'

[268] Fix | Delete

AND feed_id != 'legacy'

[269] Fix | Delete

ORDER BY last_updated ASC

[270] Fix | Delete

LIMIT %d;", self::RESULTS_PER_CRON_UPDATE );

[271] Fix | Delete

} else {

[272] Fix | Delete

$sql = $wpdb->prepare( "

[273] Fix | Delete

SELECT * FROM $feed_cache_table_name

[274] Fix | Delete

WHERE cron_update = 'yes'

[275] Fix | Delete

AND last_updated < %s

[276] Fix | Delete

AND feed_id != 'legacy'

[277] Fix | Delete

ORDER BY last_updated ASC

[278] Fix | Delete

LIMIT %d;", date( 'Y-m-d H:i:s', time() - HOUR_IN_SECONDS ), self::RESULTS_PER_CRON_UPDATE );

[279] Fix | Delete

}

[280] Fix | Delete

[281] Fix | Delete

}

[282] Fix | Delete

[283] Fix | Delete

return $wpdb->get_results( $sql, ARRAY_A );

[284] Fix | Delete

}

[285] Fix | Delete

[286] Fix | Delete

[287] Fix | Delete

/**

[288] Fix | Delete

* Creates all database tables used in the new admin area in

[289] Fix | Delete

* the 6.0 update.

[290] Fix | Delete

*

[291] Fix | Delete

* TODO: Add error reporting

[292] Fix | Delete

*

[293] Fix | Delete

* @since 2.0

[294] Fix | Delete

*/

[295] Fix | Delete

public static function create_tables() {

[296] Fix | Delete

if ( !function_exists( 'dbDelta' ) ) {

[297] Fix | Delete

require_once ABSPATH . '/wp-admin/includes/upgrade.php';

[298] Fix | Delete

}

[299] Fix | Delete

[300] Fix | Delete

global $wpdb;

[301] Fix | Delete

$max_index_length = 191;

[302] Fix | Delete

$charset_collate = '';

[303] Fix | Delete

if ( method_exists( $wpdb, 'get_charset_collate' ) ) { // get_charset_collate introduced in WP 3.5

[304] Fix | Delete

$charset_collate = $wpdb->get_charset_collate();

[305] Fix | Delete

}

[306] Fix | Delete

[307] Fix | Delete

$feeds_table_name = $wpdb->prefix . 'ctf_feeds';

[308] Fix | Delete

[309] Fix | Delete

if ( $wpdb->get_var( "show tables like '$feeds_table_name'" ) != $feeds_table_name ) {

[310] Fix | Delete

$sql = "

[311] Fix | Delete

CREATE TABLE $feeds_table_name (

[312] Fix | Delete

id bigint(20) unsigned NOT NULL auto_increment,

[313] Fix | Delete

feed_name text NOT NULL default '',

[314] Fix | Delete

feed_title text NOT NULL default '',

[315] Fix | Delete

settings longtext NOT NULL default '',

[316] Fix | Delete

author bigint(20) unsigned NOT NULL default '1',

[317] Fix | Delete

status varchar(255) NOT NULL default '',

[318] Fix | Delete

last_modified datetime NOT NULL default '0000-00-00 00:00:00',

[319] Fix | Delete

PRIMARY KEY (id),

[320] Fix | Delete

KEY author (author)

[321] Fix | Delete

) $charset_collate;

[322] Fix | Delete

";

[323] Fix | Delete

$wpdb->query( $sql );

[324] Fix | Delete

}

[325] Fix | Delete

$error = $wpdb->last_error;

[326] Fix | Delete

$query = $wpdb->last_query;

[327] Fix | Delete

$had_error = false;

[328] Fix | Delete

if ( $wpdb->get_var( "show tables like '$feeds_table_name'" ) != $feeds_table_name ) {

[329] Fix | Delete

$had_error = true;

[330] Fix | Delete

//$sb_instagram_posts_manager->add_error( 'database_create', '<strong>' . __( 'There was an error when trying to create the database tables used to locate feeds.', 'custom-twitter-feeds' ) .'</strong><br>' . $error . '<br><code>' . $query . '</code>' );

[331] Fix | Delete

}

[332] Fix | Delete

[333] Fix | Delete

if ( ! $had_error ) {

[334] Fix | Delete

//$sb_instagram_posts_manager->remove_error( 'database_create' );

[335] Fix | Delete

}

[336] Fix | Delete

[337] Fix | Delete

$feed_caches_table_name = $wpdb->prefix . 'ctf_feed_caches';

[338] Fix | Delete

[339] Fix | Delete

if ( $wpdb->get_var( "show tables like '$feed_caches_table_name'" ) != $feed_caches_table_name ) {

[340] Fix | Delete

$sql = "

[341] Fix | Delete

CREATE TABLE " . $feed_caches_table_name . " (

[342] Fix | Delete

id bigint(20) unsigned NOT NULL auto_increment,

[343] Fix | Delete

feed_id varchar(255) NOT NULL default '',

[344] Fix | Delete

cache_key varchar(255) NOT NULL default '',

[345] Fix | Delete

cache_value longtext NOT NULL default '',

[346] Fix | Delete

cron_update varchar(20) NOT NULL default 'yes',

[347] Fix | Delete

last_updated datetime NOT NULL default '0000-00-00 00:00:00',

[348] Fix | Delete

PRIMARY KEY (id),

[349] Fix | Delete

KEY feed_id (feed_id)

[350] Fix | Delete

) $charset_collate;";

[351] Fix | Delete

$wpdb->query( $sql );

[352] Fix | Delete

}

[353] Fix | Delete

$error = $wpdb->last_error;

[354] Fix | Delete

$query = $wpdb->last_query;

[355] Fix | Delete

$had_error = false;

[356] Fix | Delete

if ( $wpdb->get_var( "show tables like '$feed_caches_table_name'" ) != $feed_caches_table_name ) {

[357] Fix | Delete

$had_error = true;

[358] Fix | Delete

//$sb_instagram_posts_manager->add_error( 'database_create', '<strong>' . __( 'There was an error when trying to create the database tables used to locate feeds.', 'custom-twitter-feeds' ) .'</strong><br>' . $error . '<br><code>' . $query . '</code>' );

[359] Fix | Delete

}

[360] Fix | Delete

[361] Fix | Delete

if ( ! $had_error ) {

[362] Fix | Delete

//$sb_instagram_posts_manager->remove_error( 'database_create' );

[363] Fix | Delete

}

[364] Fix | Delete

[365] Fix | Delete

[366] Fix | Delete

if ( ! $had_error ) {

[367] Fix | Delete

//$sb_instagram_posts_manager->remove_error( 'database_create' );

[368] Fix | Delete

}

[369] Fix | Delete

}

[370] Fix | Delete

[371] Fix | Delete

[372] Fix | Delete

[373] Fix | Delete

public static function clear_ctf_feed_caches() {

[374] Fix | Delete

global $wpdb;

[375] Fix | Delete

$feed_caches_table_name = $wpdb->prefix . 'ctf_feed_caches';

[376] Fix | Delete

[377] Fix | Delete

if ( $wpdb->get_var( "show tables like '$feed_caches_table_name'" ) === $feed_caches_table_name ) {

[378] Fix | Delete

$wpdb->query( "DELETE FROM $feed_caches_table_name" );

[379] Fix | Delete

}

[380] Fix | Delete

}

[381] Fix | Delete

[382] Fix | Delete

[383] Fix | Delete

public static function reset_tables() {

[384] Fix | Delete

global $wpdb;

[385] Fix | Delete

$feeds_table_name = $wpdb->prefix . 'ctf_feeds';

[386] Fix | Delete

[387] Fix | Delete

$wpdb->query( "DROP TABLE IF EXISTS $feeds_table_name" );

[388] Fix | Delete

$feed_caches_table_name = $wpdb->prefix . 'ctf_feed_caches';

[389] Fix | Delete

[390] Fix | Delete

$wpdb->query( "DROP TABLE IF EXISTS $feed_caches_table_name" );

[391] Fix | Delete

[392] Fix | Delete

}

[393] Fix | Delete

[394] Fix | Delete

public static function reset_db_update() {

[395] Fix | Delete

update_option( 'ctf_db_version', 1.3 );

[396] Fix | Delete

delete_option( 'ctf_legacy_feed_settings' );

[397] Fix | Delete

[398] Fix | Delete

// are there existing feeds to toggle legacy onboarding?

[399] Fix | Delete

$ctf_statuses_option = get_option( 'ctf_statuses', array() );

[400] Fix | Delete

[401] Fix | Delete

if ( isset( $ctf_statuses_option['legacy_onboarding'] ) ) {

[402] Fix | Delete

unset( $ctf_statuses_option['legacy_onboarding'] );

[403] Fix | Delete

}

[404] Fix | Delete

if ( isset( $ctf_statuses_option['support_legacy_shortcode'] ) ) {

[405] Fix | Delete

unset( $ctf_statuses_option['support_legacy_shortcode'] );

[406] Fix | Delete

}

[407] Fix | Delete

[408] Fix | Delete

global $wpdb;

[409] Fix | Delete

[410] Fix | Delete

$table_name = $wpdb->prefix . "usermeta";

[411] Fix | Delete

$wpdb->query( "

[412] Fix | Delete

DELETE

[413] Fix | Delete

FROM $table_name

[414] Fix | Delete

WHERE `meta_key` LIKE ('ctf\_%')

[415] Fix | Delete

" );

[416] Fix | Delete

[417] Fix | Delete

[418] Fix | Delete

$feed_locator_table_name = esc_sql( $wpdb->prefix . CTF_FEED_LOCATOR );

[419] Fix | Delete

[420] Fix | Delete

$results = $wpdb->query( "

[421] Fix | Delete

DELETE

[422] Fix | Delete

FROM $feed_locator_table_name

[423] Fix | Delete

WHERE feed_id LIKE '*%';" );

[424] Fix | Delete

[425] Fix | Delete

update_option( 'ctf_statuses', $ctf_statuses_option );

[426] Fix | Delete

}

[427] Fix | Delete

[428] Fix | Delete

public static function reset_legacy() {

[429] Fix | Delete

[430] Fix | Delete

//Settings

[431] Fix | Delete

delete_option( 'ctf_statuses' );

[432] Fix | Delete

delete_option( 'ctf_options' );

[433] Fix | Delete

delete_option( 'ctf_ver' );

[434] Fix | Delete

delete_option( 'ctf_db_version' );

[435] Fix | Delete

[436] Fix | Delete

// Clear backup caches

[437] Fix | Delete

global $wpdb;

[438] Fix | Delete

$table_name = $wpdb->prefix . "options";

[439] Fix | Delete

$wpdb->query( "

[440] Fix | Delete

DELETE

[441] Fix | Delete

FROM $table_name

[442] Fix | Delete

WHERE `option_name` LIKE ('%!ctf\_%')

[443] Fix | Delete

" );

[444] Fix | Delete

$wpdb->query( "

[445] Fix | Delete

DELETE

[446] Fix | Delete

FROM $table_name

[447] Fix | Delete

WHERE `option_name` LIKE ('%\_transient\_&ctf\_%')

[448] Fix | Delete

" );

[449] Fix | Delete

$wpdb->query( "

[450] Fix | Delete

DELETE

[451] Fix | Delete

FROM $table_name

[452] Fix | Delete

WHERE `option_name` LIKE ('%\_transient\_timeout\_&ctf\_%')

[453] Fix | Delete

" );

[454] Fix | Delete

$wpdb->query( "

[455] Fix | Delete

DELETE

[456] Fix | Delete

FROM $table_name

[457] Fix | Delete

WHERE `option_name` LIKE ('%sb_wlupdated_%')

[458] Fix | Delete

" );

[459] Fix | Delete

[460] Fix | Delete

//image resizing

[461] Fix | Delete

$upload = wp_upload_dir();

[462] Fix | Delete

$posts_table_name = $wpdb->prefix . 'ctf_posts';

[463] Fix | Delete

$feeds_posts_table_name = esc_sql( $wpdb->prefix . 'ctf_feeds_posts' );

[464] Fix | Delete

[465] Fix | Delete

$image_files = glob( trailingslashit( $upload['basedir'] ) . trailingslashit( CTF_UPLOADS_NAME ) . '*' ); // get all file names

[466] Fix | Delete

foreach ( $image_files as $file ) { // iterate files

[467] Fix | Delete

if ( is_file( $file ) ) {

[468] Fix | Delete

unlink( $file );

[469] Fix | Delete

} // delete file

[470] Fix | Delete

}

[471] Fix | Delete

[472] Fix | Delete

//global $wp_filesystem;

[473] Fix | Delete

[474] Fix | Delete

//$wp_filesystem->delete( trailingslashit( $upload['basedir'] ) . trailingslashit( CTF_UPLOADS_NAME ) , true );

[475] Fix | Delete

//Delete tables

[476] Fix | Delete

$wpdb->query( "DROP TABLE IF EXISTS $posts_table_name" );

[477] Fix | Delete

$wpdb->query( "DROP TABLE IF EXISTS $feeds_posts_table_name" );

[478] Fix | Delete

$locator_table_name = $wpdb->prefix . CTF_FEED_LOCATOR;

[479] Fix | Delete

$wpdb->query( "DROP TABLE IF EXISTS $locator_table_name" );

[480] Fix | Delete

[481] Fix | Delete

$table_name = $wpdb->prefix . "options";

[482] Fix | Delete

$wpdb->query( "

[483] Fix | Delete

DELETE

[484] Fix | Delete

FROM $table_name

[485] Fix | Delete

WHERE `option_name` LIKE ('%\_transient\_\$ctf\_%')

[486] Fix | Delete

" );

[487] Fix | Delete

$wpdb->query( "

[488] Fix | Delete

DELETE

[489] Fix | Delete

FROM $table_name

[490] Fix | Delete

WHERE `option_name` LIKE ('%\_transient\_timeout\_\$ctf\_%')

[491] Fix | Delete

" );

[492] Fix | Delete

delete_option( 'ctf_usage_tracking' );

[493] Fix | Delete

delete_option( 'ctf_usage_tracking_config' );

[494] Fix | Delete

delete_option( 'ctf_configure' );

[495] Fix | Delete

delete_option( 'ctf_customize' );

[496] Fix | Delete

delete_option( 'ctf_style' );

[497] Fix | Delete

delete_option( 'ctf_options' );

[498] Fix | Delete

delete_option( 'ctf_statuses' );

[499] Fix | Delete