page_ac.php

没用的东西？ 国外php免费程序,相册 留言板 等

<?php
global $action,$cate,$superName,$_PAGE;

$this->set('_PAGE',$_PAGE);



switch($cate){
	case "save":
		$currentID=p('id');
		$ONE["pTitle"]=p("pageTitle");
		$ONE["pKeywords"]=p("pageKeywords");
		$ONE["pDescription"]=p("pageDescription");
		$ONE["pContent"]=p("pageContent");
		$ONE["pMember"]=p("pageMember")?1:0;
		$ONE["pShow"]=p("pageShow")?1:0;
		$ONE["pOrder"]=p("pageOrder")?p("pageOrder"):0;
		
		//if(!$ONE['pTitle']) $msg='Page title can not be empty.';
		//if(!$ONE['pContent']) $msg='Page content can not be empty.';
		
		if($currentID!=0){
			$sql="update page set pTitle='".$ONE['pTitle']."',pKeywords='".$ONE['pKeywords']."',pDescription='".$ONE['pDescription']."',pContent='".$ONE['pContent']."',pShow=".$ONE['pShow'].",pOrder=".$ONE['pOrder'].",pMember=".$ONE['pMember']." where ID=$currentID";
			$title='Page updated!';
			$msg[]='Page updated successfully.';
			$msg[]='<a href="index.php?action=page">Back to view pages</a>';
		}
		else{
			if($ONE["pOrder"]==0){
				$order=$this->db->get_one('select max(pOrder)+1 as autoOrder from page');
				if($order and $order['autoOrder']) $ONE["pOrder"]=$order['autoOrder']; else $ONE["pOrder"]=1;
			}
			
			$sql="insert into page(pTitle,pKeywords,pDescription,pContent,pShow,pOrder,pMember,pPtime) values('".$ONE['pTitle']."','".$ONE['pKeywords']."','".$ONE['pDescription']."','".$ONE['pContent']."',".$ONE['pShow'].",".$ONE['pOrder'].",".$ONE['pMember'].",".time().")";
			$title='Page added!';
			$msg[]='Page dded successfully.';
			$msg[]='<a href="index.php?action=page">Back to view pages</a>';
		}
		
		if(isset($sql)){
			$this->db->query($sql,'U_B');
		}else{$title='Warning!';}
		
		
		$this->set('finalTitle',$title);
		$this->set('msg',$msg);
		$this->set('final','warning');
	break;
	case "add":
		$currentID=g('id');
		$title='Add New Page';
				
		$ONE=array('ID'=>0,'pTitle'=>'','pKeywords'=>'','pDecription'=>'','pContent'=>create_html_editor('pageContent',450),'pShow'=>1,'pOrder'=>0,'pMember'=>0,'pParentTitle'=>'As Root');
		if($currentID){
			$title='Edit Page';			
			if($result=$this->db->get_one('select * from page where id='.$currentID)){
				$ONE['ID']				=$currentID;
				$ONE['pTitle']			=$result['pTitle'];
				$ONE['pKeywords']		=$result['pKeywords'];
				$ONE['pDescription']	=$result['pDescription'];
				$ONE['pContent']		=create_html_editor('pageContent',450,$result['pContent']);
				$ONE['pShow']			=$result['pShow'];
				$ONE['pOrder']			=$result['pOrder'];
				$ONE['pMember']			=$result['pMember'];
			}
			else{
				$msg[]='Page No. not found.';
				$msg[]='<a href="index.php?action=page">Back to view pages</a>';
			}
		}
		
		if(isset($msg)){
			$this->set('finalTitle','Warning!');
			$this->set('msg',$msg);
			$this->set('final','warning');
		}
		else{
			$this->set('finalTitle',$title);
			$this->set('ONE',$ONE);
			$this->set('final','page_edit');
		}
	break;
	case "delete":
		$pid=g('id')?g('id'):(p('id')?join(p('id'),','):false);
		if($pid){
			$sql="delete from page where id in($pid)";
			$this->db->query($sql,'U_B');
			$msg[]='Page deleted successfully.';
			$msg[]='<a href="index.php?action=page">Back to view pages</a>';
			$this->set('finalTitle','Page deleted!');
			$this->set('msg',$msg);
			$this->set('final','warning');
		}
		else{
			$msg[]='Page deleted unsuccessfully';
			$msg[]='<a href="index.php?action=page">Back to view pages</a>';
			$this->set('finalTitle','Warning!');
			$this->set('msg',$msg);
			$this->set('final','warning');
		}
	break;
	default:				
		$sql = "select id,ptitle,pshow,porder,pmember from page order by porder";
		$result=$this->db->query($sql);
		while($row=$this->db->fetch_array($result)){
			$id=$row['id'];
			$ptitle=$row['ptitle'];
			$som=$row["pshow"]==1?'<font color="#990000">Yes</font>':'No';
			$order=$row["pshow"]==1?$row["porder"]:'';
			$member=$row["pmember"]==1?'<font color="#007700">Yes</font>':'No';;
			$pages[]=array($id,$ptitle,$som,$order,$member);
		}
		if(isset($pages)) $this->set('pages',$pages);
		$this->set('finalTitle','View Pages');
		$this->set('final','page');
	break;
}
?>