<?php

[0] Fix | Delete

/**

[1] Fix | Delete

* The admin optimize tool.

[2] Fix | Delete

*

[3] Fix | Delete

* @package LiteSpeed

[4] Fix | Delete

* @since 1.2.1

[5] Fix | Delete

*/

[6] Fix | Delete

[7] Fix | Delete

namespace LiteSpeed;

[8] Fix | Delete

[9] Fix | Delete

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

[10] Fix | Delete

[11] Fix | Delete

/**

[12] Fix | Delete

* Database optimization utilities for LiteSpeed.

[13] Fix | Delete

*/

[14] Fix | Delete

class DB_Optm extends Root {

[15] Fix | Delete

[16] Fix | Delete

/**

[17] Fix | Delete

* Whether there are more sites hidden in multisite counts.

[18] Fix | Delete

*

[19] Fix | Delete

* @var bool

[20] Fix | Delete

*/

[21] Fix | Delete

private static $_hide_more = false;

[22] Fix | Delete

[23] Fix | Delete

/**

[24] Fix | Delete

* Supported cleanup types.

[25] Fix | Delete

*

[26] Fix | Delete

* @var string[]

[27] Fix | Delete

*/

[28] Fix | Delete

private static $types = [

[29] Fix | Delete

'revision',

[30] Fix | Delete

'orphaned_post_meta',

[31] Fix | Delete

'auto_draft',

[32] Fix | Delete

'trash_post',

[33] Fix | Delete

'spam_comment',

[34] Fix | Delete

'trash_comment',

[35] Fix | Delete

'trackback-pingback',

[36] Fix | Delete

'expired_transient',

[37] Fix | Delete

'all_transients',

[38] Fix | Delete

'optimize_tables',

[39] Fix | Delete

];

[40] Fix | Delete

[41] Fix | Delete

/**

[42] Fix | Delete

* Convert tables to InnoDB type identifier.

[43] Fix | Delete

*/

[44] Fix | Delete

const TYPE_CONV_TB = 'conv_innodb';

[45] Fix | Delete

[46] Fix | Delete

/**

[47] Fix | Delete

* Show if there are more sites in hidden.

[48] Fix | Delete

*

[49] Fix | Delete

* @since 3.0

[50] Fix | Delete

* @return bool

[51] Fix | Delete

*/

[52] Fix | Delete

public static function hide_more() {

[53] Fix | Delete

return self::$_hide_more;

[54] Fix | Delete

}

[55] Fix | Delete

[56] Fix | Delete

/**

[57] Fix | Delete

* Clean/Optimize WP tables.

[58] Fix | Delete

*

[59] Fix | Delete

* @since 1.2.1

[60] Fix | Delete

* @access public

[61] Fix | Delete

* @param string $type The type to clean.

[62] Fix | Delete

* @param bool $ignore_multisite If ignoring multisite check.

[63] Fix | Delete

* @return int|string The rows that will be affected, or '-' on unknown.

[64] Fix | Delete

*/

[65] Fix | Delete

public function db_count( $type, $ignore_multisite = false ) {

[66] Fix | Delete

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

[67] Fix | Delete

$num = 0;

[68] Fix | Delete

foreach ( self::$types as $v ) {

[69] Fix | Delete

$num += (int) $this->db_count( $v );

[70] Fix | Delete

}

[71] Fix | Delete

return $num;

[72] Fix | Delete

}

[73] Fix | Delete

[74] Fix | Delete

if ( ! $ignore_multisite ) {

[75] Fix | Delete

if ( is_multisite() && is_network_admin() ) {

[76] Fix | Delete

$num = 0;

[77] Fix | Delete

$blogs = Activation::get_network_ids();

[78] Fix | Delete

foreach ( $blogs as $k => $blog_id ) {

[79] Fix | Delete

if ( $k > 3 ) {

[80] Fix | Delete

self::$_hide_more = true;

[81] Fix | Delete

break;

[82] Fix | Delete

}

[83] Fix | Delete

[84] Fix | Delete

switch_to_blog( $blog_id );

[85] Fix | Delete

$num += (int) $this->db_count( $type, true );

[86] Fix | Delete

restore_current_blog();

[87] Fix | Delete

}

[88] Fix | Delete

return $num;

[89] Fix | Delete

}

[90] Fix | Delete

}

[91] Fix | Delete

[92] Fix | Delete

global $wpdb;

[93] Fix | Delete

[94] Fix | Delete

switch ( $type ) {

[95] Fix | Delete

case 'revision':

[96] Fix | Delete

$rev_max = (int) $this->conf( Base::O_DB_OPTM_REVISIONS_MAX );

[97] Fix | Delete

$rev_age = (int) $this->conf( Base::O_DB_OPTM_REVISIONS_AGE );

[98] Fix | Delete

[99] Fix | Delete

$sql_add = '';

[100] Fix | Delete

if ( $rev_age ) {

[101] Fix | Delete

$sql_add = $wpdb->prepare( ' AND post_modified < DATE_SUB( NOW(), INTERVAL %d DAY ) ', $rev_age );

[102] Fix | Delete

}

[103] Fix | Delete

[104] Fix | Delete

$sql = "SELECT COUNT(*) FROM `$wpdb->posts` WHERE post_type = 'revision' $sql_add";

[105] Fix | Delete

if ( ! $rev_max ) {

[106] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.NotPrepared

[107] Fix | Delete

return (int) $wpdb->get_var( $sql );

[108] Fix | Delete

}

[109] Fix | Delete

[110] Fix | Delete

// Has count limit.

[111] Fix | Delete

$sql = "SELECT COUNT(*) - %d FROM `$wpdb->posts` WHERE post_type = 'revision' $sql_add GROUP BY post_parent HAVING COUNT(*) > %d";

[112] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.NotPrepared

[113] Fix | Delete

$res = (array) $wpdb->get_results( $wpdb->prepare( $sql, $rev_max, $rev_max ), ARRAY_N );

[114] Fix | Delete

[115] Fix | Delete

Utility::compatibility();

[116] Fix | Delete

return array_sum( array_column( $res, 0 ) );

[117] Fix | Delete

[118] Fix | Delete

case 'orphaned_post_meta':

[119] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[120] Fix | Delete

return (int) $wpdb->get_var( "SELECT COUNT(*) FROM `$wpdb->postmeta` a LEFT JOIN `$wpdb->posts` b ON b.ID=a.post_id WHERE b.ID IS NULL" );

[121] Fix | Delete

[122] Fix | Delete

case 'auto_draft':

[123] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[124] Fix | Delete

return (int) $wpdb->get_var( "SELECT COUNT(*) FROM `$wpdb->posts` WHERE post_status = 'auto-draft'" );

[125] Fix | Delete

[126] Fix | Delete

case 'trash_post':

[127] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[128] Fix | Delete

return (int) $wpdb->get_var( "SELECT COUNT(*) FROM `$wpdb->posts` WHERE post_status = 'trash'" );

[129] Fix | Delete

[130] Fix | Delete

case 'spam_comment':

[131] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[132] Fix | Delete

return (int) $wpdb->get_var( "SELECT COUNT(*) FROM `$wpdb->comments` WHERE comment_approved = 'spam'" );

[133] Fix | Delete

[134] Fix | Delete

case 'trash_comment':

[135] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[136] Fix | Delete

return (int) $wpdb->get_var( "SELECT COUNT(*) FROM `$wpdb->comments` WHERE comment_approved = 'trash'" );

[137] Fix | Delete

[138] Fix | Delete

case 'trackback-pingback':

[139] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[140] Fix | Delete

return (int) $wpdb->get_var( "SELECT COUNT(*) FROM `$wpdb->comments` WHERE comment_type = 'trackback' OR comment_type = 'pingback'" );

[141] Fix | Delete

[142] Fix | Delete

case 'expired_transient':

[143] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[144] Fix | Delete

return (int) $wpdb->get_var(

[145] Fix | Delete

$wpdb->prepare(

[146] Fix | Delete

"SELECT COUNT(*) FROM `$wpdb->options` WHERE option_name LIKE %s AND option_value < %d",

[147] Fix | Delete

$wpdb->esc_like( '_transient_timeout_' ) . '%',

[148] Fix | Delete

time()

[149] Fix | Delete

)

[150] Fix | Delete

);

[151] Fix | Delete

[152] Fix | Delete

case 'all_transients':

[153] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[154] Fix | Delete

return (int) $wpdb->get_var(

[155] Fix | Delete

$wpdb->prepare(

[156] Fix | Delete

"SELECT COUNT(*) FROM `$wpdb->options` WHERE option_name LIKE %s",

[157] Fix | Delete

$wpdb->esc_like( '_transient_' ) . '%'

[158] Fix | Delete

)

[159] Fix | Delete

);

[160] Fix | Delete

[161] Fix | Delete

case 'optimize_tables':

[162] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[163] Fix | Delete

return (int) $wpdb->get_var(

[164] Fix | Delete

$wpdb->prepare(

[165] Fix | Delete

"SELECT COUNT(*) FROM information_schema.tables WHERE TABLE_SCHEMA = %s AND ENGINE <> 'InnoDB' AND DATA_FREE > 0",

[166] Fix | Delete

DB_NAME

[167] Fix | Delete

)

[168] Fix | Delete

);

[169] Fix | Delete

}

[170] Fix | Delete

[171] Fix | Delete

return '-';

[172] Fix | Delete

}

