gettotal("select count(*) as total from {$dbtbpre}enewssp where varname='$add[varname]' limit 1"); if($num) { printerror("HaveSp","history.go(-1)"); } $add[sptype]=(int)$add[sptype]; $add[cid]=(int)$add[cid]; $add[classid]=(int)$add[classid]; $add[tempid]=(int)$add[tempid]; $add[maxnum]=(int)$add[maxnum]; $sptime=time(); $groupid=ReturnSpGroup($add[groupid]); $userclass=ReturnSpGroup($add[userclass]); $username=','.$add[username].','; $add[isclose]=(int)$add[isclose]; $add[cladd]=(int)$add[cladd]; $add['refile']=(int)$add['refile']; $add['spfile']=DoRepFileXg($add['spfile']); $add['spfileline']=(int)$add['spfileline']; $add['spfilesub']=(int)$add['spfilesub']; $add['filepass']=(int)$add['filepass']; $add['spname']=hRepPostStr($add['spname'],1); $add['sppic']=hRepPostStr($add['sppic'],1); $add['spsay']=hRepPostStr($add['spsay'],1); $groupid=hRepPostStr($groupid,1); $userclass=hRepPostStr($userclass,1); $username=hRepPostStr($username,1); $add['spfile']=hRepPostStr($add['spfile'],1); $sql=$empire->query("insert into {$dbtbpre}enewssp(spname,varname,sppic,spsay,sptype,cid,classid,tempid,maxnum,sptime,groupid,userclass,username,isclose,cladd,refile,spfile,spfileline,spfilesub) values('$add[spname]','$add[varname]','$add[sppic]','$add[spsay]','$add[sptype]','$add[cid]','$add[classid]','$add[tempid]','$add[maxnum]','$sptime','$groupid','$userclass','$username','$add[isclose]','$add[cladd]','$add[refile]','$add[spfile]','$add[spfileline]','$add[spfilesub]');"); $spid=$empire->lastid(); //更新附件 UpdateTheFileOther(7,$spid,$add['filepass'],'other'); //生成碎片文件 if($add['refile']) { $add['spid']=$spid; DoSpReFile($add,0); } if($sql) { //操作日志 insert_dolog("spid=".$spid."
spname=".$add[spname]); printerror("AddSpSuccess","AddSp.php?enews=AddSp".hReturnEcmsHashStrHref2(0)); } else {printerror("DbError","history.go(-1)");} } //修改碎片 function EditSp($add,$userid,$username){ global $empire,$dbtbpre; $add['varname']=RepPostVar($add['varname']); $spid=(int)$add[spid]; if(!$spid||!$add[spname]||!$add[varname]) { printerror("EmptySp","history.go(-1)"); } //验证权限 CheckLevel($userid,$username,$classid,"sp"); $num=$empire->gettotal("select count(*) as total from {$dbtbpre}enewssp where varname='$add[varname]' and spid<>$spid limit 1"); if($num) { printerror("HaveSp","history.go(-1)"); } $add[sptype]=(int)$add[sptype]; $add[cid]=(int)$add[cid]; $add[classid]=(int)$add[classid]; $add[tempid]=(int)$add[tempid]; $add[maxnum]=(int)$add[maxnum]; $sptime=time(); $groupid=ReturnSpGroup($add[groupid]); $userclass=ReturnSpGroup($add[userclass]); $username=','.$add[username].','; $add[isclose]=(int)$add[isclose]; $add[cladd]=(int)$add[cladd]; $add['refile']=(int)$add['refile']; $add['spfile']=DoRepFileXg($add['spfile']); $add['oldspfile']=DoRepFileXg($add['oldspfile']); $add['spfileline']=(int)$add['spfileline']; $add['spfilesub']=(int)$add['spfilesub']; $add['filepass']=(int)$add['filepass']; $add['spname']=hRepPostStr($add['spname'],1); $add['sppic']=hRepPostStr($add['sppic'],1); $add['spsay']=hRepPostStr($add['spsay'],1); $groupid=hRepPostStr($groupid,1); $userclass=hRepPostStr($userclass,1); $username=hRepPostStr($username,1); $add['spfile']=hRepPostStr($add['spfile'],1); $sql=$empire->query("update {$dbtbpre}enewssp set spname='$add[spname]',varname='$add[varname]',sppic='$add[sppic]',spsay='$add[spsay]',sptype='$add[sptype]',cid='$add[cid]',classid='$add[classid]',tempid='$add[tempid]',maxnum='$add[maxnum]',groupid='$groupid',userclass='$userclass',username='$username',isclose='$add[isclose]',cladd='$add[cladd]',refile='$add[refile]',spfile='$add[spfile]',spfileline='$add[spfileline]',spfilesub='$add[spfilesub]' where spid='$spid'"); //更新附件 UpdateTheFileEditOther(7,$spid,'other'); //生成碎片文件 if($add['refile']) { //旧文件 if($add['spfile']!=$add['oldspfile']) { DelSpReFile($add['oldspfile']); } $add['spid']=$spid; DoSpReFile($add,0); } if($sql) { //操作日志 insert_dolog("spid=".$spid."
spname=".$add[spname]); printerror("EditSpSuccess","ListSp.php?cid=$add[fcid]&fclassid=$add[fclassid]&fsptype=$add[fsptype]".hReturnEcmsHashStrHref2(0)); } else {printerror("DbError","history.go(-1)");} } //删除碎片 function DelSp($add,$userid,$username){ global $empire,$dbtbpre; $spid=(int)$add[spid]; if(!$spid) { printerror("NotDelSpid","history.go(-1)"); } //验证权限 CheckLevel($userid,$username,$classid,"sp"); $r=$empire->fetch1("select spname,sptype,refile,spfile from {$dbtbpre}enewssp where spid='$spid'"); $sql=$empire->query("delete from {$dbtbpre}enewssp where spid='$spid'"); if($r[sptype]==1) { $empire->query("delete from {$dbtbpre}enewssp_1 where spid='$spid'"); } elseif($r[sptype]==2) { $empire->query("delete from {$dbtbpre}enewssp_2 where spid='$spid'"); } if($r[sptype]==3) { $empire->query("delete from {$dbtbpre}enewssp_3 where spid='$spid'"); $empire->query("delete from {$dbtbpre}enewssp_3_bak where spid='$spid'"); } //删除碎片文件 if($r['refile']) { DelSpReFile($r['spfile']); } //删除附件 DelFileOtherTable("modtype=7 and id='$spid'"); if($sql) { //操作日志 insert_dolog("spid=".$spid."
spname=".$r[spname]); printerror("DelSpSuccess","ListSp.php?cid=$add[fcid]&fclassid=$add[fclassid]&fsptype=$add[fsptype]".hReturnEcmsHashStrHref2(0)); } else {printerror("DbError","history.go(-1)");} } //删除碎片文件 function DelSpReFile($file){ $filename=ECMS_PATH.$file; if($file&&file_exists($filename)&&!stristr('/'.$file,'/e/')) { DelFiletext($filename); //moreportdo if($file) { $eautodofname='delfile|'.$file.'||'; eAutodo_AddDo('eDelFileSp',0,0,0,0,0,$eautodofname); } } } $enews=$_POST['enews']; if(empty($enews)) {$enews=$_GET['enews'];} if($enews) { hCheckEcmsRHash(); include('../../class/chtmlfun.php'); include('../../data/dbcache/class.php'); include('../../class/t_functions.php'); } if($enews=="AddSp")//增加碎片 { AddSp($_POST,$logininid,$loginin); } elseif($enews=="EditSp")//修改碎片 { EditSp($_POST,$logininid,$loginin); } elseif($enews=="DelSp")//删除碎片 { DelSp($_GET,$logininid,$loginin); } elseif($enews=='ReSp')//刷新碎片文件 { ReSp($_POST,$logininid,$loginin,0); } $page=(int)$_GET['page']; $page=RepPIntvar($page); $start=0; $line=30;//每页显示条数 $page_line=12;//每页显示链接数 $offset=$page*$line;//总偏移量 $add=''; $and=''; $search=''; $search.=$ecms_hashur['ehref']; //碎片类型 $sptype=(int)$_GET['sptype']; if($sptype) { $add.=$and."sptype='$sptype'"; $and=' and '; $search.="&sptype=$sptype"; } //分类 $cid=(int)$_GET['cid']; if($cid) { $add.=$and."cid='$cid'"; $and=' and '; $search.="&cid=$cid"; } //栏目 $classid=(int)$_GET['classid']; if($classid) { $add.=$and."classid='$classid'"; $search.="&classid=$classid"; } if($add) { $add=' where '.$add; } $query="select spid,spname,varname,cid,classid,isclose,sptype,sptime,refile,spfile 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="管理碎片"; //分类 $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.=""; } ?> 碎片
位置:
  
选择分类：

fetch($sql)) { $spclassname='--'; if($r[cid]) { $scr=$empire->fetch1("select classname from {$dbtbpre}enewsspclass where classid='$r[cid]'"); $spclassname=$scr['classname']; } if($r[sptype]==1) { $sptypename='静态信息'; } elseif($r[sptype]==2) { $sptypename='动态信息'; } else { $sptypename='代码碎片'; } //链接 $sphref=''; if($r['refile']) { $sphref=' href="'.$public_r['newsurl'].$r['spfile'].'" target="_blank"'; } ?>
ID
碎片名称
变量名
所属分类
碎片类型
状态
操作
title="增加时间：">
关闭':'开启'?>
[修改] [复制] [删除]