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

include "header.php";
?>

				<h2>Delete a Championship Winner</h2>

<?php
if (isset($_POST["deleteWinner"])) {
	$honourID	= $_POST["honourID"];

	$honourQuery = mysqli_query($conn, "SELECT * FROM honours WHERE id = '$honourID'");
	while ($hQ = mysqli_fetch_array($honourQuery)) {
		$honourGroup	= $hQ["groupType"];
		$honourYear		= $hQ["honourYear"];
		$honourLocation	= $hQ["honourLocation"];
		$honourWinner	= $hQ["honourWinner"];
	}

	mysqli_query($conn, "DELETE FROM honours WHERE id = '$honourID'") or die (mysqli_error($conn));

	$groupQuery = mysqli_query($conn, "SELECT groupTitle FROM honoursGroups WHERE id = '$honourGroup'");
	while ($gQ = mysqli_fetch_array($groupQuery)) {
		$groupTitle		= $gQ["groupTitle"];
	}

	$trackDate		= date("Y-m-d H:i:s");
	mysqli_query($conn, "INSERT INTO userActions (dateCreated, adminID, pageTracking, databaseUpdated, updateDetails) VALUES ('$trackDate', '$adminID', 'admin/honoursDel.html', 'leagueConfig', 'The User ". addslashes($adminName) ." &lt;$adminEmail&gt; deleted the ". addslashes($groupTitle) ." Winner ". addslashes($honourWinner) ." for $honourYear')");


	echo "<p><strong>Success!</strong> The Championship Winner $honourWinner for $honourYear has been removed.</p>";

} elseif (isset($_POST["getWinner"])) {
	$honourID	= $_POST["honourID"];

	$honourQuery = mysqli_query($conn, "SELECT * FROM honours WHERE id = '$honourID'");
	while ($hQ = mysqli_fetch_array($honourQuery)) {
		$honourGroup	= $hQ["groupType"];
		$honourYear		= $hQ["honourYear"];
		$honourLocation	= $hQ["honourLocation"];
		$honourWinner	= $hQ["honourWinner"];
	}
	$groupQuery = mysqli_query($conn, "SELECT * FROM honoursGroups WHERE id = '$honourGroup'");
	while ($gQ = mysqli_fetch_array($groupQuery)) {
		$groupName	= $gQ["groupTitle"];
	}
	?>
	<a class="pagesBack" href="honoursEdit.html">Back to Honours List</a>
    <form action="honoursDel.html" method="post" style="float:left; clear:both;">
		<input type="hidden" name="honourID" value="<?php echo $honourID ?>">
		<div class="descStTab">
			<div class="pFormRow">
				<div class="pFormTitle">Tournament Group:</div>
				<div class="pFormInput">
					<input type="text" name="groupType" size="50" value="<?php echo $groupName ?>" readonly />
					<div class="pFormLabel">
						<label class="labelName">Tournament Group:</label>
					</div>
				</div>
			</div>
			<div class="pFormRow">
				<div class="pFormTitle">Tournament Year:</div>
				<div class="pFormInput">
					<input type="text" name="honourYear" size="50" value="<?php echo $honourYear ?>" readonly />
					<div class="pFormLabel">
						<label class="labelName">Tournament Year:</label>
					</div>
				</div>
			</div>
			<div class="pFormRow">
				<div class="pFormTitle">Tournament Location:</div>
				<div class="pFormInput">
					<input type="text" name="honourLocation" size="50" value="<?php echo $honourLocation ?>" readonly />
					<div class="pFormLabel">
						<label class="labelName">Tournament Location:</label>
					</div>
				</div>
			</div>
			<div class="pFormRow">
				<div class="pFormTitle">Winner Name:</div>
				<div class="pFormInput">
					<input type="text" name="honourWinner" size="50" value="<?php echo $honourWinner ?>" readonly />
					<div class="pFormLabel">
						<label class="labelName">Winner Name:</label>
					</div>
				</div>
			</div>
		</div>
		<input type="submit" class="submitButton" name="deleteWinner" value="Delete Winner" />
	</form>
	<?php
} else {
	header("Location: /admin/honoursEdit.html");
}
?>



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