<?php
$thisCheckID	= 43;
include "globalVars.php";

if (!isset($_POST["eventID"])) {
	header("Location:/admin/knockoutEdit.html");
} else {
	$eventID	= $_POST["eventID"];
	$eventQuery = mysqli_query($conn, "SELECT eventRegType FROM forthcomingEvents WHERE id = '$eventID'");
	while ($eQ = mysqli_fetch_array($eventQuery)) {
		$eventRegType	= $eQ["eventRegType"];
	}
	if ($eventRegType == 1) {
		$submitBtnType	= "Bowlers";
	} elseif ($eventRegType == 2) {
		$submitBtnType	= "Pairs";
	} elseif ($eventRegType == 3) {
		$submitBtnType	= "Triples";
	} elseif ($eventRegType == 4) {
		$submitBtnType	= "Teams";
	}
}

include "header.php";
?>

				<h2>Update an Event for Registration - Event Details</h2>

				<div class="formContainer">
					<div class="functionButtons">
						<form action="forthcomingEdit-1.html" method="post">
							<input type="hidden" name="eventID" value="<?php echo $eventID ?>" />
							<input type="submit" class="functionSelected" name="getEvent" value="Event Details" />
						</form>
					<?php
					if (in_array("45", $adminPriv)) {
						?>
						<form action="forthcomingEdit-2.html" method="post">
							<input type="hidden" name="eventID" value="<?php echo $eventID ?>" />
							<input type="submit" name="getEvent" value="Registered <?php echo $submitBtnType ?>" />
						</form>
						<?php
					}
					?>
					</div>
				</div>

