AddTable.php
4.08 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
<?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");
$enews=RepPostStr($_GET['enews'],1);
$url="<a href=ListTable.php".$ecms_hashur['whehref'].">管理數據表</a> > 新建數據表";
//修改
if($enews=="EditTable")
{
$tid=(int)$_GET['tid'];
$url="<a href=ListTable.php".$ecms_hashur['whehref'].">管理數據表</a> > 修改數據表";
$r=$empire->fetch1("select tid,tbname,tname,tsay,yhid,intb from {$dbtbpre}enewstable where tid='$tid'");
}
//優化方案
$yh_options='';
$yhsql=$empire->query("select id,yhname from {$dbtbpre}enewsyh order by id");
while($yhr=$empire->fetch($yhsql))
{
$select='';
if($r[yhid]==$yhr[id])
{
$select=' selected';
}
$yh_options.="<option value='".$yhr[id]."'".$select.">".$yhr[yhname]."</option>";
}
db_close();
$empire=null;
?>
<!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="form1" method="post" action="../ecmsmod.php">
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
<?=$ecms_hashur['form']?>
<tr>
<td height="25" colspan="2" class="header">建立/修改數據表</td>
</tr>
<tr>
<td width="23%" height="25" bgcolor="#F8F8F8">數據表名:</td>
<td width="77%" height="25" bgcolor="#FFFFFF"><strong>
<?=$dbtbpre?>
ecms_</strong> <input name="tbname" type="text" id="tbname" value="<?=$r[tbname]?>">
*<font color="#666666">(如:news,只能由字母、數字組成)</font></td>
</tr>
<tr>
<td height="25" bgcolor="#F8F8F8">數據表標識:</td>
<td height="25" bgcolor="#FFFFFF"> <input name="tname" type="text" id="tname" value="<?=$r[tname]?>" size="38">
*<font color="#666666">(如:新聞數據表)</font></td>
</tr>
<tr>
<td height="25" bgcolor="#F8F8F8">使用優化方案:</td>
<td height="25" bgcolor="#FFFFFF"><select name="yhid" id="yhid">
<option name="0">不使用</option>
<?=$yh_options?>
</select> <input type="button" name="Submit63" value="管理優化方案" onclick="window.open('../db/ListYh.php<?=$ecms_hashur['whehref']?>');"></td>
</tr>
<tr>
<td height="25" bgcolor="#F8F8F8">是否內部表:</td>
<td height="25" bgcolor="#FFFFFF"><input type="radio" name="intb" value="0"<?=$r['intb']==0?' checked':''?>>
正常表
<input type="radio" name="intb" value="1"<?=$r['intb']==1?' checked':''?>>
內部表 <font color="#666666">(內部表前台不顯示和生成，只有後台才能查看)</font></td>
</tr>
<tr>
<td height="25" valign="top" bgcolor="#F8F8F8">備註:</td>
<td height="25" bgcolor="#FFFFFF"> <textarea name="tsay" cols="70" rows="8" id="tsay"><?=stripSlashes($r[tsay])?></textarea></td>
</tr>
<tr>
<td height="25" bgcolor="#F8F8F8"> </td>
<td height="25" bgcolor="#FFFFFF"> <input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="重置"> <input name="tid" type="hidden" id="tid" value="<?=$tid?>">
<input name="enews" type="hidden" id="enews" value="<?=$enews?>"> <input name="oldtbname" type="hidden" id="oldtbname" value="<?=$r[tbname]?>"></td>
</tr>
</table>
</form>
</body>
</html>