<?php


include 'db.php';
include 'error.php';

$selectEvent=$_GET["select"];
$eventID=$_GET["eventID"];
$eventID=clean($eventID,3);

if(empty($eventID))
{
	switch($selectEvent)
	{
		case "1":
			$listQuery="SELECT *,DATE_FORMAT(events_date, '%D %b %Y at %l:%i %p') AS NICEDATE,DATE_FORMAT(events_date, '%Y-%c-%e %k:%i') AS ISODATE FROM events WHERE sport='1' ORDER BY events_date";
			break;

		case "2":
			$listQuery="SELECT *,DATE_FORMAT(events_date, '%D %b %Y at %l:%i %p') AS NICEDATE,DATE_FORMAT(events_date, '%Y-%c-%e %k:%i') AS ISODATE FROM events WHERE sport='0' ORDER BY events_date";
			break;

		default:
			$listQuery="SELECT *,DATE_FORMAT(events_date, '%D %b %Y at %l:%i %p') AS NICEDATE,DATE_FORMAT(events_date, '%Y-%c-%e %k:%i') AS ISODATE FROM events ORDER BY events_date";
	}


	if(!($connection=@mysql_connect($hostName, $dbUsername, $dbPassword)))
		die("Could not connect to DB");

	if(!(mysql_select_db ($databaseName, $connection)))
		showerror();

	if(!($result = @mysql_query($listQuery,$connection)))
		showerror();


	include 'header.php';
	switch($selectEvent)
	{
		case "1":
			echo"<span class=\"head0\">ORS Sporting Events</span><p>";
			break;

		case "2":
			echo"<span class=\"head0\">ORS Non-Sporting Events</span><p>";
			break;

		default:
			echo"<span class=\"head0\">All ORS Events</span><p>";
	}

	eventsTable($result);
	
	mysql_close($connection);


	include 'footer.php';

}else{

	$listQuery="SELECT *,DATE_FORMAT(events_date, '%D %M %Y at %l:%i %p') AS NICEDATE FROM events WHERE events_id=$eventID";


	if(!($connection=@mysql_connect($hostName, $dbUsername, $dbPassword)))
		die("Could not connect to DB");

	if(!(mysql_select_db ($databaseName, $connection)))
		showerror();

	if(!($result = @mysql_query($listQuery,$connection)))
		showerror();

	$row=mysql_fetch_array($result);
	$header=$row["events_header"];
	$date=$row["NICEDATE"];
	mysql_close($connection);

	include 'header.php';

	echo"\n<span class=\"head0\">$header</span><br>";
	echo"\n<span class=\"head1\">$date</span><p>";
	echo $row["events_detail"];

	include 'footer.php';
}
?>