editor.php

BBWPS 宾馆管理系统 php+mysql

<?
/*
[BBWPS!] (C)2006-2010 小蜜蜂版权所有.
This is NOT a freeware, use is subject to license terms
时间：2007年12月
描述：编辑城市
*/
require("../../class/template_class.php");
require("../../config.php");
require("../../class/mysql_class.php");
require("../../function/fun.php");
require("../../function/language.php");
require("../../function/checkModuleSession.php");
$p=new Template("../template");
$DB=new DB($hostname,$username , $password ,$database,true);
$_BBWPSSESSION=isLogin("../../session/");
if($_BBWPSSESSION){
	$CID=$_POST['cp'];
	if($_GET["action"]=="del"){
		$query = "DELETE FROM `".$prefix."city` where CID='".$CID."' or cparent='".$CID."'";
		$result=$DB->query($query,1);
	}
	if($_GET["action"]==1){
		if($CID!=""){
			$query = "SELECT CID,cname FROM `".$prefix."city`";
			$result=$DB->query($query,1);
			$cname=trim($_POST['new1']);
			if(empty($cname)){
				fun($language['bjsbai'],editor);
				exit();
			}
			if($lei=$DB->query("select * from `".$prefix."city` where cname='".$cname."'",1)){
				if($DB->fetch_array($lei)){
					fun($language['procity'],editor);
					exit();
				}
			}
			if(!$DB->query("update `".$prefix."city` set cname='".$cname."'where CID='".$CID."'",false)){
				echo $DB->error();
			}
			fun($language['bianj'],editor);
		}
		else{
			fun($language['bjsbai'],editor);
		}
	}
	$p->set_file("editor_handle","editor.html");
	$query="select* from `".$prefix."city` where csort='1'";
	$result=$DB->query($query,1);
	$p->set_block("editor_handle","op","r");
	$p->set_var("r","");
	while($row=$DB->fetch_array($result)){
		$p->set_var(array("CID"=> $row['CID'],"cname"=> $row['cname']));
		$p->parse("r","op",true);
		$qy="select* from `".$prefix."city` where cparent='".$row['CID']."'";
		$rlt=$DB->query($qy,1);
		while($r=$DB->fetch_array($rlt)){
			$p->set_var(array("CID"=> $r['CID'],"cname"=> " |-".$r['cname']));
			$p->parse("r","op",true);
		}
	}
	$p->parse("output","editor_handle",true);
	$p->p("output");
}
?>