<?php

[0] Fix | Delete

/**

[1] Fix | Delete

* LiteSpeed persistent data manager.

[2] Fix | Delete

*

[3] Fix | Delete

* Handles DB tables, schema upgrades, URL-to-file mappings, and list loaders.

[4] Fix | Delete

*

[5] Fix | Delete

* @package LiteSpeed

[6] Fix | Delete

* @since 1.3.1

[7] Fix | Delete

*/

[8] Fix | Delete

[9] Fix | Delete

namespace LiteSpeed;

[10] Fix | Delete

[11] Fix | Delete

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

[12] Fix | Delete

[13] Fix | Delete

/**

[14] Fix | Delete

* Data layer for LiteSpeed Cache.

[15] Fix | Delete

*/

[16] Fix | Delete

class Data extends Root {

[17] Fix | Delete

[18] Fix | Delete

const LOG_TAG = '🚀';

[19] Fix | Delete

[20] Fix | Delete

/**

[21] Fix | Delete

* Versioned DB updaters for network-wide options.

[22] Fix | Delete

*

[23] Fix | Delete

* @var array<string,array<string>>

[24] Fix | Delete

*/

[25] Fix | Delete

private $_db_updater = [

[26] Fix | Delete

'5.3-a5' => [ 'litespeed_update_5_3' ],

[27] Fix | Delete

'7.0-b26' => [ 'litespeed_update_7' ],

[28] Fix | Delete

'7.0.1-b1' => [ 'litespeed_update_7_0_1' ],

[29] Fix | Delete

'7.7-b28' => [ 'litespeed_update_7_7' ],

[30] Fix | Delete

];

[31] Fix | Delete

[32] Fix | Delete

/**

[33] Fix | Delete

* Versioned DB updaters for per-site options in multisite.

[34] Fix | Delete

*

[35] Fix | Delete

* @var array<string,array<string>>

[36] Fix | Delete

*/

[37] Fix | Delete

private $_db_site_updater = [

[38] Fix | Delete

// '2.0' => [ 'litespeed_update_site_2_0' ],

[39] Fix | Delete

];

[40] Fix | Delete

[41] Fix | Delete

/**

[42] Fix | Delete

* Map from URL-file type to integer code.

[43] Fix | Delete

*

[44] Fix | Delete

* @var array<string,int>

[45] Fix | Delete

*/

[46] Fix | Delete

private $_url_file_types = [

[47] Fix | Delete

'css' => 1,

[48] Fix | Delete

'js' => 2,

[49] Fix | Delete

'ccss' => 3,

[50] Fix | Delete

'ucss' => 4,

[51] Fix | Delete

];

[52] Fix | Delete

[53] Fix | Delete

/** Table: image optimization results. */

[54] Fix | Delete

const TB_IMG_OPTM = 'litespeed_img_optm';

[55] Fix | Delete

/** Table: image optimization working queue. */

[56] Fix | Delete

const TB_IMG_OPTMING = 'litespeed_img_optming';

[57] Fix | Delete

/** Table: cached avatars. */

[58] Fix | Delete

const TB_AVATAR = 'litespeed_avatar';

[59] Fix | Delete

/** Table: crawler URLs. */

[60] Fix | Delete

const TB_CRAWLER = 'litespeed_crawler';

[61] Fix | Delete

/** Table: crawler blacklist. */

[62] Fix | Delete

const TB_CRAWLER_BLACKLIST = 'litespeed_crawler_blacklist';

[63] Fix | Delete

/** Table: logical URLs. */

[64] Fix | Delete

const TB_URL = 'litespeed_url';

[65] Fix | Delete

/** Table: URL → generated file mapping. */

[66] Fix | Delete

const TB_URL_FILE = 'litespeed_url_file';

[67] Fix | Delete

[68] Fix | Delete

/**

[69] Fix | Delete

* Constructor.

[70] Fix | Delete

*

[71] Fix | Delete

* @since 1.3.1

[72] Fix | Delete

*/

[73] Fix | Delete

public function __construct() {}

[74] Fix | Delete

[75] Fix | Delete

/**

[76] Fix | Delete

* Ensure required tables exist based on current configuration.

[77] Fix | Delete

*

[78] Fix | Delete

* Called on activation and when options are (re)loaded.

[79] Fix | Delete

*

[80] Fix | Delete

* @since 3.0

[81] Fix | Delete

* @access public

[82] Fix | Delete

* @return void

[83] Fix | Delete

*/

[84] Fix | Delete

public function correct_tb_existence() {

[85] Fix | Delete

// Gravatar.

[86] Fix | Delete

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

[87] Fix | Delete

$this->tb_create( 'avatar' );

[88] Fix | Delete

}

[89] Fix | Delete

[90] Fix | Delete

// Crawler.

[91] Fix | Delete

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

[92] Fix | Delete

$this->tb_create( 'crawler' );

[93] Fix | Delete

$this->tb_create( 'crawler_blacklist' );

[94] Fix | Delete

}

