ListDataTable.php
3.93 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
109
110
111
112
<?php
define('EmpireCMSAdmin','1');
require("../../class/connect.php");
require("../../class/db_sql.php");
require("../../class/functions.php");
$link=db_connect();
$empire=new mysqlquery();
$editor=1;
//驗證用戶
$lur=is_login();
$logininid=$lur['userid'];
$loginin=$lur['username'];
$loginrnd=$lur['rnd'];
$loginlevel=$lur['groupid'];
$loginadminstyleid=$lur['adminstyleid'];
//ehash
$ecms_hashur=hReturnEcmsHashStrAll();
//驗證權限
CheckLevel($logininid,$loginin,$classid,"table");
$tid=(int)$_GET['tid'];
$tbname=RepPostVar($_GET['tbname']);
if(!$tid||!$tbname)
{
printerror("ErrorUrl","history.go(-1)");
}
$r=$empire->fetch1("select tid,datatbs,deftb from {$dbtbpre}enewstable where tid='$tid'");
if(!$r[tid])
{
printerror("ErrorUrl","history.go(-1)");
}
$tr=explode(',',$r[datatbs]);
$url="數據表:[".$dbtbpre."ecms_".$tbname."] > <a href=ListDataTable.php?tid=$tid&tbname=$tbname".$ecms_hashur['ehref'].">管理副表分表</a>";
$datatbname=$dbtbpre.'ecms_'.$tbname.'_data_';
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>管理副表分表</title>
<link href="../adminstyle/<?=$loginadminstyleid?>/adminstyle.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1">
<tr>
<td>位置：<?=$url?></td>
</tr>
</table>
<form name="adddatatableform" method="post" action="../ecmsmod.php" onsubmit="return confirm('確認要增加?');">
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
<?=$ecms_hashur['form']?>
<tr class="header">
<td>增加副表分表
<input name="enews" type="hidden" id="enews" value="AddDataTable">
<input name="tid" type="hidden" id="tid" value="<?=$tid?>"> <input name="tbname" type="hidden" id="tbname" value="<?=$tbname?>"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">
<?=$datatbname?>
<input name="datatb" type="text" id="datatb" value="0" size="6">
<input type="submit" name="Submit" value="增加">
<font color="#666666">(表名要用數字)</font></td>
</tr>
</table>
</form>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
<tr class="header">
<td width="38%" height="25"><div align="center">表名</div></td>
<td width="33%" height="25"><div align="center">記錄數</div></td>
<td width="29%" height="25"><div align="center">操作</div></td>
</tr>
<?php
$count=count($tr)-1;
$maxtb=0;
for($i=1;$i<$count;$i++)
{
$total_r=$empire->fetch1("SHOW TABLE STATUS LIKE '".$datatbname.$tr[$i]."';");
$bgcolor="#ffffff";
$movejs=' onmouseout="this.style.backgroundColor=\'#ffffff\'" onmouseover="this.style.backgroundColor=\'#C3EFFF\'"';
if($tr[$i]==$r['deftb'])
{
$bgcolor="#DBEAF5";
$movejs='';
}
if($tr[$i]>$maxtb)
{
$maxtb=$tr[$i];
}
$dostr=$tr[$i]==1?"":" [<a href=\"../ecmsmod.php?tid=$tid&tbname=$tbname&enews=DelDataTable&datatb=".$tr[$i].$ecms_hashur['href']."\" onclick=\"return confirm('確認要刪除，刪除會刪除表裡的所有信息?');\">刪除</a>]";
?>
<tr bgcolor="<?=$bgcolor?>"<?=$movejs?>>
<td height="25">
<?=$datatbname?><b><?=$tr[$i]?></b>
</td>
<td height="25"><div align="center">
<?=$total_r['Rows']?>
</div></td>
<td height="25"><div align="center">[<a href="../ecmsmod.php?tid=<?=$tid?>&tbname=<?=$tbname?>&enews=DefDataTable&datatb=<?=$tr[$i]?><?=$ecms_hashur['href']?>" onclick="return confirm('確認要將這個表設為當前存放表?');">設為當前存放表</a>]<?=$dostr?></div></td>
</tr>
<?php
}
?>
</table>
<script>
document.adddatatableform.datatb.value="<?=$maxtb+1?>";
</script>
</body>
</html>
<?php
db_close();
$empire=null;
?>