$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'; }