<?php/*** 廣告位管理* @version phpcms 3.0.0 build 20060424* @package phpcms* @subpackage ads* @link http://dev.phpcms.cn phpcms模塊開發網站* @license http://www.phpcms.cn/license.html phpcms版權聲明* @copyright (C) 2005 - 2006 Phpcms Group*/defined('IN_PHPCMS') or exit(FORBIDDEN);$submenu = array(	array("添加廣告", "?mod=".$mod."&file=ads&action=add"),	array("廣告管理", "?mod=".$mod."&file=ads&action=manage"),	array("廣告訂單管理", "?mod=".$mod."&file=ads&action=signlist"),	array("添加廣告位", "?mod=".$mod."&file=place&action=add"),	array("廣告位管理", "?mod=".$mod."&file=place&action=manage"),	array("廣告模板管理", "?mod=phpcms&file=template&action=manage&module=".$mod),	array("廣告模板類型", "?mod=phpcms&file=templatetype&action=manage&module=".$mod),);$menu = adminmenu("廣告管理",$submenu);$action = $action?$action:"manage";switch($action){    case 'add':        if ($submit) {        		if(strlen($place[placename])<2 || strlen($place[placename])>30){  			showmessage("名稱不能為空且不得少于2個字符或超過30個字符！請返回！");  		}    		$badwords=array("\\",'&',"'",'"','/','*','<','>',"\r","\t","\n",'#');  		foreach ($badwords as $value) {  			if(strpos($place[placename],$value)!==false) {   				showmessage('名稱中不得包含非法字符！請返回！');   			}  		}    		foreach ($badwords as $value) {  			if(strpos($place[introduce],$value)!==false) {   				showmessage('說明中不得包含非法字符！請返回！');   			}  		}            $templateids = get_template($mod,"ads");  		if(!isset($templateids[$templateid][templatename])){  			showmessage("請輸入廣告位模版！請返回！");  		}        		if(!is_numeric($place[price])){  			showmessage("請輸入廣告位價格！請返回！");  		}        		if(!is_numeric($place[height]) && !is_numeric($place[weight])){  			showmessage("請確認輸入廣告位高度和寬度格式為數值！請返回！");  		}            $sql = "INSERT INTO ".TABLE_ADS_PLACE." SET placename='$place[placename]',introduce='$place[introduce]',templateid='$templateid',price='$place[price]',channelid='$place[channelid]',passed=".($place[passed]?1:0).",width='$place[width]',height='$place[height]'";  		$result=$db->query($sql);  		if($db->affected_rows()>0) {  			showmessage('操作完成！',"?mod=$mod&file=$file&action=manage");  		} else {  			showmessage('操作失??！意外錯誤，請確認輸入內容。');  		}                }    		$template_select = showtpl($mod,"ads","templateid");		include admintpl("place_add");		break;		case 'loadjs':			include admintpl("place_loadjs");			break;				case 'view':			include admintpl("place_view");			break;		            case 'edit':			if ($submit) {      				if(strlen($place[placename])<2 || strlen($place[placename])>30){					showmessage("名稱不能為空且不得少于2個字符或超過30個字符！請返回！");				}						$badwords=array("\\",'&',"'",'"','/','*','<','>',"\r","\t","\n",'#');				foreach ($badwords as $value) {					if(strpos($place[placename],$value)!==false) { 						showmessage('名稱中不得包含非法字符！請返回！'); 					}				}						foreach ($badwords as $value) {					if(strpos($place[introduce],$value)!==false) { 						showmessage('說明中不得包含非法字符！請返回！'); 					}				}								$templateids = get_template($mod,"ads");				if(!isset($templateids[$templateid][templatename])){					showmessage("請輸入廣告位模版！請返回！");				}								if(!is_numeric($place[price])){					showmessage("請輸入廣告位價格！請返回！");				}								if(!is_numeric($place[height]) && !is_numeric($place[weight])){					showmessage("請確認輸入廣告位高度和寬度格式為數值！請返回！");				}								$sql = "update ".TABLE_ADS_PLACE." SET placename='$place[placename]',introduce='$place[introduce]',templateid='$templateid',price='$place[price]',channelid='$place[channelid]',passed=".($place[passed]?1:0).",width='$place[width]',height='$place[height]' where placeid=".$place[placeid]." limit 1";				$result=$db->query($sql);				if($db->affected_rows()>0) {					showmessage('操作完成！',"?mod=$mod&file=$file");				} else {					showmessage('操作失??！意外錯誤，請確認輸入內容。');				}      							}					$place = $db->get_one("SELECT * FROM ".TABLE_ADS_PLACE." where placeid = $placeid limit 1");			if (count($place)<1) showmessage("未能查詢到需要的記錄，已返回。","?mod=ads&file=place");			$template_select = showtpl($mod,"ads","templateid",$place[templateid]);			include admintpl("place_edit");		break;		case 'lock':			if (is_numeric($placeid) && is_numeric($val)) {				$db->query("update ".TABLE_ADS_PLACE." set passed = $val where placeid=$placeid limit 1");			} elseif (is_array($placeid)) {				$placeids = implode(",",$placeid);				$db->query("update ".TABLE_ADS_PLACE." set passed = $val where placeid in ($placeids)");			}			if ($db->affected_rows()>0) {				showmessage('操作成功！',"?mod=ads&file=place");			} else {				showmessage('操作完成！未能查詢到符合的記錄，已返回。',"?mod=ads&file=place");			}			showmessage("錯誤參數！請返回！");		break;    case 'delete':		if(is_numeric($placeid)){	  	$db->query("delete from ".TABLE_ADS." where placeid=".$placeid);	  	$db->query("delete from ".TABLE_ADS_PLACE." where placeid=".$placeid." limit 1");		} elseif (is_array($placeid)) {			$placeids = implode(",",$placeid);	  	$db->query("delete from ".TABLE_ADS." where placeid in ($placeids)");			$db->query("delete from ".TABLE_ADS_PLACE." where placeid in ($placeids)");		}		if($db->affected_rows()>0) {			showmessage('操作成功！',"?mod=".$mod."&file=place");		} else {			showmessage("操作完成！未能查詢到符合的記錄，已返回。","?mod=ads&file=place");		}		showmessage("錯誤參數！請返回！");    break;        default :			$templateids = get_template($mod,"ads");						$page = intval($page)>0 ? $page : 1;			$offset=($page-1)*$_PHPCMS['pagesize'];			$result=$db->query("SELECT count(*) as num FROM ".TABLE_ADS_PLACE);			$r=$db->fetch_array($result);			$number=$r["num"];			$url='?mod='.$mod.'file=ads&action='.$action;			$pages = phppages($number,$page,$_PHPCMS['pagesize'],$url);			$result=$db->query("SELECT * FROM ".TABLE_ADS_PLACE." order by placeid desc limit $offset,$_PHPCMS[pagesize] ");						while($r=$db->fetch_array($result)){				$places[]=$r;			}			reset($places);			$today = time(date("Y-m-d"));			while ($place = current($places)) {				$result=$db->get_one("SELECT * FROM ".TABLE_ADS." where placeid=$place[placeid] AND passed=1 and fromdate<='$today' and todate>='$today' limit 1");				$places[key($places)][todate] = $result[todate]?date("Y-m-d",$result[todate]):"-";				$places[key($places)][username] = $result[username]?$result[username]:"-";				next($places);			}			include admintpl("place_list");}?>