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

if (isset($_POST["deleteT"])) {
	$deleteID	= $_POST["tID"];

	$tournamentBasicsQuery = mysqli_query($conn, "SELECT tournTitle, tournStartDate, tournLocation FROM knockoutConfig WHERE id = '$deleteID'");
	while ($sQ = mysqli_fetch_array($tournamentBasicsQuery)) {
		$tournTitle		= $sQ["tournTitle"];
		$tournStartDate	= $sQ["tournStartDate"];
		$tStartMonth	=  date("F", strtotime($tournStartDate));
		$tStartYear		=  date("Y", strtotime($tournStartDate));
		$tournLocation	= $sQ["tournLocation"];
	}
	if (trim($tournTitle) == "") {
		$tournTitle	= "$tournLocation $tStartMonth $tStartYear";
	}

	mysqli_query($conn, "DELETE FROM knockoutConfig WHERE id = '$deleteID'");
	mysqli_query($conn, "DELETE FROM knockoutRounds WHERE tournID = '$deleteID'");

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

} else {

	include 'header.php';
	?>

		<h2>Update a Tournament</h2>
		<table id="tournamentTable">
			<thead>
				<th>Start Date</th>
				<th>Title</th>
				<th>Location</th>
				<th>N&ordm; Competitors</th>
				<th>Group</th>
				<th>&nbsp;</th>
				<?php
				if (in_array("6", $adminPriv)) {
					?>
				<th>&nbsp;</th>
					<?php
				}
				?>
			</thead>
			<tbody>
			<?php
			$SQLquery = mysqli_query($conn, "SELECT id, tournType, tournTitle, tournStartDate, tournLocation, noCompetitors FROM knockoutConfig WHERE id > '0'");
			while ($sQ = mysqli_fetch_array($SQLquery)) {
				$tournID		= $sQ["id"];
				$tournType		= $sQ["tournType"];
				$tournTitle		= $sQ["tournTitle"];
				$tournStartDate	= $sQ["tournStartDate"];
				$tStartMonth	=  date("F", strtotime($tournStartDate));
				$tStartYear		=  date("Y", strtotime($tournStartDate));
				$startDisplay	= date("jS F, Y", strtotime($tournStartDate));
				$tournLocation	= $sQ["tournLocation"];
				$noCompetitors	= $sQ["noCompetitors"];
				if (trim($tournTitle) == "") {
					$tournTitle	= "$tournLocation $tStartMonth $tStartYear";
				}

				$tournamentIDQuery = mysqli_query($conn, "SELECT groupTitle FROM knockoutGroups WHERE id = '$tournType'");
				while ($tIQ = mysqli_fetch_array($tournamentIDQuery)) {
					$tournamentGroup	= $tIQ["groupTitle"];
				}
				?>
				<tr id="tournamentRow<?php echo $tournID ?>">
					<td><span class="tableDate"><?php echo $tournStartDate ?></span><?php echo $startDisplay ?></td>
					<td><?php echo $tournTitle ?></td>
					<td><?php echo $tournLocation ?></td>
					<td><?php echo $noCompetitors ?></td>
					<td><?php echo $tournamentGroup ?></td>
					<td class="tableBtns">
						<form action="knockoutEdit-1.html" method="post"><input type="hidden" name="tournID" value="<?php echo $tournID ?>" />
							<input type="submit" class="submitButton" name="getKTour" value="Edit">
						</form>
					</td>
				<?php
				if (in_array("6", $adminPriv)) {
					?>
					<td class="tableBtns">
						<input type="button" class="deleteButton" data-tid="<?php echo $tournID ?>" data-tt="<?php echo $tournTitle ?>" 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 Knockout Tournament <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';
}
?>