<?php

include 'db.php';
include 'error.php';


$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))
{
	include 'header.php';
	?>
			<span class="Head0">Become a Member of the ORS</span><p>
			<form name="becomeMember" action="become_member.php" method="post" onSubmit="return checkDetails(this);">

			<table border="0" width="100%" cellpadding="0" cellspacing="5">
			<tr><td width="220"></td><td width="240"></td></tr>
			<tr><td>Surname</td><td><input type="text" name="surname" size="20"></td></tr>

			<tr><td>First Name</td><td><input type="text" name="firstname" size="20"></td></tr>

			<tr><td>Years at King's Rochester</td><td><input type="text" name="years" size="20"></td></tr>

			<tr><td colspan="2">Other Details</td></tr>
			<tr><td colspan="2"><textarea name="other" rows="10" cols="45"></textarea></td></tr>

			
			<tr><td colspan="2" align="center"><input type="Submit" value="submit"></td></tr>
			</table></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);



}
?>

