<?php
include 'globalVars.php';

if (isset($_GET["galleryURL"])) {
	$galleryURL		= cleanPost($_GET["galleryURL"], $conn);
} else {
	$galleryURL		= "";
}
$thisParentID = 7;
$pageQuery = mysqli_query($conn, "SELECT * FROM pages_". $LANG_DB ." WHERE id = '7'");
while ($r = mysqli_fetch_array($pageQuery)) {
	$pageID			= $r["id"];
	$parentID		= $r["parentID"];
	$pageURL		= $r["pageURL"];
	$headerTitle	= $r["headerTitle"];
	$metaKey		= $r["metaKey"];
	$metaDesc		= $r["metaDesc"];
	$pageTitle		= $r["pageTitle"];
}
if (isset($_GET["galleryURL"])) {
	$galleryCatsQuery = mysqli_query($conn, "SELECT * FROM photoGalleryCats WHERE pageURL = '$galleryURL'");
	while ($gCQ = mysqli_fetch_array($galleryCatsQuery)) {
		$catID			= $gCQ["id"];
		$catTitle		= $gCQ["catTitle"];
		$headerTitle	= $catTitle ." ". $LANG_PHOTO_GALLERY;
		$pageTitle		= $catTitle ." ". $LANG_PHOTO_GALLERY;
	}
}
			
$pageDisplay	= "";
$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"];
	if (strstr($moduleContent, "[[MAP]]")) {
		$showMap	= true;
	}
	if (strstr($moduleContent, "[[WEATHER_BOX]]")) {
		$showWeather	= true;
	}
	$moduleContent	= moduleReplace($moduleContent, $LANG_DB, $LANG_DEFAULT_EMAIL, $url, $Iurl, $LANG_MENU_FOOD_MENU_URL, $LANG_MENU_DRINKS_MENU_URL);

	$pageDisplay	.= $moduleContent;
}
include 'header.php';

if (isset($_GET["galleryURL"])) {
	?>
	<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>
				<li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"><a href="<?php echo $url . $LANG_MENU_GALLERY_URL ?>" itemprop="item"><span itemprop="name"><?php echo $LANG_MENU_GALLERY_TITLE ?></span></a><meta itemprop="position" content="2" /></li>
				<li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"><a href="<?php echo $url . $LANG_MENU_GALLERY_URL ."/". $galleryURL ?>" itemprop="item"><span itemprop="name"><?php echo $catTitle ?></span></a><meta itemprop="position" content="3" /></li>
			</ol>
		</div>
	</div>

	<div class="mainContent tb40">
		<div class="container">
			<div class="pGallery" id="pGallery">
			<?php
			$photoGalleryQuery = mysqli_query($conn, "SELECT * FROM photoGallery WHERE galleryID = '$catID' ORDER BY RAND()");
			while ($pGQ = mysqli_fetch_array($photoGalleryQuery)) {
				$photoID	= $pGQ["id"];
				$photoURL	= substr_replace($pGQ["imageURL"], "-thumb", "-4", 0);
				$photoTitle	= $pGQ["imageTitle"];
				?>
				<div class="galleryPhoto">
					<img src="<?php echo $Iurl ?>gallery/<?php echo $photoURL ?>" width="200" alt="<?php echo $photoTitle ?>" title="<?php echo $photoTitle ?>" data-pid="<?php echo $photoID ?>">
				<?php
				if (trim($photoTitle) != "") {
					?>
					<div class="galleryPhotoTitle"><?php echo $photoTitle ?></div>
					<?php
				}
				?>
				</div>
				<?php
			}
			?>
			</div>
		</div>
	</div>
	<?php
} else {
	?>
	<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>
				<li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"><a href="<?php echo $url . $LANG_MENU_GALLERY_URL ?>" itemprop="item"><span itemprop="name"><?php echo $LANG_MENU_GALLERY_TITLE ?></span></a><meta itemprop="position" content="2" /></li>
			</ol>
		</div>
	</div>
	<?php
	echo $pageDisplay ;
	?>
	<div class="mainContent tb40">
		<div class="container">
		<div class="boxRow galleryRow">
		<?php
		$galleryCatsQuery = mysqli_query($conn, "SELECT c.pageURL, c.catTitle, (SELECT imageURL FROM photoGallery WHERE galleryID = c.id ORDER BY RAND() LIMIT 0,1) AS coverImage FROM photoGalleryCats AS c LEFT JOIN photoGallery AS g ON c.id = g.galleryID GROUP BY c.catTitle HAVING COUNT(g.id) > 0 ORDER BY c.id DESC");
		while ($gCQ = mysqli_fetch_array($galleryCatsQuery)) {
			$catURL			= $gCQ["pageURL"];
			$catTitle		= $gCQ["catTitle"];
			$coverImageURL	=  substr_replace($gCQ["coverImage"], "-thumb", "-4", 0);
			?>
			<div class="fourBox">
				<div class="photoGalleryBox">
					<a href="<?php echo $url . $LANG_MENU_GALLERY_URL ."/". $catURL ?>">
						<img src="<?php echo $Iurl ?>gallery/<?php echo $coverImageURL ?>" width="300" alt="<?php echo $catTitle ?>" title="<?php echo $catTitle ?>"></a>
					</a>
				</div>
				<div class="photoGalleryTitle"><a href="<?php echo $url . $LANG_MENU_GALLERY_URL ."/". $catURL ?>"><?php echo $catTitle ?></a></div>
			</div>
			<?php
		}
		?>
		</div>
	</div>
	<?php
}
?>
<?php
include 'footer.php';
?>