<?php	//$timestamp=strtotime("2009-03-12 12:30:00");

$seatLimit=10;

function getScheduled($email, $eventId)
{
//REMOVE RECORD BY EMAIL
	require('config.php');
						  $db=mysql_connect($h, $u, $p);
						  mysql_select_db($d, $db);

$queryDates="SELECT * FROM scheduled WHERE email='".$email."' AND event_id='".$eventId."'";
$q=mysql_query($queryDates, $db) or die(mysql_error());
while($row=mysql_fetch_assoc($q))
	{
	$rows[]=$row;
	}
	return $rows;
}
//UNREG THE EMAIL AND ATTENDING
function unReg($email, $class)
{
	require('config.php');
						  $db=mysql_connect($h, $u, $p);
						  mysql_select_db($d, $db);

$queryDates="DELETE * FROM scheduled WHERE email='".$email."' AND event_id='".$class."';
$q=mysql_query($queryDates, $db) or die(mysql_error());

}

function addCount($event_id, $count)
{
	require('config.php');
						  $db=mysql_connect($h, $u, $p);
						  mysql_select_db($d, $db);

$queryDates="UPDATE events SET attending='".$count."'event_id='".$email."'";
$q=mysql_query($queryDates, $db) or die(mysql_error());
}
function seatsAvailable($event)
{

	require('config.php');
						  $db=mysql_connect($h, $u, $p);
						  mysql_select_db($d, $db);

$queryDates="SELECT * FROM events WHERE event_id='".$event."'";
$q=mysql_query($queryDates, $db) or die(mysql_error());

	while($row=mysql_fetch_assoc($q))
	{
	$count=$seatLimit+$row['attending'];
	}

$_SESSION['count']=$count;
}


function getEvents($cat)
{
	require('config.php');
						  $db=mysql_connect($h, $u, $p);
						  mysql_select_db($d, $db);

 	//CHECK ALL EVENT IDS AGAINST EVENTS TABLE IN DATES TABLE

	$events="SELECT * FROM events WHERE category_id='".$cat."'";
	$rowEvents=mysql_query($events, $db) or die(mysql_error());


	 	//FIND SELECTED COURSE DATE

	 		//SET DATE FORMAT
			$date=date("Y-m-d G:i:s");

				while ($eventId=mysql_fetch_array($rowEvents))
				{
				//GET ALL IDS FOR EVENTS WITHIN CAT
				$eventIds[]=$eventId['event_id'];
				}

					//GET EVENT IDS FOR EVENTS SEARCH
					$got=array();
					foreach ($eventIds as $event)
					{

							$queryDates="SELECT * FROM dates WHERE date>='".$date."' AND event_id='".$event."' ORDER BY date";

							$rowDates=mysql_query($queryDates, $db) or die(mysql_error());

							$got=mysql_fetch_assoc($rowDates);

							$gotId[$got['event_id']] = $got;





					}



					foreach($gotId as $id => $got)
						{

							if ($id)
							{

							$queryDates="SELECT * FROM events WHERE event_id='".$id."'";
							$q=mysql_query($queryDates, $db) or die(mysql_error());

								while($row=mysql_fetch_assoc($q))
								{
								$seatLimit=10;
										$seatsLeft=$seatLimit-$row['attending'];

										echo "<option value=".$got['event_id'].">".$row['title']."-:".$got['date']."-:(LEFT:".$seatsLeft.")</option><BR>";

								}
								$_SESSION['description']=$row['description'];

							}

						 }
						 return $row['date'];
}

function getDateById($eventId)
{

	require('config.php');
						  $db=mysql_connect($h, $u, $p);
						  mysql_select_db($d, $db);

$queryDates="SELECT date FROM dates WHERE event_id='".$eventId."'";
$q=mysql_query($queryDates, $db) or die(mysql_error());

	while ($event=mysql_fetch_assoc($q))
	{
		$formated=strtotime($event['date']);
		return date("m/d/y g:ia", $formated);
	}


}
function getEventById($eventId)
{

	require('config.php');
						  $db=mysql_connect($h, $u, $p);
						  mysql_select_db($d, $db);

$queryDates="SELECT title FROM events WHERE event_id='".$eventId."'";
$q=mysql_query($queryDates, $db) or die(mysql_error());

	while ($event=mysql_fetch_assoc($q))
	{
		$event=$event['title'];
		return $event;
	}
}

function checkReqEntry($entry)
{

	if(!$_POST[$entry])
	{
		return true;
	}
	else
	{
	echo $entry." HAS NOT BEEN SET";
	return false;
	}
}
?>