<?php
include "globalVars.php";

include "header.php";
?>
    <h2>Update a Video Background</h2>
<?php

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

	if (isset($_POST["updateExBG"])) {
		$photoTitleEN	= $_POST["videoTitle_en"];
		$pagesLock		= $_POST["pagesLock"];
		foreach($langURLArray as $dbLang) {
			$bgTitle	= str_replace($encBad, $encGood, $_POST["videoTitle_".$dbLang]);
			if (trim($bgTitle) == "") {
				$bgTitle	= $photoTitleEN;
			}

			mysqli_query($conn, "UPDATE pageBGTitle_". $dbLang ." SET bgTitle = '". addslashes($bgTitle) ."' WHERE id = '$bgID'") 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/pagesBGVideoNew.html', 'pageBG', 'The User ". addslashes($adminName) ." &lt;$adminEmail&gt; updated the background video ID: $bgID (". addslashes($photoTitleEN) .")')");
		?>
		<p>Success!! The background has been updated.</p>
		<?php
	}

	$bgVideoQuery = mysqli_query($conn, "SELECT * FROM pageBG WHERE id = '$bgID'");
	while ($bIQ = mysqli_fetch_array($bgVideoQuery)) {
		$bgVideo		= $bIQ["bgImage"];
		$pagesLock		= $bIQ["pagesLock"];
	}

	if (count($langArray) != 1) {
		?>
    <div id="langSelector">
		<?php
		foreach($langArray as $langArrayURL=>$langArrayDisplay) {
			?>
		<a id="<?php echo $langArrayURL ?>Selector"<?php if ($langArrayURL == "en") {?> class="selectedLang"<?php } ?>><?php echo $langArrayDisplay ?></a>
			<?php
		}
		?>
    </div>
		<?php
	}
	?>
    <form action="pagesBGVideoEdit.html" method="post">
        <input type="hidden" id="bgID" name="bgID" value="<?php echo $bgID ?>" />
		<?php
		foreach($langArray as $langTab=>$langDisplay) {
			$videoTitleQuery = mysqli_query($conn, "SELECT * FROM pageBGTitle_". $langTab ." WHERE id = '$bgID'");
			while ($vTQ = mysqli_fetch_array($videoTitleQuery)) {
				$videoTitle	= $vTQ["bgTitle"];
			}
			?>
		<div class="descTab" id="<?php echo $langTab ?>SelectorTab">
			<div class="pFormRow">
				<div class="pFormTitle"><?php echo $langDisplay ?> Video Title:</div>
				<div class="pFormInput">
					<input type="text" name="videoTitle_<?php echo $langTab ?>" id="videoTitle_<?php echo $langTab ?>" size="50" value="<?php echo $videoTitle ?>"<?php if ($langTab == "en") {?> required<?php } ?> />
					<div class="pFormLabel">
						<label class="labelName"><?php echo $langDisplay ?> Video Title:</label>
					</div>
				</div>
			</div>
		</div>
			<?php
		}
		?>
		<div class="descStTab">
			<div class="pFormRow">
				<div class="pFormTitle">Limit to one page:</div>
				<div class="pFormSelect">
					<select name="pagesLock">
						<option value="0"<?php if ($pagesLock == 0) {?> selected<?php } ?>>Show on all pages</option>
					<?php
					$pageQuery = mysqli_query($conn, "SELECT * FROM pages_en ORDER BY id ASC") or die (mysqli_error($conn));
					while ($pQ = mysqli_fetch_array($pageQuery)) {
						$pageID			= $pQ["id"];
						$pageName		= $pQ["menuTitle"];
						?>
						<option value="<?php echo $pageID ?>"<?php if ($pagesLock == $pageID) {?> selected<?php } ?>><?php echo $pageName ?></option>
						<?php
					}
					?>
					</select>
					<div class="pFormLabel">
						<label class="labelName">Limit to one page:</label>
					</div>
				</div>
			</div>
		</div>
		<div class="descImgBGTab" id="uploadedVideo">
			<video loop autoplay controlslist="nodownload" muted width="100%">
				<source type="video/mp4" src="<?php echo $url ?>images/pagesBG/<?php echo $bgVideo ?>">
			</video>
		</div>
		<input type="submit" class="submitButton" name="updateExBG" value="Save background" />
	</form>
	<?php
}
?>


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