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

if (isset($_POST["leagueID"])) {
	$leagueID	= $_POST["leagueID"];
} else {
	header("Location: /admin/leagueEdit.html");
}

include "header.php";
?>
				<h2>Update a League - Page Content</h2>

<?php
$leagueURLQuery = mysqli_query($conn, "SELECT pageURL, leagueType, hasPlayoff FROM leagueConfig WHERE id = '$leagueID'");
while ($lUQ = mysqli_fetch_array($leagueURLQuery)) {
	$leagueURL	= $lUQ["pageURL"];
	$leagueType	= $lUQ["leagueType"];
	$hasPlayoff	= $lUQ["hasPlayoff"];
}
$leagueTypeURLQuery = mysqli_query($conn, "SELECT pageURL FROM leagueGroups WHERE id = '$leagueType'");
while ($lTQ = mysqli_fetch_array($leagueTypeURLQuery)) {
	$leagueTypeURL	= $lTQ["pageURL"];
}
?>

				<div class="formContainer">
					<div class="functionButtons">
						<form action="leagueEdit-1.html" method="post">
							<input type="hidden" name="leagueID" value="<?php echo $leagueID ?>" />
							<input type="submit" name="getLeague" value="Basic Details" />
						</form>
						<form action="leagueEdit-2.html" method="post">
							<input type="hidden" name="leagueID" value="<?php echo $leagueID ?>" />
							<input type="submit" name="getLeague" value="Fixtures" />
						</form>
						<?php
						if ($hasPlayoff > 0) {
							?>
						<form action="leagueEdit-2-playoffs.html" method="post">
							<input type="hidden" name="leagueID" value="<?php echo $leagueID ?>" />
							<input type="submit" name="getLeague" value="Playoffs" />
						</form>
							<?php
						}
						?>
						<form action="leagueEdit-3.html" method="post">
							<input type="hidden" name="leagueID" value="<?php echo $leagueID ?>" />
							<input type="submit" class="functionSelected" name="getLeague" value="Page Content" />
						</form>
					</div>
				</div>

<?php
if (isset($_POST["saveIntro"])) {
	$leagueText	= $_POST["leagueText"];

	mysqli_query($conn, "UPDATE leagueConfig SET leagueText = '". addslashes($leagueText) ."' WHERE id = '$leagueID'");

	$leagueQuery = mysqli_query($conn, "SELECT * FROM leagueConfig WHERE id = '$leagueID'");
	while ($lQ = mysqli_fetch_array($leagueQuery)) {
		$leagueType			= $lQ["leagueType"];
		$lFullSDate			= $lQ["startDate"];
		$lStartMonth		= date("F", strtotime($lFullSDate));
		$lStartYear			= date("Y", strtotime($lFullSDate));
		$leagueStartDate	= "$lStartMonth $lStartYear";
	}
	$leagueIDQuery = mysqli_query($conn, "SELECT groupTitle FROM leagueGroups WHERE id = '$leagueType'");
	while ($lIQ = mysqli_fetch_array($leagueIDQuery)) {
		$groupTitle		= $lIQ["groupTitle"];
	}

	$trackDate		= date("Y-m-d H:i:s");
	$trackTitle		= "$groupTitle $leagueStartDate";
	mysqli_query($conn, "INSERT INTO userActions (dateCreated, adminID, pageTracking, databaseUpdated, updateDetails) VALUES ('$trackDate', '$adminID', 'admin/leagueEdit-3.html', 'leagueConfig', 'The User ". addslashes($adminName) ." &lt;$adminEmail&gt; updated the page text of the league ID: $leagueID (". addslashes($trackTitle) .")')");

	echo "<p><strong>The changes to this league page have been saved.</strong></p>";
}

$leagueTextQuery = mysqli_query($conn, "SELECT leagueText FROM leagueConfig WHERE id = '$leagueID'");
while ($lTQ = mysqli_fetch_array($leagueTextQuery)) {
	$leagueText	= $lTQ["leagueText"];
}
if (isset($_POST["finalised"])) {
	?>
	<p>The fixtures for this league have now been saved. You can download them as a PDF to send in emails or print</p>
	<a href="/pdf/<?php echo $leagueTypeURL ?>-<?php echo $leagueURL ?>-league-fixtures.pdf" class="submitButton" target="_blank">Print League Fixtures</a>
	<?php	
}
?>
    <form action="leagueEdit-3.html" method="post">
		<input type="hidden" name="leagueID" value="<?php echo $leagueID ?>" />
		<div class="descStTab">
			<div class="pFormRow pFormTxtRow">
				<div class="pFormTitle">League Introduction:</div>
			</div>
			<div class="pFormRow pFormTxtRow">
				<div id="leagueText" class="tinyTxtEditor"><?php echo $leagueText ?></div>
				<div class="pFormLabel">
					<label class="labelName">League Introduction:</label>
				</div>
			</div>
		</div>
		<input type="submit" class="submitButton" name="saveIntro" value="Save League Introduction" />
	</form>

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