query("insert into {$dbtbpre}enewsyh(yhname,yhtext,hlist,qlist,bqnew,bqhot,bqpl,bqgood,bqfirst,bqdown,otherlink,qmlist,dobq,dojs,dosbq,rehtml) values('$add[yhname]','$add[yhtext]','$add[hlist]','$add[qlist]','$add[bqnew]','$add[bqhot]','$add[bqpl]','$add[bqgood]','$add[bqfirst]','$add[bqdown]','$add[otherlink]','$add[qmlist]','$add[dobq]','$add[dojs]','$add[dosbq]','$add[rehtml]');");
GetClass();//更新缓存
if($sql)
{
$id=$empire->lastid();
//操作日志
insert_dolog("id=$id&yhname=$add[yhname]");
printerror("AddYhSuccess","AddYh.php?enews=AddYh".hReturnEcmsHashStrHref2(0));
}
else
{
printerror("DbError","history.go(-1)");
}
}
//修改优化方案
function EditYh($add,$userid,$username){
global $empire,$dbtbpre;
$add=ReturnYhVar($add);
$id=(int)$add['id'];
if(!$id||!$add[yhname])
{
printerror("EmptyYhname","history.go(-1)");
}
//验证权限
CheckLevel($userid,$username,$classid,"yh");
$sql=$empire->query("update {$dbtbpre}enewsyh set yhname='$add[yhname]',yhtext='$add[yhtext]',hlist='$add[hlist]',qlist='$add[qlist]',bqnew='$add[bqnew]',bqhot='$add[bqhot]',bqpl='$add[bqpl]',bqgood='$add[bqgood]',bqfirst='$add[bqfirst]',bqdown='$add[bqdown]',otherlink='$add[otherlink]',qmlist='$add[qmlist]',dobq='$add[dobq]',dojs='$add[dojs]',dosbq='$add[dosbq]',rehtml='$add[rehtml]' where id='$id'");
GetClass();//更新缓存
if($sql)
{
//操作日志
insert_dolog("id=$id&yhname=$add[yhname]");
printerror("EditYhSuccess","ListYh.php".hReturnEcmsHashStrHref2(1));
}
else
{
printerror("DbError","history.go(-1)");
}
}
//删除优化方案
function DelYh($id,$userid,$username){
global $empire,$dbtbpre;
$id=(int)$id;
if(!$id)
{
printerror("NotChangeYhid","history.go(-1)");
}
//验证权限
CheckLevel($userid,$username,$classid,"yh");
$r=$empire->fetch1("select yhname from {$dbtbpre}enewsyh where id='$id'");
$sql=$empire->query("delete from {$dbtbpre}enewsyh where id='$id'");
GetClass();//更新缓存
if($sql)
{
//操作日志
insert_dolog("id=$id&yhname=$r[yhname]");
printerror("DelYhSuccess","ListYh.php".hReturnEcmsHashStrHref2(1));
}
else
{
printerror("DbError","history.go(-1)");
}
}
$enews=$_POST['enews'];
if(empty($enews))
{$enews=$_GET['enews'];}
if($enews)
{
hCheckEcmsRHash();
}
if($enews=="AddYh")
{
AddYh($_POST,$logininid,$loginin);
}
elseif($enews=="EditYh")
{
EditYh($_POST,$logininid,$loginin);
}
elseif($enews=="DelYh")
{
$id=$_GET['id'];
DelYh($id,$logininid,$loginin);
}
else
{}
$search=$ecms_hashur['ehref'];
$page=(int)$_GET['page'];
$page=RepPIntvar($page);
$start=0;
$line=20;//每页显示条数
$page_line=20;//每页显示链接数
$offset=$page*$line;//总偏移量
$query="select id,yhname from {$dbtbpre}enewsyh";
$totalquery="select count(*) as total from {$dbtbpre}enewsyh";
$num=$empire->gettotal($totalquery);//取得总条数
$query=$query." order by id desc limit $offset,$line";
$sql=$empire->query($query);
$returnpage=page2($num,$line,$page_line,$start,$page,$search);
?>
优化方案