sys_data.php
2.72 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
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
<?php
/**
* 数据库备份/还原
*
* @version $Id: sys_data.php 1 17:19 2010年7月20日Z tianya $
* @package DedeCMS.Administrator
* @copyright Copyright (c) 2007 - 2010, DesDev, Inc.
* @license http://help.dedecms.com/usersguide/license.html
* @link http://www.dedecms.com
*/
require_once(dirname(__FILE__)."/config.php");
CheckPurview('sys_Data');
if(empty($dopost)) $dopost = '';
if($dopost=="viewinfo") //查看表结构
{
echo "[<a href='#' onclick='javascript:HideObj(\"_mydatainfo\")'><u>关闭</u></a>]\r\n<xmp>";
if(empty($tablename))
{
echo "没有指定表名！";
}
else
{
$dsql->SetQuery("SHOW CREATE TABLE ".$dsql->dbName.".".$tablename);
$dsql->Execute('me');
$row2 = $dsql->GetArray('me',MYSQL_BOTH);
$ctinfo = $row2[1];
echo trim($ctinfo);
}
echo '</xmp>';
exit();
}
else if($dopost=="opimize") //优化表
{
echo "[<a href='#' onclick='javascript:HideObj(\"_mydatainfo\")'><u>关闭</u></a>]\r\n<xmp>";
if(empty($tablename))
{
echo "没有指定表名！";
}
else
{
$rs = $dsql->ExecuteNoneQuery("OPTIMIZE TABLE `$tablename` ");
if($rs)
{
echo "执行优化表： $tablename OK！";
}
else
{
echo "执行优化表： $tablename 失败，原因是：".$dsql->GetError();
}
}
echo '</xmp>';
exit();
}
else if($dopost=="repair") //修复表
{
echo "[<a href='#' onclick='javascript:HideObj(\"_mydatainfo\")'><u>关闭</u></a>]\r\n<xmp>";
if(empty($tablename))
{
echo "没有指定表名！";
}
else
{
$rs = $dsql->ExecuteNoneQuery("REPAIR TABLE `$tablename` ");
if($rs)
{
echo "修复表： $tablename OK！";
}
else
{
echo "修复表： $tablename 失败，原因是：".$dsql->GetError();
}
}
echo '</xmp>';
exit();
}
//获取系统存在的表信息
$otherTables = Array();
$dedeSysTables = Array();
$channelTables = Array();
$dsql->SetQuery("SELECT addtable FROM `#@__channeltype` ");
$dsql->Execute();
while($row = $dsql->GetObject())
{
$channelTables[] = $row->addtable;
}
$dsql->SetQuery("SHOW TABLES");
$dsql->Execute('t');
while($row = $dsql->GetArray('t',MYSQL_BOTH))
{
if(preg_match("#^{$cfg_dbprefix}#", $row[0])||in_array($row[0],$channelTables))
{
$dedeSysTables[] = $row[0];
}
else
{
$otherTables[] = $row[0];
}
}
$mysql_version = $dsql->GetVersion();
include DedeInclude('templets/sys_data.htm');
function TjCount($tbname,&$dsql)
{
$row = $dsql->GetOne("SELECT COUNT(*) AS dd FROM $tbname");
return $row['dd'];
}