conmanage.php

在传统CMS文章内容管理功能基础上

<?
/*
    [BBWPS!] (C)2006-2010 小蜜蜂版权所有.
	  This is NOT a freeware, use is subject to license terms
	  功能:编辑广告
*/

error_reporting(0);
if(!function_exists("CheckRequire")){
	exit("Forbidden");
}
$p=new Template("./template/ad");
$db= new DB($hostname,$username,$password,$database);
$action=$_REQUEST["act"];
if(!$action){
	$sql="select * from ".$prefix."advertisements";
}
elseif ($action=="sort"){
	$field=$_GET["field"];
	$condition=$_GET["condition"];
	$sql="select * from ".$prefix."advertisements order by $field $condition";
	$action="sort&field=$field&condition=$condition";
}
elseif ($action=="edit"){
	$isMagic = @ini_get("magic_quotes_gpc");
	if(!$isMagic){
		if (is_array($_POST['advnew'])){
			foreach($_POST['advnew'] AS $key => $value) {
				$value = str_replace('\"','||queto||',$value);
				$value = str_replace('"','\"',$value);
				$value = str_replace('||queto||','\"',$value);
				$_POST['advnew'][$key]=$value;
			}
		}
	}
	$adid = $_GET['adid'];
	$title = $_POST['advnew']['title'];
	$adtag = $_POST['advnew']['adtag'];
	foreach ($_POST['advnew']['targets'] as $values){
		if($values!=""){
			$targets.=$values."|";
		}
	}
	$targets = substr($targets,0,-1);
	$starttime = $_POST['advnew']['starttime'];
	$starttime = strtotime($starttime);
	$endtime = $_POST['advnew']['endtime'];
	$endtime = strtotime($endtime);
	$code = $_POST['advnew']['code']['html'];
	$sql = "select adtag from ".$prefix."advertisements where adid!='$adid'";
	$sqlRes = $db->query($sql,true);
	while ($sqlObj=$db->fetch_object($sqlRes)){
		if($sqlObj->adtag==$adtag){
			$db->__DB();
			unset($db,$sql,$sqlRes,$sqlObj,$style,$title,$adtag);
			MsgError($langAdminArray["ad_reapt"]);
		}
	}
	unset($sql,$sqlRes,$sqlObj);
	if($title==""||$title==null||$adtag==""||$adtag==null||$starttime==""||$starttime==null||$code==""||$code==null){
		MsgError($langAdminArray["ad_input"]);
	}
	
	$updateSql = "update ".$prefix."advertisements set title='".$title."', adtag='".$adtag."', targets='".$targets."', code='".$code."', starttime='".$starttime."', endtime='".$endtime."' where adid=".$adid;
	$db->update($updateSql);
	$db->__DB;
	ExeSuccess($langAdminArray["ad_succs"],"?mod=ad&f=conmanage");
}
elseif ($action=="showContent"){
	$adid = $_GET['adid'];
	$selectSql = "select * from ".$prefix."advertisements where adid=".$adid;
	$obj = $db->get_one($selectSql);
	$targets = explode("|",$obj->targets);
	foreach ($moduleArray as $value){
		$selectpath="";
		for($i=0;$i<count($targets);$i++){
			if($value['id']==$targets[$i]){
				$selectpath="selected";
				break;
			}
		}
		$optionString.="<option value=\"".$value['id']."\" {$selectpath}>&nbsp;&nbsp;> ".$value['name']."</option><option value=\"\">&nbsp;</option>";
	}
	if($targets[0]=="all"){
		$p->set_var("allselected","selected");
	}
	$p->set_file("handle","adedit.html");
	$p->set_var("title",$obj->title);
	$p->set_var("type",$obj->type);
	$p->set_var("html",$obj->code);
	$p->set_var("adtag",$obj->adtag);
	$p->set_var("adid",$obj->adid);
	$p->set_var("starttime",date("Y-m-d",$obj->starttime));
	$p->set_var("endtime",date("Y-m-d",$obj->endtime));
	$p->set_var("option",$optionString);
	$p->parse("output","handle");
	$p->p("output");
	unset($p);
	exit();
}
elseif ($action=="delete"){
	$articleidA=$_POST["adid"];
	foreach ($articleidA as $articleid){
		$db->update("delete from ".$prefix."advertisements where adid=$articleid");
	}
	ExeSuccess($langAdminArray["ad_succs"],"?mod=ad&f=conmanage");
}
elseif($action=="passtime"){
	$nowTime = time();
	$sql="select * from ".$prefix."advertisements where endtime<".$nowTime." order by adid desc";
}elseif ($action=="able"){
	$ableidA=$_POST["adid"];
	if($ableidA==""){
		MsgError($langAdminArray["ad_input"]);
	}
	foreach ($ableidA as $ableid){
		$db->update("update ".$prefix."advertisements set available=1 where adid=$ableid");
	}
	unset($ableidA,$ableid);
	ExeSuccess($langAdminArray["ad_succs"],"?mod=ad&f=conmanage");
}elseif ($action=="unable"){
	$ableidA=$_POST["adid"];
	if($ableidA==""){
		MsgError($langAdminArray["ad_input"]);
	}
	foreach ($ableidA as $ableid){
		$db->update("update ".$prefix."advertisements set available=0 where adid=$ableid");
	}
	unset($ableidA,$ableid);
	ExeSuccess($langAdminArray["ad_succs"],"?mod=ad&f=conmanage");
}
else{
	exit("Forbidden");
}
$currentpage=$_REQUEST["next"];
if($currentpage==null){
	$whichpage=1;
}
else{
	$whichpage=$currentpage;
}
$lower_item=($whichpage-1)*30;
$result=$db->query($sql,false);
$allMsg=mysql_num_rows($result);
mysql_free_result($result);
$allPage=ceil($allMsg/30);
$db->query($sql." limit $lower_item,30",true);
while ($rs=$db->fetch_object()){
	$p->set_file("handleBrowse","bl_row.html");
	$p->set_var("adid",$rs->adid);
	if($rs->available==0){
		$p->set_var("available",$langAdminArray["ad_unable"]);
	}else {
		$p->set_var("available",$langAdminArray["ad_able"]);
	}
	$p->set_var("title",$rs->title);
	$p->set_var("type",$rs->type);
	$p->set_var("starttime",date("Y-m-d",$rs->starttime));
	$p->set_var("endtime",date("Y-m-d",$rs->endtime));
	$targets = explode("|",$rs->targets);
	foreach ($moduleArray as $value){
		for($i=0;$i<count($targets);$i++){
			if($value['id']==$targets[$i]){
				$targetStr = $value['name'];
			}
		}
	}
	if($targets[0]=="all"){
		$targetStr=$langAdminArray["ad_allmodule"];
	}
	$p->set_var("targets",$targetStr);
	$p->parse("link","handleBrowse",true);
	unset($value,$values,$targetStr);
}
$p->set_file("handle","browselist.html");
$split_page=show_split_page($whichpage,$allPage,"admin.php?mod=ad&f=conmanage&c=3");
$sortArray["articleid_desc"]="desc";
$sortArray["catid_desc"]="desc";
$sortArray["isinsert_desc"]="desc";
$sortArray["hits_desc"]="desc";
$sortArray["status_desc"]="desc";
$sortArray["addtime_desc"]="desc";
$sortArray["passtime_desc"]="desc";

$sortArray["articleid_s"]=$langAdminArray["desc"];
$sortArray["catid_s"]=$langAdminArray["desc"];
$sortArray["isinsert_s"]=$langAdminArray["desc"];
$sortArray["hits_s"]=$langAdminArray["desc"];
$sortArray["status_s"]=$langAdminArray["desc"];
$sortArray["addtime_s"]=$langAdminArray["desc"];
$sortArray["passtime_s"]=$langAdminArray["desc"];

if($field){
	if($condition=="desc"){
		$sortArray[$field."_desc"]="asc";
		$sortArray[$field."_s"]=$langAdminArray["asc"];
	}
	else{
		$sortArray[$field."_desc"]="desc";
		$sortArray[$field."_s"]=$langAdminArray["desc"];
	}
}
$p->set_var($sortArray);
$p->set_var("cid",$cid);
$p->set_var("articleid_desc",$sortArray[$field."_desc"]);
$p->set_var("split_page",$split_page);
$p->set_var("allpage",$allPage);
$p->set_var("allmsg",$allMsg);
$p->set_var("whichpage",$whichpage);
$p->parse("output","handle");
$p->p("output");
?>