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

if (isset($_POST["deleteE"])) {
	$deleteID	= $_POST["eID"];

	$eventBasicsQuery = mysqli_query($conn, "SELECT eventTitle, eventStartDate, eventLocation FROM forthcomingEvents WHERE id = '$deleteID'");
	while ($sQ = mysqli_fetch_array($eventBasicsQuery)) {
		$eventTitle		= $sQ["eventTitle"];
		$eventStartDate	= $sQ["eventStartDate"];
		$tStartMonth	=  date("F", strtotime($tournStartDate));
		$tStartYear		=  date("Y", strtotime($tournStartDate));
		$eventLocation	= $sQ["eventLocation"];
	}

	mysqli_query($conn, "DELETE FROM forthcomingEvents WHERE id = '$deleteID'");
	mysqli_query($conn, "DELETE FROM forthcomingRegistrations WHERE eventID = '$deleteID'");

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

} else {

	include 'header.php';
	?>

		<h2>Update a Forthcoming Event</h2>
		<table id="forthcomingTable">
			<thead>
				<th>Start Date</th>
				<th>Title</th>
				<th>Location</th>
				<th>N&ordm; Registered</th>
				<th>Registration</th>
				<th>&nbsp;</th>
				<?php
				if (in_array("44", $adminPriv)) {
					?>
				<th>&nbsp;</th>
					<?php
				}
				?>
			</thead>
			<tbody>
			<?php
			$SQLquery = mysqli_query($conn, "SELECT * FROM forthcomingEvents WHERE id > '0'");
			while ($sQ = mysqli_fetch_array($SQLquery)) {
				$eventID		= $sQ["id"];
				$eventTitle		= $sQ["eventTitle"];
				$eventType		= $sQ["eventType"];
				$eventRegType	= $sQ["eventRegType"];
				$eventStartDate	= $sQ["eventStartDate"];
				$eStartMonth	= date("F", strtotime($eventStartDate));
				$eStartYear		= date("Y", strtotime($eventStartDate));
				$startDisplay	= date("jS M, Y", strtotime($eventStartDate));
				$regStartDate	= $sQ["regStartDate"];
				$regStartDisp	= date("d/m/Y", strtotime($regStartDate));
				$regEndDate		= $sQ["regEndDate"];
				$regEndDisp		= date("d/m/Y", strtotime($regEndDate));
				$eventLocation	= $sQ["eventLocation"];

				$noRegisteredQuery = mysqli_query($conn, "SELECT id FROM forthcomingRegistrations WHERE eventID = '$eventID'");
				$noRegistered	= mysqli_num_rows($noRegisteredQuery);
				if ($noRegistered == 1) {
					$addS	= false;
				} else {
					$addS	= true;
				}
				if ($eventRegType == 1) {
					$noRegistered	.= " Bowler";
				} elseif ($eventRegType == 2) {
					$noRegistered	.= " Pair";
				} elseif ($eventRegType == 3) {
					$noRegistered	.= " Triple";
				} elseif ($eventRegType == 4) {
					$noRegistered	.= " Team";
				}
				if ($addS == true) {
					$noRegistered	.= "s";
				}
				?>
				<tr id="eventRow<?php echo $eventID ?>">
					<td><span class="tableDate"><?php echo $eventStartDate ?></span><?php echo $startDisplay ?></td>
					<td><?php echo $eventTitle ?></td>
					<td><?php echo $eventLocation ?></td>
					<td><?php echo $noRegistered ?></td>
					<td><span class="tableDate"><?php echo $regEndDate ?></span><?php echo "$regStartDisp - $regEndDisp" ?></td>
					<td class="tableBtns">
						<form action="forthcomingEdit-1.html" method="post"><input type="hidden" name="eventID" value="<?php echo $eventID ?>" />
							<input type="submit" class="submitButton" name="getFEvent" value="Edit">
						</form>
					</td>
				<?php
				if (in_array("44", $adminPriv)) {
					?>
					<td class="tableBtns">
						<input type="button" class="deleteButton" data-tid="<?php echo $eventID ?>" data-tt="<?php echo $eventTitle ?>" value="Delete">
					</td>
					<?php
				}
				?>
				</tr>
				<?php
			}
			?>
			</tbody>
		</table>

<div id="deleteConfirmPop" class="deletePop">
	<div class="deletePopBG">
		<div class="deletePopContainer">
			<h4>Confirm Delete</h4>
			<p>Are you sure you want to delete the Event <span id="groupNameC"></span>?</p>
			<p class="deleteWarning">Warning, once you click to confirm the data will be removed completely and cannot be retrieved.</p>
			<input type="hidden" id="gidInputC" value="">
			<div class="pForm50">
				<button type="button" class="submitButton cancelDeleteC">No</button>
			</div>
			<div class="pForm50">
				<button type="button" id="confirmTDelete" class="deleteButton">Yes, Delete it</button>
			</div>
		</div>
	</div>
</div>
	<?php
	include 'footer.php';
}
?>