| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215 | 
							- <?php
 
- define('EmpireCMSAdmin','1');
 
- require("../class/connect.php");
 
- require("../class/db_sql.php");
 
- require("../class/functions.php");
 
- require LoadLang("pub/fun.php");
 
- require("../data/dbcache/class.php");
 
- $link=db_connect();
 
- $empire=new mysqlquery();
 
- //验证用户
 
- $lur=is_login();
 
- $logininid=$lur['userid'];
 
- $loginin=$lur['username'];
 
- $loginrnd=$lur['rnd'];
 
- $loginlevel=$lur['groupid'];
 
- $loginadminstyleid=$lur['adminstyleid'];
 
- //ehash
 
- $ecms_hashur=hReturnEcmsHashStrAll();
 
- $classid=(int)$_GET['classid'];
 
- $bclassid=(int)$class_r[$classid]['bclassid'];
 
- //取得栏目名
 
- if(!$class_r[$classid][classid]||!$class_r[$classid][tbname])
 
- {
 
- 	printerror("ErrorUrl","history.go(-1)");
 
- }
 
- //验证权限
 
- $doselfinfo=CheckLevel($logininid,$loginin,$classid,"news");
 
- //取得模型表
 
- $fieldexp="<!--field--->";
 
- $recordexp="<!--record-->";
 
- //返回搜索字段列表
 
- function ReturnSearchOptions($enter,$field,$record){
 
- 	global $modid,$emod_r;
 
- 	$r=explode($record,$enter);
 
- 	$count=count($r)-1;
 
- 	for($i=0;$i<$count;$i++)
 
- 	{
 
- 		if(!$sr['searchallfield'])
 
- 		{
 
- 			$or="";
 
- 		}
 
- 		else
 
- 		{
 
- 			$or=" or ";
 
- 		}
 
- 		$r1=explode($field,$r[$i]);
 
- 		if($r1[1]=="special.field"||strstr($emod_r[$modid]['tbdataf'],','.$r1[1].','))
 
- 		{
 
- 			continue;
 
- 		}
 
- 		if($r1[1]=="id")
 
- 		{
 
- 			$sr['searchallfield'].=$or.$r1[1]."='[!--key--]'";
 
- 			$sr['select'].="<option value=\"".$r1[1]."\">".$r1[0]."</option>";
 
- 			continue;
 
- 		}
 
- 		$sr['searchallfield'].=$or.$r1[1]." like '%[!--key--]%'";
 
- 		$sr['select'].="<option value=\"".$r1[1]."\">".$r1[0]."</option>";
 
- 	}
 
- 	return $sr;
 
- }
 
- $modid=(int)$class_r[$classid][modid];
 
- $infomod_r=$empire->fetch1("select enter,tbname,sonclass,listfile from {$dbtbpre}enewsmod where mid=".$modid);
 
- if(empty($infomod_r['tbname']))
 
- {
 
- 	printerror("ErrorUrl","history.go(-1)");
 
- }
 
- $infomod_r['enter'].='发布者<!--field--->username<!--record-->ID<!--field--->id<!--record-->关键字<!--field--->keyboard<!--record-->';
 
- $searchoptions_r=ReturnSearchOptions($infomod_r['enter'],$fieldexp,$recordexp);
 
- //审核表
 
- $search='';
 
- $search.=$ecms_hashur['ehref'];
 
- $addecmscheck='';
 
- $ecmscheck=(int)$_GET['ecmscheck'];
 
- $indexchecked=1;
 
- if($ecmscheck)
 
- {
 
- 	$search.='&ecmscheck='.$ecmscheck;
 
- 	$addecmscheck='&ecmscheck='.$ecmscheck;
 
- 	$indexchecked=0;
 
- }
 
- $infotb=ReturnInfoMainTbname($class_r[$classid][tbname],$indexchecked);
 
- //导航
 
- $url=AdminReturnClassLink($classid).' > 管理归档  (<a href="AddNews.php?enews=AddNews&bclassid='.$bclassid.'&classid='.$classid.$addecmscheck.$ecms_hashur['ehref'].'">增加信息</a>)';
 
- $start=0;
 
- $page=(int)$_GET['page'];
 
- $page=RepPIntvar($page);
 
- $line=intval($public_r['hlistinfonum']);//每页显示
 
- $page_line=16;
 
- $offset=$page*$line;
 
- $search.="&bclassid=$bclassid&classid=$classid";
 
- $add='';
 
- $ewhere='';
 
- //搜索
 
- $sear=RepPostStr($_GET['sear'],1);
 
- if($sear)
 
