<?php
include "globalVars.php";

$thisParentID	= 2;

if (isset($_GET["calendarURL"])) {
	$pageURL	= $_GET["calendarURL"];

	$calendarQuery = mysqli_query($conn, "SELECT * FROM calendars WHERE pageURL = '$pageURL'");
	while ($cQ = mysqli_fetch_array($calendarQuery)) {
		$thisPageID		= $cQ["id"];
		$calendarID		= $thisPageID;
		$calendarName	= $cQ["calendarName"];
		$calendarURL	= $cQ["calendarURL"];
	}
	$headerTitle	= "$calendarName $LANG_CALENDAR";

} else {
	$pageURL	= "";
	$thisPageID	= 2;
	$calendarID	= 1;

	$calendarQuery = mysqli_query($conn, "SELECT * FROM calendars WHERE id = '1'");
	while ($cQ = mysqli_fetch_array($calendarQuery)) {
		$calendarName	= $cQ["calendarName"];
		$calendarURL	= $cQ["calendarURL"];
	}
	$pageQuery = mysqli_query($conn, "SELECT * FROM pages_". $LANG_DB ." WHERE id = '2'");
	while ($r = mysqli_fetch_array($pageQuery)) {
		$headerTitle	= $r["headerTitle"];
	}
}
$pageTitle	= $headerTitle;

$pageQuery = mysqli_query($conn, "SELECT * FROM pages_". $LANG_DB ." WHERE id = '2'");
while ($r = mysqli_fetch_array($pageQuery)) {
	$pageID			= $r["id"];
	$parentURL		= $r["pageURL"];
	$parentID		= $r["parentID"];
	$pageMenuTitle	= $r["menuTitle"];
	$metaKey		= $r["metaKey"];
	$metaDesc		= $r["metaDesc"];
}
$calCount	= 2;
$pParentID	= 0;
if ($parentID != 0) {
	$parentQuery = mysqli_query($conn, "SELECT pageURL, parentID, noHTML, pageTitle FROM pages_". $LANG_DB ." WHERE id = '$parentID'");
	while ($paQ = mysqli_fetch_array($parentQuery)) {
		$pParentURL		= $paQ["pageURL"];
		$pParentID		= $paQ["parentID"];
		$pNoHTML		= $paQ["noHTML"];
		$pParentTitle	= $paQ["menuTitle"];
		if ($pNoHTML == 0) {
			$pParentURL	.= ".html";
		}
	}
	$calCount++;
	if ($pParentID != 0) {
		$parentParentQuery = mysqli_query($conn, "SELECT pageURL, noHTML, pageTitle FROM pages_". $LANG_DB ." WHERE id = '$pParentID'");
		while ($ppaQ = mysqli_fetch_array($parentParentQuery)) {
			$ppParentURL	= $ppaQ["pageURL"];
			$ppNoHTML		= $ppaQ["noHTML"];
			$ppParentTitle	= $ppaQ["menuTitle"];
			if ($ppNoHTML == 0) {
				$ppParentURL	.= ".html";
			}
		}
		$calCount++;
	}
}

$pageDisplay	= "";

if (!isset($_GET["calendarURL"])) {
	$pageContentQuery = mysqli_query($conn, "SELECT moduleContent FROM pagesModules_". $LANG_DB ." WHERE pageID = '$pageID' ORDER BY moduleOrder ASC");
	while ($pC = mysqli_fetch_array($pageContentQuery)) {
		$moduleContent	= $pC["moduleContent"];
		$moduleContent	= moduleReplace($moduleContent, $LANG_DB, $LANG_DEFAULT_EMAIL, $url, $Iurl);

		$pageDisplay	.= $moduleContent;
	}
}

include "header.php";
?>
	<div id="pageBreadcrumb">
		<div class="container">
			<ol id="pagesBreadcrumb" itemscope itemtype="http://schema.org/BreadcrumbList">
				<li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"><a href="<?php echo $url ?>" itemprop="item"><span itemprop="name"><i class="fa fa-home" aria-hidden="true" title="<?php echo $LANG_MENU_HOME_TITLE ?>"></i></span></a><meta itemprop="position" content="1" /></li>
			<?php
			if ($parentID != 0) {
				?>
				<li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"><a href="<?php echo $url . $pParentURL ?>" itemprop="item"><span itemprop="name"><?php echo $pParentTitle ?></span></a><meta itemprop="position" content="2" /></li>
				<?php
			}
			if ($pParentID != 0) {
				?>
				<li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"><a href="<?php echo $url . $ppParentURL ?>" itemprop="item"><span itemprop="name"><?php echo $ppParentTitle ?></span></a><meta itemprop="position" content="3" /></li>
				<?php
			}
			?>
				<li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"><a href="<?php echo $url . $parentURL ?>" itemprop="item"><span itemprop="name"><?php echo $pageMenuTitle ?></span></a><meta itemprop="position" content="<?php echo $calCount ?>" /></li>
			<?php
			if (isset($_GET["calendarURL"])) {
				?>
				<li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"><a href="<?php echo $url . $parentURL ."/". $pageURL ?>.html" itemprop="item"><span itemprop="name"><?php echo $calendarName ?></span></a><meta itemprop="position" content="<?php echo $calCount + 1 ?>" /></li>
				<?php
			}
			?>
			</ol>
		</div>
	</div>
<?php
	echo $pageDisplay;
?>
	<div class="mainContent pageBlock tb40">
		<div class="container">
			<div class="pageLeft">
				<iframe src="<?php echo $calendarURL ?>" scrolling="auto" title="<?php echo $calendarURL ?>" width="100%" height="650" frameborder="0"></iframe>
			</div>
			<div class="pageRight">
				<div class="pageLinks">
					<h3><?php echo $LANG_OTHER_CALENDARS ?></h3>
					<ul>
					<?php
					if (isset($_GET["calendarURL"])) {
						?>
						<li><a href="<?php echo $url . $parentURL ?>"><i class="far fa-calendar-alt"></i> <?php echo $LANG_MAIN_CALENDAR ?></a></li>
						<?php
					}
					$otherCalendarsQuery = mysqli_query($conn, "SELECT pageURL, calendarName FROM calendars WHERE id != '$calendarID' AND (id > '1') ORDER BY calendarName ASC");
					while ($oCQ = mysqli_fetch_array($otherCalendarsQuery)) {
						$otherURL	= $oCQ["pageURL"];
						$otherName	= $oCQ["calendarName"];
						?>
						<li><a href="<?php echo $url . $parentURL ."/". $otherURL ?>.html"><i class="far fa-calendar-alt"></i> <?php echo $otherName ?></a></li>
						<?php
					}
					?>
					</ul>
				</div>
			</div>
		</div>
	</div>

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