<?php

[0] Fix | Delete

[1] Fix | Delete

/**

[2] Fix | Delete

* The admin optimize tool

[3] Fix | Delete

*

[4] Fix | Delete

*

[5] Fix | Delete

* @since 1.2.1

[6] Fix | Delete

* @package LiteSpeed

[7] Fix | Delete

* @subpackage LiteSpeed/src

[8] Fix | Delete

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

[9] Fix | Delete

*/

[10] Fix | Delete

[11] Fix | Delete

namespace LiteSpeed;

[12] Fix | Delete

[13] Fix | Delete

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

[14] Fix | Delete

[15] Fix | Delete

class DB_Optm extends Root

[16] Fix | Delete

{

[17] Fix | Delete

private static $_hide_more = false;

[18] Fix | Delete

[19] Fix | Delete

private static $TYPES = array(

[20] Fix | Delete

'revision',

[21] Fix | Delete

'orphaned_post_meta',

[22] Fix | Delete

'auto_draft',

[23] Fix | Delete

'trash_post',

[24] Fix | Delete

'spam_comment',

[25] Fix | Delete

'trash_comment',

[26] Fix | Delete

'trackback-pingback',

[27] Fix | Delete

'expired_transient',

[28] Fix | Delete

'all_transients',

[29] Fix | Delete

'optimize_tables',

[30] Fix | Delete

);

[31] Fix | Delete

const TYPE_CONV_TB = 'conv_innodb';

[32] Fix | Delete

[33] Fix | Delete

/**

[34] Fix | Delete

* Show if there are more sites in hidden

[35] Fix | Delete

*

[36] Fix | Delete

* @since 3.0

[37] Fix | Delete

*/

[38] Fix | Delete

public static function hide_more()

[39] Fix | Delete

{

[40] Fix | Delete

return self::$_hide_more;

[41] Fix | Delete

}

[42] Fix | Delete

[43] Fix | Delete

/**

[44] Fix | Delete

* Clean/Optimize WP tables

[45] Fix | Delete

*

[46] Fix | Delete

* @since 1.2.1

[47] Fix | Delete

* @access public

[48] Fix | Delete

* @param string $type The type to clean

[49] Fix | Delete

* @param bool $ignore_multisite If ignore multisite check

[50] Fix | Delete

* @return int The rows that will be affected

[51] Fix | Delete

*/

[52] Fix | Delete

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

[53] Fix | Delete

{

[54] Fix | Delete

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

[55] Fix | Delete

$num = 0;

[56] Fix | Delete

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

[57] Fix | Delete

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

[58] Fix | Delete

}

[59] Fix | Delete

return $num;

[60] Fix | Delete

}

[61] Fix | Delete

[62] Fix | Delete

if (!$ignore_multisite) {

[63] Fix | Delete

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

[64] Fix | Delete

$num = 0;

[65] Fix | Delete

$blogs = Activation::get_network_ids();

[66] Fix | Delete

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

[67] Fix | Delete

if ($k > 3) {

[68] Fix | Delete

self::$_hide_more = true;

[69] Fix | Delete

break;

[70] Fix | Delete

}

[71] Fix | Delete

[72] Fix | Delete

switch_to_blog($blog_id);

[73] Fix | Delete

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

[74] Fix | Delete

restore_current_blog();

[75] Fix | Delete

}

[76] Fix | Delete

return $num;

[77] Fix | Delete

}

[78] Fix | Delete

}

[79] Fix | Delete

[80] Fix | Delete

global $wpdb;

[81] Fix | Delete

[82] Fix | Delete

switch ($type) {

[83] Fix | Delete

case 'revision':

[84] Fix | Delete

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

[85] Fix | Delete

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

[86] Fix | Delete

$sql_add = '';

[87] Fix | Delete

if ($rev_age) {

[88] Fix | Delete

$sql_add = " and post_modified < DATE_SUB( NOW(), INTERVAL $rev_age DAY ) ";

[89] Fix | Delete

}

[90] Fix | Delete

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

[91] Fix | Delete

if (!$rev_max) {

[92] Fix | Delete

return $wpdb->get_var($sql);

[93] Fix | Delete

}

[94] Fix | Delete

// Has count limit

[95] Fix | Delete

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

[96] Fix | Delete

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

[97] Fix | Delete

[98] Fix | Delete

Utility::compatibility();

[99] Fix | Delete

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

[100] Fix | Delete

[101] Fix | Delete

case 'orphaned_post_meta':

[102] Fix | Delete

return $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");

[103] Fix | Delete

[104] Fix | Delete

case 'auto_draft':

[105] Fix | Delete

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

[106] Fix | Delete

[107] Fix | Delete

case 'trash_post':

[108] Fix | Delete

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

[109] Fix | Delete

[110] Fix | Delete

case 'spam_comment':

[111] Fix | Delete

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

[112] Fix | Delete

[113] Fix | Delete

case 'trash_comment':

[114] Fix | Delete

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

[115] Fix | Delete

[116] Fix | Delete

case 'trackback-pingback':

[117] Fix | Delete

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

[118] Fix | Delete

[119] Fix | Delete

case 'expired_transient':

[120] Fix | Delete

return $wpdb->get_var("SELECT COUNT(*) FROM `$wpdb->options` WHERE option_name LIKE '_transient_timeout%' AND option_value < " . time());

[121] Fix | Delete

[122] Fix | Delete

case 'all_transients':

[123] Fix | Delete

return $wpdb->get_var("SELECT COUNT(*) FROM `$wpdb->options` WHERE option_name LIKE '%_transient_%'");

[124] Fix | Delete

[125] Fix | Delete

case 'optimize_tables':

[126] Fix | Delete

return $wpdb->get_var("SELECT COUNT(*) FROM information_schema.tables WHERE TABLE_SCHEMA = '" . DB_NAME . "' and ENGINE <> 'InnoDB' and DATA_FREE > 0");

[127] Fix | Delete

}

[128] Fix | Delete

[129] Fix | Delete

return '-';

[130] Fix | Delete

}

[131] Fix | Delete

[132] Fix | Delete

/**

[133] Fix | Delete

* Clean/Optimize WP tables

[134] Fix | Delete

*

[135] Fix | Delete

* @since 1.2.1

[136] Fix | Delete

* @since 3.0 changed to private

[137] Fix | Delete

* @access private

[138] Fix | Delete

*/

[139] Fix | Delete

private function _db_clean($type)

[140] Fix | Delete

{

[141] Fix | Delete

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

[142] Fix | Delete

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

[143] Fix | Delete

$this->_db_clean($v);

[144] Fix | Delete

}

[145] Fix | Delete

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

[146] Fix | Delete

}

[147] Fix | Delete

[148] Fix | Delete

global $wpdb;

[149] Fix | Delete

switch ($type) {

[150] Fix | Delete

case 'revision':

[151] Fix | Delete

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

[152] Fix | Delete

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

[153] Fix | Delete

[154] Fix | Delete

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

[155] Fix | Delete

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

[156] Fix | Delete

[157] Fix | Delete

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

[158] Fix | Delete

return "

[159] Fix | Delete

$postmeta

[160] Fix | Delete

CROSS JOIN $table

[161] Fix | Delete

ON $posts.ID = $postmeta.post_id

[162] Fix | Delete

";

[163] Fix | Delete

};

[164] Fix | Delete

[165] Fix | Delete

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

[166] Fix | Delete

[167] Fix | Delete

$sql_add = $rev_age ? "AND $posts.post_modified < DATE_SUB( NOW(), INTERVAL $rev_age DAY )" : '';

[168] Fix | Delete

[169] Fix | Delete

