Edit File by line

<?php

[0] Fix | Delete

/**

[1] Fix | Delete

* Class CTF_Feed_Locator

[2] Fix | Delete

[3] Fix | Delete

* Locates feeds on the site and logs information about them in the database.

[4] Fix | Delete

[5] Fix | Delete

* @since 1.14

[6] Fix | Delete

[7] Fix | Delete

namespace TwitterFeed;

[8] Fix | Delete

use TwitterFeed\Builder\CTF_Db;

[9] Fix | Delete

if ( ! defined( 'ABSPATH' ) ) {

[10] Fix | Delete

die( '-1' );

[11] Fix | Delete

}

[12] Fix | Delete

[13] Fix | Delete

class CTF_Feed_Locator

[14] Fix | Delete

{

[15] Fix | Delete

private $feed_details;

[16] Fix | Delete

[17] Fix | Delete

private $expiration_time;

[18] Fix | Delete

[19] Fix | Delete

private $matching_entries;

[20] Fix | Delete

[21] Fix | Delete

public function __construct( $feed_details ) {

[22] Fix | Delete

/**

[23] Fix | Delete

* Example of how $feed_details is structured

[24] Fix | Delete

[25] Fix | Delete

* $feed_details = array(

[26] Fix | Delete

* 'feed_id' => $transient_name,

[27] Fix | Delete

* 'atts' => $atts,

[28] Fix | Delete

* 'location' => array(

[29] Fix | Delete

* 'post_id' => get_the_ID(),

[30] Fix | Delete

* 'html' => 'unknown'

[31] Fix | Delete

* )

[32] Fix | Delete

* );

[33] Fix | Delete

[34] Fix | Delete

if ( isset( $feed_details['atts'] ) && ! empty( $feed_details['atts']['feed'] ) ) {

[35] Fix | Delete

$feed_details['feed_id'] = '*' . $feed_details['atts']['feed'];

[36] Fix | Delete

}

[37] Fix | Delete

$this->feed_details = $feed_details;

[38] Fix | Delete

[39] Fix | Delete

$this->matching_entries = array();

[40] Fix | Delete

[41] Fix | Delete

$this->expiration_time = time() - 2 * WEEK_IN_SECONDS;

[42] Fix | Delete

}

[43] Fix | Delete

[44] Fix | Delete

/**

[45] Fix | Delete

* Returns records that match the post ID and feed ID

[46] Fix | Delete

* of the feed being located

[47] Fix | Delete

[48] Fix | Delete

* @return array

[49] Fix | Delete

[50] Fix | Delete

* @since 1.14

[51] Fix | Delete

[52] Fix | Delete

public function retrieve_matching_entries() {

[53] Fix | Delete

global $wpdb;

[54] Fix | Delete

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

[55] Fix | Delete

[56] Fix | Delete

$results = $wpdb->get_results( $wpdb->prepare("

[57] Fix | Delete

SELECT *

[58] Fix | Delete

FROM $feed_locator_table_name

[59] Fix | Delete

WHERE post_id = %d

[60] Fix | Delete

AND feed_id = %s", $this->feed_details['location']['post_id'], $this->feed_details['feed_id'] ),ARRAY_A );

[61] Fix | Delete

[62] Fix | Delete

return $results;

[63] Fix | Delete

}

[64] Fix | Delete

[65] Fix | Delete

/**

[66] Fix | Delete

* Add feed being located to the database

[67] Fix | Delete

[68] Fix | Delete

* @since 1.14

[69] Fix | Delete

[70] Fix | Delete

public function insert_entry() {

[71] Fix | Delete

if ( empty( $this->feed_details['location']['post_id'] ) ) {

[72] Fix | Delete

return false;

[73] Fix | Delete

}

[74] Fix | Delete

global $wpdb;

[75] Fix | Delete

[76] Fix | Delete

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

[77] Fix | Delete

[78] Fix | Delete

$affected = $wpdb->query( $wpdb->prepare( "INSERT INTO $feed_locator_table_name

[79] Fix | Delete

(feed_id,

[80] Fix | Delete

post_id,

[81] Fix | Delete

html_location,

[82] Fix | Delete

shortcode_atts,

[83] Fix | Delete

last_update)

[84] Fix | Delete

VALUES (

[85] Fix | Delete

%s,

[86] Fix | Delete

%d,

[87] Fix | Delete

%s,

[88] Fix | Delete

%s,

[89] Fix | Delete

%s);",

[90] Fix | Delete

$this->feed_details['feed_id'],

[91] Fix | Delete

$this->feed_details['location']['post_id'],

[92] Fix | Delete

$this->feed_details['location']['html'],

[93] Fix | Delete

ctf_json_encode( $this->feed_details['atts'] ),

[94] Fix | Delete

date( 'Y-m-d H:i:s' ) ) );

[95] Fix | Delete

}

[96] Fix | Delete

[97] Fix | Delete

/**

[98] Fix | Delete

* Update a record based on the existing "id" column. Location can change

[99] Fix | Delete

* from "unknown" to one of footer, content, header, or sidebar.

[100] Fix | Delete

[101] Fix | Delete

* @param $id

[102] Fix | Delete

* @param $location

[103] Fix | Delete

[104] Fix | Delete

* @since 1.14

[105] Fix | Delete

[106] Fix | Delete

public function update_entry( $id, $location ) {

[107] Fix | Delete

global $wpdb;

[108] Fix | Delete

[109] Fix | Delete

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

[110] Fix | Delete

[111] Fix | Delete

$query = $wpdb->query( $wpdb->prepare( "

[112] Fix | Delete

UPDATE $feed_locator_table_name

[113] Fix | Delete

SET last_update = %s, html_location = %s

[114] Fix | Delete

WHERE id = %d;", date( 'Y-m-d H:i:s' ), $location, $id ) );

[115] Fix | Delete

}

[116] Fix | Delete

[117] Fix | Delete

/**

[118] Fix | Delete

* Processes a feed being located based on whether or not the record

[119] Fix | Delete

* exists as well as whether or not an unknown location needs to be

[120] Fix | Delete

* updated.

[121] Fix | Delete

[122] Fix | Delete

* @since 1.14

[123] Fix | Delete

[124] Fix | Delete

public function add_or_update_entry() {

[125] Fix | Delete

if ( empty( $this->feed_details['feed_id'] ) ) {

[126] Fix | Delete

return;

[127] Fix | Delete

}

[128] Fix | Delete

[129] Fix | Delete

$this->matching_entries = $this->retrieve_matching_entries();

[130] Fix | Delete

[131] Fix | Delete

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

[132] Fix | Delete

$this->insert_entry();

[133] Fix | Delete

} else {

[134] Fix | Delete

$matching_indices = array();

[135] Fix | Delete

$matched_location = false;

[136] Fix | Delete

$non_unknown_match = false;

[137] Fix | Delete

$unknown_match = false;

[138] Fix | Delete

[139] Fix | Delete

foreach ( $this->matching_entries as $index => $matching_entry ) {

[140] Fix | Delete

$details_atts = is_array( $this->feed_details['atts'] ) ? $this->feed_details['atts'] : array();

[141] Fix | Delete

$matching_atts = json_decode( $matching_entry['shortcode_atts'], true );

[142] Fix | Delete

if ( ! is_array( $matching_atts ) ) {

[143] Fix | Delete

$matching_atts = array();

[144] Fix | Delete

}

[145] Fix | Delete

$atts_diff = array_diff( $matching_atts, $details_atts ); // determines if the shortcode settings match the shortcode settings of an existing feed

[146] Fix | Delete

if ( empty( $atts_diff ) ) {

[147] Fix | Delete

$matching_indices[] = $matching_entry['id'];

[148] Fix | Delete

if ( $matching_entry['html_location'] === $this->feed_details['location']['html'] ) {

[149] Fix | Delete

$matched_location = $index;

[150] Fix | Delete

$this->update_entry( $matching_entry['id'], $matching_entry['html_location'] );

[151] Fix | Delete

}

[152] Fix | Delete

if ( $matching_entry['html_location'] !== 'unknown' ) {

[153] Fix | Delete

$non_unknown_match = $index;

[154] Fix | Delete

} else {

[155] Fix | Delete

$unknown_match = $index;

[156] Fix | Delete

}

[157] Fix | Delete

}

[158] Fix | Delete

}

[159] Fix | Delete

[160] Fix | Delete

if ( false === $matched_location ) {

[161] Fix | Delete

// if there is no matched location, there is only one feed on the page, and the feed being checked has an unknown location, update the known location

[162] Fix | Delete

if ( count( $matching_indices ) === 1

[163] Fix | Delete

&& $this->feed_details['location']['html'] === 'unknown'

[164] Fix | Delete

&& false !== $non_unknown_match ) {

[165] Fix | Delete

$this->update_entry( $this->matching_entries[ $non_unknown_match ]['id'], $this->matching_entries[ $non_unknown_match ]['html_location'] );

[166] Fix | Delete

} else {

[167] Fix | Delete

if ( $this->feed_details['location']['html'] !== 'unknown'

[168] Fix | Delete

&& false !== $unknown_match ) {

[169] Fix | Delete

$this->update_entry( $this->matching_entries[ $unknown_match ]['id'], $this->feed_details['location']['html'] );

[170] Fix | Delete

} else {

[171] Fix | Delete

$this->insert_entry();

[172] Fix | Delete

}

[173] Fix | Delete

[174] Fix | Delete

}

[175] Fix | Delete

}

[176] Fix | Delete

[177] Fix | Delete

}

[178] Fix | Delete

}

[179] Fix | Delete

[180] Fix | Delete

/**

[181] Fix | Delete

* Old feeds are only detected once a day to keep load on the server low.

[182] Fix | Delete

[183] Fix | Delete

* @return bool

[184] Fix | Delete

[185] Fix | Delete

* @since 1.14

[186] Fix | Delete

[187] Fix | Delete

public static function should_clear_old_locations() {

[188] Fix | Delete

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

[189] Fix | Delete

$last_old_feed_check = isset( $ctf_statuses_option['feed_locator']['last_check'] ) ? $ctf_statuses_option['feed_locator']['last_check'] : 0;

[190] Fix | Delete

[191] Fix | Delete

return $last_old_feed_check < time() - DAY_IN_SECONDS;

[192] Fix | Delete

}

[193] Fix | Delete

[194] Fix | Delete

/**

[195] Fix | Delete

* Old feeds are removed if they haven't been updated in two weeks.

[196] Fix | Delete

[197] Fix | Delete

* @since 1.14

[198] Fix | Delete

[199] Fix | Delete

public static function delete_old_locations() {

[200] Fix | Delete

global $wpdb;

[201] Fix | Delete

[202] Fix | Delete

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

[203] Fix | Delete

$two_weeks_ago = date( 'Y-m-d H:i:s', time() - 2 * WEEK_IN_SECONDS );

[204] Fix | Delete

[205] Fix | Delete

$affected = $wpdb->query( $wpdb->prepare(

[206] Fix | Delete

"DELETE FROM $feed_locator_table_name WHERE last_update < %s;", $two_weeks_ago ) );

[207] Fix | Delete

[208] Fix | Delete

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

[209] Fix | Delete

$ctf_statuses_option['feed_locator']['last_check'] = time();

[210] Fix | Delete

if ( ! isset( $ctf_statuses_option['feed_locator']['initialized'] ) ) {

[211] Fix | Delete

$ctf_statuses_option['feed_locator']['initialized'] = time();

[212] Fix | Delete

}

[213] Fix | Delete

[214] Fix | Delete

update_option( 'ctf_statuses', $ctf_statuses_option, true );

[215] Fix | Delete

}

[216] Fix | Delete

[217] Fix | Delete

/**

[218] Fix | Delete

* Feeds are located with the page load randomly (5% or 1/30 loads)

[219] Fix | Delete

* to decrease load on the server.

[220] Fix | Delete

[221] Fix | Delete

* If the locating just started (within 5 minutes) it is run more often

[222] Fix | Delete

* to collect feed locations quickly.

[223] Fix | Delete

[224] Fix | Delete

* @return bool

[225] Fix | Delete

[226] Fix | Delete

* @since 1.14

[227] Fix | Delete

[228] Fix | Delete

public static function should_do_locating() {

[229] Fix | Delete

if ( is_admin() ) {

[230] Fix | Delete

return false;

[231] Fix | Delete

}

[232] Fix | Delete

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

[233] Fix | Delete

if ( isset( $ctf_statuses_option['feed_locator']['initialized'] )

[234] Fix | Delete

&& $ctf_statuses_option['feed_locator']['initialized'] < (time() - 300) ) {

[235] Fix | Delete

$should_do_locating = rand( 1, 10 ) === 10;

[236] Fix | Delete

} else {

[237] Fix | Delete

$should_do_locating = rand( 1, 30 ) === 30;

[238] Fix | Delete

}

[239] Fix | Delete

$should_do_locating = apply_filters( 'ctf_should_do_locating', $should_do_locating );

[240] Fix | Delete

[241] Fix | Delete

return $should_do_locating;

[242] Fix | Delete

}

[243] Fix | Delete

[244] Fix | Delete

/**

[245] Fix | Delete

* Simliar to the should_do_locating method but will add an additional

[246] Fix | Delete

* database query to see if there is a feed with an unknown location that

[247] Fix | Delete

* matches the details of the feed in question.

[248] Fix | Delete

[249] Fix | Delete

* @param $feed_id

[250] Fix | Delete

* @param $post_id

[251] Fix | Delete

[252] Fix | Delete

* @return bool

[253] Fix | Delete

[254] Fix | Delete

* @since 1.14

[255] Fix | Delete

[256] Fix | Delete

public static function should_do_ajax_locating( $feed_id, $post_id ) {

[257] Fix | Delete

if ( is_admin() ) {

[258] Fix | Delete

return false;

[259] Fix | Delete

}

[260] Fix | Delete

$should_do_locating = rand( 1, 50 ) === 50;

[261] Fix | Delete

[262] Fix | Delete

$should_do_locating = apply_filters( 'ctf_should_do_ajax_locating', $should_do_locating );

[263] Fix | Delete

[264] Fix | Delete

return $should_do_locating;

[265] Fix | Delete

}

[266] Fix | Delete

[267] Fix | Delete

/**

[268] Fix | Delete

* Feeds are located with the page load randomly (1/30 loads)

[269] Fix | Delete

* to decrease load on the server.

[270] Fix | Delete

[271] Fix | Delete

* If the locating just started (within 5 minutes) it is run more often

[272] Fix | Delete

* to collect feed locations quickly.

[273] Fix | Delete

[274] Fix | Delete

* @param $feed_id

[275] Fix | Delete

* @param $post_id

[276] Fix | Delete

[277] Fix | Delete

* @return bool

[278] Fix | Delete

[279] Fix | Delete

* @since 1.14

[280] Fix | Delete

[281] Fix | Delete

public static function entries_need_locating( $feed_id, $post_id ) {

[282] Fix | Delete

global $wpdb;

[283] Fix | Delete

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

[284] Fix | Delete

[285] Fix | Delete

$one_day_ago = date( 'Y-m-d H:i:s', time() - DAY_IN_SECONDS );

[286] Fix | Delete

[287] Fix | Delete

$results = $wpdb->get_results( $wpdb->prepare("

[288] Fix | Delete

SELECT id

[289] Fix | Delete

FROM $feed_locator_table_name

[290] Fix | Delete

WHERE html_location = 'unknown'

[291] Fix | Delete

AND last_update < %s

[292] Fix | Delete

AND feed_id = %s

[293] Fix | Delete

AND post_id = %d

[294] Fix | Delete

LIMIT 1;", $one_day_ago, $feed_id, $post_id ),ARRAY_A );

[295] Fix | Delete

[296] Fix | Delete

return isset( $results[0] );

[297] Fix | Delete

}

[298] Fix | Delete

[299] Fix | Delete

/**

[300] Fix | Delete

* A custom table stores locations

[301] Fix | Delete

[302] Fix | Delete

* @since 1.14

[303] Fix | Delete

[304] Fix | Delete

public static function create_table() {

[305] Fix | Delete

global $wpdb;

[306] Fix | Delete

[307] Fix | Delete

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

[308] Fix | Delete

[309] Fix | Delete

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

[310] Fix | Delete

$sql = "CREATE TABLE " . $feed_locator_table_name . " (

[311] Fix | Delete

id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,

[312] Fix | Delete

feed_id VARCHAR(50) DEFAULT '' NOT NULL,

[313] Fix | Delete

post_id BIGINT(20) UNSIGNED NOT NULL,

[314] Fix | Delete

html_location VARCHAR(50) DEFAULT 'unknown' NOT NULL,

[315] Fix | Delete

shortcode_atts LONGTEXT NOT NULL,

[316] Fix | Delete

last_update DATETIME

[317] Fix | Delete

);";

[318] Fix | Delete

$wpdb->query( $sql );

[319] Fix | Delete

}

[320] Fix | Delete

$error = $wpdb->last_error;

[321] Fix | Delete

$query = $wpdb->last_query;

[322] Fix | Delete

$had_error = false;

[323] Fix | Delete

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

[324] Fix | Delete

$had_error = true;

[325] Fix | Delete

}

[326] Fix | Delete

[327] Fix | Delete

if ( ! $had_error ) {

[328] Fix | Delete

$wpdb->query( "ALTER TABLE $feed_locator_table_name ADD INDEX feed_id (feed_id)" );

[329] Fix | Delete

$wpdb->query( "ALTER TABLE $feed_locator_table_name ADD INDEX post_id (post_id)" );

[330] Fix | Delete

}

[331] Fix | Delete

}

[332] Fix | Delete

[333] Fix | Delete

/**

[334] Fix | Delete

* Counts the number of unique feeds in the database.

[335] Fix | Delete

[336] Fix | Delete

* @return int

[337] Fix | Delete

[338] Fix | Delete

* @since 1.14

[339] Fix | Delete

[340] Fix | Delete

public static function count_unique() {

[341] Fix | Delete

global $wpdb;

[342] Fix | Delete

[343] Fix | Delete

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

[344] Fix | Delete

$results_content = $wpdb->get_results( "

[345] Fix | Delete

SELECT COUNT(*) AS num_entries

[346] Fix | Delete

FROM $feed_locator_table_name

[347] Fix | Delete

WHERE html_location = 'content'

[348] Fix | Delete

", ARRAY_A );

[349] Fix | Delete

[350] Fix | Delete

[351] Fix | Delete

$results_other = $wpdb->get_results( "

[352] Fix | Delete

SELECT COUNT(*) AS num_entries

[353] Fix | Delete

FROM $feed_locator_table_name

[354] Fix | Delete

WHERE html_location != 'content'

[355] Fix | Delete

AND html_location != 'unknown'

[356] Fix | Delete

GROUP BY feed_id

[357] Fix | Delete

", ARRAY_A );

[358] Fix | Delete

[359] Fix | Delete

$total = 0;

[360] Fix | Delete

if ( isset( $results_content[0]['num_entries'] ) ) {

[361] Fix | Delete

$total += (int)$results_content[0]['num_entries'];

[362] Fix | Delete

}

[363] Fix | Delete

if ( isset( $results_other[0]['num_entries'] ) ) {

[364] Fix | Delete

$total += (int)$results_other[0]['num_entries'];

[365] Fix | Delete

}

[366] Fix | Delete

[367] Fix | Delete

return $total;

[368] Fix | Delete

}

[369] Fix | Delete

[370] Fix | Delete

/**

[371] Fix | Delete

* Creates a summary of the located feeds in an array

[372] Fix | Delete

[373] Fix | Delete

* @return array

[374] Fix | Delete

[375] Fix | Delete

* @since 1.14

[376] Fix | Delete

[377] Fix | Delete

public static function summary() {

[378] Fix | Delete

global $wpdb;

[379] Fix | Delete

[380] Fix | Delete

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

[381] Fix | Delete

[382] Fix | Delete

$locations = array(

[383] Fix | Delete

array(

[384] Fix | Delete

'label' => __( 'Content', 'custom-twitter-feeds' ),

[385] Fix | Delete

'html_locations' => array( 'content', 'unknown' )

[386] Fix | Delete

[387] Fix | Delete

array(

[388] Fix | Delete

'label' => __( 'Header', 'custom-twitter-feeds' ),

[389] Fix | Delete

'html_locations' => array( 'header' ),

[390] Fix | Delete

'group_by' => 'feed_id'

[391] Fix | Delete

[392] Fix | Delete

array(

[393] Fix | Delete

'label' => __( 'Sidebar', 'custom-twitter-feeds' ),

[394] Fix | Delete

'html_locations' => array( 'sidebar' ),

[395] Fix | Delete

'group_by' => 'feed_id'

[396] Fix | Delete

[397] Fix | Delete

array(

[398] Fix | Delete

'label' => __( 'Footer', 'custom-twitter-feeds' ),

[399] Fix | Delete

'html_locations' => array( 'footer' ),

[400] Fix | Delete

'group_by' => 'feed_id'

[401] Fix | Delete

)

[402] Fix | Delete

);

[403] Fix | Delete

[404] Fix | Delete

$one_result_found = false;

[405] Fix | Delete

[406] Fix | Delete

foreach ( $locations as $key => $location ) {

[407] Fix | Delete

$in = implode( "', '", $location['html_locations'] );

[408] Fix | Delete

$group_by = isset( $location['group_by'] ) ? "GROUP BY " . $location['group_by'] : "";

[409] Fix | Delete

$results = $wpdb->get_results("

[410] Fix | Delete

SELECT *

[411] Fix | Delete

FROM $feed_locator_table_name

[412] Fix | Delete

WHERE html_location IN ('$in')

[413] Fix | Delete

$group_by

[414] Fix | Delete

ORDER BY last_update ASC",ARRAY_A );

[415] Fix | Delete

[416] Fix | Delete

if ( isset( $results[0] ) ) {

[417] Fix | Delete

$one_result_found = true;

[418] Fix | Delete

}

[419] Fix | Delete

[420] Fix | Delete

$locations[ $key ]['results'] = $results;

[421] Fix | Delete

}

[422] Fix | Delete

[423] Fix | Delete

if ( ! $one_result_found ) {

[424] Fix | Delete

return array();

[425] Fix | Delete

}

[426] Fix | Delete

[427] Fix | Delete

return $locations;

[428] Fix | Delete

}

[429] Fix | Delete

[430] Fix | Delete

[431] Fix | Delete

/**

[432] Fix | Delete

* Queries the locator table for feeds by feed_id

[433] Fix | Delete

[434] Fix | Delete

* @param $args

[435] Fix | Delete

[436] Fix | Delete

* @return array|object|null

[437] Fix | Delete

[438] Fix | Delete

* @since 2.0

[439] Fix | Delete

[440] Fix | Delete

public static function twitter_feed_locator_query( $args ) {

[441] Fix | Delete

global $wpdb;

[442] Fix | Delete

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

[443] Fix | Delete

[444] Fix | Delete

$group_by = '';

[445] Fix | Delete

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

[446] Fix | Delete

$group_by = "GROUP BY " . esc_sql( $args['group_by'] );

[447] Fix | Delete

}

[448] Fix | Delete

[449] Fix | Delete

$location_string = 'content';

[450] Fix | Delete

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

[451] Fix | Delete

$locations = array_map( 'esc_sql', $args['html_location'] );

[452] Fix | Delete

$location_string = implode( "', '", $locations );

[453] Fix | Delete

}

[454] Fix | Delete

[455] Fix | Delete

$page = 0;

[456] Fix | Delete

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

[457] Fix | Delete

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

[458] Fix | Delete

unset( $args['page'] );

[459] Fix | Delete

}

[460] Fix | Delete

[461] Fix | Delete

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

[462] Fix | Delete

[463] Fix | Delete

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

[464] Fix | Delete

$results = $wpdb->get_results( $wpdb->prepare("

[465] Fix | Delete

SELECT *

[466] Fix | Delete

FROM $feed_locator_table_name

[467] Fix | Delete

WHERE shortcode_atts = %s

[468] Fix | Delete

AND html_location IN ( '$location_string' )

[469] Fix | Delete

$group_by

[470] Fix | Delete

LIMIT %d

[471] Fix | Delete

OFFSET %d;", $args['shortcode_atts'], CTF_Db::RESULTS_PER_PAGE, $offset ),ARRAY_A );

[472] Fix | Delete

} else {

[473] Fix | Delete

$results = $wpdb->get_results( $wpdb->prepare("

[474] Fix | Delete

SELECT *

[475] Fix | Delete

FROM $feed_locator_table_name

[476] Fix | Delete

WHERE feed_id = %s

[477] Fix | Delete

AND html_location IN ( '$location_string' )

[478] Fix | Delete

$group_by

[479] Fix | Delete

LIMIT %d

[480] Fix | Delete

OFFSET %d;", $args['feed_id'], CTF_Db::RESULTS_PER_PAGE, $offset ),ARRAY_A );

[481] Fix | Delete

}

[482] Fix | Delete

[483] Fix | Delete

return $results;

[484] Fix | Delete

}

[485] Fix | Delete

[486] Fix | Delete

/**

[487] Fix | Delete

* Queries all legacy feeds that have been located

[488] Fix | Delete

[489] Fix | Delete

* @param $args

[490] Fix | Delete

[491] Fix | Delete

* @return array|object|null

[492] Fix | Delete

[493] Fix | Delete

* @since 2.0

[494] Fix | Delete

[495] Fix | Delete

public static function legacy_twitter_feed_locator_query( $args ) {

[496] Fix | Delete

global $wpdb;

[497] Fix | Delete

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

[498] Fix | Delete

[499] Fix | Delete