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'];
$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'])
{
DoSpReFile($add,0);
}
if($sql)
{
//操作日志
insert_dolog("spid=".$spid."
spname=".$add[spname]);
printerror("AddSpSuccess","AddSp.php?enews=AddSp");
}
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'];
$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']);
}
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]");
}
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]");
}
else
{printerror("DbError","history.go(-1)");}
}
//删除碎片文件
function DelSpReFile($file){
$filename=ECMS_PATH.$file;
if($file&&file_exists($filename)&&!stristr('/'.$file,'/e/'))
{
DelFiletext($filename);
}
}
$enews=$_POST['enews'];
if(empty($enews))
{$enews=$_GET['enews'];}
if($enews)
{
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='';
//碎片类型
$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.="";
}
?>
碎片