[95] Fix | Delete

[96] Fix | Delete

// URL mapping.

[97] Fix | Delete

$this->tb_create( 'url' );

[98] Fix | Delete

$this->tb_create( 'url_file' );

[99] Fix | Delete

[100] Fix | Delete

// Image optm tables are managed on-demand.

[101] Fix | Delete

}

[102] Fix | Delete

[103] Fix | Delete

/**

[104] Fix | Delete

* Upgrade global configuration/data to match plugin version.

[105] Fix | Delete

*

[106] Fix | Delete

* @since 3.0

[107] Fix | Delete

* @access public

[108] Fix | Delete

*

[109] Fix | Delete

* @param string $ver Currently stored version string.

[110] Fix | Delete

* @return string|void 'upgrade' on success, or void if no-op.

[111] Fix | Delete

*/

[112] Fix | Delete

public function conf_upgrade( $ver ) {

[113] Fix | Delete

// Skip count check if `Use Primary Site Configurations` is on (deprecated note kept intentionally).

[114] Fix | Delete

[115] Fix | Delete

if ( $this->_get_upgrade_lock() ) {

[116] Fix | Delete

return;

[117] Fix | Delete

}

[118] Fix | Delete

[119] Fix | Delete

$this->_set_upgrade_lock( true );

[120] Fix | Delete

[121] Fix | Delete

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

[122] Fix | Delete

[123] Fix | Delete

// Init log manually.

[124] Fix | Delete

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

[125] Fix | Delete

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

[126] Fix | Delete

}

[127] Fix | Delete

[128] Fix | Delete

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

[129] Fix | Delete

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

[130] Fix | Delete

foreach ( $v as $v2 ) {

[131] Fix | Delete

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

[132] Fix | Delete

call_user_func( $v2 );

[133] Fix | Delete

}

[134] Fix | Delete

}

[135] Fix | Delete

}

[136] Fix | Delete

[137] Fix | Delete

// Reload options.

[138] Fix | Delete

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

[139] Fix | Delete

[140] Fix | Delete

$this->correct_tb_existence();

[141] Fix | Delete

[142] Fix | Delete

// Update related files.

[143] Fix | Delete

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

[144] Fix | Delete

[145] Fix | Delete

// Update version to latest.

[146] Fix | Delete

Conf::delete_option( Base::_VER );

[147] Fix | Delete

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

[148] Fix | Delete

[149] Fix | Delete

self::debug( 'Updated version to ' . Core::VER );

[150] Fix | Delete

[151] Fix | Delete

$this->_set_upgrade_lock( false );

[152] Fix | Delete

[153] Fix | Delete

if ( ! defined( 'LSWCP_EMPTYCACHE' ) ) {

[154] Fix | Delete

define( 'LSWCP_EMPTYCACHE', true );

[155] Fix | Delete

}

[156] Fix | Delete

Purge::purge_all();

[157] Fix | Delete

[158] Fix | Delete

return 'upgrade';

[159] Fix | Delete

}

[160] Fix | Delete

[161] Fix | Delete

