query("insert into {$dbtbpre}enewsspclass(classname,classsay) values('$add[classname]','$add[classsay]');"); $classid=$empire->lastid(); if($sql) { //操作日志 insert_dolog("classid=".$classid."
classname=".$add[classname]); printerror("AddSpClassSuccess","AddSpClass.php?enews=AddSpClass".hReturnEcmsHashStrHref2(0)); } else {printerror("DbError","history.go(-1)");} } //修改碎片分类 function EditSpClass($add,$userid,$username){ global $empire,$dbtbpre; $classid=(int)$add[classid]; if(!$classid||!$add[classname]) { printerror("EmptySpClassname","history.go(-1)"); } //验证权限 CheckLevel($userid,$username,$classid,"sp"); $add['classname']=hRepPostStr($add['classname'],1); $add['classsay']=hRepPostStr($add['classsay'],1); $sql=$empire->query("update {$dbtbpre}enewsspclass set classname='$add[classname]',classsay='$add[classsay]' where classid='$classid'"); if($sql) { //操作日志 insert_dolog("classid=".$classid."
classname=".$add[classname]); printerror("EditSpClassSuccess","ListSpClass.php".hReturnEcmsHashStrHref2(1)); } else {printerror("DbError","history.go(-1)");} } //删除碎片分类 function DelSpClass($classid,$userid,$username){ global $empire,$dbtbpre; $classid=(int)$classid; if(!$classid) { printerror("NotDelSpClassid","history.go(-1)"); } //验证权限 CheckLevel($userid,$username,$classid,"sp"); $r=$empire->fetch1("select classname from {$dbtbpre}enewsspclass where classid='$classid'"); $sql=$empire->query("delete from {$dbtbpre}enewsspclass where classid='$classid'"); if($sql) { //操作日志 insert_dolog("classid=".$classid."
classname=".$r[classname]); printerror("DelSpClassSuccess","ListSpClass.php".hReturnEcmsHashStrHref2(1)); } else {printerror("DbError","history.go(-1)");} } $enews=$_POST['enews']; if(empty($enews)) {$enews=$_GET['enews'];} if($enews) { hCheckEcmsRHash(); } if($enews=="AddSpClass")//增加碎片分类 { AddSpClass($_POST,$logininid,$loginin); } elseif($enews=="EditSpClass")//修改碎片分类 { EditSpClass($_POST,$logininid,$loginin); } elseif($enews=="DelSpClass")//删除碎片分类 { $classid=$_GET['classid']; DelSpClass($classid,$logininid,$loginin); } $search=$ecms_hashur['ehref']; $page=(int)$_GET['page']; $page=RepPIntvar($page); $start=0; $line=30;//每页显示条数 $page_line=12;//每页显示链接数 $offset=$page*$line;//总偏移量 $query="select classid,classname from {$dbtbpre}enewsspclass"; $totalquery="select count(*) as total from {$dbtbpre}enewsspclass"; $num=$empire->gettotal($totalquery);//取得总条数 $query=$query." order by classid desc limit $offset,$line"; $sql=$empire->query($query); $returnpage=page2($num,$line,$page_line,$start,$page,$search); $url="管理碎片 > 管理碎片分类"; ?> 碎片分类
位置:

fetch($sql)) { ?>
ID
分类名称
操作
[修改] [删除]