<?php
if (isset($_POST["updateEvent"])) {
	$eventType		= cleanPost($_POST["eventType"], $conn);
	$eventRegType	= cleanPost($_POST["eventRegType"], $conn);
	$eventTitle		= cleanPost($_POST["eventTitle"], $conn);
	$eventLocation	= cleanPost($_POST["eventLocation"], $conn);

	$eventStartDate	= cleanPost($_POST["eventStartDate"], $conn);
	list($startDay, $startMonth, $startYear)	= explode("/", $eventStartDate);
	$eventStartDate	= $startYear ."-". $startMonth ."-". $startDay;

	$regStartDate	= cleanPost($_POST["regStartDate"], $conn);
	list($regStartDay, $regStartMonth, $regStartYear)	= explode("/", $regStartDate);
	$regStartDate	= $regStartYear ."-". $regStartMonth ."-". $regStartDay;

	$regEndDate		= cleanPost($_POST["regEndDate"], $conn);
	list($regEndDay, $regEndMonth, $regEndYear)	= explode("/", $regEndDate);
	$regEndDate		= $regEndYear ."-". $regEndMonth ."-". $regEndDay;

	$eventText		= $_POST["eventText"];

	mysqli_query($conn, "UPDATE forthcomingEvents SET eventTitle = '". addslashes($eventTitle) ."', eventType = '$eventType', eventRegType = '$eventRegType', eventLocation = '". addslashes($eventLocation) ."', eventStartDate = '$eventStartDate', regStartDate = '$regStartDate', regEndDate = '$regEndDate', eventText = '". addslashes($eventText) ."' WHERE id = '$eventID'") or die (mysqli_error($conn));

	$trackDate		= date("Y-m-d H:i:s");
	mysqli_query($conn, "INSERT INTO userActions (dateCreated, adminID, pageTracking, databaseUpdated, updateDetails) VALUES ('$trackDate', '$adminID', 'admin/forthcomingEdit-1.html', 'forthcomingEvents', 'The User ". addslashes($adminName) ." &lt;$adminEmail&gt; updated the event ID: $eventID (". addslashes($eventTitle) .") for registration')");

	echo "<p><strong>Success!</strong> The Event $eventTitle has been updated.</p>";

}
if (isset($_POST["eventID"])) {
	$eventID	= $_POST["eventID"];

	$eventQuery = mysqli_query($conn, "SELECT * FROM forthcomingEvents WHERE id = '$eventID'");
	while ($eQ = mysqli_fetch_array($eventQuery)) {
		$eventTitle		= $eQ["eventTitle"];
		$eventType		= $eQ["eventType"];
		$eventRegType	= $eQ["eventRegType"];
		$eventLocation	= $eQ["eventLocation"];
		$eventStartDate	= date("d/m/Y", strtotime($eQ["eventStartDate"]));
		$regStartDate	= date("d/m/Y", strtotime($eQ["regStartDate"]));
		$regEndDate		= date("d/m/Y", strtotime($eQ["regEndDate"]));
		$eventText		= $eQ["eventText"];
	}
	?>
    <form action="forthcomingEdit-1.html" method="post" style="float:left; clear:both;">
		<input type="hidden" name="eventID" value="<?php echo $eventID ?>" />
		<div class="descStTab">
			<div class="pFormRow">
				<div class="pFormTitle">League or Tournament?:</div>
				<div class="pFormSelect">
					<select name="eventType" required>
						<option value="1"<?php if ($eventType == 1) {?> selected<?php } ?>>Tournament</option>
						<option value="2"<?php if ($eventType == 2) {?> selected<?php } ?>>League</option>
					</select>
					<div class="pFormLabel">
						<label class="labelName">League or Tournament?:</label>
					</div>
				</div>
			</div>
			<div class="pFormRow">
				<div class="pFormTitle">Registration Type: <span class="infoButton"><img src="images/infoButton.png" width="14" height="14" alt="Help" title="Help" border="0" /><span>This will be used in the registration page to show the correct number of registration boxes (1 per person / team)</span></span></div>
				<div class="pFormSelect">
					<select name="eventRegType" required>
						<option value="1"<?php if ($eventRegType == 1) {?> selected<?php } ?>>Solo</option>
						<option value="2"<?php if ($eventRegType == 2) {?> selected<?php } ?>>Pair</option>
						<option value="3"<?php if ($eventRegType == 3) {?> selected<?php } ?>>Triples</option>
						<option value="4"<?php if ($eventRegType == 4) {?> selected<?php } ?>>Team</option>
					</select>
					<div class="pFormLabel">
						<label class="labelName">Registration Type:</label>
					</div>
				</div>
			</div>
			<div class="pFormRow">
				<div class="pFormTitle">Event Title: <span class="infoButton"><img src="images/infoButton.png" width="14" height="14" alt="Help" title="Help" border="0" /><span>This should explain exactly what the event is (eg: Mixed Pairs Autumn Knockout Tournament <?php echo date("Y") ?> / Winter Teams League <?php echo date("Y") ?>)</span></span></div>
				<div class="pFormInput">
					<input type="text" name="eventTitle" size="50" value="<?php echo $eventTitle ?>" />
					<div class="pFormLabel">
						<label class="labelName">Event Title:</label>
					</div>
				</div>
			</div>
			<div class="pFormRow">
				<div class="pFormTitle">Event Location:</div>
				<div class="pFormInput">
					<input type="text" name="eventLocation" size="50" value="<?php echo $eventLocation ?>" />
					<div class="pFormLabel">
						<label class="labelName">Event Location:</label>
					</div>
				</div>
			</div>
			<div class="pFormRow">
				<div class="pFormTitle">Tournament / League Start Date</div>
				<div class="pFormInput">
					<input type="text" name="eventStartDate" id="eventStartDate" size="50" value="<?php echo $eventStartDate ?>" required />
					<div class="pFormLabel">
						<label class="labelName">Tournament/ League Start Date:</label>
					</div>
				</div>
			</div>
			<div class="pFormRow">
				<div class="pFormTitle">Registration Start Date</div>
				<div class="pFormInput">
					<input type="text" name="regStartDate" id="regStartDate" size="50" value="<?php echo $regStartDate ?>" required />
					<div class="pFormLabel">
						<label class="labelName">Registration Start Date:</label>
					</div>
				</div>
			</div>
			<div class="pFormRow">
				<div class="pFormTitle">Registration End Date</div>
				<div class="pFormInput">
					<input type="text" name="regEndDate" id="regEndDate" size="50" value="<?php echo $regEndDate ?>" required />
					<div class="pFormLabel">
						<label class="labelName">Registration End Date:</label>
					</div>
				</div>
			</div>
			<div class="pFormRow pFormTxtRow">
				<div class="pFormTitle">Text about the Event: <span class="infoButton"><img src="images/infoButton.png" width="14" height="14" alt="Help" title="Help" border="0" /><span>This should be detailed information about the event and will appear on the registration page above the form the bowlers will use to register for the event</span></span></div>
				<div id="eventText" class="tinyTxtEditor"><?php echo $eventText ?></div>
				<div class="pFormLabel">
					<label class="labelName">Text about the Event:</label>
				</div>
			</div>
		</div>
		<input type="submit" class="submitButton" name="updateEvent" value="Update this Event" />
	</form>
	<?php
}
?>

<?php
include "footer.php";
?>