[173] Fix | Delete

[174] Fix | Delete

/**

[175] Fix | Delete

* Clean/Optimize WP tables.

[176] Fix | Delete

*

[177] Fix | Delete

* @since 1.2.1

[178] Fix | Delete

* @since 3.0 changed to private

[179] Fix | Delete

* @access private

[180] Fix | Delete

* @param string $type Cleanup type.

[181] Fix | Delete

* @return string Status message.

[182] Fix | Delete

*/

[183] Fix | Delete

private function _db_clean( $type ) {

[184] Fix | Delete

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

[185] Fix | Delete

foreach ( self::$types as $v ) {

[186] Fix | Delete

$this->_db_clean( $v );

[187] Fix | Delete

}

[188] Fix | Delete

return __( 'Clean all successfully.', 'litespeed-cache' );

[189] Fix | Delete

}

[190] Fix | Delete

[191] Fix | Delete

global $wpdb;

[192] Fix | Delete

[193] Fix | Delete

switch ( $type ) {

[194] Fix | Delete

case 'revision':

[195] Fix | Delete

$rev_max = (int) $this->conf( Base::O_DB_OPTM_REVISIONS_MAX );

[196] Fix | Delete

$rev_age = (int) $this->conf( Base::O_DB_OPTM_REVISIONS_AGE );

[197] Fix | Delete

[198] Fix | Delete

$postmeta = "`$wpdb->postmeta`";

[199] Fix | Delete

$posts = "`$wpdb->posts`";

[200] Fix | Delete

[201] Fix | Delete

$sql_postmeta_join = function ( $table ) use ( $postmeta, $posts ) {

[202] Fix | Delete

return "

[203] Fix | Delete

$postmeta

[204] Fix | Delete

CROSS JOIN $table

[205] Fix | Delete

ON $posts.ID = $postmeta.post_id

[206] Fix | Delete

";

[207] Fix | Delete

};

[208] Fix | Delete

[209] Fix | Delete

$sql_where = "WHERE $posts.post_type = 'revision'";

[210] Fix | Delete

[211] Fix | Delete

// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared

[212] Fix | Delete

$sql_add = $rev_age ? $wpdb->prepare( ' AND ' . $posts . '.post_modified < DATE_SUB( NOW(), INTERVAL %d DAY )', $rev_age ) : '';

[213] Fix | Delete

[214] Fix | Delete

if ( ! $rev_max ) {

[215] Fix | Delete

$sql_where = "$sql_where $sql_add";

[216] Fix | Delete

$sql_postmeta = $sql_postmeta_join( $posts );

[217] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared

[218] Fix | Delete

$wpdb->query( "DELETE $postmeta FROM $sql_postmeta $sql_where" );

[219] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared

[220] Fix | Delete

$wpdb->query( "DELETE FROM $posts $sql_where" );

[221] Fix | Delete

} else {

[222] Fix | Delete

// Has count limit.

[223] Fix | Delete

$sql = "

[224] Fix | Delete

SELECT COUNT(*) - %d

[225] Fix | Delete

AS del_max, post_parent

[226] Fix | Delete

FROM $posts

[227] Fix | Delete

WHERE post_type = 'revision'

[228] Fix | Delete

$sql_add

[229] Fix | Delete

GROUP BY post_parent

[230] Fix | Delete

HAVING COUNT(*) > %d

[231] Fix | Delete

";

[232] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.NotPrepared

[233] Fix | Delete

$res = (array) $wpdb->get_results( $wpdb->prepare( $sql, $rev_max, $rev_max ) );

[234] Fix | Delete

$sql_where = "

[235] Fix | Delete

$sql_where

[236] Fix | Delete

AND post_parent = %d

[237] Fix | Delete

ORDER BY ID

[238] Fix | Delete

LIMIT %d

[239] Fix | Delete

";

[240] Fix | Delete

$sql_postmeta = $sql_postmeta_join( "(SELECT ID FROM $posts $sql_where) AS $posts" );

[241] Fix | Delete

foreach ( $res as $v ) {

[242] Fix | Delete

$args = [ (int) $v->post_parent, (int) $v->del_max ];

[243] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare

[244] Fix | Delete

$wpdb->query( $wpdb->prepare( "DELETE $postmeta FROM $sql_postmeta", $args ) );

[245] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare

[246] Fix | Delete

$wpdb->query( $wpdb->prepare( "DELETE FROM $posts $sql_where", $args ) );

[247] Fix | Delete

}

[248] Fix | Delete

}

[249] Fix | Delete

[250] Fix | Delete

return __( 'Clean post revisions successfully.', 'litespeed-cache' );

[251] Fix | Delete

[252] Fix | Delete

case 'orphaned_post_meta':

[253] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[254] Fix | Delete

$wpdb->query( "DELETE a FROM `$wpdb->postmeta` a LEFT JOIN `$wpdb->posts` b ON b.ID=a.post_id WHERE b.ID IS NULL" );

[255] Fix | Delete

return __( 'Clean orphaned post meta successfully.', 'litespeed-cache' );

[256] Fix | Delete

[257] Fix | Delete

case 'auto_draft':

[258] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[259] Fix | Delete

$wpdb->query( "DELETE FROM `$wpdb->posts` WHERE post_status = 'auto-draft'" );

[260] Fix | Delete

return __( 'Clean auto drafts successfully.', 'litespeed-cache' );

[261] Fix | Delete

[262] Fix | Delete

case 'trash_post':

[263] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[264] Fix | Delete

$wpdb->query( "DELETE FROM `$wpdb->posts` WHERE post_status = 'trash'" );

[265] Fix | Delete

return __( 'Clean trashed posts and pages successfully.', 'litespeed-cache' );

[266] Fix | Delete

[267] Fix | Delete

case 'spam_comment':

[268] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[269] Fix | Delete

$wpdb->query( "DELETE FROM `$wpdb->comments` WHERE comment_approved = 'spam'" );

[270] Fix | Delete

return __( 'Clean spam comments successfully.', 'litespeed-cache' );

[271] Fix | Delete

[272] Fix | Delete

case 'trash_comment':

[273] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[274] Fix | Delete

$wpdb->query( "DELETE FROM `$wpdb->comments` WHERE comment_approved = 'trash'" );

[275] Fix | Delete

return __( 'Clean trashed comments successfully.', 'litespeed-cache' );

[276] Fix | Delete

[277] Fix | Delete

case 'trackback-pingback':

[278] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[279] Fix | Delete

$wpdb->query( "DELETE FROM `$wpdb->comments` WHERE comment_type = 'trackback' OR comment_type = 'pingback'" );

[280] Fix | Delete

return __( 'Clean trackbacks and pingbacks successfully.', 'litespeed-cache' );

[281] Fix | Delete

[282] Fix | Delete

case 'expired_transient':

[283] Fix | Delete

$keys_to_delete = [];

[284] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[285] Fix | Delete

$transients = $wpdb->get_results(

[286] Fix | Delete

$wpdb->prepare(

[287] Fix | Delete

"SELECT option_name FROM `$wpdb->options` WHERE option_name LIKE %s AND option_value < %d",

[288] Fix | Delete

$wpdb->esc_like( '_transient_timeout_' ) . '%',

[289] Fix | Delete

time()

[290] Fix | Delete

),

[291] Fix | Delete

);

[292] Fix | Delete

foreach ( $transients as $transient ) {

[293] Fix | Delete

$keys_to_delete[] = $transient->option_name;

[294] Fix | Delete

$keys_to_delete[] = str_replace( '_transient_timeout_', '_transient_', $transient->option_name );

[295] Fix | Delete

}

[296] Fix | Delete

[297] Fix | Delete

if ( ! empty( $keys_to_delete ) ) {

[298] Fix | Delete

$placeholders = implode( ',', array_fill( 0, count( $keys_to_delete ), '%s' ) );

[299] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[300] Fix | Delete

$wpdb->query(

[301] Fix | Delete

$wpdb->prepare(

[302] Fix | Delete

// phpcs:ignore WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare, WordPress.DB.PreparedSQL.InterpolatedNotPrepared

[303] Fix | Delete

"DELETE FROM `$wpdb->options` WHERE option_name IN ( $placeholders )",

[304] Fix | Delete

$keys_to_delete

[305] Fix | Delete

)

[306] Fix | Delete

);

[307] Fix | Delete

}

[308] Fix | Delete

return __( 'Clean expired transients successfully.', 'litespeed-cache' );

[309] Fix | Delete

[310] Fix | Delete

case 'all_transients':

[311] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[312] Fix | Delete

$wpdb->query(

[313] Fix | Delete

$wpdb->prepare(

[314] Fix | Delete

"DELETE FROM `$wpdb->options` WHERE option_name LIKE %s",

[315] Fix | Delete

$wpdb->esc_like( '_transient_' ) . '%'

[316] Fix | Delete

)

[317] Fix | Delete

);

[318] Fix | Delete

return __( 'Clean all transients successfully.', 'litespeed-cache' );

[319] Fix | Delete

[320] Fix | Delete

case 'optimize_tables':

[321] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[322] Fix | Delete

$result = (array) $wpdb->get_results(

[323] Fix | Delete

$wpdb->prepare(

[324] Fix | Delete

"SELECT table_name, DATA_FREE FROM information_schema.tables WHERE TABLE_SCHEMA = %s AND ENGINE <> 'InnoDB' AND DATA_FREE > 0",

[325] Fix | Delete

DB_NAME

[326] Fix | Delete

)

[327] Fix | Delete

);

[328] Fix | Delete

if ( $result ) {

[329] Fix | Delete

foreach ( $result as $row ) {

[330] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared

[331] Fix | Delete

$wpdb->query( 'OPTIMIZE TABLE ' . esc_sql( $row->table_name ) );

[332] Fix | Delete

}

[333] Fix | Delete

}

[334] Fix | Delete

return __( 'Optimized all tables.', 'litespeed-cache' );

[335] Fix | Delete

}