/**

[162] Fix | Delete

* Upgrade per-site configuration/data to match plugin version (multisite).

[163] Fix | Delete

*

[164] Fix | Delete

* @since 3.0

[165] Fix | Delete

* @access public

[166] Fix | Delete

*

[167] Fix | Delete

* @param string $ver Currently stored version string.

[168] Fix | Delete

* @return void

[169] Fix | Delete

*/

[170] Fix | Delete

public function conf_site_upgrade( $ver ) {

[171] Fix | Delete

if ( $this->_get_upgrade_lock() ) {

[172] Fix | Delete

return;

[173] Fix | Delete

}

[174] Fix | Delete

[175] Fix | Delete

$this->_set_upgrade_lock( true );

[176] Fix | Delete

[177] Fix | Delete

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

[178] Fix | Delete

[179] Fix | Delete

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

[180] Fix | Delete

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

[181] Fix | Delete

foreach ( $v as $v2 ) {

[182] Fix | Delete

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

[183] Fix | Delete

call_user_func( $v2 );

[184] Fix | Delete

}

[185] Fix | Delete

}

[186] Fix | Delete

}

[187] Fix | Delete

[188] Fix | Delete

// Reload options.

[189] Fix | Delete

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

[190] Fix | Delete

[191] Fix | Delete

Conf::delete_site_option( Base::_VER );

[192] Fix | Delete

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

[193] Fix | Delete

[194] Fix | Delete

self::debug( 'Updated site_version to ' . Core::VER );

[195] Fix | Delete

[196] Fix | Delete

$this->_set_upgrade_lock( false );

[197] Fix | Delete

[198] Fix | Delete

if ( ! defined( 'LSWCP_EMPTYCACHE' ) ) {

[199] Fix | Delete

define( 'LSWCP_EMPTYCACHE', true );

[200] Fix | Delete

}

[201] Fix | Delete

Purge::purge_all();

[202] Fix | Delete

}

[203] Fix | Delete

[204] Fix | Delete

/**

[205] Fix | Delete

* Whether an upgrade lock is in effect.

[206] Fix | Delete

*

[207] Fix | Delete

* @since 3.0.1

[208] Fix | Delete

* @return int|false Timestamp if locked and recent, false otherwise.

[209] Fix | Delete

*/

[210] Fix | Delete

private function _get_upgrade_lock() {

[211] Fix | Delete

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

[212] Fix | Delete

if ( ! $is_upgrading ) {

[213] Fix | Delete

$this->_set_upgrade_lock( false ); // Seed option to avoid repeated DB reads later.

[214] Fix | Delete

}

[215] Fix | Delete

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

[216] Fix | Delete

return $is_upgrading;

[217] Fix | Delete

}

[218] Fix | Delete

[219] Fix | Delete

return false;

[220] Fix | Delete

}

[221] Fix | Delete

[222] Fix | Delete

/**

[223] Fix | Delete

* Show the upgrading banner if upgrade script is running.

[224] Fix | Delete

*

[225] Fix | Delete

* @since 3.0.1

[226] Fix | Delete

* @return void

[227] Fix | Delete

*/

[228] Fix | Delete

public function check_upgrading_msg() {

[229] Fix | Delete

$is_upgrading = $this->_get_upgrade_lock();

[230] Fix | Delete

if ( ! $is_upgrading ) {

[231] Fix | Delete

return;

[232] Fix | Delete

}

[233] Fix | Delete

[234] Fix | Delete

Admin_Display::info(

[235] Fix | Delete

sprintf(

[236] Fix | Delete

/* translators: %s: time string */

[237] Fix | Delete

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

[238] Fix | Delete

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

[239] Fix | Delete

) . ' [LiteSpeed]',

[240] Fix | Delete

true

[241] Fix | Delete

);

[242] Fix | Delete

}

[243] Fix | Delete

[244] Fix | Delete

/**

[245] Fix | Delete

* Set/clear the upgrade process lock.

[246] Fix | Delete

*

[247] Fix | Delete

* @since 3.0.1

[248] Fix | Delete

*

[249] Fix | Delete

* @param bool $lock True to set, false to clear.

[250] Fix | Delete

* @return void

[251] Fix | Delete

*/

