ListF.php
5.39 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
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
<?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,"f");
$tid=(int)$_GET['tid'];
$tbname=RepPostVar($_GET['tbname']);
if(!$tid||!$tbname)
{
printerror("ErrorUrl","history.go(-1)");
}
$url="數據表:[".$dbtbpre."ecms_".$tbname."] > <a href=ListF.php?tid=$tid&tbname=$tbname".$ecms_hashur['ehref'].">字段管理</a>";
$sql=$empire->query("select * from {$dbtbpre}enewsf where tid='$tid' order by myorder,fid");
?>
<!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">
<?=$ecms_hashur['form']?>
<tr>
<td class="emenubutton"><input type="button" name="Submit2" value="增加字段" onclick="self.location.href='AddF.php?enews=AddF&tid=<?=$tid?>&tbname=<?=$tbname?><?=$ecms_hashur['ehref']?>';"></td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
<tr class="header">
<td width="6%" height="25"><div align="center">順序</div></td>
<td width="8%"><div align="center">表</div></td>
<td width="29%" height="25"><div align="center">字段名</div></td>
<td width="20%"><div align="center">字段標識</div></td>
<td width="15%"> <div align="center">字段類型</div></td>
<td width="8%"><div align="center">採集項</div></td>
<td width="14%" height="25"><div align="center">操作</div></td>
</tr>
<?php
while($r=$empire->fetch($sql))
{
$ftype=$r[ftype];
if($r[flen])
{
if($r[ftype]!="TEXT"&&$r[ftype]!="MEDIUMTEXT"&&$r[ftype]!="LONGTEXT"&&$r[ftype]!="DATE"&&$r[ftype]!="DATETIME")
{
$ftype.="(".$r[flen].")";
}
}
if($r[iscj])
{$iscj="是";}
else
{$iscj="否";}
if($r[isadd])
{
$do="[<a href='AddF.php?tid=$tid&tbname=$tbname&enews=EditF&fid=".$r[fid].$ecms_hashur['ehref']."'>修改</a>] [<a href='../ecmsmod.php?tid=$tid&tbname=$tbname&enews=DelF&fid=".$r[fid].$ecms_hashur['href']."' onclick=\"return confirm('確認要刪除？');\">刪除</a>]";
}
else
{
$ftype="系統字段";
$r[f]="<a title='系統字段'><font color=red>".$r[f]."</font></a>";
$do="<a href='EditSysF.php?tid=$tid&tbname=$tbname&fid=".$r[fid].$ecms_hashur['ehref']."'><font color=red>[修改系統字段]</font></a>";
}
if($r[tbdataf]==1)
{
$tbdataf=$r[isadd]?"<a href='ChangeDataTableF.php?tid=$tid&tbname=$tbname&fid=".$r[fid].$ecms_hashur['ehref']."' title='點擊將字段轉移到主表'>副表</a>":"副表";
}
else
{
$tbdataf=$r[isadd]?"<a href='ChangeDataTableF.php?tid=$tid&tbname=$tbname&fid=".$r[fid].$ecms_hashur['ehref']."' title='點擊將字段轉移到副表'>主表</a>":"主表";
}
?>
<tr bgcolor="#ffffff" onmouseout="this.style.backgroundColor='#ffffff'" onmouseover="this.style.backgroundColor='#C3EFFF'">
<td height="25"><div align="center">
<input name="myorder[]" type="text" id="myorder[]" value="<?=$r[myorder]?>" size="3">
<input type=hidden name=fid[] value=<?=$r[fid]?>>
</div></td>
<td><div align="center">
<?=$tbdataf?>
</div></td>
<td height="25"><div align="center">
<?=$r[f]?>
</div></td>
<td><div align="center">
<?=$r[fname]?>
</div></td>
<td><div align="center">
<?=$ftype?>
</div></td>
<td><div align="center">
<?=$iscj?>
</div></td>
<td height="25"><div align="center">
<?=$do?>
</div></td>
</tr>
<?
}
?>
<tr bgcolor="ffffff">
<td height="25"> </td>
<td height="25" colspan="6"><input type="submit" name="Submit" value="修改字段順序">
<input name="enews" type="hidden" id="enews" value="EditFOrder"> <input name="tid" type="hidden" id="tid" value="<?=$tid?>">
<input name="tbname" type="hidden" id="tbname" value="<?=$tbname?>"></td>
</tr>
<tr bgcolor="ffffff">
<td height="25"> </td>
<td height="25" colspan="6"><font color="#666666">說明：順序值越小越顯示前面，紅色字段名為系統字段，點擊「主表」/「副表」可以進行字段轉移.</font></td>
</tr>
</table>
</form>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1">
<tr>
<td><div align="center"> [<a href="javascript:window.close();">關閉</a>] </div></td>
</tr>
</table>
</body>
</html>
<?
db_close();
$empire=null;
?>