[336] Fix | Delete

}

[337] Fix | Delete

[338] Fix | Delete

/**

[339] Fix | Delete

* Get all MyISAM tables.

[340] Fix | Delete

*

[341] Fix | Delete

* @since 3.0

[342] Fix | Delete

* @access public

[343] Fix | Delete

* @return array

[344] Fix | Delete

*/

[345] Fix | Delete

public function list_myisam() {

[346] Fix | Delete

global $wpdb;

[347] Fix | Delete

[348] Fix | Delete

$like = $wpdb->esc_like( $wpdb->prefix ) . '%';

[349] Fix | Delete

[350] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery

[351] Fix | Delete

return (array) $wpdb->get_results(

[352] Fix | Delete

$wpdb->prepare(

[353] Fix | Delete

"SELECT TABLE_NAME as table_name, ENGINE as engine

[354] Fix | Delete

FROM information_schema.tables

[355] Fix | Delete

WHERE TABLE_SCHEMA = %s AND ENGINE = 'myisam' AND TABLE_NAME LIKE %s",

[356] Fix | Delete

DB_NAME,

[357] Fix | Delete

$like

[358] Fix | Delete

)

[359] Fix | Delete

);

[360] Fix | Delete

}

[361] Fix | Delete

[362] Fix | Delete

