<?php

[0] Fix | Delete

[1] Fix | Delete

/**

[2] Fix | Delete

* The class to store and manage litespeed db data.

[3] Fix | Delete

*

[4] Fix | Delete

* @since 1.3.1

[5] Fix | Delete

* @package LiteSpeed

[6] Fix | Delete

* @subpackage LiteSpeed/src

[7] Fix | Delete

* @author LiteSpeed Technologies <info@litespeedtech.com>

[8] Fix | Delete

*/

[9] Fix | Delete

[10] Fix | Delete

namespace LiteSpeed;

[11] Fix | Delete

[12] Fix | Delete

defined('WPINC') || exit();

[13] Fix | Delete

[14] Fix | Delete

class Data extends Root

[15] Fix | Delete

{

[16] Fix | Delete

const LOG_TAG = '[Data]';

[17] Fix | Delete

[18] Fix | Delete

private $_db_updater = array(

[19] Fix | Delete

'3.5.0.3' => array('litespeed_update_3_5'),

[20] Fix | Delete

'4.0' => array('litespeed_update_4'),

[21] Fix | Delete

'4.1' => array('litespeed_update_4_1'),

[22] Fix | Delete

'4.3' => array('litespeed_update_4_3'),

[23] Fix | Delete

'4.4.4-b1' => array('litespeed_update_4_4_4'),

[24] Fix | Delete

'5.3-a5' => array('litespeed_update_5_3'),

[25] Fix | Delete

);

[26] Fix | Delete

[27] Fix | Delete

private $_db_site_updater = array(

[28] Fix | Delete

// Example

[29] Fix | Delete

// '2.0' => array(

[30] Fix | Delete

// 'litespeed_update_site_2_0',

[31] Fix | Delete

// ),

[32] Fix | Delete

);

[33] Fix | Delete

[34] Fix | Delete

private $_url_file_types = array(

[35] Fix | Delete

'css' => 1,

[36] Fix | Delete

'js' => 2,

[37] Fix | Delete

'ccss' => 3,

[38] Fix | Delete

'ucss' => 4,

[39] Fix | Delete

);

[40] Fix | Delete

[41] Fix | Delete

const TB_IMG_OPTM = 'litespeed_img_optm';

[42] Fix | Delete

const TB_IMG_OPTMING = 'litespeed_img_optming'; // working table

[43] Fix | Delete

const TB_AVATAR = 'litespeed_avatar';

[44] Fix | Delete

const TB_CRAWLER = 'litespeed_crawler';

[45] Fix | Delete

const TB_CRAWLER_BLACKLIST = 'litespeed_crawler_blacklist';

[46] Fix | Delete

const TB_URL = 'litespeed_url';

[47] Fix | Delete

const TB_URL_FILE = 'litespeed_url_file';

[48] Fix | Delete

[49] Fix | Delete

/**

[50] Fix | Delete

* Init

[51] Fix | Delete

*

[52] Fix | Delete

* @since 1.3.1

[53] Fix | Delete

*/

[54] Fix | Delete

public function __construct()

[55] Fix | Delete

{

[56] Fix | Delete

}

[57] Fix | Delete

[58] Fix | Delete

/**

[59] Fix | Delete

* Correct table existence

[60] Fix | Delete

*

[61] Fix | Delete

* Call when activate -> update_confs()

[62] Fix | Delete

* Call when update_confs()

[63] Fix | Delete

*

[64] Fix | Delete

* @since 3.0

[65] Fix | Delete

* @access public

[66] Fix | Delete

*/

[67] Fix | Delete

public function correct_tb_existence()

[68] Fix | Delete

{

[69] Fix | Delete

// Gravatar

[70] Fix | Delete

if ($this->conf(Base::O_DISCUSS_AVATAR_CACHE)) {

[71] Fix | Delete

$this->tb_create('avatar');

[72] Fix | Delete

}

[73] Fix | Delete

[74] Fix | Delete

// Crawler

[75] Fix | Delete

if ($this->conf(Base::O_CRAWLER)) {

[76] Fix | Delete

$this->tb_create('crawler');

[77] Fix | Delete

$this->tb_create('crawler_blacklist');

[78] Fix | Delete

}

[79] Fix | Delete

[80] Fix | Delete

// URL mapping

[81] Fix | Delete

$this->tb_create('url');

[82] Fix | Delete

$this->tb_create('url_file');

[83] Fix | Delete

[84] Fix | Delete

// Image optm is a bit different. Only trigger creation when sending requests. Drop when destroying.

[85] Fix | Delete

}

[86] Fix | Delete

[87] Fix | Delete

/**

[88] Fix | Delete

* Upgrade conf to latest format version from previous versions

[89] Fix | Delete

*

[90] Fix | Delete

* NOTE: Only for v3.0+

[91] Fix | Delete

*

[92] Fix | Delete

* @since 3.0

[93] Fix | Delete

* @access public

[94] Fix | Delete

*/

[95] Fix | Delete

public function conf_upgrade($ver)

[96] Fix | Delete

{

[97] Fix | Delete

// Skip count check if `Use Primary Site Configurations` is on

[98] Fix | Delete

// Deprecated since v3.0 as network primary site didn't override the subsites conf yet

[99] Fix | Delete

// if ( ! is_main_site() && ! empty ( $this->_site_options[ self::NETWORK_O_USE_PRIMARY ] ) ) {

[100] Fix | Delete

// return;

[101] Fix | Delete

// }

[102] Fix | Delete

[103] Fix | Delete

if ($this->_get_upgrade_lock()) {

[104] Fix | Delete

return;

[105] Fix | Delete

}

[106] Fix | Delete

[107] Fix | Delete

$this->_set_upgrade_lock(true);

[108] Fix | Delete

[109] Fix | Delete

require_once LSCWP_DIR . 'src/data.upgrade.func.php';

[110] Fix | Delete

[111] Fix | Delete

// Init log manually

[112] Fix | Delete

if ($this->conf(Base::O_DEBUG)) {

[113] Fix | Delete

$this->cls('Debug2')->init();

[114] Fix | Delete

}

[115] Fix | Delete

[116] Fix | Delete

foreach ($this->_db_updater as $k => $v) {

[117] Fix | Delete

if (version_compare($ver, $k, '<')) {

[118] Fix | Delete

// run each callback

[119] Fix | Delete

foreach ($v as $v2) {

[120] Fix | Delete

Debug2::debug("[Data] Updating [ori_v] $ver \t[to] $k \t[func] $v2");

[121] Fix | Delete

call_user_func($v2);

[122] Fix | Delete

}

[123] Fix | Delete

}

[124] Fix | Delete

}

[125] Fix | Delete

[126] Fix | Delete

// Reload options

[127] Fix | Delete

$this->cls('Conf')->load_options();

[128] Fix | Delete

[129] Fix | Delete

$this->correct_tb_existence();

[130] Fix | Delete

[131] Fix | Delete

// Update related files

[132] Fix | Delete

$this->cls('Activation')->update_files();

[133] Fix | Delete

[134] Fix | Delete

// Update version to latest

[135] Fix | Delete

Conf::delete_option(Base::_VER);

[136] Fix | Delete

Conf::add_option(Base::_VER, Core::VER);

[137] Fix | Delete

[138] Fix | Delete

Debug2::debug('[Data] Updated version to ' . Core::VER);

[139] Fix | Delete

[140] Fix | Delete

$this->_set_upgrade_lock(false);

[141] Fix | Delete

[142] Fix | Delete

!defined('LSWCP_EMPTYCACHE') && define('LSWCP_EMPTYCACHE', true); // clear all sites caches

[143] Fix | Delete

Purge::purge_all();

[144] Fix | Delete

[145] Fix | Delete

Cloud::version_check('upgrade');

[146] Fix | Delete

}

[147] Fix | Delete

[148] Fix | Delete

/**

[149] Fix | Delete

* Upgrade site conf to latest format version from previous versions

[150] Fix | Delete

*

[151] Fix | Delete

* NOTE: Only for v3.0+

[152] Fix | Delete

*

[153] Fix | Delete

* @since 3.0

[154] Fix | Delete

* @access public

[155] Fix | Delete

*/

[156] Fix | Delete

public function conf_site_upgrade($ver)

[157] Fix | Delete

{

[158] Fix | Delete

if ($this->_get_upgrade_lock()) {

[159] Fix | Delete

return;

[160] Fix | Delete

}

[161] Fix | Delete

[162] Fix | Delete

$this->_set_upgrade_lock(true);

[163] Fix | Delete

[164] Fix | Delete

require_once LSCWP_DIR . 'src/data.upgrade.func.php';

[165] Fix | Delete

[166] Fix | Delete

foreach ($this->_db_site_updater as $k => $v) {

[167] Fix | Delete

if (version_compare($ver, $k, '<')) {

[168] Fix | Delete

// run each callback

[169] Fix | Delete

foreach ($v as $v2) {

[170] Fix | Delete

Debug2::debug("[Data] Updating site [ori_v] $ver \t[to] $k \t[func] $v2");

[171] Fix | Delete

call_user_func($v2);

[172] Fix | Delete

}

[173] Fix | Delete

}

[174] Fix | Delete

}

[175] Fix | Delete

[176] Fix | Delete

// Reload options

[177] Fix | Delete

$this->cls('Conf')->load_site_options();

[178] Fix | Delete

[179] Fix | Delete

Conf::delete_site_option(Base::_VER);

[180] Fix | Delete

Conf::add_site_option(Base::_VER, Core::VER);

[181] Fix | Delete

[182] Fix | Delete

Debug2::debug('[Data] Updated site_version to ' . Core::VER);

[183] Fix | Delete

[184] Fix | Delete

$this->_set_upgrade_lock(false);

[185] Fix | Delete

[186] Fix | Delete

!defined('LSWCP_EMPTYCACHE') && define('LSWCP_EMPTYCACHE', true); // clear all sites caches

[187] Fix | Delete

Purge::purge_all();

[188] Fix | Delete

}

[189] Fix | Delete

[190] Fix | Delete

/**

[191] Fix | Delete

* Check if upgrade script is running or not

[192] Fix | Delete

*

[193] Fix | Delete

* @since 3.0.1

[194] Fix | Delete

*/

[195] Fix | Delete

private function _get_upgrade_lock()

[196] Fix | Delete

{

[197] Fix | Delete

$is_upgrading = get_option('litespeed.data.upgrading');

[198] Fix | Delete

if (!$is_upgrading) {

[199] Fix | Delete

$this->_set_upgrade_lock(false); // set option value to existed to avoid repeated db query next time

[200] Fix | Delete

}

[201] Fix | Delete

if ($is_upgrading && time() - $is_upgrading < 3600) {

[202] Fix | Delete

return $is_upgrading;

[203] Fix | Delete

}

[204] Fix | Delete

[205] Fix | Delete

return false;

[206] Fix | Delete

}

[207] Fix | Delete

[208] Fix | Delete

/**

[209] Fix | Delete

* Show the upgrading banner if upgrade script is running

[210] Fix | Delete

*

[211] Fix | Delete

* @since 3.0.1

[212] Fix | Delete

*/

[213] Fix | Delete

public function check_upgrading_msg()

[214] Fix | Delete

{

[215] Fix | Delete

$is_upgrading = $this->_get_upgrade_lock();

[216] Fix | Delete

if (!$is_upgrading) {

[217] Fix | Delete

return;

[218] Fix | Delete

}

[219] Fix | Delete

[220] Fix | Delete

Admin_Display::info(

[221] Fix | Delete

sprintf(

[222] Fix | Delete

__('The database has been upgrading in the background since %s. This message will disappear once upgrade is complete.', 'litespeed-cache'),

[223] Fix | Delete

'<code>' . Utility::readable_time($is_upgrading) . '</code>'

[224] Fix | Delete

) . ' [LiteSpeed]',

[225] Fix | Delete

true

[226] Fix | Delete

);

[227] Fix | Delete

}

[228] Fix | Delete

[229] Fix | Delete

/**

[230] Fix | Delete

* Set lock for upgrade process

[231] Fix | Delete

*

[232] Fix | Delete

* @since 3.0.1

[233] Fix | Delete

*/

[234] Fix | Delete

private function _set_upgrade_lock($lock)

[235] Fix | Delete

{

[236] Fix | Delete

if (!$lock) {

[237] Fix | Delete

update_option('litespeed.data.upgrading', -1);

[238] Fix | Delete

} else {

[239] Fix | Delete

update_option('litespeed.data.upgrading', time());

[240] Fix | Delete

}

[241] Fix | Delete

}

[242] Fix | Delete

[243] Fix | Delete

/**

[244] Fix | Delete

* Upgrade the conf to v3.0 from previous v3.0- data

[245] Fix | Delete

*

[246] Fix | Delete

* NOTE: Only for v3.0-

[247] Fix | Delete

*

[248] Fix | Delete

* @since 3.0

[249] Fix | Delete

* @access public

[250] Fix | Delete

*/

[251] Fix | Delete

public function try_upgrade_conf_3_0()

[252] Fix | Delete

{

[253] Fix | Delete

$previous_options = get_option('litespeed-cache-conf');

[254] Fix | Delete

if (!$previous_options) {

[255] Fix | Delete

Cloud::version_check('new');

[256] Fix | Delete

return;

[257] Fix | Delete

}

[258] Fix | Delete

[259] Fix | Delete

$ver = $previous_options['version'];

[260] Fix | Delete

[261] Fix | Delete

!defined('LSCWP_CUR_V') && define('LSCWP_CUR_V', $ver);

[262] Fix | Delete

[263] Fix | Delete

// Init log manually

[264] Fix | Delete

if ($this->conf(Base::O_DEBUG)) {

[265] Fix | Delete

$this->cls('Debug2')->init();

[266] Fix | Delete

}

[267] Fix | Delete

Debug2::debug('[Data] Upgrading previous settings [from] ' . $ver . ' [to] v3.0');

[268] Fix | Delete

[269] Fix | Delete

if ($this->_get_upgrade_lock()) {

[270] Fix | Delete

return;

[271] Fix | Delete

}

[272] Fix | Delete

[273] Fix | Delete

$this->_set_upgrade_lock(true);

[274] Fix | Delete

[275] Fix | Delete

require_once LSCWP_DIR . 'src/data.upgrade.func.php';

[276] Fix | Delete

[277] Fix | Delete

// Here inside will update the version to v3.0

[278] Fix | Delete

litespeed_update_3_0($ver);

[279] Fix | Delete

[280] Fix | Delete

$this->_set_upgrade_lock(false);

[281] Fix | Delete

[282] Fix | Delete

Debug2::debug('[Data] Upgraded to v3.0');

[283] Fix | Delete

[284] Fix | Delete

// Upgrade from 3.0 to latest version

[285] Fix | Delete

$ver = '3.0';

[286] Fix | Delete

if (Core::VER != $ver) {

[287] Fix | Delete

$this->conf_upgrade($ver);

[288] Fix | Delete

} else {

[289] Fix | Delete

// Reload options

[290] Fix | Delete

$this->cls('Conf')->load_options();

[291] Fix | Delete

[292] Fix | Delete

$this->correct_tb_existence();

[293] Fix | Delete

[294] Fix | Delete

!defined('LSWCP_EMPTYCACHE') && define('LSWCP_EMPTYCACHE', true); // clear all sites caches

[295] Fix | Delete

Purge::purge_all();

[296] Fix | Delete

[297] Fix | Delete

Cloud::version_check('upgrade');

[298] Fix | Delete

}

[299] Fix | Delete

}

[300] Fix | Delete

[301] Fix | Delete

/**

[302] Fix | Delete

* Get the table name

[303] Fix | Delete

*

[304] Fix | Delete

* @since 3.0

[305] Fix | Delete

* @access public

[306] Fix | Delete

*/

[307] Fix | Delete

public function tb($tb)

[308] Fix | Delete

{

[309] Fix | Delete

global $wpdb;

[310] Fix | Delete

[311] Fix | Delete

switch ($tb) {

[312] Fix | Delete

case 'img_optm':

[313] Fix | Delete

return $wpdb->prefix . self::TB_IMG_OPTM;

[314] Fix | Delete

break;

[315] Fix | Delete

[316] Fix | Delete

case 'img_optming':

[317] Fix | Delete

return $wpdb->prefix . self::TB_IMG_OPTMING;

[318] Fix | Delete

break;

[319] Fix | Delete

[320] Fix | Delete

case 'avatar':

[321] Fix | Delete

return $wpdb->prefix . self::TB_AVATAR;

[322] Fix | Delete

break;

[323] Fix | Delete

[324] Fix | Delete

case 'crawler':

[325] Fix | Delete

return $wpdb->prefix . self::TB_CRAWLER;

[326] Fix | Delete

break;

[327] Fix | Delete

[328] Fix | Delete

case 'crawler_blacklist':

[329] Fix | Delete

return $wpdb->prefix . self::TB_CRAWLER_BLACKLIST;

[330] Fix | Delete

break;

[331] Fix | Delete

[332] Fix | Delete

case 'url':

[333] Fix | Delete

return $wpdb->prefix . self::TB_URL;

[334] Fix | Delete

break;

[335] Fix | Delete

[336] Fix | Delete

case 'url_file':

[337] Fix | Delete

return $wpdb->prefix . self::TB_URL_FILE;

[338] Fix | Delete

break;

[339] Fix | Delete

[340] Fix | Delete

default:

[341] Fix | Delete

break;

[342] Fix | Delete

}

[343] Fix | Delete

}

[344] Fix | Delete

[345] Fix | Delete

/**

[346] Fix | Delete

* Check if one table exists or not

[347] Fix | Delete

*

[348] Fix | Delete

* @since 3.0

[349] Fix | Delete

* @access public

[350] Fix | Delete

*/

[351] Fix | Delete

public function tb_exist($tb)

[352] Fix | Delete

{

[353] Fix | Delete

global $wpdb;

[354] Fix | Delete

return $wpdb->get_var("SHOW TABLES LIKE '" . $this->tb($tb) . "'");

[355] Fix | Delete

}

[356] Fix | Delete

[357] Fix | Delete

/**

[358] Fix | Delete

* Get data structure of one table

[359] Fix | Delete

*

[360] Fix | Delete

* @since 2.0

[361] Fix | Delete

* @access private

[362] Fix | Delete

*/

[363] Fix | Delete

private function _tb_structure($tb)

[364] Fix | Delete

{

[365] Fix | Delete

return File::read(LSCWP_DIR . 'src/data_structure/' . $tb . '.sql');

[366] Fix | Delete

}

[367] Fix | Delete

[368] Fix | Delete

/**

[369] Fix | Delete

* Create img optm table and sync data from wp_postmeta

[370] Fix | Delete

*

[371] Fix | Delete

* @since 3.0

[372] Fix | Delete

* @access public

[373] Fix | Delete

*/

[374] Fix | Delete

public function tb_create($tb)

[375] Fix | Delete

{

[376] Fix | Delete

global $wpdb;

[377] Fix | Delete

[378] Fix | Delete

Debug2::debug2('[Data] Checking table ' . $tb);

[379] Fix | Delete

[380] Fix | Delete

// Check if table exists first

[381] Fix | Delete

if ($this->tb_exist($tb)) {

[382] Fix | Delete

Debug2::debug2('[Data] Existed');

[383] Fix | Delete

return;

[384] Fix | Delete

}

[385] Fix | Delete

[386] Fix | Delete

Debug2::debug('[Data] Creating ' . $tb);

[387] Fix | Delete

[388] Fix | Delete

$sql = sprintf(

[389] Fix | Delete

'CREATE TABLE IF NOT EXISTS `%1$s` (' . $this->_tb_structure($tb) . ') %2$s;',

[390] Fix | Delete

$this->tb($tb),

[391] Fix | Delete

$wpdb->get_charset_collate() // 'DEFAULT CHARSET=utf8'

[392] Fix | Delete

);

[393] Fix | Delete

[394] Fix | Delete

$res = $wpdb->query($sql);

[395] Fix | Delete

if ($res !== true) {

[396] Fix | Delete

Debug2::debug('[Data] Warning! Creating table failed!', $sql);

[397] Fix | Delete

Admin_Display::error(Error::msg('failed_tb_creation', array('<code>' . $tb . '</code>', '<code>' . $sql . '</code>')));

[398] Fix | Delete

}

[399] Fix | Delete

}

[400] Fix | Delete

[401] Fix | Delete

/**

[402] Fix | Delete

* Drop table

[403] Fix | Delete

*

[404] Fix | Delete

* @since 3.0

[405] Fix | Delete

* @access public

[406] Fix | Delete

*/

[407] Fix | Delete

public function tb_del($tb)

[408] Fix | Delete

{

[409] Fix | Delete

global $wpdb;

[410] Fix | Delete

[411] Fix | Delete

if (!$this->tb_exist($tb)) {

[412] Fix | Delete

return;

[413] Fix | Delete

}

[414] Fix | Delete

[415] Fix | Delete

Debug2::debug('[Data] Deleting table ' . $tb);

[416] Fix | Delete

[417] Fix | Delete

$q = 'DROP TABLE IF EXISTS ' . $this->tb($tb);

[418] Fix | Delete

$wpdb->query($q);

[419] Fix | Delete

}

[420] Fix | Delete

[421] Fix | Delete

/**

[422] Fix | Delete

* Drop generated tables

[423] Fix | Delete

*

[424] Fix | Delete

* @since 3.0

[425] Fix | Delete

* @access public

[426] Fix | Delete

*/

[427] Fix | Delete

public function tables_del()

[428] Fix | Delete

{

[429] Fix | Delete

$this->tb_del('avatar');

[430] Fix | Delete

$this->tb_del('crawler');

[431] Fix | Delete

$this->tb_del('crawler_blacklist');

[432] Fix | Delete

$this->tb_del('url');

[433] Fix | Delete

$this->tb_del('url_file');

[434] Fix | Delete

[435] Fix | Delete

// Deleting img_optm only can be done when destroy all optm images

[436] Fix | Delete

}

[437] Fix | Delete

[438] Fix | Delete

/**

[439] Fix | Delete

* Keep table but clear all data

[440] Fix | Delete

*

[441] Fix | Delete

* @since 4.0

[442] Fix | Delete

*/

[443] Fix | Delete

public function table_truncate($tb)

[444] Fix | Delete

{

[445] Fix | Delete

global $wpdb;

[446] Fix | Delete

$q = 'TRUNCATE TABLE ' . $this->tb($tb);

[447] Fix | Delete

$wpdb->query($q);

[448] Fix | Delete

}

[449] Fix | Delete

[450] Fix | Delete

/**

[451] Fix | Delete

* Clean certain type of url_file

[452] Fix | Delete

*

[453] Fix | Delete

* @since 4.0

[454] Fix | Delete

*/

[455] Fix | Delete

public function url_file_clean($file_type)

[456] Fix | Delete

{

[457] Fix | Delete

global $wpdb;

[458] Fix | Delete

[459] Fix | Delete

if (!$this->tb_exist('url_file')) {

[460] Fix | Delete

return;

[461] Fix | Delete

}

[462] Fix | Delete

[463] Fix | Delete

$type = $this->_url_file_types[$file_type];

[464] Fix | Delete

$q = 'DELETE FROM ' . $this->tb('url_file') . ' WHERE `type` = %d';

[465] Fix | Delete

$wpdb->query($wpdb->prepare($q, $type));

[466] Fix | Delete

[467] Fix | Delete

// Added to cleanup url table. See issue: https://wordpress.org/support/topic/wp_litespeed_url-1-1-gb-in-db-huge-big/

[468] Fix | Delete

$wpdb->query(

[469] Fix | Delete

'DELETE d

[470] Fix | Delete

FROM `' .

[471] Fix | Delete

$this->tb('url') .

[472] Fix | Delete

'` AS d

[473] Fix | Delete

LEFT JOIN `' .

[474] Fix | Delete

$this->tb('url_file') .

[475] Fix | Delete

'` AS f ON d.`id` = f.`url_id`

[476] Fix | Delete

WHERE f.`url_id` IS NULL'

[477] Fix | Delete

);

[478] Fix | Delete

}

[479] Fix | Delete

[480] Fix | Delete

/**

[481] Fix | Delete

* Generate filename based on URL, if content md5 existed, reuse existing file.

[482] Fix | Delete

* @since 4.0

[483] Fix | Delete

*/

[484] Fix | Delete

public function save_url($request_url, $vary, $file_type, $filecon_md5, $path, $mobile = false, $webp = false)

[485] Fix | Delete

{

[486] Fix | Delete

global $wpdb;

[487] Fix | Delete

[488] Fix | Delete

if (strlen($vary) > 32) {

[489] Fix | Delete

$vary = md5($vary);

[490] Fix | Delete

}

[491] Fix | Delete

[492] Fix | Delete

$type = $this->_url_file_types[$file_type];

[493] Fix | Delete

[494] Fix | Delete

$tb_url = $this->tb('url');

[495] Fix | Delete

$tb_url_file = $this->tb('url_file');

[496] Fix | Delete

$q = "SELECT * FROM `$tb_url` WHERE url=%s";

[497] Fix | Delete

$url_row = $wpdb->get_row($wpdb->prepare($q, $request_url), ARRAY_A);

[498] Fix | Delete

if (!$url_row) {

[499] Fix | Delete