<?php

include 'db.php';
include 'error.php';
include 'auth.php';

$eventID=$_GET["eventID"];

$eventHeader=$_POST["eventHeader"];
$eventDate=$_POST["eventDate"];
$eventDetail=$_POST["eventDetail"];
$eventSport=$_POST["eventSport"];
$eventSportType=$_POST["eventSportType"];
$modify=$_POST["modify"];
$modifyID=$_POST["modifyID"];


if (empty($eventHeader) || empty($eventDetail) || empty($eventDate))
{


	if(empty($eventID))
	{
		include 'header.php';
		?>
				<span class="Head0">Admin - Add Event</span><p>
				<form name="addEvent" action="event_add.php" method="post" onSubmit="return consoliDate(this);">
				<input type="hidden" name="eventDate"><input type="hidden" name="modify" value="0">

				<table border="0" width="100%" cellpadding="3" cellspacing="0">
				<tr><td width="220"></td><td width="240"></td></tr>
				<tr><td colspan="2">Event Header</td></tr>
				<tr><td colspan="2"><input type="text" name="eventHeader" size="60"></td></tr>

				<tr><td colspan="2">Event Detail</td></tr>
				<tr><td colspan="2"><textarea name="eventDetail" rows="10" cols="45"></textarea></td></tr>

				<tr><td>Event Date (dd/mm/yyyy)</td><td>Event Time (hh:mm)</td></tr>

				<tr><td><input type="text" name="day" size="1">/<input type="text" name="month" size="1">/<input type="text" name="year" size="2"></td>
				<td><input type="text" name="hour" size="2">:<input type="text" name="min" size="2"></td></tr>

				<tr><td>Sport Event?&nbsp;<input type="checkbox" name="eventSport" value="on" onClick="sportCheck();"></td><td>Sport Type</td></tr>
				<tr><td></td>

				<td><input type="text" name="eventSportType" size="15" disabled></td></tr>
				
				<tr><td colspan="2" align="center"><input type="submit" value="submit"></td></tr>
				</table></form>

		<?php
		include 'footer.php';
	}else
	{
		//Event Id exists so need to modify

		if(!($connection=@mysql_connect($hostName, $dbUsername, $dbPassword)))
			die("Could not connect");

		if(!(mysql_select_db ($databaseName, $connection)))
			showerror();


		$viewQuery="SELECT * FROM events WHERE events_id=$eventID";
		//echo($insertQuery);

		if(!($result = @mysql_query($viewQuery,$connection)))
			showerror();

		mysql_close($connection);

		$row=mysql_fetch_array($result);
		$eventDate=$row["events_date"];
		$eventYear=substr($eventDate,0,4);
		$eventMth=substr($eventDate,5,2);
		$eventDay=substr($eventDate,8,2);
		$eventHour=substr($eventDate,11,2);
		$eventMin=substr($eventDate,14,2);



		include 'header.php';
		?>
				<form name="addEvent" action="event_add.php" method="post" onSubmit="return consoliDate(this);">
				<input type="hidden" name="eventDate"><input type="hidden" name="modify" value="1"><input type="hidden" name="modifyID" value="<?php echo($eventID); ?>">
				Event Header<br>
				<input type="text" name="eventHeader" size="60" value="<?php echo($row["events_header"]); ?>">
				<br>
				Event Detail<br>
				<textarea name="eventDetail" rows="10" cols="45"><?php echo($row["events_detail"]); ?></textarea>
				<br>
				Event Date<br>
				<input type="text" name="day" size="1" value="<?php echo($eventDay); ?>"><input type="text" name="month" size="1" value="<?php echo($eventMth); ?>"><input type="text" name="year" size="2" value="<?php echo($eventYear); ?>">
				<br>
				Event Time<br>
				<input type="text" name="hour" size="2" value="<?php echo($eventHour); ?>">:<input type="text" name="min" size="2" value="<?php echo($eventMin); ?>">
				<br>
				Sport Event<br>
				<input type="checkbox" name="eventSport" 
				<?php
					if(($row["sport"])=="1")
						echo "checked";
				?>		
				>
				<br>
				Sport Type<br>
				<input type="text" name="eventSportType" size="15" value="<?php echo($row["sport_type"]); ?>"><br>
				
				
				<input type="submit" value="submit"></form>



		<?php
		include 'footer.php';
	}





}else
{

	
	$eventDate=clean($eventDate,20);
	$eventHeader=clean($eventHeader,100);
	$eventDetail=clean($eventDetail,3000);
	if($eventSport=="on")
		$eventSport=1;
	else
		$eventSport=0;
	$eventSportType=clean($eventSportType,20);


	if(!($connection=@mysql_connect($hostName, $dbUsername, $dbPassword)))
		die("Could not connect");

	if(!(mysql_select_db ($databaseName, $connection)))
		showerror();

	if ($modify=="0")
	{
		$insertQuery="insert into events values(NULL,".
												"\"".$eventHeader."\",".
												"\"".$eventDetail."\",".
												"\"".$eventDate."\",".
												"\"".$eventSport."\",".
												"\"".$eventSportType."\")";
	}else{
		$insertQuery="UPDATE events SET events_header=\"".$eventHeader."\", events_detail=\"".$eventDetail."\", events_date=\"".$eventDate."\",sport=\"".$eventSport."\",sport_type=\"".$eventSportType."\" WHERE events_id=$modifyID";
	}
	
	
	//echo($insertQuery);

	if((@mysql_query($insertQuery,$connection)) && mysql_affected_rows()==1)
		{
			if($modify=="0")
			{
				$modifyID=mysql_insert_id($connection);
				$modifyID.="&isNew=T";
			}				
		//print_r($modifyID);
		header("Location:event_add_success.php?"."eventId=".$modifyID."&status=T");
		}
	else
		header("Location:event_add_success.php?"."&status=F");




	mysql_close($connection);



}
?>