/**

[363] Fix | Delete

* Convert tables to InnoDB.

[364] Fix | Delete

*

[365] Fix | Delete

* @since 3.0

[366] Fix | Delete

* @access private

[367] Fix | Delete

* @return void

[368] Fix | Delete

*/

[369] Fix | Delete

private function _conv_innodb() {

[370] Fix | Delete

global $wpdb;

[371] Fix | Delete

[372] Fix | Delete

$tb_param = isset( $_GET['litespeed_tb'] ) ? sanitize_text_field( wp_unslash( $_GET['litespeed_tb'] ) ) : ''; // phpcs:ignore WordPress.Security.NonceVerification.Recommended

[373] Fix | Delete

[374] Fix | Delete

if ( ! $tb_param ) {

[375] Fix | Delete

Admin_Display::error( 'No table to convert or invalid nonce' );

[376] Fix | Delete

return;

[377] Fix | Delete

}

[378] Fix | Delete

[379] Fix | Delete

$tb = false;

[380] Fix | Delete

$list = $this->list_myisam();

[381] Fix | Delete

$names = wp_list_pluck( $list, 'table_name' );

[382] Fix | Delete

[383] Fix | Delete

if ( in_array( $tb_param, $names, true ) ) {

[384] Fix | Delete

$tb = $tb_param;

[385] Fix | Delete

}

[386] Fix | Delete

[387] Fix | Delete

if ( ! $tb ) {

[388] Fix | Delete

Admin_Display::error( 'No existing table' );

[389] Fix | Delete

return;

[390] Fix | Delete

}

[391] Fix | Delete

[392] Fix | Delete

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.DirectDatabaseQuery.SchemaChange

[393] Fix | Delete

$wpdb->query( 'ALTER TABLE ' . esc_sql( DB_NAME ) . '.' . esc_sql( $tb ) . ' ENGINE = InnoDB' );

[394] Fix | Delete

[395] Fix | Delete

Debug2::debug( "[DB] Converted $tb to InnoDB" );

[396] Fix | Delete

[397] Fix | Delete

$msg = __( 'Converted to InnoDB successfully.', 'litespeed-cache' );

[398] Fix | Delete

Admin_Display::success( $msg );

[399] Fix | Delete

}

