$username = substr($r[username], 1, -1);
}
//修改
if ($enews == "EditSp") {
$r = $empire->fetch1("select * from {$dbtbpre}enewssp where spid='{$spid}'");
$postword = '修改碎片';
$noteditword = '';
$disabled = ' disabled';
$sptypehidden = '<input type="hidden" name="sptype" value="' . $r[sptype] . '">';
$url = "<a href=ListSp.php" . $ecms_hashur['whehref'] . ">管理碎片</a> > 修改碎片：<b>" . $r[spname] . "</b>";
$username = substr($r[username], 1, -1);
}
//标签模板
$bqtemp = '';
$bqtempsql = $empire->query("select tempid,tempname from " . GetTemptb("enewsbqtemp") . " order by tempid");
while ($bqtempr = $empire->fetch($bqtempsql)) {
$select = "";
if ($r[tempid] == $bqtempr[tempid]) {
$select = " selected";
}
$bqtemp .= "<option value='" . $bqtempr[tempid] . "'" . $select . ">" . $bqtempr[tempname] . "</option>";
}
//栏目
$options = ShowClass_AddClass("", $r[classid], 0, "|-", 0, 0);
//分类
$scstr = '';
$scsql = $empire->query("select classid,classname from {$dbtbpre}enewsspclass order by classid");
while ($scr = $empire->fetch($scsql)) {
$select = "";
if ($scr[classid] == $r[cid]) {
$select = " selected";
if ($schecked == 1) {
$add .= $and . egetmf('checked') . "=0";
} else {
$add .= $and . egetmf('checked') . "=1";
}
$search .= "&schecked={$schecked}";
}
$totalquery = "select count(*) as total from " . eReturnMemberTable() . $add;
$num = $empire->gettotal($totalquery);
$query = "select " . eReturnSelectMemberF('*') . " from " . eReturnMemberTable() . $add;
$query .= " order by " . egetmf('userid') . " desc limit {$offset},{$line}";
$sql = $empire->query($query);
$returnpage = page2($num, $line, $page_line, $start, $page, $search);
//----------会员组
$sql1 = $empire->query("select * from {$dbtbpre}enewsmembergroup order by level");
while ($l_r = $empire->fetch($sql1)) {
if ($groupid == $l_r[groupid]) {
$select = " selected";
} else {
$select = "";
}
$group .= "<option value=" . $l_r[groupid] . $select . ">" . $l_r[groupname] . "</option>";
}
?>
<!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/<?php
echo $loginadminstyleid;
$url = $urlgname . "<a href=ListJstemp.php?gid={$gid}>管理JS模板</a> > 增加JS模板";
//复制
if ($enews == "AddJstemp" && $_GET['docopy']) {
$tempid = (int) $_GET['tempid'];
$r = $empire->fetch1("select * from " . GetDoTemptb("enewsjstemp", $gid) . " where tempid={$tempid}");
$url = $urlgname . "<a href=ListJstemp.php?gid={$gid}>管理JS模板</a> > 复制JS模板: " . $r[tempname];
}
//修改
if ($enews == "EditJstemp") {
$tempid = (int) $_GET['tempid'];
$r = $empire->fetch1("select * from " . GetDoTemptb("enewsjstemp", $gid) . " where tempid={$tempid}");
$url = $urlgname . "<a href=ListJstemp.php?gid={$gid}>管理JS模板</a> > 修改JS模板: " . $r[tempname];
}
//系统模型
$msql = $empire->query("select mid,mname from {$dbtbpre}enewsmod where usemod=0 order by myorder,mid");
while ($mr = $empire->fetch($msql)) {
if ($mr[mid] == $r[modid]) {
$select = " selected";
} else {
$select = "";
}
$mod .= "<option value=" . $mr[mid] . $select . ">" . $mr[mname] . "</option>";
}
//分类
$cstr = "";
$csql = $empire->query("select classid,classname from {$dbtbpre}enewsjstempclass order by classid");
while ($cr = $empire->fetch($csql)) {
$select = "";
if ($cr[classid] == $r[classid]) {
$select = " selected";
}
while ($r = $empire->fetch($sql)) {
$classurl = sys_ReturnBqClassname($r, 9);
$titleurl = sys_ReturnBqTitleLink($r);
echo "<tr bgcolor='#ffffff' height='23'><td>[<a href='" . $classurl . "' target='_blank'>" . $class_r[$r[classid]][classname] . "</a>] <a href='{$titleurl}' target='_blank' title='发布时间：" . date("Y-m-d H:i:s", $r[newstime]) . "'>" . stripSlashes($r[title]) . "</a></td><td>" . $r[$field] . "</td></tr>";
}
echo "</table>";
}
$where = '';
//数据表
$tbname = RepPostVar($_GET['tbname']);
if (empty($tbname)) {
$tbname = $public_r['tbname'];
}
$htb = 0;
$tbsql = $empire->query("select tbname,tname from {$dbtbpre}enewstable order by tid");
while ($tbr = $empire->fetch($tbsql)) {
$select = "";
if ($tbr[tbname] == $tbname) {
$htb = 1;
$select = " selected";
}
$tbs .= "<option value='" . $tbr[tbname] . "'" . $select . ">" . $tbr[tname] . "</option>";
}
if ($htb == 0) {
printerror('ErrorUrl', '');
}
//栏目
$classid = (int) $_GET['classid'];
if ($classid) {
$and = $where ? ' and ' : ' where ';
if ($class_r[$classid][islast]) {
$ecms_hashur = hReturnEcmsHashStrAll();
//验证权限
CheckLevel($logininid, $loginin, $classid, "buygroup");
$enews = ehtmlspecialchars($_GET['enews']);
$r[gmoney] = 10;
$r[gfen] = 0;
$r[gdate] = 0;
$url = "<a href=ListBuyGroup.php" . $ecms_hashur['whehref'] . ">管理充值类型</a> > 增加充值类型";
if ($enews == "EditBuyGroup") {
$id = (int) $_GET['id'];
$r = $empire->fetch1("select * from {$dbtbpre}enewsbuygroup where id='{$id}' limit 1");
$url = "<a href=ListBuyGroup.php" . $ecms_hashur['whehref'] . ">管理充值类型</a> > 修改充值类型";
}
//----------会员组
$sql = $empire->query("select groupid,groupname from {$dbtbpre}enewsmembergroup order by level");
while ($level_r = $empire->fetch($sql)) {
if ($r[ggroupid] == $level_r[groupid]) {
$select = " selected";
} else {
$select = "";
}
$group .= "<option value=" . $level_r[groupid] . $select . ">" . $level_r[groupname] . "</option>";
if ($r[gzgroupid] == $level_r[groupid]) {
$zselect = " selected";
} else {
$zselect = "";
}
$zgroup .= "<option value=" . $level_r[groupid] . $zselect . ">" . $level_r[groupname] . "</option>";
if ($r[buygroupid] == $level_r[groupid]) {
$bselect = " selected";
} else {
$r = $empire->fetch1("select * from {$dbtbpre}enewsmemberform where fid='{$fid}'");
$url = "<a href='ListMemberForm.php'>管理会员表单</a> > 复制会员表单: " . $r['fname'];
$postword = '复制会员表单';
}
//修改
if ($enews == "EditMemberForm") {
$fid = (int) $_GET['fid'];
$ftype = "";
$url = "<a href='ListMemberForm.php'>管理会员表单</a> > 修改会员表单";
$postword = '修改会员表单';
$r = $empire->fetch1("select * from {$dbtbpre}enewsmemberform where fid='{$fid}'");
}
//取得字段
$no = 0;
$fsql = $empire->query("select f,fname from {$dbtbpre}enewsmemberf order by myorder,fid");
while ($fr = $empire->fetch($fsql)) {
$no++;
$bgcolor = "ffffff";
if ($no % 2 == 0) {
$bgcolor = "#F8F8F8";
}
$like = $field . $fr[f] . $record;
$slike = "," . $fr[f] . ",";
//录入项
$enterchecked = "";
if (strstr($r[enter], $like)) {
$enterchecked = " checked";
//取得字段标识
$dor = explode($like, $r[enter]);
if (strstr($dor[0], $record)) {
$dor1 = explode($record, $dor[0]);
$add = $_GET;
$havehtml = (int) $add['havehtml'];
$add[classid] = RepPostVar($add[classid]);
$add[from] = RepPostStrUrl($add[from]);
$add[retype] = RepPostStr($add[retype], 1);
$add[startday] = RepPostStr($add[startday], 1);
$add[endday] = RepPostStr($add[endday], 1);
$add[startid] = RepPostVar($add[startid]);
$add[endid] = RepPostVar($add[endid]);
$tbname = $add['tbname'];
$count = count($tbname);
//刷新所有表
if (!$count) {
$j = 0;
$tsql = $empire->query("select tbname from {$dbtbpre}enewstable where intb=0 order by tid");
while ($tr = $empire->fetch($tsql)) {
$tbname[$j] = $tr[tbname];
$j++;
}
$count = count($tbname);
}
esetcookie("retablenum", $count, 0, 1);
esetcookie("rechecktablenum", 0, 0, 1);
$url = "../ecmschtml.php?enews=ReNewsHtml&classid={$add['classid']}&from=" . urlencode($add[from]) . "&retype={$add['retype']}&startday={$add['startday']}&endday={$add['endday']}&startid={$add['startid']}&endid={$add['endid']}&havehtml={$havehtml}&reallinfotime=" . time() . $ecms_hashur['href'];
echo "<link href='../adminstyle/" . $loginadminstyleid . "/adminstyle.css' rel='stylesheet' type='text/css'><center>要刷新的表的总个数为:<font color=red>{$count}</font>个</center><br>";
for ($i = 0; $i < $count; $i++) {
$tbname[$i] = RepPostVar($tbname[$i]);
$trueurl = $url . "&tbname=" . $tbname[$i];
echo "<table width='100%' border=0 align=center cellpadding=3 cellspacing=1 class=tableborder><tr class=header><td>刷新数据表：" . $tbname[$i] . "</td></tr><tr><td bgcolor='#ffffff'><iframe frameborder=0 height=35 id='" . $tbname[$i] . "' scrolling=no \n src=\"" . $trueurl . "\" \n width=\"100%\"></iframe></td></tr></table>";
}
db_close();
<?php
require "../class/connect.php";
require "../class/db_sql.php";
require "../class/q_functions.php";
require "../class/user.php";
eCheckCloseMods('pay');
//关闭模块
$link = db_connect();
$empire = new mysqlquery();
//是否登陆
$user = islogin();
$pr = $empire->fetch1("select paymoneytofen,payminmoney from {$dbtbpre}enewspublic limit 1");
$paysql = $empire->query("select payid,paytype,payfee,paysay,payname from {$dbtbpre}enewspayapi where isclose=0 order by myorder,payid");
$pays = '';
while ($payr = $empire->fetch($paysql)) {
$pays .= "<option value='" . $payr[payid] . "'>" . $payr[payname] . "</option>";
}
//导入模板
require ECMS_PATH . 'e/template/payapi/payapi.php';
db_close();
$empire = null;
//验证权限
CheckLevel($logininid, $loginin, $classid, "totaldata");
$userid = (int) $_GET['userid'];
$username = RepPostVar($_GET['username']);
$tbname = RepPostVar($_GET['tbname']);
if (empty($tbname)) {
$tbname = $public_r['tbname'];
}
if (!$userid || !$username || !$tbname) {
printerror('ErrorUrl', '');
}
//数据表
$b = 0;
$htb = 0;
$tbsql = $empire->query("select tbname,tname from {$dbtbpre}enewstable order by tid");
while ($tbr = $empire->fetch($tbsql)) {
$b = 1;
$select = "";
if ($tbr[tbname] == $tbname) {
$htb = 1;
$select = " selected";
}
$tbstr .= "<option value='" . $tbr[tbname] . "'" . $select . ">" . $tbr[tname] . "</option>";
}
if ($b == 0) {
printerror('ErrorUrl', '');
}
if ($htb == 0) {
printerror('ErrorUrl', '');
}
//日期
$doorder = "id desc";
} else {
$doorder = $thisclassr[listorder];
}
}
$search .= "&totalnum={$num}";
$search1 = $search;
$search .= "&myorder={$myorder}";
$returnpage = page2($num, $line, $page_line, $start, $page, $search);
$phpmyself = urlencode($_SERVER['PHP_SELF'] . "?" . $_SERVER["QUERY_STRING"]);
//取得专题
$ztclass = "";
$doztclass = "";
$ztwhere = ReturnClass($class_r[$classid][featherclass]);
$z_sql = $empire->query("select ztname,ztid,tbname from {$dbtbpre}enewszt where usezt=0 and (classid=0 or classid='{$classid}' or (" . $ztwhere . "))");
while ($z_r = $empire->fetch($z_sql)) {
/*
//不同表
if($class_r[$classid][tbname]!=$z_r[tbname])
{continue;}
*/
$selected = "";
if ($z_r[ztid] == $ztid) {
$selected = " selected";
}
$ztclass .= "<option value='" . $z_r[ztid] . "'" . $selected . ">" . $z_r[ztname] . "</option>";
$doztclass .= "<option value='" . $z_r[ztid] . "'>" . $z_r[ztname] . "</option>";
}
//标题分类
$tts = '';
$ttsql = $empire->query("select typeid,tname from {$dbtbpre}enewsinfotype where mid='{$modid}' order by myorder");
$r[jssql] = "select * from [!db.pre!]ecms_news where checked=1 order by id limit 10";
//复制
if ($enews == "AddUserjs" && $_GET['docopy']) {
$jsid = (int) $_GET['jsid'];
$r = $empire->fetch1("select * from {$dbtbpre}enewsuserjs where jsid='{$jsid}'");
$url = "<a href=ListUserjs.php>管理用户自定义JS</a> > 复制自定义JS：<b>" . $r[jsname] . "</b>";
}
//修改
if ($enews == "EditUserjs") {
$jsid = (int) $_GET['jsid'];
$r = $empire->fetch1("select * from {$dbtbpre}enewsuserjs where jsid='{$jsid}'");
$url = "<a href=ListUserjs.php>管理用户自定义JS</a> -> 修改自定义JS：<b>" . $r[jsname] . "</b>";
}
//js模板
$jstempsql = $empire->query("select tempid,tempname from " . GetTemptb("enewsjstemp") . " order by tempid");
while ($jstempr = $empire->fetch($jstempsql)) {
$select = "";
if ($r[jstempid] == $jstempr[tempid]) {
$select = " selected";
}
$jstemp .= "<option value='" . $jstempr[tempid] . "'" . $select . ">" . $jstempr[tempname] . "</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=gb2312">
<link href="../adminstyle/<?php
echo $loginadminstyleid;
<tr>
<td width="24%">操作类型：</td>
<td width="76%"><select name="dotype" id="select">
<option value="6">专题最新信息</option>
<option value="7">专题点击排行</option>
<option value="8">专题推荐信息</option>
<option value="11">专题评论排行</option>
<option value="14">专题头条信息</option>
<option value="17">专题下载排行</option>
</select></td>
</tr>
</table>';
//选择专题
$ztclass = '';
$ztsql = $empire->query("select ztid,ztname from {$dbtbpre}enewszt order by ztid desc");
while ($ztr = $empire->fetch($ztsql)) {
$ztclass .= "<option value='" . $ztr['ztid'] . "'>" . $ztr['ztname'] . "</option>";
}
if ($addselfinfo == 1) {
} else {
$selfinfooption = '<option value="\'selfinfo\'">当前专题</option>';
}
$changeobject = '<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="24%">选择专题：</td>
<td width="76%"><select name="classid" id="select2">
' . $selfinfooption . '
' . $ztclass . '
</select></td>
</tr>
</table>';
$enews = ehtmlspecialchars($_GET['enews']);
$r['ppath'] = ReturnAbsEcmsPath();
$url = "<a href=ListMoreport.php" . $ecms_hashur['whehref'] . ">管理网站访问端</a> > 增加网站访问端";
$postword = '增加网站访问端';
if ($enews == "EditMoreport") {
$pid = (int) $_GET['pid'];
if ($pid == 1) {
printerror("ErrorUrl", "history.go(-1)");
}
$r = $empire->fetch1("select * from {$dbtbpre}enewsmoreport where pid='{$pid}' limit 1");
$url = "<a href=ListMoreport.php" . $ecms_hashur['whehref'] . ">管理网站访问端</a> > 修改网站访问端：<b>" . $r[pname] . "</b>";
$postword = '修改网站访问端';
}
$tgtemps = '';
$tgsql = $empire->query("select gid,gname,isdefault from {$dbtbpre}enewstempgroup order by gid");
while ($tgr = $empire->fetch($tgsql)) {
$selected = '';
if ($tgr['gid'] == $r['tempgid']) {
$selected = ' selected';
}
$tgtemps .= "<option value='" . $tgr['gid'] . "'" . $selected . ">" . $tgr['gname'] . "</option>";
}
?>
<!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/<?php
echo $loginadminstyleid;
?>
printerror("AddInfoErrorClassid", "history.go(-1)");
}
$bclassid = $class_r[$classid][bclassid];
$id = (int) $_GET['id'];
//附件验证码
if (!$doselfinfo['doeditinfo']) {
printerror("NotEditInfoLevel", "EditInfoSimple.php?isclose=1" . $ecms_hashur['ehref']);
}
$filepass = $id;
$ecmsfirstpost = 0;
//模型
$modid = $class_r[$classid][modid];
$enter = $emod_r[$modid]['enter'];
//会员组
$sql1 = $empire->query("select groupid,groupname from {$dbtbpre}enewsmembergroup order by level");
while ($l_r = $empire->fetch($sql1)) {
$ygroup .= "<option value=" . $l_r[groupid] . ">" . $l_r[groupname] . "</option>";
}
//初始化数据
$r = array();
$todaytime = date("Y-m-d H:i:s");
//-----------------------------------------修改信息
//索引表
$index_r = $empire->fetch1("select classid,id,checked from {$dbtbpre}ecms_" . $class_r[$classid][tbname] . "_index where id='{$id}' limit 1");
if (!$index_r['id'] || $index_r['classid'] != $classid) {
printerror("ErrorUrl", "history.go(-1)");
}
//返回表
$infotb = ReturnInfoMainTbname($class_r[$classid][tbname], $index_r['checked']);
//主表
$r = $empire->fetch1("select * from " . $infotb . " where id='{$id}' limit 1");
&id=<?php
echo $pid;
?>
&enews=<?php
echo $enews;
?>
&keyid='+keyid;
//document.getElementById('doaddkey'+infoid).innerHTML='---';
}
</script>
</head>
<body>
<table width="100%" border="0" cellspacing="1" cellpadding="3" class="tableborder">
<?php
while ($infor = $empire->fetch($sql)) {
$titleurl = sys_ReturnBqTitleLink($infor);
?>
<tr bgcolor="#FFFFFF" onmouseout="this.style.backgroundColor='#ffffff'" onmouseover="this.style.backgroundColor='#C3EFFF'">
<td width="11%" height="25">
<div align="center">
<?php
echo $infor['id'];
?>
</div></td>
<td width="75%"><a href="<?php
echo $titleurl;
?>
" target="_blank" title="发布时间：<?php
echo date('Y-m-d H:i:s', $infor['newstime']);
?>
$retitlewriter = " checked";
}
if ($r[copyimg]) {
$copyimg = " checked";
}
if ($r[copyflash]) {
$copyflash = " checked";
}
//节点
$infoclass = ShowClass_AddInfoClass($r[bclassid], 0, "|-", 0);
//专题
$ztwhere = ReturnClass($class_r[$r[newsclassid]][featherclass]);
$z_sql = $empire->query("select ztname,ztid,tbname from {$dbtbpre}enewszt where usezt=0 and (classid=0 or classid='{$r['newsclassid']}' or (" . $ztwhere . ")) order by ztid");
$j = 0;
$br = "";
while ($z_r = $empire->fetch($z_sql)) {
/*
//不同表
if($class_r[$r[newsclassid]][tbname]!=$z_r[tbname])
{continue;}
*/
$j++;
if ($j % 6 == 0) {
$br = "<br>";
} else {
$br = "";
}
$c_zr = explode("|" . $z_r[ztid] . "|", $r[newsztid]);
if (count($c_zr) != 1) {
$z_s = " checked";
} else {
//验证用户
$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, "public");
$r = $empire->fetch1("select * from {$dbtbpre}enewspl_set limit 1");
//评论权限
$plgroup = '';
$mgsql = $empire->query("select groupid,groupname from {$dbtbpre}enewsmembergroup order by level");
while ($mgr = $empire->fetch($mgsql)) {
if ($r[plgroupid] == $mgr[groupid]) {
$plgroup_select = ' selected';
} else {
$plgroup_select = '';
}
$plgroup .= "<option value=" . $mgr[groupid] . $plgroup_select . ">" . $mgr[groupname] . "</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>
$fcfile = "../data/fc/ListEnews.php";
$fcjsfile = "../data/fc/cmsclass.js";
if (file_exists($fcjsfile) && file_exists($fcfile)) {
$class = GetFcfiletext($fcjsfile);
$acr = explode(",", $r[classid]);
$count = count($acr);
for ($i = 1; $i < $count - 1; $i++) {
$class = str_replace("<option value='{$acr[$i]}'", "<option value='{$acr[$i]}' selected", $class);
}
} else {
$class = ShowClass_AddClass(str_replace(',', '|', $r[classid]), "n", 0, "|-", 0, 3);
}
} elseif ($r['doing'] == 2 || $cdoing == 2) {
$cname = '专题';
$ztsql = $empire->query("select ztid,ztname from {$dbtbpre}enewszt order by ztid");
while ($ztr = $empire->fetch($ztsql)) {
$selected = strstr($r[classid], ',' . $ztr[ztid] . ',') ? ' selected' : '';
$class .= "<option value='{$ztr['ztid']}'" . $selected . ">{$ztr['ztname']}</option>";
}
} elseif ($r['doing'] == 3 || $cdoing == 3) {
$cname = '列表';
$ulsql = $empire->query("select listid,listname from {$dbtbpre}enewsuserlist order by listid");
while ($ulr = $empire->fetch($ulsql)) {
$selected = strstr($r[classid], ',' . $ulr[listid] . ',') ? ' selected' : '';
$class .= "<option value='{$ulr['listid']}'" . $selected . ">{$ulr['listname']}</option>";
}
} elseif ($r['doing'] == 4 || $cdoing == 4) {
$cname = '页面';
$upsql = $empire->query("select id,title from {$dbtbpre}enewspage order by id");
while ($upr = $empire->fetch($upsql)) {
$selected = strstr($r[classid], ',' . $upr[id] . ',') ? ' selected' : '';
$mtype = "";
$r = $empire->fetch1("select * from {$dbtbpre}enewsmod where mid='{$mid}' and tid='{$tid}'");
$url = "数据表:[" . $dbtbpre . "ecms_" . $tbname . "] > <a href=ListM.php?tid={$tid}&tbname={$tbname}" . $ecms_hashur['ehref'] . ">系统模型管理</a> > 复制系统模型: " . $r['mname'];
}
//修改系统模型
if ($enews == "EditM") {
$postword = '修改';
$mid = (int) $_GET['mid'];
$mtype = "";
$url = "数据表:[" . $dbtbpre . "ecms_" . $tbname . "] > <a href=ListM.php?tid={$tid}&tbname={$tbname}" . $ecms_hashur['ehref'] . ">系统模型管理</a> > 修改系统模型";
$r = $empire->fetch1("select * from {$dbtbpre}enewsmod where mid='{$mid}' and tid='{$tid}'");
}
//取得字段
$no = 0;
$fsql = $empire->query("select f,fname,iscj,dotemp,tbdataf from {$dbtbpre}enewsf where isshow=1 and tid='{$tid}' order by myorder,fid");
while ($fr = $empire->fetch($fsql)) {
$no++;
$bgcolor = "ffffff";
if ($no % 2 == 0) {
$bgcolor = "#F8F8F8";
}
$like = $field . $fr[f] . $record;
$slike = "," . $fr[f] . ",";
//录入项
if (strstr($r[enter], $like)) {
$enterchecked = " checked";
//取得字段标识
$dor = explode($like, $r[enter]);
if (strstr($dor[0], $record)) {
$dor1 = explode($record, $dor[0]);
$last = count($dor1) - 1;
}
//标题分类
$ttid = (int) $_GET['ttid'];
if ($ttid) {
$add .= " and ttid='{$ttid}'";
}
$search .= "&sear=1&keyboard={$keyboard}&show={$show}&showspecial={$showspecial}&ttid={$ttid}";
}
//显示重复标题
if ($_GET['showretitle'] == 1) {
$search .= "&showretitle=1&srt=" . intval($_GET['srt']);
$addsrt = "";
$srtid = "";
$first = 1;
$srtsql = $empire->query("select id,title from " . $infotb . " where classid='{$classid}' group by title having(count(*))>1");
while ($srtr = $empire->fetch($srtsql)) {
if ($first == 1) {
$addsrt .= "title='" . addslashes($srtr['title']) . "'";
$srtid .= $srtr['id'];
$first = 0;
} else {
$addsrt .= " or title='" . addslashes($srtr['title']) . "'";
$srtid .= "," . $srtr['id'];
}
}
if (!empty($addsrt)) {
if ($_GET['srt'] == 1) {
$add .= " and (" . $addsrt . ") and id not in (" . $srtid . ")";
} else {
$add .= " and (" . $addsrt . ")";
}
//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/<?php
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//验证权限
CheckLevel($logininid, $loginin, $classid, "setmclass");
$r[newline] = 10;
$r[hotline] = 10;
$r[goodline] = 10;
$r[hotplline] = 10;
$r[firstline] = 10;
$url = "<a href=SetMoreClass.php>批量设置栏目</a>";
//系统模型
$m_sql = $empire->query("select mid,mname,usemod from {$dbtbpre}enewsmod order by myorder,mid");
while ($m_r = $empire->fetch($m_sql)) {
if (empty($m_r[usemod])) {
if ($m_r[mid] == $r[modid]) {
$m_d = " selected";
} else {
$m_d = "";
}
$mod_options .= "<option value=" . $m_r[mid] . $m_d . ">" . $m_r[mname] . "</option>";
}
//列表模板
$listtemp_options .= "<option value=0 style='background:#99C4E3'>" . $m_r[mname] . "</option>";
$lt_sql = $empire->query("select tempid,tempname from " . GetTemptb("enewslisttemp") . " where modid='{$m_r['mid']}'");
while ($lt_r = $empire->fetch($lt_sql)) {
if ($lt_r[tempid] == $r[listtempid]) {
$lt_d = " selected";
} else {
$postword = '增加计划任务';
$r['isopen'] = 1;
$r['doday'] = '*';
$r['doweek'] = '*';
$r['dohour'] = '*';
$r['dominute'] = ',';
if ($enews == "EditTask") {
$id = (int) $_GET['id'];
$r = $empire->fetch1("select * from {$dbtbpre}enewstask where id='{$id}'");
$url = "<a href='ListTask.php" . $ecms_hashur['whehref'] . "'>管理计划任务</a> > 修改计划任务：<b>" . $r[taskname] . "</b>";
$postword = '修改计划任务';
}
//用户
$userselect = '';
$usersql = $empire->query("select userid,username from {$dbtbpre}enewsuser order by userid");
while ($ur = $empire->fetch($usersql)) {
$select = "";
if ($ur[userid] == $r[userid]) {
$select = " selected";
}
$userselect .= "<option value='" . $ur[userid] . "'" . $select . ">" . $ur[username] . "</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">
<link href="../adminstyle/<?php
echo $loginadminstyleid;
">
<input type=hidden name=start value="<?php
echo $start;
?>
">
<?php
echo $re[1];
?>
<tr class="header">
<td width="6%" height="25"> <div align="center">去除</div></td>
<td width="55%"><div align="center">标题</div></td>
<td width="18%"><div align="center">发布者</div></td>
<td width="21%"><div align="center">发布时间</div></td>
</tr>
<?php
while ($r = $empire->fetch($sql)) {
//时间
$truetime = date_time($r[truetime], "Y-m-d H:i:s");
$lastdotime = date_time($r[lastdotime], "Y-m-d H:i:s");
$oldtitle = $r[title];
$r[title] = stripSlashes(sub($r[title], 0, 45, false));
if (empty($r[checked])) {
$checked = " title='未审核' style='background:#99C4E3'";
} else {
$checked = "";
}
//会员投稿
if ($r[ismember]) {
$r[username] = "<font color=red>" . $r[username] . "</font>";
}
$titleurl = sys_ReturnBqTitleLink($r);
} else {
if (!$doselfinfo['doeditinfo']) {
printerror("NotEditInfoLevel", "history.go(-1)");
}
$filepass = $id;
$word = '修改信息';
$ecmsfirstpost = 0;
}
//模型
$modid = $class_r[$classid][modid];
$enter = $emod_r[$modid]['enter'];
//导航
$url = AdminReturnClassLink($classid) . ' > ' . $word;
//会员组
$sql1 = $empire->query("select groupid,groupname from {$dbtbpre}enewsmembergroup order by level");
while ($l_r = $empire->fetch($sql1)) {
$ygroup .= "<option value=" . $l_r[groupid] . ">" . $l_r[groupname] . "</option>";
}
if ($enews == "AddNews") {
$group = str_replace(" value=" . $class_r[$classid][groupid] . ">", " value=" . $class_r[$classid][groupid] . " selected>", $ygroup);
}
//初始化数据
$r = array();
$newstime = time();
$r[newstime] = date("Y-m-d H:i:s");
$todaytime = $r[newstime];
$r[checked] = $class_r[$classid][checked];
$r[newspath] = date($class_r[$classid][newspath]);
$r[onclick] = 0;
$r[userfen] = 0;
$titlefontb = "";
$search .= "&scond={$scond}";
}
//模型
$modid = (int) $_GET['modid'];
if ($modid) {
$add .= " and modid={$modid}";
$search .= "&modid={$modid}";
}
}
if ($add) {
$add = " where" . substr($add, 4, strlen($add));
}
//系统模型
$modselect = "";
$msql = $empire->query("select mid,mname from {$dbtbpre}enewsmod where usemod=0 order by myorder,mid");
while ($mr = $empire->fetch($msql)) {
$select = "";
if ($mr[mid] == $modid) {
$select = " selected";
}
$modselect .= "<option value='" . $mr[mid] . "'" . $select . ">" . $mr[mname] . "</option>";
}
$totalquery = "select count(*) as total from {$dbtbpre}enewsclass" . $add;
$query = "select * from {$dbtbpre}enewsclass" . $add;
$num = $empire->gettotal($totalquery);
//取得总条数
//排序
$myorder = (int) $_GET['myorder'];
if ($myorder == 1) {
$doorder = "myorder";
} else {
}
if ($add) {
$add = ' where ' . $add;
}
$query = "select spid,spname,varname,cid,classid,isclose,sptype,sptime from {$dbtbpre}enewssp" . $add;
$totalquery = "select count(*) as total from {$dbtbpre}enewssp" . $add;
$num = $empire->gettotal($totalquery);
//取得总条数
$query = $query . " order by spid desc limit {$offset},{$line}";
$sql = $empire->query($query);
$returnpage = page2($num, $line, $page_line, $start, $page, $search);
$url = "<a href=ListSp.php>管理碎片</a>";
//分类
$scstr = "";
$scsql = $empire->query("select classid,classname from {$dbtbpre}enewsspclass order by classid");
while ($scr = $empire->fetch($scsql)) {
$select = "";
if ($scr[classid] == $cid) {
$select = " selected";
}
$scstr .= "<option value='" . $scr[classid] . "'" . $select . ">" . $scr[classname] . "</option>";
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>碎片</title>
<link href="../adminstyle/<?php
echo $loginadminstyleid;
?>
}
//节点名称
$cr = $empire->fetch1("select classname,newsclassid,classid,tbname from {$dbtbpre}enewsinfoclass where classid='{$classid}'");
if (!$cr[classid]) {
printerror("ErrorUrl", "history.go(-1)");
}
$r = $empire->fetch1("select * from {$dbtbpre}ecms_infotmp_" . $cr[tbname] . " where id='{$id}'");
if (empty($r[id])) {
printerror("ErrorUrl", "history.go(-1)");
}
//模型
$modid = (int) $class_r[$cr[newsclassid]][modid];
$enter = $emod_r[$modid]['enter'];
//会员组
$sql1 = $empire->query("select * from {$dbtbpre}enewsmembergroup order by level");
while ($l_r = $empire->fetch($sql1)) {
$ygroup .= "<option value=" . $l_r[groupid] . ">" . $l_r[groupname] . "</option>";
}
//----------------特殊模型----------------
//下载地址前缀
if (strstr($enter, ',downpath,') || strstr($enter, ',onlinepath,')) {
$downurlqz = "";
$newdownqz = "";
$downsql = $empire->query("select urlname,url,urlid from {$dbtbpre}enewsdownurlqz order by urlid");
while ($downr = $empire->fetch($downsql)) {
$downurlqz .= "<option value='" . $downr[url] . "'>" . $downr[urlname] . "</option>";
$newdownqz .= "<option value='" . $downr[urlid] . "'>" . $downr[urlname] . "</option>";
}
}
//html编辑器
if ($emod_r[$modid]['editorf'] && $emod_r[$modid]['editorf'] != ',') {
<tr>
<td height="25" bgcolor="#FFFFFF"> 类别名称:
<input name="classname" type="text" id="classname">
<input type="submit" name="Submit" value="增加">
<input type="reset" name="Submit2" value="重置"></td>
</tr>
</table>
</form>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
<tr class="header">
<td width="10%"><div align="center">ID</div></td>
<td width="59%" height="25"><div align="center">类别名称</div></td>
<td width="31%" height="25"><div align="center">操作</div></td>
</tr>
<?
while($r=$empire->fetch($sql))
{
?>
<form name=form2 method=post action=../ecmscom.php>
<?php
echo $ecms_hashur['form'];
?>
<input type=hidden name=enews value=EditBqtempClass>
<input name=doing type=hidden value=bqtemp>
<input type=hidden name=classid value=<?php
echo $r[classid];
?>
>
<tr bgcolor="#FFFFFF" onmouseout="this.style.backgroundColor='#ffffff'" onmouseover="this.style.backgroundColor='#C3EFFF'">
<td><div align="center"><?php
echo $r[classid];
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//验证权限
CheckLevel($logininid, $loginin, $classid, "tags");
$r = $empire->fetch1("select opentags,tagstempid,usetags,chtags,tagslistnum from {$dbtbpre}enewspublic limit 1");
//系统模型
$usetags = '';
$chtags = '';
$i = 0;
$modsql = $empire->query("select mid,mname from {$dbtbpre}enewsmod order by myorder,mid");
while ($modr = $empire->fetch($modsql)) {
$i++;
if ($i % 4 == 0) {
$br = "<br>";
} else {
$br = "";
}
$select = '';
if (strstr($r[usetags], ',' . $modr[mid] . ',')) {
$select = ' checked';
}
$usetags .= "<input type=checkbox name=umid[] value='{$modr['mid']}'" . $select . ">{$modr['mname']} " . $br;
$chselect = '';
if (strstr($r[chtags], ',' . $modr[mid] . ',')) {
$chselect = ' checked';
}