if (!$rev_max) {

[170] Fix | Delete

$sql_where = "$sql_where $sql_add";

[171] Fix | Delete

$sql_postmeta = $sql_postmeta_join($posts);

[172] Fix | Delete

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

[173] Fix | Delete

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

[174] Fix | Delete

} else {

[175] Fix | Delete

// Has count limit

[176] Fix | Delete

$sql = "

[177] Fix | Delete

SELECT COUNT(*) - $rev_max

[178] Fix | Delete

AS del_max, post_parent

[179] Fix | Delete

FROM $posts

[180] Fix | Delete

WHERE post_type = 'revision'

[181] Fix | Delete

$sql_add

[182] Fix | Delete

GROUP BY post_parent

[183] Fix | Delete

HAVING COUNT(*) > $rev_max

[184] Fix | Delete

";

[185] Fix | Delete

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

[186] Fix | Delete

$sql_where = "

[187] Fix | Delete

$sql_where

[188] Fix | Delete

AND post_parent = %d

[189] Fix | Delete

ORDER BY ID

[190] Fix | Delete

LIMIT %d

[191] Fix | Delete

";

[192] Fix | Delete

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

[193] Fix | Delete

foreach ($res as $v) {

[194] Fix | Delete

$args = array($v->post_parent, $v->del_max);

[195] Fix | Delete

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

[196] Fix | Delete

$wpdb->query($sql);

[197] Fix | Delete

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

[198] Fix | Delete

$wpdb->query($sql);

[199] Fix | Delete

}

[200] Fix | Delete

}

[201] Fix | Delete

[202] Fix | Delete

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

[203] Fix | Delete

[204] Fix | Delete

case 'orphaned_post_meta':

[205] 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");

[206] Fix | Delete

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

[207] Fix | Delete

[208] Fix | Delete

case 'auto_draft':

[209] Fix | Delete

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

[210] Fix | Delete

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

[211] Fix | Delete

[212] Fix | Delete

case 'trash_post':

[213] Fix | Delete

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

[214] Fix | Delete

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

[215] Fix | Delete

[216] Fix | Delete

case 'spam_comment':

[217] Fix | Delete

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

[218] Fix | Delete

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

[219] Fix | Delete

[220] Fix | Delete

case 'trash_comment':

[221] Fix | Delete

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

[222] Fix | Delete

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

[223] Fix | Delete

[224] Fix | Delete

case 'trackback-pingback':

[225] Fix | Delete

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

[226] Fix | Delete

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

[227] Fix | Delete

[228] Fix | Delete

case 'expired_transient':

[229] Fix | Delete

$wpdb->query("DELETE FROM `$wpdb->options` WHERE option_name LIKE '_transient_timeout%' AND option_value < " . time());

[230] Fix | Delete

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

[231] Fix | Delete

[232] Fix | Delete

case 'all_transients':

[233] Fix | Delete

$wpdb->query("DELETE FROM `$wpdb->options` WHERE option_name LIKE '%\\_transient\\_%'");

[234] Fix | Delete

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

[235] Fix | Delete

[236] Fix | Delete

case 'optimize_tables':

[237] Fix | Delete

$sql = "SELECT table_name, DATA_FREE FROM information_schema.tables WHERE TABLE_SCHEMA = '" . DB_NAME . "' and ENGINE <> 'InnoDB' and DATA_FREE > 0";

[238] Fix | Delete

$result = $wpdb->get_results($sql);

[239] Fix | Delete

if ($result) {

[240] Fix | Delete

foreach ($result as $row) {

[241] Fix | Delete

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

[242] Fix | Delete

}

[243] Fix | Delete

}

[244] Fix | Delete

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

[245] Fix | Delete

}

[246] Fix | Delete

}

[247] Fix | Delete

[248] Fix | Delete

/**

[249] Fix | Delete

* Get all myisam tables

[250] Fix | Delete

*

[251] Fix | Delete

* @since 3.0

[252] Fix | Delete

* @access public

[253] Fix | Delete

*/

[254] Fix | Delete

public function list_myisam()

[255] Fix | Delete

{

[256] Fix | Delete

global $wpdb;

[257] Fix | Delete

$q = "SELECT * FROM information_schema.tables WHERE TABLE_SCHEMA = '" . DB_NAME . "' and ENGINE = 'myisam' AND TABLE_NAME LIKE '{$wpdb->prefix}%'";

[258] Fix | Delete

return $wpdb->get_results($q);

[259] Fix | Delete

}

[260] Fix | Delete

[261] Fix | Delete

/**

[262] Fix | Delete

* Convert tables to InnoDB

[263] Fix | Delete

*

[264] Fix | Delete

* @since 3.0

[265] Fix | Delete

* @access private

[266] Fix | Delete

*/

[267] Fix | Delete

private function _conv_innodb()

