<?php
include_once("session.php");
include_once("settings.php");

/*echo "<pre>";
print_r($_REQUEST);
echo "</pre>";*/

foreach($_REQUEST as $key => $val){
	$$key = $val;
}
$target_path = "../cat_images/events/";
$prefix=time();
$target_path = $target_path.basename($prefix.$_FILES['eventImage']['name']); 


$startDate =  strtotime($startDate) + 37800;
$endDate   = strtotime($endDate)  + 37800;

if($_REQUEST['mode']=="Edit"){
	if($_FILES['eventImage']['name'] != ""){
		if(move_uploaded_file($_FILES['eventImage']['tmp_name'], $target_path)) {
			chmod($target_path,0777); 
			$upload_image = basename($prefix.$_FILES['eventImage']['name']);
			$str = "image = '".$upload_image."', ";
		}		
	}
	 $sql="update `tblNews` set ".$str." `type`='".$txtType."', `title`='".$txtTitle."', `description`='".mysql_real_escape_string($EditDescription)."',  `startDate`='".$startDate."', `endDate`='".$endDate."' ,`updatedOn`= unix_timestamp() , updatedBy='admin' where `id`=".$id."";
}


else{
	if($_FILES['eventImage']['name']!=""){
		if(move_uploaded_file($_FILES['eventImage']['tmp_name'], $target_path)) {
			chmod($target_path,0777); 
			$upload_image = basename($prefix.$_FILES['eventImage']['name']);				
		}		
	}
	$sql="INSERT INTO `tblNews` (`type`, `title`, `description`, `image`, `startDate`, `endDate`, `createdOn`, `createdBy`, `isDeleted`) VALUES ('".$txtType."', '".$txtTitle."', '".mysql_real_escape_string($EditDescription)."', '".$upload_image."', '".$startDate."', '".$endDate."', unix_timestamp(), 'admin', 'no')";
}


$result=mysql_query($sql) or die(mysql_error());

?>
<script>
document.location="events_list.php?page=listevents"
</script>