<?php

include 'db.php';
include 'error.php';
include 'auth.php';

include 'header.php';

$eventId=clean($_GET["eventId"],3);
$status=clean($_GET["status"],1);
$isNew=clean($_GET["isNew"],1);


switch($status)
{
	case "T":
		$query="SELECT *,DATE_FORMAT(events_date, '%D %b %Y at %H:%i') AS NICEDATE FROM events WHERE events_id=$eventId";

		if(!($connection=@mysql_connect($hostName, $dbUsername, $dbPassword)))
			die("Could not connect");

		if(!(mysql_select_db ($databaseName, $connection)))
			showerror();

		if(!($result=@mysql_query($query,$connection)))
			showerror();

		mysql_close($connection);

		if($row=@mysql_fetch_array($result))
		{
			if($isNew=="T")
			{
				echo"The following event was added";
			}else{
				echo"The event was modified as follows:";				
			}
			
			
			echo"\n<br>Event Header: ".$row["events_header"];
			echo"\n<br>Event Details: ".$row["events_detail"];
			echo"\n<br>Event Date and Time: ".$row["NICEDATE"];
			echo"\n<br>Sport? ";
			if($row["sport"]=="1")
				echo"Yes";
			else
				echo"No";
			echo"\n<br>Sport Type: ".$row["sport_type"];
		}
		break;
		
	case "F":
		echo"Error adding/modifying Event, please retry";
		break;

	default:
		echo"Unexpected arrival";
}

include 'footer.php';
?>


