optimizer_log.php
2.44 KB
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
<?php
/**
* [Discuz!] (C)2001-2099 Comsenz Inc.
* This is NOT a freeware, use is subject to license terms
*
* $Id: optimizer_log.php 31344 2012-08-15 04:01:32Z zhangjie $
*/
if(!defined('IN_DISCUZ')) {
exit('Access Denied');
}
class optimizer_log {
private $table = array();
public function __construct() {
global $_G;
$this->table = array(
'common_magiclog' =>
array( 'tablename' => 'common_magiclog',
'splitvalue' => $_G['timestamp'] - '365',
'splitfield' => 'dateline',
'splitglue' => '<',
),
'common_card_log' =>
array('tablename' => 'common_card_log',
'splitvalue' => $_G['timestamp'] - '86400 * 365',
'splitfield' => 'dateline',
'splitglue' => '<',
),
);
}
public function mergetable($tablename) {
return C::t($tablename)->merge_table();
}
public function check() {
$count = 0;
foreach($this->table as $table) {
$wheresql = $table['splitfield'].$table['splitglue'].$table['splitvalue'];
if(C::t($table['tablename'])->split_check($wheresql)) {
$count++;
}
}
if($count) {
return array('status' => '1','type' => 'view', 'lang' => lang('optimizer', 'optimizer_log_clean', array('count' => $count)));
} else {
return array('status' => '0', 'type' => 'view', 'lang' => lang('optimizer', 'optimizer_log_not_found'));
}
}
public function optimizer() {
$adminfile = defined(ADMINSCRIPT) ? ADMINSCRIPT : 'admin.php';
dheader('Location: '.$_G['siteurl'].$adminfile.'?action=optimizer&operation=log_optimizer&type=optimizer_log');
}
public function get_option() {
$return = array();
foreach($this->table as $table) {
$wheresql = $table['splitfield'].$table['splitglue'].$table['splitvalue'];
if(C::t($table['tablename'])->split_check($wheresql)) {
$status = C::t($table['tablename'])->tablestatus;
$return[] = array(
'tablename' => $table['tablename'],
'name' => $status['Name'],
'rows' => $status['Rows'],
'moverows' => $status['Move_rows'],
'data_length' => $status['Data_length'],
'index_length' => $status['Index_length'],
'create_time' => $status['Create_time'],
);
}
}
return $return;
}
public function option_optimizer($tablename) {
$table = $this->table[$tablename];
$wheresql = $table['splitfield'].$table['splitglue'].$table['splitvalue'];
return C::t($tablename)->split_table($wheresql);
}
}
?>