- {
 
- 	$keyboard=RepPostVar2($_GET['keyboard']);
 
- 	$show=RepPostVar($_GET['show']);
 
- 	//关键字
 
- 	if($keyboard)
 
- 	{
 
- 		//搜索全部
 
- 		if(!$show)
 
- 		{
 
- 			$add=" and (".str_replace("[!--key--]",$keyboard,$searchoptions_r['searchallfield']).")";
 
- 		}
 
- 		//搜索字段
 
- 		elseif($show&&strstr($infomod_r['enter'],"<!--field--->".$show."<!--record-->"))
 
- 		{
 
- 			$add=$show!="id"?" and (".$show." like '%$keyboard%')":" and (".$show."='$keyboard')";
 
- 			$searchoptions_r['select']=str_replace(" value=\"".$show."\">"," value=\"".$show."\" selected>",$searchoptions_r['select']);
 
- 		}
 
- 	}
 
- 	//标题分类
 
- 	$ttid=(int)$_GET['ttid'];
 
- 	if($ttid)
 
- 	{
 
- 		$add.=" and ttid='$ttid'";
 
- 	}
 
- 	$search.="&sear=1&keyboard=$keyboard&show=$show&ttid=$ttid";
 
- }
 
- //只能编辑自己的信息
 
- if($doselfinfo['doselfinfo'])
 
- {
 
- 	$add.=" and userid='$logininid' and ismember=0";
 
- }
 
- //单栏目单表
 
- $singletable=0;
 
- if($infomod_r[sonclass]=='|'.$classid.'|')
 
- {
 
- 	$singletablenum=$empire->gettotal("select count(*) as total from {$dbtbpre}enewsclass where tbname='".$class_r[$classid][tbname]."' and islast=1");
 
- 	$singletable=$singletablenum==1?1:0;
 
- }
 
- if($infomod_r[sonclass]=='|'.$classid.'|'&&$singletable==1)
 
- {
 
- 	$ewhere=$add?' where '.substr($add,5):'';
 
- }
 
- else
 
- {
 
- 	$ewhere=" where classid='$classid'".$add;
 
- }
 
- //统计
 
- $totalquery="select count(*) as total from {$dbtbpre}ecms_".$class_r[$classid][tbname]."_doc".$ewhere;
 
- $totalnum=(int)$_GET['totalnum'];
 
- if($totalnum<1)
 
- {
 
- 	$num=$empire->gettotal($totalquery);//取得总条数
 
- }
 
- else
 
- {
 
- 	$num=$totalnum;
 
- }
 
- //排序
 
- $myorder=RepPostStr($_GET['myorder'],1);
 
- if($myorder==1)//时间
 
- {$doorder="newstime desc";}
 
- elseif($myorder==2)//评论数
 
- {$doorder="plnum desc";}
 
- elseif($myorder==3)//人气
 
- {$doorder="onclick desc";}
 
- elseif($myorder==4)//ID号
 
- {$doorder="id desc";}
 
- else//默认排序
 
- {
 
- 	$thisclassr=$empire->fetch1("select listorder from {$dbtbpre}enewsclass where classid='$classid'");
 
- 	if(empty($thisclassr[listorder]))
 
- 	{
 
- 		$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(eReturnSelfPage(1));
 
- //标题分类
 
- $tts='';
 
- $ttsql=$empire->query("select typeid,tname from {$dbtbpre}enewsinfotype where mid='$modid' order by myorder");
 
- while($ttr=$empire->fetch($ttsql))
 
- {
 
- 	$select='';
 
- 	if($ttr[typeid]==$ttid)
 
- 	{
 
- 		$select=' selected';
 
- 	}
 
- 	$tts.="<option value='$ttr[typeid]'".$select.">$ttr[tname]</option>";
 
- }
 
- $stts=$tts?"<select name='ttid'><option value='0'>标题分类</option>$tts</select>":"";
 
- //栏目链接
 
- $getcurlr['classid']=$classid;
 
- $classurl=sys_ReturnBqClassname($getcurlr,9);
 
- //导入页面
 
- $deftempfile=ECMS_PATH.'e/data/html/list/doclistinfo.php';
 
- if($infomod_r[listfile])
 
- {
 
- 	$tempfile=ECMS_PATH.'e/data/html/list/doc'.$infomod_r[listfile].'.php';
 
- 	if(!file_exists($tempfile))
 
- 	{
 
- 		$tempfile=$deftempfile;
 
- 	}
 
- }
 
- else
 
- {
 
- 	$tempfile=$deftempfile;
 
- }
 
- require($tempfile);
 
- db_close();
 
- $empire=null;
 
- ?>
 
 
  |