Edit File by line

<?php

[0] Fix | Delete

[1] Fix | Delete

namespace TwitterFeed\Admin;

[2] Fix | Delete

[3] Fix | Delete

if ( ! defined( 'ABSPATH' ) ) exit; // Exit if accessed directly

[4] Fix | Delete

[5] Fix | Delete

/**

[6] Fix | Delete

* Custom Twitter Feed Cache.

[7] Fix | Delete

[8] Fix | Delete

* @since 2.0

[9] Fix | Delete

[10] Fix | Delete

class SB_Twitter_Cache {

[11] Fix | Delete

[12] Fix | Delete

/**

[13] Fix | Delete

* @var int

[14] Fix | Delete

[15] Fix | Delete

private $feed_id;

[16] Fix | Delete

[17] Fix | Delete

/**

[18] Fix | Delete

* @var int

[19] Fix | Delete

[20] Fix | Delete

private $page;

[21] Fix | Delete

[22] Fix | Delete

/**

[23] Fix | Delete

* @var string

[24] Fix | Delete

[25] Fix | Delete

private $suffix;

[26] Fix | Delete

[27] Fix | Delete

/**

[28] Fix | Delete

* @var bool

[29] Fix | Delete

[30] Fix | Delete

private $is_legacy;

[31] Fix | Delete

[32] Fix | Delete

/**

[33] Fix | Delete

* @var int

[34] Fix | Delete

[35] Fix | Delete

private $cache_time;

[36] Fix | Delete

[37] Fix | Delete

/**

[38] Fix | Delete

* @var array

[39] Fix | Delete

[40] Fix | Delete

private $posts;

[41] Fix | Delete

[42] Fix | Delete

/**

[43] Fix | Delete

* @var array

[44] Fix | Delete

[45] Fix | Delete

private $posts_page;

[46] Fix | Delete

[47] Fix | Delete

/**

[48] Fix | Delete

* @var bool

[49] Fix | Delete

[50] Fix | Delete

private $is_expired;

[51] Fix | Delete

[52] Fix | Delete

/**

[53] Fix | Delete

* @var array

[54] Fix | Delete

[55] Fix | Delete

private $header;

[56] Fix | Delete

[57] Fix | Delete

/**

[58] Fix | Delete

* @var array

[59] Fix | Delete

[60] Fix | Delete

private $resized_images;

[61] Fix | Delete

[62] Fix | Delete

/**

[63] Fix | Delete

* @var array

[64] Fix | Delete

[65] Fix | Delete

private $meta;

[66] Fix | Delete

[67] Fix | Delete

/**

[68] Fix | Delete

* @var array

[69] Fix | Delete

[70] Fix | Delete

private $posts_backup;

[71] Fix | Delete

[72] Fix | Delete

/**

[73] Fix | Delete

* @var array

[74] Fix | Delete

[75] Fix | Delete

private $header_backup;

[76] Fix | Delete

[77] Fix | Delete

[78] Fix | Delete

/**

[79] Fix | Delete

* CTF_Cache constructor. Set the feed id, cache key, legacy

[80] Fix | Delete

[81] Fix | Delete

* @param string $feed_id

[82] Fix | Delete

* @param int $page

[83] Fix | Delete

* @param int $cache_time

[84] Fix | Delete

[85] Fix | Delete

* @since 2.0

[86] Fix | Delete

[87] Fix | Delete

public function __construct( $feed_id, $page = 1, $cache_time = 0 ) {

[88] Fix | Delete

$this->cache_time = (int) $cache_time;

[89] Fix | Delete

$this->is_legacy = strpos( $feed_id, '*' ) !== 0;

[90] Fix | Delete

$this->page = $page;

[91] Fix | Delete

[92] Fix | Delete

if ( $this->page === 1 ) {

[93] Fix | Delete

$this->suffix = '';

[94] Fix | Delete

} else {

[95] Fix | Delete

$this->suffix = '_' . $this->page;

[96] Fix | Delete

}

[97] Fix | Delete

[98] Fix | Delete

$this->feed_id = str_replace( '*', '', $feed_id );

[99] Fix | Delete

[100] Fix | Delete

if ( is_admin() ) {

[101] Fix | Delete

$this->feed_id .= $this->maybe_customizer_suffix();

[102] Fix | Delete

}

[103] Fix | Delete

[104] Fix | Delete

}

[105] Fix | Delete

[106] Fix | Delete

[107] Fix | Delete

/**

[108] Fix | Delete

* Set all caches based on available data.

[109] Fix | Delete

[110] Fix | Delete

* @since 2.0

[111] Fix | Delete

[112] Fix | Delete

public function retrieve_and_set() {

[113] Fix | Delete

[114] Fix | Delete

$expired = true;

[115] Fix | Delete

$existing_caches = $this->query_ctf_feed_caches();

[116] Fix | Delete

[117] Fix | Delete

foreach ( $existing_caches as $cache ) {

[118] Fix | Delete

switch ( $cache['cache_key'] ) {

[119] Fix | Delete

case 'posts':

[120] Fix | Delete

$this->posts = $cache['cache_value'];

[121] Fix | Delete

if ( strtotime( $cache['last_updated'] ) > time() - $this->cache_time ) {

[122] Fix | Delete

$expired = false;

[123] Fix | Delete

}

[124] Fix | Delete

[125] Fix | Delete

if ( empty( $cache['cache_value'] ) ) {

[126] Fix | Delete

$expired = true;

[127] Fix | Delete

}

[128] Fix | Delete

break;

[129] Fix | Delete

case 'posts' . $this->suffix:

[130] Fix | Delete

$this->posts_page = $cache['cache_value'];

[131] Fix | Delete

break;

[132] Fix | Delete

case 'header':

[133] Fix | Delete

$this->header = $cache['cache_value'];

[134] Fix | Delete

break;

[135] Fix | Delete

case 'resized_images' . $this->suffix:

[136] Fix | Delete

$this->resized_images = $cache['cache_value'];

[137] Fix | Delete

break;

[138] Fix | Delete

case 'meta' . $this->suffix:

[139] Fix | Delete

$this->meta = $cache['cache_value'];

[140] Fix | Delete

break;

[141] Fix | Delete

case 'posts_backup' . $this->suffix:

[142] Fix | Delete

$this->posts_backup = $cache['cache_value'];

[143] Fix | Delete

break;

[144] Fix | Delete

case 'header_backup' . $this->suffix:

[145] Fix | Delete

$this->header_backup = $cache['cache_value'];

[146] Fix | Delete

break;

[147] Fix | Delete

}

[148] Fix | Delete

}

[149] Fix | Delete

[150] Fix | Delete

$this->is_expired = $expired;

[151] Fix | Delete

[152] Fix | Delete

if ( $this->cache_time < 1 ) {

[153] Fix | Delete

$this->is_expired = true;

[154] Fix | Delete

}

[155] Fix | Delete

[156] Fix | Delete

}

[157] Fix | Delete

[158] Fix | Delete

/**

[159] Fix | Delete

* Whether or not the cache needs to be refreshed

[160] Fix | Delete

[161] Fix | Delete

* @param string $cache_type

[162] Fix | Delete

[163] Fix | Delete

* @return bool

[164] Fix | Delete

[165] Fix | Delete

* @since 2.0

[166] Fix | Delete

[167] Fix | Delete

public function is_expired( $cache_type = 'posts' ) {

[168] Fix | Delete

[169] Fix | Delete

if ( $cache_type !== 'posts' ) {

[170] Fix | Delete

$cache = $this->get( $cache_type );

[171] Fix | Delete

[172] Fix | Delete

return ( empty( $cache ) || $this->is_expired );

[173] Fix | Delete

}

[174] Fix | Delete

if ( $this->page === 1 ) {

[175] Fix | Delete

return $this->is_expired;

[176] Fix | Delete

} else {

[177] Fix | Delete

if ( $this->is_expired ) {

[178] Fix | Delete

return true;

[179] Fix | Delete

}

[180] Fix | Delete

if ( empty( $this->posts_page ) ) {

[181] Fix | Delete

return true;

[182] Fix | Delete

}

[183] Fix | Delete

}

[184] Fix | Delete

return false;

[185] Fix | Delete

}

[186] Fix | Delete

[187] Fix | Delete

[188] Fix | Delete

/**

[189] Fix | Delete

* Get data currently stored in the database for the type

[190] Fix | Delete

[191] Fix | Delete

* @param string $type

[192] Fix | Delete

[193] Fix | Delete

* @return string

[194] Fix | Delete

[195] Fix | Delete

* @since 2.0

[196] Fix | Delete

[197] Fix | Delete

public function get( $type ) {

[198] Fix | Delete

$return = array();

[199] Fix | Delete

switch ( $type ) {

[200] Fix | Delete

case 'posts':

[201] Fix | Delete

$return = $this->posts;

[202] Fix | Delete

break;

[203] Fix | Delete

case 'posts' . $this->suffix:

[204] Fix | Delete

$return = $this->posts_page;

[205] Fix | Delete

break;

[206] Fix | Delete

case 'header':

[207] Fix | Delete

$return = $this->header;

[208] Fix | Delete

break;

[209] Fix | Delete

case 'resized_images':

[210] Fix | Delete

$return = $this->resized_images;

[211] Fix | Delete

break;

[212] Fix | Delete

case 'meta':

[213] Fix | Delete

$return = $this->meta;

[214] Fix | Delete

break;

[215] Fix | Delete

case 'posts_backup':

[216] Fix | Delete

$return = $this->posts_backup;

[217] Fix | Delete

break;

[218] Fix | Delete

case 'header_backup':

[219] Fix | Delete

$return = $this->header_backup;

[220] Fix | Delete

break;

[221] Fix | Delete

}

[222] Fix | Delete

[223] Fix | Delete

return $return;

[224] Fix | Delete

}

[225] Fix | Delete

[226] Fix | Delete

/**

[227] Fix | Delete

* @param string $type

[228] Fix | Delete

* @param array $cache_value

[229] Fix | Delete

[230] Fix | Delete

* @since 2.0

[231] Fix | Delete

[232] Fix | Delete

public function set( $type, $cache_value ) {

[233] Fix | Delete

switch ( $type ) {

[234] Fix | Delete

case 'posts':

[235] Fix | Delete

$this->posts = $cache_value;

[236] Fix | Delete

break;

[237] Fix | Delete

case 'posts' . $this->suffix:

[238] Fix | Delete

$this->posts_page = $cache_value;

[239] Fix | Delete

break;

[240] Fix | Delete

case 'header':

[241] Fix | Delete

$this->header = $cache_value;

[242] Fix | Delete

break;

[243] Fix | Delete

case 'resized_images':

[244] Fix | Delete

$this->resized_images = $cache_value;

[245] Fix | Delete

break;

[246] Fix | Delete

case 'meta':

[247] Fix | Delete

$this->meta = $cache_value;

[248] Fix | Delete

break;

[249] Fix | Delete

case 'posts_backup':

[250] Fix | Delete

$this->posts_backup = $cache_value;

[251] Fix | Delete

break;

[252] Fix | Delete

case 'header_backup':

[253] Fix | Delete

$this->header_backup = $cache_value;

[254] Fix | Delete

break;

[255] Fix | Delete

}

[256] Fix | Delete

}

[257] Fix | Delete

[258] Fix | Delete

/**

[259] Fix | Delete

* Update a single cache with new data. Try to accept any data and convert it

[260] Fix | Delete

* to JSON if needed

[261] Fix | Delete

[262] Fix | Delete

* @param string $cache_type

[263] Fix | Delete

* @param array|object|string $cache_value

[264] Fix | Delete

* @param bool $include_backup

[265] Fix | Delete

* @param bool $cron_update

[266] Fix | Delete

[267] Fix | Delete

* @return int

[268] Fix | Delete

[269] Fix | Delete

* @since 2.0

[270] Fix | Delete

[271] Fix | Delete

public function update_or_insert( $cache_type, $cache_value, $include_backup = true, $cron_update = true ) {

[272] Fix | Delete

$this->clear_wp_cache();

[273] Fix | Delete

[274] Fix | Delete

if ( $this->page > 1 || ( $cache_type !== 'posts' && $cache_type !== 'header' ) ) {

[275] Fix | Delete

$cron_update = false;

[276] Fix | Delete

}

[277] Fix | Delete

[278] Fix | Delete

if ( strpos( $this->feed_id, '_CUSTOMIZER' ) !== false ) {

[279] Fix | Delete

$cron_update = false;

[280] Fix | Delete

}

[281] Fix | Delete

[282] Fix | Delete

$cache_key = $cache_type . $this->suffix;

[283] Fix | Delete

[284] Fix | Delete

$this->set( $cache_key, $cache_value );

[285] Fix | Delete

[286] Fix | Delete

if ( is_array( $cache_value ) || is_object( $cache_value ) ) {

[287] Fix | Delete

$cache_value = ctf_json_encode( $cache_value );

[288] Fix | Delete

}

[289] Fix | Delete

[290] Fix | Delete

global $wpdb;

[291] Fix | Delete

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

[292] Fix | Delete

[293] Fix | Delete

$sql = $wpdb->prepare(

[294] Fix | Delete

[295] Fix | Delete

SELECT * FROM $cache_table_name

[296] Fix | Delete

WHERE feed_id = %s

[297] Fix | Delete

AND cache_key = %s",

[298] Fix | Delete

$this->feed_id,

[299] Fix | Delete

$cache_key

[300] Fix | Delete

);

[301] Fix | Delete

[302] Fix | Delete

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

[303] Fix | Delete

$data = array();

[304] Fix | Delete

$where = array();

[305] Fix | Delete

$format = array();

[306] Fix | Delete

[307] Fix | Delete

$data['cache_value'] = $cache_value;

[308] Fix | Delete

$format[] = '%s';

[309] Fix | Delete

[310] Fix | Delete

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

[311] Fix | Delete

$format[] = '%s';

[312] Fix | Delete

[313] Fix | Delete

if ( ! empty( $existing[0] ) ) {

[314] Fix | Delete

$where['feed_id'] = $this->feed_id;

[315] Fix | Delete

$where_format[] = '%s';

[316] Fix | Delete

[317] Fix | Delete

$where['cache_key'] = $cache_key;

[318] Fix | Delete

$where_format[] = '%s';

[319] Fix | Delete

[320] Fix | Delete

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

[321] Fix | Delete

} else {

[322] Fix | Delete

$data['cache_key'] = $cache_key;

[323] Fix | Delete

$format[] = '%s';

[324] Fix | Delete

[325] Fix | Delete

$data['cron_update'] = $cron_update === true ? 'yes' : '';

[326] Fix | Delete

$format[] = '%s';

[327] Fix | Delete

[328] Fix | Delete

$data['feed_id'] = $this->feed_id;

[329] Fix | Delete

$format[] = '%s';

[330] Fix | Delete

[331] Fix | Delete

$affected = $wpdb->insert( $cache_table_name, $data, $format );

[332] Fix | Delete

}

[333] Fix | Delete

[334] Fix | Delete

return $affected;

[335] Fix | Delete

}

[336] Fix | Delete

[337] Fix | Delete

/**

[338] Fix | Delete

* Tasks to do after a new set of posts are retrieved

[339] Fix | Delete

[340] Fix | Delete

* @since 2.0

[341] Fix | Delete

[342] Fix | Delete

public function after_new_posts_retrieved() {

[343] Fix | Delete

if ( $this->page === 1 ) {

[344] Fix | Delete

$this->clear( 'all' );

[345] Fix | Delete

}

[346] Fix | Delete

}

[347] Fix | Delete

[348] Fix | Delete

/**

[349] Fix | Delete

* Resets caches after they expire

[350] Fix | Delete

[351] Fix | Delete

* @param string $type

[352] Fix | Delete

[353] Fix | Delete

* @return bool|false|int

[354] Fix | Delete

[355] Fix | Delete

* @since 2.0

[356] Fix | Delete

[357] Fix | Delete

public function clear( $type ) {

[358] Fix | Delete

$this->clear_wp_cache();

[359] Fix | Delete

[360] Fix | Delete

global $wpdb;

[361] Fix | Delete

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

[362] Fix | Delete

[363] Fix | Delete

$feed_id = str_replace( array( '_CUSTOMIZER', '_CUSTOMIZER_MODMODE' ), '', $this->feed_id );

[364] Fix | Delete

[365] Fix | Delete

if ( $type === 'all' ) {

[366] Fix | Delete

$affected = $wpdb->query(

[367] Fix | Delete

$wpdb->prepare(

[368] Fix | Delete

"UPDATE $cache_table_name

[369] Fix | Delete

SET cache_value = ''

[370] Fix | Delete

WHERE feed_id = %s

[371] Fix | Delete

AND cache_key NOT IN ( 'posts', 'posts_backup', 'header_backup' );",

[372] Fix | Delete

$feed_id

[373] Fix | Delete

)

[374] Fix | Delete

);

[375] Fix | Delete

[376] Fix | Delete

$affected = $wpdb->query(

[377] Fix | Delete

$wpdb->prepare(

[378] Fix | Delete

"UPDATE $cache_table_name

[379] Fix | Delete

SET cache_value = ''

[380] Fix | Delete

WHERE feed_id = %s",

[381] Fix | Delete

$feed_id . '_CUSTOMIZER'

[382] Fix | Delete

)

[383] Fix | Delete

);

[384] Fix | Delete

[385] Fix | Delete

$mod_mode_where = esc_sql( $feed_id ) . '_CUSTOMIZER_MODMODE%';

[386] Fix | Delete

$affected = $wpdb->query(

[387] Fix | Delete

$wpdb->prepare(

[388] Fix | Delete

"UPDATE $cache_table_name

[389] Fix | Delete

SET cache_value = ''

[390] Fix | Delete

WHERE feed_id like %s",

[391] Fix | Delete

$mod_mode_where

[392] Fix | Delete

)

[393] Fix | Delete

);

[394] Fix | Delete

} else {

[395] Fix | Delete

[396] Fix | Delete

$data = array( 'cache_value' => '' );

[397] Fix | Delete

$format = array( '%s' );

[398] Fix | Delete

[399] Fix | Delete

$where['feed_id'] = $feed_id;

[400] Fix | Delete

$where_format[] = '%s';

[401] Fix | Delete

[402] Fix | Delete

$where['cache_key'] = $type . $this->suffix;

[403] Fix | Delete

$where_format[] = '%s';

[404] Fix | Delete

[405] Fix | Delete

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

[406] Fix | Delete

[407] Fix | Delete

$where['feed_id'] = $feed_id . '_CUSTOMIZER';

[408] Fix | Delete

[409] Fix | Delete

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

[410] Fix | Delete

[411] Fix | Delete

$where['feed_id'] = $feed_id . '_CUSTOMIZER_MODMODE';

[412] Fix | Delete

[413] Fix | Delete

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

[414] Fix | Delete

}

[415] Fix | Delete

[416] Fix | Delete

return $affected;

[417] Fix | Delete

}

[418] Fix | Delete

[419] Fix | Delete

public function get_customizer_cache() {

[420] Fix | Delete

if ( strpos( $this->feed_id, '_CUSTOMIZER' ) === false ) {

[421] Fix | Delete

$feed_id = $this->feed_id . '_CUSTOMIZER';

[422] Fix | Delete

} else {

[423] Fix | Delete

$feed_id = $this->feed_id;

[424] Fix | Delete

}

[425] Fix | Delete

global $wpdb;

[426] Fix | Delete

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

[427] Fix | Delete

[428] Fix | Delete

$sql = $wpdb->prepare(

[429] Fix | Delete

[430] Fix | Delete

SELECT * FROM $cache_table_name

[431] Fix | Delete

WHERE feed_id = %s

[432] Fix | Delete

AND cache_key = 'posts'",

[433] Fix | Delete

$feed_id

[434] Fix | Delete

);

[435] Fix | Delete

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

[436] Fix | Delete

[437] Fix | Delete

$return = array();

[438] Fix | Delete

if ( ! empty( $results[0] ) ) {

[439] Fix | Delete

$return = $results[0]['cache_value'];

[440] Fix | Delete

$return = json_decode( $return, true );

[441] Fix | Delete

[442] Fix | Delete

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

[443] Fix | Delete

}

[444] Fix | Delete

[445] Fix | Delete

return $return;

[446] Fix | Delete

}

[447] Fix | Delete

[448] Fix | Delete

/**

[449] Fix | Delete

* Clears caches in the WP Options table used mostly by legacy feeds.

[450] Fix | Delete

* Also resets caches created by common page caching plugins

[451] Fix | Delete

[452] Fix | Delete

* @param false $hard_clear

[453] Fix | Delete

* @since 2.0

[454] Fix | Delete

[455] Fix | Delete

public static function clear_legacy( $hard_clear = false ) {

[456] Fix | Delete

global $wpdb;

[457] Fix | Delete

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

[458] Fix | Delete

[459] Fix | Delete

if ( $hard_clear ) {

[460] Fix | Delete

$affected = $wpdb->query(

[461] Fix | Delete

"DELETE FROM $cache_table_name

[462] Fix | Delete

WHERE feed_id LIKE ('ctf\_%')

[463] Fix | Delete

AND cache_key NOT IN ( 'posts_backup', 'header_backup' );"

[464] Fix | Delete

);

[465] Fix | Delete

} else {

[466] Fix | Delete

$affected = $wpdb->query(

[467] Fix | Delete

"UPDATE $cache_table_name

[468] Fix | Delete

SET cache_value = ''

[469] Fix | Delete

WHERE feed_id LIKE ('ctf\_%')

[470] Fix | Delete

AND cache_key NOT IN ( 'posts_backup', 'header_backup' );"

[471] Fix | Delete

);

[472] Fix | Delete

}

[473] Fix | Delete

[474] Fix | Delete

[475] Fix | Delete

[476] Fix | Delete

}

[477] Fix | Delete

[478] Fix | Delete

/**

[479] Fix | Delete

* Get all available caches from the ctf_cache table.

[480] Fix | Delete

[481] Fix | Delete

* @return array

[482] Fix | Delete

[483] Fix | Delete

* @since 2.0

[484] Fix | Delete

[485] Fix | Delete

public function query_ctf_feed_caches() {

[486] Fix | Delete

$feed_cache = wp_cache_get( $this->get_wp_cache_key() );

[487] Fix | Delete

[488] Fix | Delete

if ( false === $feed_cache ) {

[489] Fix | Delete

global $wpdb;

[490] Fix | Delete

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

[491] Fix | Delete

[492] Fix | Delete

if ( $this->page === 1 ) {

[493] Fix | Delete

$sql = $wpdb->prepare(

[494] Fix | Delete

[495] Fix | Delete

SELECT * FROM $cache_table_name

[496] Fix | Delete

WHERE feed_id = %s",

[497] Fix | Delete

$this->feed_id

[498] Fix | Delete

);

[499] Fix | Delete