[400] Fix | Delete

[401] Fix | Delete

/**

[402] Fix | Delete

* Count all autoload size.

[403] Fix | Delete

*

[404] Fix | Delete

* @since 3.0

[405] Fix | Delete

* @access public

[406] Fix | Delete

* @return object Summary with size, entries, and toplist.

[407] Fix | Delete

*/

[408] Fix | Delete

public function autoload_summary() {

[409] Fix | Delete

global $wpdb;

[410] Fix | Delete

[411] Fix | Delete

$autoload_values = function_exists( 'wp_autoload_values_to_autoload' ) ? wp_autoload_values_to_autoload() : [ 'yes', 'on', 'auto-on', 'auto' ];

[412] Fix | Delete

$placeholders = implode( ',', array_fill( 0, count( $autoload_values ), '%s' ) );

[413] Fix | Delete

[414] Fix | Delete

// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare

[415] Fix | Delete

$summary = $wpdb->get_row(

[416] Fix | Delete

$wpdb->prepare(

[417] Fix | Delete

"SELECT SUM(LENGTH(option_value)) AS autoload_size, COUNT(*) AS autload_entries

[418] Fix | Delete

FROM `$wpdb->options`

[419] Fix | Delete

WHERE autoload IN ($placeholders)",

[420] Fix | Delete

$autoload_values

[421] Fix | Delete

)

[422] Fix | Delete

);

[423] Fix | Delete

[424] Fix | Delete

// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare

[425] Fix | Delete

$summary->autoload_toplist = $wpdb->get_results(

[426] Fix | Delete

$wpdb->prepare(

[427] Fix | Delete

"SELECT option_name, LENGTH(option_value) AS option_value_length, autoload

[428] Fix | Delete

FROM `$wpdb->options`

[429] Fix | Delete

WHERE autoload IN ($placeholders)

[430] Fix | Delete

ORDER BY option_value_length DESC

[431] Fix | Delete

LIMIT 20",

[432] Fix | Delete

$autoload_values

[433] Fix | Delete

)

[434] Fix | Delete

);

[435] Fix | Delete

[436] Fix | Delete

return $summary;

[437] Fix | Delete

}