[252] Fix | Delete

private function _set_upgrade_lock( $lock ) {

[253] Fix | Delete

if ( ! $lock ) {

[254] Fix | Delete

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

[255] Fix | Delete

} else {

[256] Fix | Delete

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

[257] Fix | Delete

}

[258] Fix | Delete

}

[259] Fix | Delete

[260] Fix | Delete

/**

[261] Fix | Delete

* Get a fully-qualified table name by slug.

[262] Fix | Delete

*

[263] Fix | Delete

* @since 3.0

[264] Fix | Delete

* @access public

[265] Fix | Delete

*

[266] Fix | Delete

* @param string $tb Table slug (e.g., 'url_file').

[267] Fix | Delete

* @return string|null

[268] Fix | Delete

*/

[269] Fix | Delete

public function tb( $tb ) {

[270] Fix | Delete

global $wpdb;

[271] Fix | Delete

[272] Fix | Delete

switch ( $tb ) {

[273] Fix | Delete

case 'img_optm':

[274] Fix | Delete

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

[275] Fix | Delete

[276] Fix | Delete

case 'img_optming':

[277] Fix | Delete

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

[278] Fix | Delete

[279] Fix | Delete

case 'avatar':

[280] Fix | Delete

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

[281] Fix | Delete

[282] Fix | Delete

case 'crawler':

[283] Fix | Delete

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

[284] Fix | Delete

[285] Fix | Delete

case 'crawler_blacklist':

[286] Fix | Delete

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

[287] Fix | Delete

[288] Fix | Delete

case 'url':

[289] Fix | Delete

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

[290] Fix | Delete

[291] Fix | Delete

case 'url_file':

[292] Fix | Delete

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

[293] Fix | Delete

[294] Fix | Delete

default:

[295] Fix | Delete

return null;

[296] Fix | Delete

}

[297] Fix | Delete

}

[298] Fix | Delete

[299] Fix | Delete

/**

[300] Fix | Delete

* Check if a table exists.

[301] Fix | Delete

*

[302] Fix | Delete

* @since 3.0

[303] Fix | Delete

* @access public

[304] Fix | Delete

*

[305] Fix | Delete

* @param string $tb Table slug.

[306] Fix | Delete

* @return bool

[307] Fix | Delete

*/

[308] Fix | Delete