[268] Fix | Delete

{

[269] Fix | Delete

global $wpdb;

[270] Fix | Delete

[271] Fix | Delete

if (empty($_GET['tb'])) {

[272] Fix | Delete

Admin_Display::error('No table to convert');

[273] Fix | Delete

return;

[274] Fix | Delete

}

[275] Fix | Delete

[276] Fix | Delete

$tb = false;

[277] Fix | Delete

[278] Fix | Delete

$list = $this->list_myisam();

[279] Fix | Delete

foreach ($list as $v) {

[280] Fix | Delete

if ($v->TABLE_NAME == $_GET['tb']) {

[281] Fix | Delete

$tb = $v->TABLE_NAME;

[282] Fix | Delete

break;

[283] Fix | Delete

}

[284] Fix | Delete

}

[285] Fix | Delete

[286] Fix | Delete

if (!$tb) {

[287] Fix | Delete

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

[288] Fix | Delete

return;

[289] Fix | Delete

}

[290] Fix | Delete

[291] Fix | Delete

$q = 'ALTER TABLE ' . DB_NAME . '.' . $tb . ' ENGINE = InnoDB';

[292] Fix | Delete

$wpdb->query($q);

[293] Fix | Delete

[294] Fix | Delete

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

[295] Fix | Delete

[296] Fix | Delete

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

[297] Fix | Delete

Admin_Display::succeed($msg);

[298] Fix | Delete

}

[299] Fix | Delete

[300] Fix | Delete

/**

[301] Fix | Delete

* Count all autoload size

[302] Fix | Delete

*

[303] Fix | Delete

* @since 3.0

[304] Fix | Delete

* @access public

[305] Fix | Delete

*/

[306] Fix | Delete

public function autoload_summary()

[307] Fix | Delete

{

[308] Fix | Delete

global $wpdb;

[309] Fix | Delete

[310] Fix | Delete

$summary = $wpdb->get_row("SELECT SUM(LENGTH(option_value)) AS autoload_size,COUNT(*) AS autload_entries FROM `$wpdb->options` WHERE autoload='yes'");

[311] Fix | Delete

[312] Fix | Delete

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

[313] Fix | Delete

"SELECT option_name, LENGTH(option_value) AS option_value_length FROM `$wpdb->options` WHERE autoload='yes' ORDER BY option_value_length DESC LIMIT 20"

[314] Fix | Delete

);

[315] Fix | Delete

[316] Fix | Delete

return $summary;

[317] Fix | Delete

}

[318] Fix | Delete

[319] Fix | Delete

/**

[320] Fix | Delete

* Handle all request actions from main cls

[321] Fix | Delete

*

[322] Fix | Delete

* @since 3.0

[323] Fix | Delete

* @access public

[324] Fix | Delete

*/

[325] Fix | Delete

public function handler()

[326] Fix | Delete

{

[327] Fix | Delete

$type = Router::verify_type();

[328] Fix | Delete

[329] Fix | Delete

switch ($type) {

[330] Fix | Delete

case 'all':

[331] Fix | Delete

case in_array($type, self::$TYPES):

[332] Fix | Delete

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

[333] Fix | Delete

$blogs = Activation::get_network_ids();

[334] Fix | Delete

foreach ($blogs as $blog_id) {

[335] Fix | Delete

switch_to_blog($blog_id);

[336] Fix | Delete

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

[337] Fix | Delete

restore_current_blog();

[338] Fix | Delete

}

[339] Fix | Delete

} else {

[340] Fix | Delete

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

[341] Fix | Delete

}

[342] Fix | Delete

Admin_Display::succeed($msg);

[343] Fix | Delete

break;

[344] Fix | Delete

[345] Fix | Delete

case self::TYPE_CONV_TB:

[346] Fix | Delete

$this->_conv_innodb();

[347] Fix | Delete

break;

[348] Fix | Delete

[349] Fix | Delete

default:

[350] Fix | Delete

break;

[351] Fix | Delete

}

[352] Fix | Delete

[353] Fix | Delete

Admin::redirect();

[354] Fix | Delete

}

[355] Fix | Delete

}

[356] Fix | Delete

[357] Fix | Delete