[438] Fix | Delete

[439] Fix | Delete

/**

[440] Fix | Delete

* Handle all request actions from main cls.

[441] Fix | Delete

*

[442] Fix | Delete

* @since 3.0

[443] Fix | Delete

* @access public

[444] Fix | Delete

* @return void

[445] Fix | Delete

*/

[446] Fix | Delete

public function handler() {

[447] Fix | Delete

$type = Router::verify_type();

[448] Fix | Delete

[449] Fix | Delete

switch ($type) {

[450] Fix | Delete

case self::TYPE_CONV_TB:

[451] Fix | Delete

$this->_conv_innodb();

[452] Fix | Delete

break;

[453] Fix | Delete

[454] Fix | Delete

default:

[455] Fix | Delete

if ( 'all' === $type || in_array( $type, self::$types, true ) ) {

[456] Fix | Delete

if ( is_multisite() && is_network_admin() ) {

[457] Fix | Delete

$blogs = Activation::get_network_ids();

[458] Fix | Delete

foreach ( $blogs as $blog_id ) {

[459] Fix | Delete

switch_to_blog( $blog_id );

[460] Fix | Delete

$msg = $this->_db_clean( $type );

[461] Fix | Delete

restore_current_blog();

[462] Fix | Delete

}

[463] Fix | Delete

} else {

[464] Fix | Delete

$msg = $this->_db_clean( $type );

[465] Fix | Delete

}

[466] Fix | Delete

Admin_Display::success( $msg );

[467] Fix | Delete

}

[468] Fix | Delete

break;

[469] Fix | Delete

}

[470] Fix | Delete

[471] Fix | Delete

Admin::redirect();

[472] Fix | Delete

}

[473] Fix | Delete

[474] Fix | Delete

/**

[475] Fix | Delete

* Clean DB via WP-CLI.

[476] Fix | Delete

*

[477] Fix | Delete

* @since 7.0

[478] Fix | Delete

* @access public

[479] Fix | Delete

* @param string $args Cleanup type.

[480] Fix | Delete

* @return string|false

[481] Fix | Delete

*/

[482] Fix | Delete

public function handler_clean_db_cli( $args ) {

[483] Fix | Delete

if ( defined( 'WP_CLI' ) && constant('WP_CLI') ) {

[484] Fix | Delete

return $this->_db_clean( $args );

[485] Fix | Delete

}

[486] Fix | Delete

[487] Fix | Delete

return false;

[488] Fix | Delete

}

[489] Fix | Delete

}

[490] Fix | Delete

[491] Fix | Delete