📄 adduserlist.php
字号:
<?php
require("../../class/connect.php");
include("../../class/db_sql.php");
include("../../class/config.php");
include("../../class/functions.php");
$link=db_connect();
$empire=new mysqlquery();
$logininid=getcvar('loginuserid');
$loginin=getcvar('loginusername');
$loginrnd=getcvar('loginrnd');
$loginlevel=getcvar('loginlevel');
$editor=1;
is_login($logininid,$loginin,$loginrnd);
//验证权限
CheckLevel($logininid,$loginin,$classid,"userlist");
$enews=$_GET['enews'];
$url="<a href=ListUserlist.php>管理自定义信息列表</a> -> 增加自定义信息列表";
$r[jsfilename]="../../list/";
$r[filetype]=".html";
$r[filepath]="../../a/";
$r[totalsql]="select count(*) as total from [!db.pre!]ecms_news where checked=1";
$r[listsql]="select * from [!db.pre!]ecms_news where checked=1 order by id";
$r[maxnum]=0;
$r[lencord]=25;
//复制
if($enews=="AddUserlist"&&$_GET['docopy'])
{
$listid=(int)$_GET['listid'];
$r=$empire->fetch1("select * from {$dbtbpre}enewsuserlist where listid='$listid'");
$url="<a href=ListUserlist.php>管理自定义信息列表</a> -> 复制自定义信息列表:<b>".$r[listname]."</b>";
}
//修改
if($enews=="EditUserlist")
{
$listid=(int)$_GET['listid'];
$r=$empire->fetch1("select * from {$dbtbpre}enewsuserlist where listid='$listid'");
$url="<a href=ListUserlist.php>管理自定义信息列表</a> -> 修改自定义信息列表:<b>".$r[listname]."</b>";
}
//列表模板
$msql=$empire->query("select mid,mname from {$dbtbpre}enewsmod order by mid");
while($mr=$empire->fetch($msql))
{
$listtemp_options.="<option value=0 style='background:#99C4E3'>".$mr[mname]."</option>";
$l_sql=$empire->query("select tempid,tempname from ".GetTemptb("enewslisttemp")." where modid='$mr[mid]'");
while($l_r=$empire->fetch($l_sql))
{
if($l_r[tempid]==$r[listtempid])
{$l_d=" selected";}
else
{$l_d="";}
$listtemp_options.="<option value=".$l_r[tempid].$l_d."> |-".$l_r[tempname]."</option>";
}
}
db_close();
$empire=null;
//风格
$loginadminstyleid=(int)getcvar('loginadminstyleid');
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../adminstyle/<?=$loginadminstyleid?>/adminstyle.css" rel="stylesheet" type="text/css">
<title>自定义信息列表</title>
</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="ListUserlist.php">
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
<tr class="header">
<td height="25" colspan="2">增加自定义信息列表
<input name="enews" type="hidden" id="enews" value="<?=$enews?>"> <input name="listid" type="hidden" id="listid" value="<?=$listid?>">
<input name="oldfilepath" type="hidden" id="oldfilepath" value="<?=$r[filepath]?>">
<input name="oldfiletype" type="hidden" id="oldfiletype" value="<?=$r[filetype]?>"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="18%" height="25">列表名称:</td>
<td width="82%" height="25"> <input name="listname" type="text" id="listname" value="<?=$r[listname]?>" size="42">
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25">网页标题:</td>
<td height="25"><input name="pagetitle" type="text" id="pagetitle" value="<?=$r[pagetitle]?>" size="42"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25">文件存放目录:</td>
<td height="25"><input name="filepath" type="text" id="filepath" value="<?=$r[filepath]?>" size="42">
<input type="button" name="Submit4" value="选择目录" onclick="window.open('../file/ChangePath.php?returnform=opener.document.form1.filepath.value','','width=400,height=500,scrollbars=yes');">
<font color="#666666">(如:<strong>"../../a/</strong>"表示根目录下的a目录)</font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25">文件扩展名:</td>
<td height="25"><input name="filetype" type="text" id="filetype" value="<?=$r[filetype]?>" size="12">
<select name="select" onchange="document.form1.filetype.value=this.value">
<option value=".html">扩展名</option>
<option value=".html">.html</option>
<option value=".htm">.htm</option>
<option value=".php">.php</option>
<option value=".shtml">.shtml</option>
</select>
(如.html,.xml,.htm等) </td>
</tr>
<tr bgcolor="#FFFFFF">
<td rowspan="4">查询SQL语句:</td>
<td height="25">统计记录:
<input name="totalsql" type="text" id="totalsql" value="<?=htmlspecialchars(stripSlashes($r[totalsql]))?>" size="72"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25"><font color="#666666">(如:select count(*) as total from phome_ecms_news
where classid=1 and checked=1)</font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25">查询记录:
<input name="listsql" type="text" id="listsql" value="<?=htmlspecialchars(stripSlashes($r[listsql]))?>" size="72"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25"><font color="#666666">(如:select * from phome_ecms_news where
classid=1 and checked=1 order by id)</font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="26">查询总条数:</td>
<td height="26"><input name="maxnum" type="text" id="lencord" value="<?=$r[maxnum]?>" size="6">
条信息(0为不限制)</td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="26">每页显示:</td>
<td height="26"> <input name="lencord" type="text" id="jsname3" value="<?=$r[lencord]?>" size="6">
条信息</td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25">使用列表模板:</td>
<td height="25"><select name="listtempid" id="listtempid">
<?=$listtemp_options?>
</select> <input type="button" name="Submit622" value="管理列表模板" onclick="window.open('../template/ListListtemp.php');"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25"> </td>
<td height="25"> <input type="submit" name="Submit" value="提交"> <input type="reset" name="Submit2" value="重置"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25"> </td>
<td height="25">表前缀可用“<strong>[!db.pre!]</strong>”表示</td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -