<?php
include "globalVars.php";

$pageQuery = mysqli_query($conn, "SELECT * FROM pages_". $LANG_DB ." WHERE id = '20'");
while ($r = mysqli_fetch_array($pageQuery)) {
	$pageID				= $r["id"];
	$pageURL			= $r["pageURL"];
	$breadcrumbTitle	= $r["menuTitle"];
	$headerTitle		= $r["headerTitle"];
	$thisTM				= $r["topMenu"];
	$thisParentID		= $r["parentID"];
	$metaKey			= $r["metaKey"];
	$metaDesc			= $r["metaDesc"];
	$pageTitle			= $r["pageTitle"];
}

$thisPageID	= $pageID;

if ($thisParentID != 0) {
	$parentQuery = mysqli_query($conn, "SELECT parentID, pageURL, headerTitle, placeHolder FROM pages_". $LANG_DB ." WHERE id = '$thisParentID'");
	while ($paQ = mysqli_fetch_array($parentQuery)) {
		$thisGParentID	= $paQ["parentID"];
		$parentURL		= $paQ["pageURL"];
		$parentTitle	= $paQ["headerTitle"];
		$placeHolder	= $paQ["placeHolder"];
	}
}

$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, "[[LEAGUE_TABLE_BOX]]")) {
		$includeSlider	= true;
	}
	$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 ($thisParentID == 0) {
				?>
				<li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"><a href="<?php echo $url . $pageURL ?>" itemprop="item"><span itemprop="name"><?php echo $headerTitle ?></span></a><meta itemprop="position" content="2" /></li>
				<?php
			} else {
				if ($placeHolder == 0) {
					?>
				<li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"><a href="<?php echo $url . $parentURL ?>.html" itemprop="item"><span itemprop="name"><?php echo $parentTitle ?></span></a><meta itemprop="position" content="2" /></li>
					<?php
				} else {
					?>
				<li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"><a itemprop="item"><span itemprop="name"><?php echo $parentTitle ?></span></a><meta itemprop="position" content="2" /></li>
					<?php
				}
				?>
				<li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"><a href="<?php echo $url . $pageURL ?>" itemprop="item"><span itemprop="name"><?php echo $headerTitle ?></span></a><meta itemprop="position" content="3" /></li>
				<?php
			}
			?>
			</ol>
		</div>
	</div>

	<?php
	echo $pageDisplay;
	?>

	<div class="mainContent b40">
		<div class="container">
			<div id="subscribeRow">
				<div id="subscribeForm">
					<input type="email" id="subEmail" placeholder="<?php echo $LANG_EVENT_SUBSCRIBE_EMAIL ?>">
					<button type="button" id="subNotiList"><?php echo $LANG_EVENT_SUBSCRIBE_SUBMIT ?></button>
				</div>
			</div>
		</div>
	</div>

	<?php
	$regDateToday		= date("Y-m-d");

	$forthcomingEventsRegQuery = mysqli_query($conn, "SELECT * FROM forthcomingEvents WHERE eventStartDate >= '$regDateToday' ORDER BY regEndDate ASC");
	if (mysqli_num_rows($forthcomingEventsRegQuery) == 0) {
		?>
	<div class="mainContent tb40">
		<div class="container">
			<div class="textRow">
				<p><?php echo $LANG_EVENTS_NONE_SET ?></p>
			</div>
		</div>
	</div>
		<?php
	} else {
		?>
	<div class="mainContent tb40">
		<div class="container">
			<div class="textRow">
			<?php
			while ($fERQ = mysqli_fetch_array($forthcomingEventsRegQuery)) {
				$eventURL		= $fERQ["pageURL"];
				$eventTitle		= $fERQ["eventTitle"];
				$eventType		= $fERQ["eventType"];
				$eventRegType	= $fERQ["eventRegType"];
				$eventLocation	= $fERQ["eventLocation"];
				if (trim($eventLocation) != "") {
					$eventTitle	.= " $LANG_EVENTS_AT $eventLocation";
				}
				$eventDate		= date("jS F, Y", strtotime($fERQ["eventStartDate"]));
				$regStartDate	= $fERQ["regStartDate"];
				$regEndDate		= $fERQ["regEndDate"];
				$regStartDisp	= date("jS F", strtotime($regStartDate));
				$regEndDisp		= date("jS F, Y", strtotime($regEndDate));
				if ($eventType == 1) {
					$eventIntro	= $LANG_EVENT_STARTS_TOURNEY_DATE;
				} else {
					$eventIntro	= $LANG_EVENT_STARTS_LEAGUE_DATE;
				}
				switch($eventRegType) {
					case "1":
					$eventRegType	= $LANG_EVENTS_SOLOS;
					break;
					case "2":
					$eventRegType	= $LANG_EVENTS_PAIRS;
					break;
					case "3":
					$eventRegType	= $LANG_EVENTS_TRIPLES;
					break;
					case "4":
					$eventRegType	= $LANG_EVENTS_TEAMS;
					break;
				}
				if ($regStartDate > $regDateToday) {
					$regDatesText	= str_replace(array("[[REG_OPEN_DATE]]", "[[REG_CLOSE_DATE]]"), array("<strong>$regStartDisp</strong>", "<strong>$regEndDisp</strong>"), $LANG_EVENT_REG_OPEN_DATES);
				} elseif ($regEndDate < $regDateToday) {
					$regDatesText	= $LANG_EVENT_REG_CLOSED;
				} else {
					$regDatesText	= str_replace("[[REG_CLOSE_DATE]]", "<strong>$regEndDisp</strong>", $LANG_EVENT_REG_OPEN_TO_DATE);
				}
				$eventIntro	.= " $eventDate ". str_replace("[[EVENT_FORMAT]]", "<strong>$eventRegType</strong>", $LANG_EVENT_FORMAT);
				?>
				<div class="eventsContainer<?php if ( ($regDateToday >= $regStartDate) && ($regDateToday <= $regEndDate) ) {?> currentEvent<?php } ?>">
					<h3><a href="<?php echo $url . $LANG_MENU_EVENTS_URL . "/". $eventURL ?>"><?php echo $eventTitle ?></a></h3>
					<p><?php echo $eventIntro ?></p>
					<p><?php echo $regDatesText ?></p>
					<?php
					if ( ($regDateToday >= $regStartDate) && ($regDateToday <= $regEndDate) ) {
						?>
					<a href="<?php echo $url . $LANG_MENU_EVENTS_URL . "/". $eventURL ?>" class="registerForEvent"><?php echo $LANG_EVENTS_REG_BTN_TITLE ?></a>
						<?php
					}
					?>
				</div>
				<?php
			}
			?>
			</div>
		</div>
	</div>
		<?php
	}
	?>

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