<?php
$thisCheckID	= 40;
include 'globalVars.php';

include 'header.php';

$usedArray	= array("1", "6");
?>

	<h3>Update the Main menu</h2>
	<p><span class="infoButton" style="margin:0 10px 0 0;"><img src="images/infoButton.png" width="14" height="14" alt="Help" title="Help" border="0" /></span> Drag the menu buttons from the right to the active menu on the left. To create the pages as part of the submenu, drag the button to slightly right of the top menu. You can have as many top level menu items as you choose</p>

	<div id="menuTitles">
		<h2>Current Main Menu</h2>
		<h3>Unused Menu Items</h3>
	</div>
	<div id="dd-Home" class="dd-handle">Home page</div>
	<div id="menuSetup">
		<div class="dd" id="nestable">
		<?php
		$subMenuQuery = mysqli_query($conn, "SELECT id, menuTitle FROM pages_en WHERE topMenu = '1' AND (id NOT IN('1','6')) ORDER BY menuOrder ASC");
		if (mysqli_num_rows($subMenuQuery) == 0) {
			?>
			<div class="dd-empty"></div>
			<?php
		} else {
			?>
			<ol class="dd-list">
			<?php			
			while ($sMQ = mysqli_fetch_array($subMenuQuery)) {
				$menuID			= $sMQ["id"];
				$menuTitle		= $sMQ["menuTitle"];
				$usedArray[]	= $menuID;
				?>
				<li class="dd-item" data-id="<?php echo $menuID ?>"><div class="dd-handle"><?php echo $menuTitle ?></div>
				<?php
				$subPagesQuery = mysqli_query($conn, "SELECT id, menuTitle FROM pages_en WHERE parentID = '$menuID' ORDER BY menuOrder ASC");
				if (mysqli_num_rows($subPagesQuery) != 0) {
					?>
					<ol class="dd-list">
					<?php
					while ($sPQ = mysqli_fetch_array($subPagesQuery)) {
						$subPageID		= $sPQ["id"];
						$subMenuTitle	= $sPQ["menuTitle"];
						$usedArray[]	= $subPageID;
						?>
						<li class="dd-item" data-id="<?php echo $subPageID ?>"><div class="dd-handle"><?php echo $subMenuTitle ?></div>
						<?php
						$subSubPagesQuery = mysqli_query($conn, "SELECT id, menuTitle FROM pages_en WHERE parentID = '$subPageID' ORDER BY menuOrder ASC");
						if (mysqli_num_rows($subSubPagesQuery) != 0) {
							?>
							<ol class="dd-list">
							<?php
							while ($ssPQ = mysqli_fetch_array($subSubPagesQuery)) {
								$subSubPageID		= $ssPQ["id"];
								$subSubMenuTitle	= $ssPQ["menuTitle"];
								$usedArray[]		= $subSubPageID;
								?>
								<li class="dd-item" data-id="<?php echo $subSubPageID ?>"><div class="dd-handle"><?php echo $subSubMenuTitle ?></div></li>
								<?php
							}
							?>
							</ol>
							<?php
						}
						?>
						</li>
						<?php
					}
					?>
					</ol>
					<?php
				}
				?>
				</li>
				<?php
			}
			?>
			</ol>
			<?php
		}
		?>
		</div>
		<div class="dd" id="unused">
	<?php
	$unusedList = implode("', '", $usedArray);
	$unusedPagesQuery = mysqli_query($conn, "SELECT id, menuTitle FROM pages_en WHERE id NOT IN('". $unusedList ."') AND (topMenu = '0') AND (placeHolder != '2') ORDER BY id ASC") or die (mysqli_error($conn));
	$unusedPages = mysqli_num_rows($unusedPagesQuery);
	if ($unusedPages > 0) {
		?>
			<ol class="dd-list">
			<?php
			
			while ($uPQ = mysqli_fetch_array($unusedPagesQuery)) {
				$pageID			= $uPQ["id"];
				$menuTitle		= $uPQ["menuTitle"];
				?>
				<li class="dd-item" data-id="<?php echo $pageID ?>"><div class="dd-handle"><?php echo $menuTitle ?></div></li>
				<?php
			}
			?>
			</ol>
		<?php
	} else {
		?>
			<div class="dd-empty"></div>
		<?php
	}
	?>
		</ol>
	</div>
	<div id="dd-Contact" class="dd-handle">Contact Us</div>

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