Edit File by line

<?php

[0] Fix | Delete

/**

[1] Fix | Delete

* Twitter Feed Cache

[2] Fix | Delete

[3] Fix | Delete

* A bridge to use the new feed caches table

[4] Fix | Delete

[5] Fix | Delete

* @since 2.0

[6] Fix | Delete

[7] Fix | Delete

namespace TwitterFeed;

[8] Fix | Delete

[9] Fix | Delete

class CtfCache {

[10] Fix | Delete

[11] Fix | Delete

/**

[12] Fix | Delete

* @var string

[13] Fix | Delete

[14] Fix | Delete

private $feed_id;

[15] Fix | Delete

[16] Fix | Delete

/**

[17] Fix | Delete

* @var int

[18] Fix | Delete

[19] Fix | Delete

private $page;

[20] Fix | Delete

[21] Fix | Delete

/**

[22] Fix | Delete

* @var int

[23] Fix | Delete

[24] Fix | Delete

private $cache_time;

[25] Fix | Delete

[26] Fix | Delete

public function __construct( $feed_id, $cache_time, $page ) {

[27] Fix | Delete

$this->feed_id = $feed_id;

[28] Fix | Delete

[29] Fix | Delete

$this->page = $page;

[30] Fix | Delete

[31] Fix | Delete

$this->cache_time = $cache_time;

[32] Fix | Delete

[33] Fix | Delete

if ( is_admin() ) {

[34] Fix | Delete

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

[35] Fix | Delete

}

[36] Fix | Delete

}

[37] Fix | Delete

[38] Fix | Delete

/**

[39] Fix | Delete

* Mimic WP get_transient

[40] Fix | Delete

[41] Fix | Delete

* @param string $transient_name

[42] Fix | Delete

[43] Fix | Delete

* @return false|string

[44] Fix | Delete

[45] Fix | Delete

public function get_transient( $transient_name ) {

[46] Fix | Delete

$results = $this->query_ctf_feed_caches( $transient_name );

[47] Fix | Delete

[48] Fix | Delete

if ( empty( $results ) ) {

[49] Fix | Delete

return false;

[50] Fix | Delete

}

[51] Fix | Delete

[52] Fix | Delete

if ( empty( $results[0]['cache_value'] ) ) {

[53] Fix | Delete

return false;

[54] Fix | Delete

}

[55] Fix | Delete

[56] Fix | Delete

if ( strtotime( $results[0]['last_updated'] ) < time() - $this->cache_time ) {

[57] Fix | Delete

return false;

[58] Fix | Delete

}

[59] Fix | Delete

[60] Fix | Delete

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

[61] Fix | Delete

}

[62] Fix | Delete

[63] Fix | Delete

/**

[64] Fix | Delete

* Mimic WP get_option for persistent caches

[65] Fix | Delete

[66] Fix | Delete

* @param string $transient_name

[67] Fix | Delete

[68] Fix | Delete

* @return false|string

[69] Fix | Delete

[70] Fix | Delete

public function get_persistent( $transient_name ) {

[71] Fix | Delete

$results = $this->query_ctf_feed_caches( $transient_name );

[72] Fix | Delete

[73] Fix | Delete

if ( empty( $results ) ) {

[74] Fix | Delete

$results = get_option( $transient_name, false );

[75] Fix | Delete

[76] Fix | Delete

if ( ! empty( $results ) ) {

[77] Fix | Delete

return $results;

[78] Fix | Delete

}

[79] Fix | Delete

}

[80] Fix | Delete

[81] Fix | Delete

if ( empty( $results ) ) {

[82] Fix | Delete

return false;

[83] Fix | Delete

}

[84] Fix | Delete

[85] Fix | Delete

if ( empty( $results[0]['cache_value'] ) ) {

[86] Fix | Delete

return false;

[87] Fix | Delete

}

[88] Fix | Delete

[89] Fix | Delete

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

[90] Fix | Delete

}

[91] Fix | Delete

[92] Fix | Delete

/**

[93] Fix | Delete

* Mimic WP set_transient

[94] Fix | Delete

[95] Fix | Delete

* @param $transient_name

[96] Fix | Delete

* @param $value

[97] Fix | Delete

[98] Fix | Delete

* @return bool|int

[99] Fix | Delete

[100] Fix | Delete

public function set_transient( $transient_name, $value, $backup = false, $cron_update = true ) {

[101] Fix | Delete

return $this->update_or_insert( $transient_name, $value, $backup, $cron_update );

[102] Fix | Delete

}

[103] Fix | Delete

[104] Fix | Delete

/**

[105] Fix | Delete

* Mimic WP update_option for persistent

[106] Fix | Delete

[107] Fix | Delete

* @param $transient_name

[108] Fix | Delete

* @param $value

[109] Fix | Delete

[110] Fix | Delete

* @return bool|int

[111] Fix | Delete

[112] Fix | Delete

public function set_persistent( $transient_name, $value ) {

[113] Fix | Delete

return $this->update_or_insert( $transient_name, $value );

[114] Fix | Delete

}

[115] Fix | Delete

[116] Fix | Delete

/**

[117] Fix | Delete

* Update or insert cache data

[118] Fix | Delete

[119] Fix | Delete

* @param string $transient_name

[120] Fix | Delete

* @param string $cache_value

[121] Fix | Delete

* @param bool $include_backup

[122] Fix | Delete

* @param bool $cron_update

[123] Fix | Delete

[124] Fix | Delete

* @return bool|int|\mysqli_result|resource|null

[125] Fix | Delete

[126] Fix | Delete

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

[127] Fix | Delete

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

[128] Fix | Delete

$cron_update = false;

[129] Fix | Delete

}

[130] Fix | Delete

[131] Fix | Delete

if ( ! empty( $this->page ) ) {

[132] Fix | Delete

$cron_update = false;

[133] Fix | Delete

}

[134] Fix | Delete

[135] Fix | Delete

if ( $this->feed_id === 'legacy' ) {

[136] Fix | Delete

$cron_update = false;

[137] Fix | Delete

}

[138] Fix | Delete

[139] Fix | Delete

global $wpdb;

[140] Fix | Delete

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

[141] Fix | Delete

[142] Fix | Delete

$sql = $wpdb->prepare(

[143] Fix | Delete

[144] Fix | Delete

SELECT * FROM $cache_table_name

[145] Fix | Delete

WHERE feed_id = %s

[146] Fix | Delete

AND cache_key = %s",

[147] Fix | Delete

$this->feed_id,

[148] Fix | Delete

$transient_name

[149] Fix | Delete

);

[150] Fix | Delete

[151] Fix | Delete

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

[152] Fix | Delete

$data = array();

[153] Fix | Delete

$where = array();

[154] Fix | Delete

$format = array();

[155] Fix | Delete

[156] Fix | Delete

$data['cache_value'] = $cache_value;

[157] Fix | Delete

$format[] = '%s';

[158] Fix | Delete

[159] Fix | Delete

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

[160] Fix | Delete

$format[] = '%s';

[161] Fix | Delete

[162] Fix | Delete

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

[163] Fix | Delete

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

[164] Fix | Delete

$where_format[] = '%s';

[165] Fix | Delete

[166] Fix | Delete

$where['cache_key'] = $transient_name;

[167] Fix | Delete

$where_format[] = '%s';

[168] Fix | Delete

[169] Fix | Delete

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

[170] Fix | Delete

} else {

[171] Fix | Delete

$data['cache_key'] = $transient_name;

[172] Fix | Delete

$format[] = '%s';

[173] Fix | Delete

[174] Fix | Delete

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

[175] Fix | Delete

$format[] = '%s';

[176] Fix | Delete

[177] Fix | Delete

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

[178] Fix | Delete

$format[] = '%s';

[179] Fix | Delete

[180] Fix | Delete

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

[181] Fix | Delete

}

[182] Fix | Delete

[183] Fix | Delete

return $affected;

[184] Fix | Delete

}

[185] Fix | Delete

[186] Fix | Delete

/**

[187] Fix | Delete

* @param $transient_name

[188] Fix | Delete

[189] Fix | Delete

* @return array|false

[190] Fix | Delete

[191] Fix | Delete

private function query_ctf_feed_caches( $transient_name ) {

[192] Fix | Delete

$feed_cache = wp_cache_get( $transient_name );

[193] Fix | Delete

if ( false === $feed_cache || ! is_array( $feed_cache ) ) {

[194] Fix | Delete

global $wpdb;

[195] Fix | Delete

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

[196] Fix | Delete

[197] Fix | Delete

$sql = $wpdb->prepare(

[198] Fix | Delete

[199] Fix | Delete

SELECT * FROM $cache_table_name

[200] Fix | Delete

WHERE cache_key = %s

[201] Fix | Delete

ORDER BY last_updated DESC",

[202] Fix | Delete

$transient_name

[203] Fix | Delete

);

[204] Fix | Delete

[205] Fix | Delete

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

[206] Fix | Delete

[207] Fix | Delete

wp_cache_set( $transient_name, $feed_cache );

[208] Fix | Delete

}

[209] Fix | Delete

[210] Fix | Delete

return $feed_cache;

[211] Fix | Delete

}

[212] Fix | Delete

[213] Fix | Delete

/**

[214] Fix | Delete

* @return string

[215] Fix | Delete

[216] Fix | Delete

private function maybe_customizer_suffix() {

[217] Fix | Delete

$additional_suffix = '';

[218] Fix | Delete

$in_customizer = ! empty( $_POST['previewSettings'] ) || ( isset( $_GET['page'] ) && $_GET['page'] === 'ctf-feed-builder' );

[219] Fix | Delete

if ( $in_customizer ) {

[220] Fix | Delete

$additional_suffix .= '_CUSTOMIZER';

[221] Fix | Delete

}

[222] Fix | Delete

[223] Fix | Delete

return $additional_suffix;

[224] Fix | Delete

}

[225] Fix | Delete

}

[226] Fix | Delete

[227] Fix | Delete