public function tb_exist( $tb ) {

[309] Fix | Delete

global $wpdb;

[310] Fix | Delete

[311] Fix | Delete

$save_state = $wpdb->suppress_errors;

[312] Fix | Delete

$wpdb->suppress_errors( true );

[313] Fix | Delete

$describe = $wpdb->get_var( 'DESCRIBE `' . $this->tb( $tb ) . '`' ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.NotPrepared

[314] Fix | Delete

$wpdb->suppress_errors( $save_state );

[315] Fix | Delete

[316] Fix | Delete

return null !== $describe;

[317] Fix | Delete

}

[318] Fix | Delete

[319] Fix | Delete

/**

[320] Fix | Delete

* Get the SQL structure (columns/indexes) for a given table slug.

[321] Fix | Delete

*

[322] Fix | Delete

* @since 2.0

[323] Fix | Delete

* @access private

[324] Fix | Delete

*

[325] Fix | Delete

* @param string $tb Table slug.

[326] Fix | Delete

* @return string SQL columns/indexes definition.

[327] Fix | Delete

*/

[328] Fix | Delete

private function _tb_structure( $tb ) {

[329] Fix | Delete

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

[330] Fix | Delete

}

[331] Fix | Delete

[332] Fix | Delete

/**

[333] Fix | Delete

* Create a table by slug if it doesn't exist.

[334] Fix | Delete

*

[335] Fix | Delete

* @since 3.0

[336] Fix | Delete

* @access public

[337] Fix | Delete

*

[338] Fix | Delete

* @param string $tb Table slug.

[339] Fix | Delete

* @return void

[340] Fix | Delete

*/

[341] Fix | Delete

public function tb_create( $tb ) {

[342] Fix | Delete

global $wpdb;

[343] Fix | Delete

[344] Fix | Delete

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

[345] Fix | Delete

[346] Fix | Delete

// Check if table exists first.

[347] Fix | Delete

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

[348] Fix | Delete

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

[349] Fix | Delete

return;

[350] Fix | Delete

}

[351] Fix | Delete

[352] Fix | Delete

self::debug( 'Creating ' . $tb );

[353] Fix | Delete

[354] Fix | Delete

$sql = sprintf(

[355] Fix | Delete

'CREATE TABLE IF NOT EXISTS `%1$s` (%2$s) %3$s;',

[356] Fix | Delete

$this->tb( $tb ),

[357] Fix | Delete

$this->_tb_structure( $tb ),

[358] Fix | Delete

$wpdb->get_charset_collate()

[359] Fix | Delete

);

[360] Fix | Delete

$res = $wpdb->query( $sql ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.NotPrepared

[361] Fix | Delete

if ( false === $res ) {

[362] Fix | Delete

self::debug( 'Warning! Creating table failed!', $sql );

[363] Fix | Delete

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

[364] Fix | Delete

}

[365] Fix | Delete

}

[366] Fix | Delete

[367] Fix | Delete

/**

[368] Fix | Delete

* Drop a table by slug.

[369] Fix | Delete

*

[370] Fix | Delete

* @since 3.0

[371] Fix | Delete

* @access public

[372] Fix | Delete

*

[373] Fix | Delete

* @param string $tb Table slug.

[374] Fix | Delete

* @return void

[375] Fix | Delete

*/

[376] Fix | Delete

public function tb_del( $tb ) {

[377] Fix | Delete

global $wpdb;

[378] Fix | Delete

[379] Fix | Delete

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

[380] Fix | Delete

return;

[381] Fix | Delete

}

[382] Fix | Delete

[383] Fix | Delete

self::debug( 'Deleting table ' . $tb );

[384] Fix | Delete

[385] Fix | Delete

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

[386] Fix | Delete

$wpdb->query( $q ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.NotPrepared

[387] Fix | Delete

}

[388] Fix | Delete

[389] Fix | Delete

/**

[390] Fix | Delete

* Drop all generated tables (except image optimization working tables).

[391] Fix | Delete

*

[392] Fix | Delete

* @since 3.0

[393] Fix | Delete

* @access public

[394] Fix | Delete

* @return void

[395] Fix | Delete

*/

[396] Fix | Delete

public function tables_del() {

[397] Fix | Delete

$this->tb_del( 'avatar' );

[398] Fix | Delete

$this->tb_del( 'crawler' );

[399] Fix | Delete

$this->tb_del( 'crawler_blacklist' );

[400] Fix | Delete

$this->tb_del( 'url' );

[401] Fix | Delete

$this->tb_del( 'url_file' );

[402] Fix | Delete

[403] Fix | Delete

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

[404] Fix | Delete

}

[405] Fix | Delete

[406] Fix | Delete

/**

[407] Fix | Delete

* TRUNCATE a table by slug.

[408] Fix | Delete

*

[409] Fix | Delete

* @since 4.0

[410] Fix | Delete

* @access public

[411] Fix | Delete

*

[412] Fix | Delete

* @param string $tb Table slug.

[413] Fix | Delete

* @return void

[414] Fix | Delete

*/

[415] Fix | Delete

public function table_truncate( $tb ) {

[416] Fix | Delete

global $wpdb;

[417] Fix | Delete

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

[418] Fix | Delete

$wpdb->query( $q ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.NotPrepared

[419] Fix | Delete

}

[420] Fix | Delete

[421] Fix | Delete

/**

[422] Fix | Delete

* Clean URL-file rows for a given file type and prune orphaned URLs.

[423] Fix | Delete

*

[424] Fix | Delete

* @since 4.0

[425] Fix | Delete

* @access public

[426] Fix | Delete

*

[427] Fix | Delete

* @param string $file_type One of 'css','js','ccss','ucss'.

[428] Fix | Delete

* @return void

[429] Fix | Delete

*/

[430] Fix | Delete

public function url_file_clean( $file_type ) {

[431] Fix | Delete

global $wpdb;

[432] Fix | Delete

[433] Fix | Delete

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

[434] Fix | Delete

return;

[435] Fix | Delete

}

[436] Fix | Delete

[437] Fix | Delete

if ( ! isset( $this->_url_file_types[ $file_type ] ) ) {

[438] Fix | Delete

return;

[439] Fix | Delete

}

[440] Fix | Delete

[441] Fix | Delete

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

[442] Fix | Delete

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

[443] Fix | Delete

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

[444] Fix | Delete

[445] Fix | Delete

// Delete all of this type.

[446] Fix | Delete

$q = "DELETE FROM `$tb_url_file` WHERE `type` = %d";

[447] Fix | Delete

$wpdb->query( $wpdb->prepare( $q, $type ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.NotPrepared

[448] Fix | Delete

[449] Fix | Delete

// Prune orphaned rows in URL table.

[450] Fix | Delete

$sql = "DELETE d

[451] Fix | Delete

FROM `{$tb_url}` AS d

[452] Fix | Delete

LEFT JOIN `{$tb_url_file}` AS f ON d.`id` = f.`url_id`

[453] Fix | Delete

WHERE f.`url_id` IS NULL";

[454] Fix | Delete

$wpdb->query( $sql ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.NotPrepared

[455] Fix | Delete

}

[456] Fix | Delete

[457] Fix | Delete

/**

[458] Fix | Delete

* Persist (or rotate) the mapping from URL+vary to a generated file.

[459] Fix | Delete

*

[460] Fix | Delete

* @since 4.0

[461] Fix | Delete

* @access public

[462] Fix | Delete

*

[463] Fix | Delete

* @param string $request_url Full request URL.

[464] Fix | Delete

* @param string $vary Vary string (may be long; will be md5 if >32).

[465] Fix | Delete

* @param string $file_type One of 'css','js','ccss','ucss'.

[466] Fix | Delete

* @param string $filecon_md5 MD5 of the generated file content.

[467] Fix | Delete

* @param string $path Base path where files live.

[468] Fix | Delete

* @param bool $mobile Whether mapping is for mobile.

[469] Fix | Delete

* @param bool $webp Whether mapping is for webp.

[470] Fix | Delete

* @return void

[471] Fix | Delete

*/

[472] Fix | Delete

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

[473] Fix | Delete

global $wpdb;

[474] Fix | Delete

[475] Fix | Delete

if ( strlen( $vary ) > 32 ) {

[476] Fix | Delete

$vary = md5( $vary );

[477] Fix | Delete

}

[478] Fix | Delete

[479] Fix | Delete

if ( ! isset( $this->_url_file_types[ $file_type ] ) ) {

[480] Fix | Delete

return;

[481] Fix | Delete

}

[482] Fix | Delete

[483] Fix | Delete

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

[484] Fix | Delete

[485] Fix | Delete

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

[486] Fix | Delete

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

[487] Fix | Delete

[488] Fix | Delete

// Ensure URL row exists.

[489] Fix | Delete

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

[490] Fix | Delete

$url_row = $wpdb->get_row( $wpdb->prepare( $q, $request_url ), ARRAY_A ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.NotPrepared

[491] Fix | Delete

if ( ! $url_row ) {

[492] Fix | Delete

$q = "INSERT INTO `$tb_url` SET url=%s";

[493] Fix | Delete

$wpdb->query( $wpdb->prepare( $q, $request_url ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.NotPrepared

[494] Fix | Delete

$url_id = (int) $wpdb->insert_id;

[495] Fix | Delete

} else {

[496] Fix | Delete

$url_id = (int) $url_row['id'];

[497] Fix | Delete

}

[498] Fix | Delete

[499] Fix | Delete