<?php

include 'db.php';
include 'error.php';
include 'auth.php';

$eventID=$_GET["eventID"];
$deleteSure=$_POST["deleteSure"];
$deleteID=$_POST["deleteID"];

if(empty($deleteSure))
{
	?>
	<?php
		include 'header.php';
		$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();

		if($row=@mysql_fetch_array($result))
		{
			echo"Are you sure you want to delete the following event?";
			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"];
		}
	?>
	<form name="delEvent" action="event_del.php" method="post">
	<input type="hidden" name="deleteSure" value="1"><input type="hidden" name="deleteID" value="<?php echo($eventID); ?>">
	<input type="submit" value="Delete"></form>


	
	<?php
	include 'footer.php';

}else{

	if(!($connection=@mysql_connect($hostName, $dbUsername, $dbPassword)))
		die("Could not connect to DB");

	if(!(mysql_select_db ($databaseName, $connection)))
		showerror();


	$deleteQuery="DELETE FROM events WHERE events_id=$deleteID";


	if((@mysql_query($deleteQuery,$connection)) && mysql_affected_rows()==1)
		{
		header("Location:event_del_success.php?"."status=T");
		}
	else
		header("Location:event_del_success.php?"."&status=F");

	mysql_close($connection);

}

?>