1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
|
<?php
if (!defined('WPO_VERSION')) die('No direct access allowed');
class WP_Optimization_orphanedtables extends WP_Optimization {
public $available_for_auto = false;
public $setting_default = true;
public $changes_table_data = true;
public $run_multisite = false;
private $last_message;
/**
* Display or hide optimization in optimizations list.
*
* @return bool
*/
public function display_in_optimizations_list() {
return false;
}
/**
* Run optimization.
*/
public function optimize() {
// check if single table name posted or optimize all tables.
if (isset($this->data['optimization_table']) && '' != $this->data['optimization_table']) {
$table = $this->optimizer->get_table($this->data['optimization_table']);
$result = (false === $table) ? false : $this->delete_table($table);
$this->register_meta('success', $result);
if (false === $result) {
$this->register_meta('message', $this->last_message);
}
} else {
// delete all orphaned tables if table name was not selected.
$tables = $this->optimizer->get_tables();
$deleted = 0;
foreach ($tables as $table) {
if ($table->is_using) continue;
if ($this->delete_table($table)) {
$deleted++;
}
}
$this->register_output(sprintf(_n('%s orphaned table deleted', '%s orphaned tables deleted', $deleted), $deleted));
if ($deleted > 0) {
$this->register_output(sprintf(_n('Deleting %s orphaned table was unsuccessful', 'Repairing %s orphaned tables were unsuccessful', $deleted), $deleted));
}
}
}
/**
* Drop table from database.
*
* @param object $table_obj object contains information about database table.
*
* @return bool
*/
private function delete_table($table_obj) {
global $wpdb;
// don't delete table if it in use and plugin active.
if (!$table_obj->can_be_removed) return true;
$sql_query = "DROP TABLE `{$table_obj->Name}`";
$this->logger->info($sql_query);
$result = $wpdb->query($sql_query);
// check if drop query finished successfully.
if ('' != $wpdb->last_error) {
$this->last_message = $wpdb->last_error;
$this->logger->info($wpdb->last_error);
}
return $result;
}
/**
* Get count of unused database tables, i.e. not using by any of installed plugin.
*
* @return int
*/
public function get_unused_tables_count() {
$tablesinfo = $this->optimizer->get_tables();
$unused_tables = 0;
if (!empty($tablesinfo)) {
foreach ($tablesinfo as $tableinfo) {
if (false == $tableinfo->is_using) {
$unused_tables++;
}
}
}
return $unused_tables;
}
/**
* Register info about optimization.
*/
public function get_info() {
$corrupted_tables = $this->get_unused_tables_count();
if (0 == $corrupted_tables) {
$this->register_output(__('No corrupted tables found', 'wp-optimize'));
} else {
$this->register_output(sprintf(_n('%s corrupted table found', '%s corrupted tables found', $corrupted_tables), $corrupted_tables));
}
}
/**
* Returns settings label.
*
* @return string
*/
public function settings_label() {
return __('Delete orphaned database tables', 'wp-optimize');
}
}
|