event_ac.php

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

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

switch($cate){
	case "save":
		$currentID=p('id');
		$ONE["eTitle"]=p("eventTitle");
		$ONE["eKeywords"]=p("eventKeywords");
		$ONE["eDescription"]=p("eventDescription");
		$ONE["eContent"]=p("eventContent");
		$ONE["eTimes"]=p("eventDate")?p("eventDate"):date('Y/m/d',time());
		$times=explode("/" ,$ONE["eTimes"]);
		$ONE["eTimes"]=mktime(0,0,0,$times[1],$times[2],$times[0]);
		
		//if(!$ONE['eTitle']) $msg='Events title can not be empty.';
		//if(!$ONE['eContent']) $msg='Events content can not be empty.';
		
		if($currentID!=0){
			$sql="update event set eTitle='".$ONE['eTitle']."',eKeywords='".$ONE['eKeywords']."',eDescription='".$ONE['eDescription']."',eContent='".$ONE['eContent']."',eCreated=".$ONE['eTimes'].",eUpdated=".time()." where ID=$currentID";
			$title='Event updated!';
			$msg[]='Event updated successfully.';
			$msg[]='<a href="index.php?action=event">Back to view events</a>';
		}
		else{
			$sql="insert into event(eTitle,eKeywords,eDescription,eContent,eCreated) values('".$ONE['eTitle']."','".$ONE['eKeywords']."','".$ONE['eDescription']."','".$ONE['eContent']."',".$ONE['eTimes'].")";
			$title='New event added!';
			$msg[]='New event added successfully.';
			$msg[]='<a href="index.php?action=event">Back to view events</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 Events';
		
		$ONE=array('ID'=>0,'eTitle'=>'','eKeywords'=>'','eDecription'=>'','eContent'=>create_html_editor('eventContent',450),'eTimes'=>date('Y/m/d',time()));
		if($currentID){
			$title='Edit Events';			
			if($result=$this->db->get_one('select * from event where id='.$currentID)){
				$ONE['ID']				=$currentID;
				$ONE['eTitle']			=$result['eTitle'];
				$ONE['eKeywords']		=$result['eKeywords'];
				$ONE['eDescription']	=$result['eDescription'];
				$ONE['eContent']		=create_html_editor('evnetContent',450,$result['eContent']);
				$ONE['eTimes']			=date('Y/m/d',$result['eCreated']);
			}
			else{
				$msg[]='Events No. not found.';
				$msg[]='<a href="index.php?action=event">Back to view events</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','events_edit');
		}
	break;
	case "delete":
		$pid=g('id')?g('id'):(p('id')?join(p('id'),','):false);
		if($pid){
			$sql="delete from event where id in($pid)";
			$this->db->query($sql,'U_B');
			$msg[]='Event deleted successfully.';
			$msg[]='<a href="index.php?action=event">Back to view events</a>';
			$this->set('finalTitle','Event deleted!');
			$this->set('msg',$msg);
			$this->set('final','warning');
		}
		else{
			$msg[]='Event deleted unsuccessfully';
			$msg[]='<a href="index.php?action=event">Back to view events</a>';
			$this->set('finalTitle','Warning!');
			$this->set('msg',$msg);
			$this->set('final','warning');
		}
	break;
	default:
		$page[]=20;
		if(g('page')){$page[]=intval(g('page'));}else{$page[]=1;}
		$sql = "select count(id) as amount from event"; 
		$result=$this->db->query($sql);
		$row=$this->db->fetch_array($result);
		$amount = $row['amount'];
		if($amount){
			if($amount % $page[0]){$page[]=(int)($amount/$page[0])+1;}else{$page[]=$amount/$page[0];}
			$page[]=$amount;
		}
		else{$page[]=0;$page[]=0;}
		
		$sql = "select id,etitle,eCreated from event order by eCreated desc limit ".($page[1]-1)*$page[0].",".$page[0];
		$result=$this->db->query($sql);
		while($row=$this->db->fetch_array($result)){
			$id=$row['id'];
			$title=$row['etitle'];
			$nTime=date('M d,Y',$row['eCreated']);
			$events[]=array($id,$title,$nTime);
		}
		if(isset($events)) $this->set('events',$events);
		$this->set('page',$page);
		$this->set('finalTitle','View Events');
		$this->set('final','events');
	break;
}
?>