<?php

include_once 'connection.php';

#include 'html.php';

#Init DB Connections
$setDBH = createDBH();
$setNDBH = createNDBH();


$GLSLoginLink = '<div class="float-right"><a href="/GLSLogin/">Log In Here</a></div>';

$subheaderArray = [];
$menuArray = [];
$submenuArray = [];
$submenuDropNav = [];
$setImage = '';
$setColors = '';

/*
# Connection to database
$DBH = new PDO("mysql:host=$host;dbname=$db_name", $username, $password);
$DBH->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
*/
#Determines references for page
$idplayer = ( isset( $_GET['playerid'] ) && is_numeric( $_GET['playerid'] ) ) ? intval( $_GET['playerid'] ) : 0;
$idplayerassignment = ( isset( $_GET['playerteamid'] ) && is_numeric( $_GET['playerteamid'] ) ) ? intval( $_GET['playerteamid'] ) : 0;
$currentteam = ( isset( $_GET['teamid'] ) && is_numeric( $_GET['teamid'] ) ) ? intval( $_GET['teamid'] ) : 0;
$currentlevel = ( isset( $_GET['levelid'] ) && is_numeric( $_GET['levelid'] ) ) ? intval( $_GET['levelid'] ) : 0;
$currentdivision = ( isset( $_GET['divid'] ) ) ?  $_GET['divid'] : NULL;
$currentseason = ( isset( $_GET['seasonid'] ) && is_numeric( $_GET['seasonid'] ) ) ? intval( $_GET['seasonid'] ) : 0;
$currentsubseason = ( isset( $_GET['subseasonid'] ) && is_numeric( $_GET['subseasonid'] ) ) ? intval( $_GET['subseasonid'] ) : 0;
$currentgame = ( isset( $_GET['gameID'] ) && is_numeric( $_GET['gameID'] ) ) ? intval( $_GET['gameID'] ) : 0;
$currentnews = ( isset( $_GET['newsid'] ) && is_numeric( $_GET['newsid'] ) ) ? intval( $_GET['newsid'] ) : 0;
$currentblog =  ( isset( $_GET['blogid'] ) && is_numeric( $_GET['blogid'] ) ) ? intval( $_GET['blogid'] ) : 0;
$pageselect = ( isset( $_GET['pageselect'] ) && is_numeric( $_GET['pageselect'] ) ) ? intval( $_GET['pageselect'] ) : 0;
$currentfilter = ( isset( $_GET['currentfilter'] ) ) ?  $_GET['currentfilter'] : NULL;

#Sets an array incorporating current page variables for query, and a reset query to bring a page back to page 1
$Currentquery = array("teamid"=>$currentteam, "levelid"=>$currentlevel, "divid"=>$currentdivision, "seasonid"=>$currentseason,"subseasonid"=>$currentsubseason, "page"=>$pageselect, "filter"=>$currentfilter);

$Resetpage = array("teamid"=>$currentteam, "levelid"=>$currentlevel, "divid"=>$currentdivision, "seasonid"=>$currentseason,"subseasonid"=>$currentsubseason, "page"=>0, "filter"=>$currentfilter);
#print_r($Currentquery);

if ($currentnews != 0) {
	function NewsTarget($Newsid) {
		$pdoConnect = createNDBH();
		$NewsFetch = $pdoConnect->prepare('SELECT Target, Targetid, TargetDivision FROM newsdeliver WHERE NewsidRef = :idnews LIMIT 1');
		$NewsFetch->bindParam(':idnews', $Newsid, PDO::PARAM_INT);
		$NewsFetch->execute();
		$NewsSelected = $NewsFetch->fetch(PDO::FETCH_ASSOC);
	return $NewsSelected;
	}

	function getLevelID($seasonLevelID) {
		$setDBH = createDBH();

		$levelFetchSQL = 'SELECT SeasonLevels.idLevel, SeasonLevels.idSeason FROM SeasonLevels WHERE idSeasonLevel=:seasonlevelid LIMIT 1;';
		$fetchLevelID = $setDBH->prepare($levelFetchSQL);
		$fetchLevelID->bindParam(':seasonlevelid', $seasonLevelID, PDO::PARAM_INT);
		$fetchLevelID->execute();
		$getLevelID = $fetchLevelID->fetch(PDO::FETCH_ASSOC);

		return $getLevelID;
	}

	$getTarget = NewsTarget($currentnews);
	if ($getTarget['Target'] == 'game' || $getTarget['Target'] == 'preview') {$currentgame = $getTarget['Targetid'];}
	elseif ($getTarget['Target'] == 'team') {$currentteam = $getTarget['Targetid'];}
	elseif ($getTarget['Target'] == 'playerteam') {$idplayerassignment = $getTarget['Targetid'];}
	elseif ($getTarget['Target'] == 'player') {$idplayer = $getTarget['Targetid'];}
	elseif ($getTarget['Target'] == 'season') {$currentseason = $getTarget['Targetid'];}
	elseif ($getTarget['Target'] == 'level') {
		$targetData = getLevelID($getTarget['Targetid']);
		$currentseason = $targetData['idSeason'];
		$currentlevel = $targetData['idLevel'];
		if(!empty($getTarget['TargetDivision'])) {$currentdivision = $getTarget['TargetDivision'];}
	}
	elseif ($getTarget['Target'] == 'blog') {$currentblog = $getTarget['Targetid'];}
}

if ($idplayerassignment != 0)
{
	$playerheader = $setDBH->prepare('SELECT SeasonName, idSeason, PlayerNumber, PlayerLast, PlayerFirst, TeamName, playerassignment.idTeamAssignmentkey AS Teamid, idPlayerskey FROM playerassignment JOIN players ON playerassignment.idPlayerskey = players.idPlayers JOIN teamstatview ON playerassignment.idTeamAssignmentkey = teamstatview.idTeamAssignment WHERE playerassignment.idPlayerAssignment = :playerassignmentid LIMIT 1');
	$playerheader->bindParam(':playerassignmentid', $idplayerassignment, PDO::PARAM_INT);
	$playerheader->execute();
	$playerheadreturn = $playerheader->fetch(PDO::FETCH_ASSOC);
	$currentseason = $playerheadreturn['idSeason'];
	$playerteam = $playerheadreturn['Teamid'];
	$playerid = $playerheadreturn['idPlayerskey'];
	$subheaderArray[] = array('link'=>'/AHA/season?seasonid='.$playerheadreturn['idSeason'], 'text'=>$playerheadreturn['SeasonName']);
	$subheaderArray[] = array('link'=>'/AHA/team?teamid='.$playerheadreturn['Teamid'], 'text'=>$playerheadreturn['TeamName']);

	$subheader = '<a href = "teamid?teamid='.$playerheadreturn['Teamid'].'">'.$playerheadreturn['TeamName'].' Home</a>';
	$header = '# '.$playerheadreturn['PlayerNumber'].' '.$playerheadreturn['PlayerFirst'].' '.$playerheadreturn['PlayerLast'];
	#$ToplineHeader = ' -> <a href="season?seasonid='.$playerheadreturn['idSeason'].'">'.$playerheadreturn['SeasonName'].'</a>  -> <a href="teamid?teamid='.$playerteam.'">'.$subheader.'</a> -> <a href="playercard?playerteamid='.$idplayerassignment.'">'.$header.'</a>';
	$menuArray[] = array('link'=>'/AHA/team?teamid='.$playerheadreturn['Teamid'], 'text'=>$playerheadreturn['TeamName'].' Home');
	$menuArray[] = array('link'=>'/AHA/playercard?playerid='.$playerid, 'text'=>'Player History');
	
	$playercustom = $setNDBH->prepare('SELECT imagelocation FROM cssplayerassignment WHERE PlayertableRef = "playerassignment" AND PlayeridRef = :idplayer ORDER BY imageUpload DESC LIMIT 1');
	$playercustom->bindParam(':idplayer', $idplayerassignment, PDO::PARAM_INT);
	$playercustom->execute();
	$testexist = $playercustom->rowCount();
	if ($testexist > 0)
		{
			$getimage = $playercustom->fetch(PDO::FETCH_ASSOC);
			$setImage = $getimage['imagelocation'];
			#$headerimage = '<img class="imagePlayer" src="playerimages/'.$getimage['imagelocation'].'">';
		}

	#Adds Custom Team Logo
	$playerteamcustom = $setNDBH->prepare('SELECT cssCustom, imagelocation, colorPrimary, textColorPrimary, colorBanner, textColorBanner, colorSecondary, textColorSecondary, colorTertiary, textColorTertiary FROM cssteamassignment WHERE TeamtableRef = "teamassignment" AND TeamidRef = :idteam LIMIT 1');
	$playerteamcustom->bindParam(':idteam', $playerteam, PDO::PARAM_INT);
	$playerteamcustom->execute();
	$getCSScustom = $playerteamcustom->fetch(PDO::FETCH_ASSOC);

	if (empty($getCSScustom['cssCustom'])) {$setTheme = '';} else {$setTheme = $getCSScustom['cssCustom'];}

	$setColors = array(
		'customCSS' => $setTheme,
		'colorBanner' => $getCSScustom['colorBanner'] ?? '', 
		'textBanner' => $getCSScustom['textColorPrimary']?? '', 
		'colorPrimary' => $getCSScustom['colorPrimary']?? '', 
		'textPrimary' => $getCSScustom['textColorPrimary']?? '', 
		'colorSecondary' => $getCSScustom['colorSecondary']?? '', 
		'textSecondary' => $getCSScustom['textColorSecondary']?? '', 
		'colorTertiary' => $getCSScustom['colorTertiary']?? '', 
		'textTertiary' => $getCSScustom['textColorTertiary']?? '', 
	);	
}
elseif ($idplayer !=0) {
	$playerheader = $setDBH->prepare('SELECT PlayerLast, PlayerFirst, idPlayers FROM players WHERE players.idPlayers = :playerid LIMIT 1');
	$playerheader->bindParam(':playerid', $idplayer, PDO::PARAM_INT);
	$playerheader->execute();
	$playerheadreturn = $playerheader->fetch(PDO::FETCH_ASSOC);
	$headermenu = NULL;
	$header = $playerheadreturn['PlayerFirst'].' '.$playerheadreturn['PlayerLast'];
	$subheader = NULL;
	#$ToplineHeader = ' -> '.$header;
	$playercustom = $setNDBH->prepare('SELECT imagelocation FROM cssplayerassignment WHERE PlayertableRef = "player" AND PlayeridRef = :idplayer ORDER BY imageUpload DESC LIMIT 1');
	$playercustom->bindParam(':idplayer', $idplayer, PDO::PARAM_INT);
	$playercustom->execute();
	$testexist = $playercustom->rowCount();
	if ($testexist > 0)
		{
			$getimage = $playercustom->fetch(PDO::FETCH_ASSOC);
			$setImage = $getimage['imagelocation'];
			#$headerimage = '<img class="imagePlayer" src="playerimages/'.$getimage['imagelocation'].'">';
		}
}
elseif ($currentteam != 0) {
	$teamheader = $setDBH->prepare('SELECT idSeason, idTeamAssignment, idLevelSeason, Level, Division, idTeam, TeamName, SeasonName FROM teamstatview WHERE idTeamAssignment = :idteam AND ((teamStartDate IS NULL OR CURDATE() > teamStartDate) AND (teamEndDate IS NULL OR teamEndDate > curdate())) LIMIT 1');
	//$teamheader = $setDBH->prepare('SELECT idSeason, idTeamAssignment, idLevelSeason, Level, Division, idTeam, TeamName, SeasonName FROM teamstatview WHERE idTeamAssignment = :idteam ORDER BY SortOrder ASC LIMIT 1');
	$teamheader->bindParam(':idteam', $currentteam, PDO::PARAM_INT);
	$teamheader->execute();
	$teamheaderreturn = $teamheader->fetch(PDO::FETCH_ASSOC);
	$currentseason = $teamheaderreturn['idSeason'];
	$subheaderArray[] = array('link'=>'/AHA/season?seasonid='.$teamheaderreturn['idSeason'], 'text'=>$teamheaderreturn['SeasonName']);
	#$subheader = '<a href="season?seasonid='.$teamheaderreturn['idSeason'].'&levelid='.$teamheaderreturn['idLevelSeason'];
	if (!empty($teamheaderreturn['Division']))
	{
		$subheaderArray[] = array('link'=>'/AHA/season?seasonid='.$teamheaderreturn['idSeason'].'&levelid='.$teamheaderreturn['idLevelSeason'].'&divid='.$teamheaderreturn['Division'], 'text'=>$teamheaderreturn['Level'].' '.$teamheaderreturn['Division']);
		
		#$subheader .= '&divid='.$teamheaderreturn['Division'];
	} else {
		$subheaderArray[] = array('link'=>'/AHA/season?seasonid='.$teamheaderreturn['idSeason'].'&levelid='.$teamheaderreturn['idLevelSeason'], 'text'=>$teamheaderreturn['Level']);
	}
	#$subheader .= '">'.$teamheaderreturn['Level'].' '.$teamheaderreturn['Division'].'</a>';
	$header = $teamheaderreturn['TeamName'];
	if (empty($teamheaderreturn['Division']))
	{
		$ToplineHeader = ' -> <a href="season?seasonid='.$teamheaderreturn['idSeason'].'&levelid='.$teamheaderreturn['idLevelSeason'].'">'.$teamheaderreturn['Level'].'</a> -> '.$teamheaderreturn['TeamName'];
	}	else {
	$ToplineHeader = ' -> <a href="season?seasonid='.$teamheaderreturn['idSeason'].'&levelid='.$teamheaderreturn['idLevelSeason'].'">'.$teamheaderreturn['Level'].'</a> -> <a href="season?seasonid='.$teamheaderreturn['idSeason'].'&levelid='.$teamheaderreturn['idLevelSeason'].'&divid='.$teamheaderreturn['Division'].'">'.$teamheaderreturn['Division'].'</a> -> '.$teamheaderreturn['TeamName'];
		}
	$headermenu = '<ul>
					<li><a href="team?teamid='.$currentteam.'">Team Home</a></li>
					<li><a href="roster?teamid='.$currentteam.'">Roster</a></li>
					<li><a href="teamschedule?teamid='.$currentteam.'">Scores/Schedule</a></li>
					<li><a href="teamranking?teamid='.$currentteam.'">Team Rankings</a></li>
					<li><a href="teamstathistory?teamid='.$currentteam.'">Team Stats</a></li>
					<li><a href="rosterstats?teamid='.$currentteam.'">Player Stats</a></li>';

	$menuArray[] = array('link'=>'/AHA/team?teamid='.$currentteam, 'text'=>'Team Home');
	$menuArray[] = array('link'=>'/AHA/roster?teamid='.$currentteam, 'text'=>'Roster');
	$menuArray[] = array('link'=>'/AHA/teamschedule?teamid='.$currentteam, 'text'=>'Scores/Schedule');
	$menuArray[] = array('link'=>'/AHA/teamranking?teamid='.$currentteam, 'text'=>'Team Rankings');
	$menuArray[] = array('link'=>'/AHA/teamstats?teamid='.$currentteam, 'text'=>'Team Stats');
	$menuArray[] = array('link'=>'/AHA/rosterstats?teamid='.$currentteam, 'text'=>'Player Stats');

	#Adds Custom Team Links
	$linkcustom = $setDBH->prepare('SELECT LinkPath, LinkName FROM teamcustomlink WHERE TeamClassref = "teamassignment" AND TeamidRef = :idteam LIMIT 1');
	$linkcustom->bindParam(':idteam', $currentteam, PDO::PARAM_INT);
	$linkcustom->execute();				
	$countlinks = $linkcustom->rowCount();
	if ($countlinks > 0) {
		while ($getlink = $linkcustom->fetch(PDO::FETCH_ASSOC))
		{	$menuArray[] = array('link'=>$getlink['LinkPath'], 'text'=>$getlink['LinkName']);}
	}
	$headermenu .= '</ul>'; 
	
	#Adds Custom Team Logo
	$teamcustom = $setNDBH->prepare('SELECT cssCustom, imagelocation, colorPrimary, textColorPrimary, colorBanner, textColorBanner, colorSecondary, textColorSecondary, colorTertiary, textColorTertiary FROM cssteamassignment WHERE TeamtableRef = "teamassignment" AND TeamidRef = :idteam LIMIT 1');
	$teamcustom->bindParam(':idteam', $currentteam, PDO::PARAM_INT);
	$teamcustom->execute();
	$getcustom = $teamcustom->fetch(PDO::FETCH_ASSOC);
	if (!empty($getcustom['imagelocation'])) {
			$setImage = $getcustom['imagelocation'];
			#$headerimage = '<img src="teamimages/'.$getimage['imagelocation'].'">';			
	} else {
		$teamstandard = $setDBH->prepare('SELECT externalLargeImage FROM team JOIN teamassignment ON team.idTeam = teamassignment.idTeamkey WHERE idTeamAssignment = :idteam LIMIT 1');
		$teamstandard->bindParam(':idteam', $currentteam, PDO::PARAM_INT);
		$teamstandard->execute();
		$getAHAimage = $teamstandard->fetch(PDO::FETCH_ASSOC);
		
		if (!empty($getAHAimage['externalLargeImage'])) {
			$setImage = $getAHAimage['externalLargeImage'];	
			#$headerimage = '<img src="'.$getAHAimage['externalLargeImage'].'">';
		}
	}

	if (empty($getcustom['cssCustom'])) {$setTheme = '';} else {$setTheme = $getcustom['cssCustom'];}

	$setColors = array(
		'customCSS' => $setTheme,
		'colorBanner' => $getcustom['colorBanner'] ?? '', 
		'textBanner' => $getcustom['textColorPrimary']?? '', 
		'colorPrimary' => $getcustom['colorPrimary']?? '', 
		'textPrimary' => $getcustom['textColorPrimary']?? '', 
		'colorSecondary' => $getcustom['colorSecondary']?? '', 
		'textSecondary' => $getcustom['textColorSecondary']?? '', 
		'colorTertiary' => $getcustom['colorTertiary']?? '', 
		'textTertiary' => $getcustom['textColorTertiary']?? '', 
	);	

}	
elseif ($currentlevel != 0 AND !empty($currentdivision)) {
	$divisionheader = $setDBH->prepare('SELECT idSeason, SeasonName, idLevelSeason, Level, Division, idTeam, TeamName FROM teamstatview WHERE idSeason = :seasonid AND idLevelSeason = :idlevel AND Division = :div LIMIT 1');
	$divisionheader->bindParam(':idlevel', $currentlevel, PDO::PARAM_INT);
	$divisionheader->bindParam(':seasonid', $currentseason, PDO::PARAM_INT);
	$divisionheader->bindParam(':div', $currentdivision, PDO::PARAM_STR);
	$divisionheader->execute();
	$divisionheaderreturn = $divisionheader->fetch(PDO::FETCH_ASSOC);
	
	$subheaderArray[] = array('link'=>'/AHA/season?seasonid='.$divisionheaderreturn['idSeason'], 'text'=>$divisionheaderreturn['SeasonName']);
	$subheaderArray[] = array('link'=>'/AHA/season?seasonid='.$divisionheaderreturn['idSeason'].'&levelid='.$divisionheaderreturn['idLevelSeason'], 'text'=>$divisionheaderreturn['Level']);

	$divisionlistSQL = 'SELECT DISTINCT Division, SortPriority, idLevelSeason FROM teamstatview WHERE idSeason = :idSeason AND idLevelSeason = :idlevel AND Division <> "" GROUP BY SortPriority, idLevelSeason ORDER BY SortPriority ASC, idLevelSeason ASC';
	$divisionlist = $setDBH->prepare($divisionlistSQL);
	$divisionlist->bindParam(':idSeason', $currentseason, PDO::PARAM_INT);
	$divisionlist->bindParam(':idlevel', $currentlevel, PDO::PARAM_INT);
	$divisionlist->execute();
	$submenuDropNav[] = array('link'=>NULL, 'text'=> 'Divisions' );
	$submenuDropNav[] = array('link'=>'/AHA/season?seasonid='.$currentseason.'&levelid='.$currentlevel, 'text'=> 'Back to Level' );
	if ($divisionlist->rowCount() > 0){
		while ($divisionfetch = $divisionlist->fetch(PDO::FETCH_ASSOC))
		{
			$submenuDropNav[] = array('link'=>'/AHA/season?seasonid='.$currentseason.'&levelid='.$currentlevel.'&divid='.$divisionfetch['Division'], 'text'=>$divisionfetch['Division']);
		}
	}

	$header = $divisionheaderreturn['Level'].' '.$divisionheaderreturn['Division'];


	$menuArray[] = array('link'=>'/AHA/season?seasonid='.$currentseason.'&levelid='.$currentlevel.'&divid='.$currentdivision, 'text'=>$header.' Home');
	$menuArray[] = array('link'=>'/AHA/schedule?seasonid='.$currentseason.'&levelid='.$currentlevel.'&divid='.$currentdivision, 'text'=>'Scores/Schedule');
	$menuArray[] = array('link'=>'/AHA/standings?seasonid='.$currentseason.'&levelid='.$currentlevel.'&divid='.$currentdivision, 'text'=>'Standings');
	$menuArray[] = array('link'=>'/AHA/teamstats?seasonid='.$currentseason.'&levelid='.$currentlevel.'&divid='.$currentdivision, 'text'=>'Team Stats');
	$menuArray[] = array('link'=>'/AHA/seasonleaders?seasonid='.$currentseason.'&levelid='.$currentlevel.'&divid='.$currentdivision, 'text'=>'Player Stats');
					
	$teamsingroupSQL = 'SELECT DISTINCT idTeamAssignment, teamstatview.TeamName, externalSmallImage, cssCustom FROM teamstatview JOIN team ON teamstatview.idTeam = team.idTeam LEFT JOIN jjglover_GLSHockey_NewsCss.cssteamassignment ON teamstatview.idTeamAssignment = cssteamassignment.TeamidRef AND TeamtableRef = "teamassignment" WHERE idSeason = :idSeason AND idLevelSeason = :idLevel AND Division = :division';
	$teamsingroupfetch = $setDBH->prepare($teamsingroupSQL);
	$teamsingroupfetch->bindParam(':idSeason', $currentseason, PDO::PARAM_INT);
	$teamsingroupfetch->bindParam(':idLevel', $currentlevel, PDO::PARAM_INT);
	$teamsingroupfetch->bindParam(':division', $currentdivision, PDO::PARAM_STR);
	$teamsingroupfetch->execute();
	$submenuArray[] = array('link'=>NULL, 'text'=> 'Teams');
	while ($teamfetch = $teamsingroupfetch->fetch(PDO::FETCH_ASSOC))
		{$submenuArray[] = array('link'=>'/AHA/team?teamid='.$teamfetch['idTeamAssignment'], 'text'=>$teamfetch['TeamName'], 'teamImage'=>$teamfetch['externalSmallImage'], 'teamTheme'=>$teamfetch['cssCustom']);		}
	}
	
elseif ($currentlevel != 0)	{
	$levelheader = $setDBH->prepare('SELECT idSeason, SeasonName, idLevelSeason, Level, Division, idTeamAssignment, TeamName FROM teamstatview WHERE idSeason = :seasonid AND idLevelSeason = :idlevel LIMIT 1');
	$levelheader->bindParam(':idlevel', $currentlevel, PDO::PARAM_INT);
	$levelheader->bindParam(':seasonid', $currentseason, PDO::PARAM_INT);
	$levelheader->execute();
	$levelheaderreturn = $levelheader->fetch(PDO::FETCH_ASSOC);
	#$subheader = '<a href="season?seasonid='.$levelheaderreturn['idSeason'].'">'.$levelheaderreturn['SeasonName'].'</a>';
	$header = $levelheaderreturn['Level'];

	$subheaderArray[] = array('link'=>'/AHA/season?seasonid='.$levelheaderreturn['idSeason'], 'text'=>$levelheaderreturn['SeasonName']);

	$levelsingroupSQL = 'SELECT DISTINCT idLevelSeason, Level, SortPriority FROM teamstatview WHERE idSeason = :idSeason GROUP BY SortPriority, idLevelSeason ORDER BY SortPriority ASC, idLevelSeason ASC';
	$levelsingroupfetch = $setDBH->prepare($levelsingroupSQL);
	$levelsingroupfetch->bindParam(':idSeason', $currentseason, PDO::PARAM_INT);
	$levelsingroupfetch->execute();
	$submenuDropNav[] = array('link'=>NULL, 'text'=> 'Change Level' );
	if ($levelsingroupfetch->rowCount() > 0){
		while ($levelfetch = $levelsingroupfetch->fetch(PDO::FETCH_ASSOC))
		{
			$submenuDropNav[] = array('link'=>'/AHA/season?seasonid='.$currentseason.'&levelid='.$levelfetch['idLevelSeason'], 'text'=>$levelfetch['Level']);
		}
	}
	
	#$ToplineHeader = '-> <a href="season?seasonid='.$levelheaderreturn['idSeason'].'">'.$levelheaderreturn['SeasonName'].'</a> -> '.$levelheaderreturn['Level'];

	$menuArray[] = array('link'=>'/AHA/season?seasonid='.$currentseason.'&levelid='.$currentlevel, 'text'=>$header.' Home');
	$menuArray[] = array('link'=>'/AHA/schedule?seasonid='.$currentseason.'&levelid='.$currentlevel, 'text'=>'Scores/Schedule');
	$menuArray[] = array('link'=>'/AHA/standings?seasonid='.$currentseason.'&levelid='.$currentlevel, 'text'=>'Standings');
	$menuArray[] = array('link'=>'/AHA/teamstats?seasonid='.$currentseason.'&levelid='.$currentlevel, 'text'=>'Team Stats');
	$menuArray[] = array('link'=>'/AHA/seasonleaders?seasonid='.$currentseason.'&levelid='.$currentlevel, 'text'=>'Player Stats');

	$divinlevelSQL = 'SELECT DISTINCT idLevelSeasonkey, Level, teamstatassignment.TeamDivision FROM teamstatassignment JOIN teamassignment ON teamstatassignment.idTeamAssignmentkey = teamassignment.idTeamAssignment JOIN level ON teamstatassignment.idLevelSeasonkey = level.idLevelSeason JOIN subseason ON teamstatassignment.idsubseasonkey = subseason.idsubseason WHERE teamassignment.idSeasonkey = :idSeason AND idLevelSeason = :idLevel ORDER BY subseason.SortOrder DESC, teamstatassignment.TeamDivision';
	$divinlevelfetch = $setDBH->prepare($divinlevelSQL);
	$divinlevelfetch->bindParam(':idSeason', $currentseason, PDO::PARAM_INT);
	$divinlevelfetch->bindParam(':idLevel', $currentlevel, PDO::PARAM_INT);
	$divinlevelfetch->execute();
	$DivCount = $divinlevelfetch->rowCount();
	if ($DivCount > 1)
	{
		$submenuArray[] = array('link'=>NULL, 'text'=> 'Divisions' );

		while ($divsearch = $divinlevelfetch->fetch(PDO::FETCH_ASSOC))
	{
		$submenuArray[] = array('link'=>'/AHA/season?seasonid='.$currentseason.'&levelid='.$divsearch['idLevelSeasonkey'].'&divid='.$divsearch['TeamDivision'], 'text'=>$divsearch['TeamDivision']);
	}
	} else {
			$teamsingroupSQL = 'SELECT DISTINCT idTeamAssignment, teamstatview.TeamName, externalSmallImage, cssCustom FROM teamstatview JOIN team ON teamstatview.idTeam = team.idTeam LEFT JOIN jjglover_GLSHockey_NewsCss.cssteamassignment ON teamstatview.idTeamAssignment = cssteamassignment.TeamidRef AND TeamtableRef = "teamassignment" WHERE idSeason = :idSeason AND idLevelSeason = :idLevel';
			$teamsingroupfetch = $setDBH->prepare($teamsingroupSQL);
			$teamsingroupfetch->bindParam(':idSeason', $currentseason, PDO::PARAM_INT);
			$teamsingroupfetch->bindParam(':idLevel', $currentlevel, PDO::PARAM_INT);
			$teamsingroupfetch->execute();
			$submenuArray[] = array('link'=>NULL, 'text'=> 'Teams' );
				while ($teamfetch = $teamsingroupfetch->fetch(PDO::FETCH_ASSOC))
			{
				$submenuArray[] = array('link'=>'/AHA/team?teamid='.$teamfetch['idTeamAssignment'], 'text'=>$teamfetch['TeamName'], 'teamImage'=>$teamfetch['externalSmallImage'], 'teamTheme'=>$teamfetch['cssCustom']);
			}
	}
}
elseif ($currentseason != 0) {
	$seasonheader = $setDBH->prepare('SELECT DISTINCT teamstatview.idLeague, LeagueName, LeagueDesc, idSeason, SeasonName, idLevelSeason, Level, Division FROM teamstatview JOIN league ON teamstatview.idLeague = league.idLeague WHERE idSeason = :seasonid LIMIT 1');
	$seasonheader->bindParam(':seasonid', $currentseason, PDO::PARAM_INT);
	$seasonheader->execute();
	$seasonheaderreturn = $seasonheader->fetch(PDO::FETCH_ASSOC);
	#$ToplineHeader = ' -> '.$seasonheaderreturn['SeasonName'];
	#$subheader = $seasonheaderreturn['LeagueDesc'];
	$header = $seasonheaderreturn['SeasonName'];

	$subheaderArray[] = array('link'=>null, 'text'=>$seasonheaderreturn['LeagueDesc']);

	$PresentSeason = $setDBH->prepare('SELECT SeasonDisplay, idSeason, CurrentSeason FROM season WHERE CurrentSeason <> 2 ORDER BY SeasonStart DESC');
	$PresentSeason ->execute();
	$submenuDropNav[] = array('link'=>NULL, 'text'=> 'Change Season' );
	if ($PresentSeason->rowCount() > 0)
	while ($PresentSeasonfetched = $PresentSeason ->fetch(PDO::FETCH_ASSOC))
	{
		$submenuDropNav[] = array('link'=>'/AHA/season?seasonid='.$PresentSeasonfetched['idSeason'], 'text'=>$PresentSeasonfetched['SeasonDisplay']);
	}

	$menuArray[] = array('link'=>'/AHA/season?seasonid='.$currentseason, 'text'=>$header.' Home');
	$menuArray[] = array('link'=>'/AHA/schedule?seasonid='.$currentseason, 'text'=>'Scores/Schedule');
	$menuArray[] = array('link'=>'/AHA/standings?seasonid='.$currentseason, 'text'=>'Standings');
	$menuArray[] = array('link'=>'/AHA/teamstats?seasonid='.$currentseason, 'text'=>'Team Stats');
	$menuArray[] = array('link'=>'/AHA/seasonleaders?seasonid='.$currentseason, 'text'=>'Player Stats');

	$levelsingroupSQL = 'SELECT DISTINCT idLevelSeason, Level, SortPriority FROM teamstatview WHERE idSeason = :idSeason GROUP BY idLevelSeason, LEVEL, SortPriority ORDER BY SortPriority ASC, idLevelSeason ASC';
	$levelsingroupfetch = $setDBH->prepare($levelsingroupSQL);
	$levelsingroupfetch->bindParam(':idSeason', $currentseason, PDO::PARAM_INT);
	$levelsingroupfetch->execute();
	$submenuArray[] = array('link'=>NULL, 'text'=> 'Levels: ' );
	while ($levelfetch = $levelsingroupfetch->fetch(PDO::FETCH_ASSOC))
	{
		$submenuArray[] = array('link'=>'/AHA/season?seasonid='.$currentseason.'&levelid='.$levelfetch['idLevelSeason'], 'text'=>$levelfetch['Level']);
	}
	#$BNavbar .= '</ul></div>';
}
elseif ($currentgame != 0) {
	$gameheader = $setDBH->prepare('SELECT idGame, GameDate, game.idSeasonkey, season.SeasonDisplay, game.idsubseasonkey, SubSeasonName, HomeTeam, hometeamname.TeamName as HomeTeamName, hometeamstat.teamPrefix AS HomePrefix, hometeamstat.TeamDivision, hometeamstat.idLevelSeasonkey, Level, AwayTeam, awayteamname.TeamName as AwayTeamName, awayteamstat.teamPrefix AS AwayPrefix FROM game JOIN teamassignment AS hometeamassignment ON game.HomeTeam = hometeamassignment.idTeamAssignment JOIN teamstatassignment AS hometeamstat ON hometeamassignment.idTeamAssignment = hometeamstat.idTeamAssignmentkey AND game.idsubseasonkey = hometeamstat.idsubseasonkey JOIN team AS hometeamname ON hometeamassignment.idTeamkey = hometeamname.idTeam JOIN level ON hometeamstat.idLevelSeasonkey = level.idLevelSeason JOIN teamassignment AS awayteamassignment ON game.AwayTeam = awayteamassignment.idTeamAssignment JOIN teamstatassignment AS awayteamstat ON awayteamassignment.idTeamAssignment = awayteamstat.idTeamAssignmentkey AND game.idsubseasonkey = awayteamstat.idsubseasonkey JOIN team AS awayteamname ON awayteamassignment.idTeamkey = awayteamname.idTeam JOIN season on game.idSeasonkey = season.idSeason JOIN subseason ON game.idsubseasonkey = subseason.idsubseason WHERE idGame = :gameid LIMIT 1');
	$gameheader->bindParam(':gameid', $currentgame, PDO::PARAM_INT);
	$gameheader->execute();
	$gameheaderreturn = $gameheader->fetch(PDO::FETCH_ASSOC);
	$currentseason = $gameheaderreturn['idSeasonkey'];
	$levelid = $gameheaderreturn['idLevelSeasonkey'];
	$levelname = $gameheaderreturn['Level'];
	$division = $gameheaderreturn['TeamDivision'];

	if (!empty($division))
		{$levelname = $levelname.' '.$division;}

	$hometeamname = $gameheaderreturn['HomeTeamName'];
	if (!empty($gameheaderreturn['HomePrefix'])) 
		{$hometeamname = $gameheaderreturn['HomePrefix'].' '.$hometeamname;}

	$awayteamname = $gameheaderreturn['AwayTeamName'];
	if (!empty($gameheaderreturn['AwayPrefix'])) 
		{$awayteamname = $gameheaderreturn['AwayPrefix'].' '.$awayteamname;}

	$ToplineHeader = '';
	$subheader = '<a href="season?seasonid='.$currentseason.'&levelid='.$levelid.'">'.$levelname.' '.$gameheaderreturn['SubSeasonName'].'</a>';
	$header = $hometeamname.' vs. '.$awayteamname;
	if (empty($division))
	{
		$subheaderArray[] = array('link'=>'/AHA/season?seasonid='.$currentseason.'&levelid='.$levelid, 'text'=>$levelname.' '.$gameheaderreturn['SubSeasonName']);

		$menuArray[] = array('link'=>'/AHA/season?seasonid='.$currentseason.'&levelid='.$levelid, 'text'=>$levelname.' Home');
		$menuArray[] = array('link'=>'/AHA/schedule?seasonid='.$currentseason.'&levelid='.$levelid, 'text'=>'Scores/Schedule');
		$menuArray[] = array('link'=>'/AHA/standings?seasonid='.$currentseason.'&levelid='.$levelid, 'text'=>'Standings');
		$menuArray[] = array('link'=>'/AHA/teamstats?seasonid='.$currentseason.'&levelid='.$levelid, 'text'=>'Team Stats');
		$menuArray[] = array('link'=>'/AHA/seasonleaders?seasonid='.$currentseason.'&levelid='.$levelid, 'text'=>'Player Stats');


	} else {
		$subheaderArray[] = array('link'=>'/AHA/season?seasonid='.$currentseason.'&levelid='.$levelid.'&divid='.$division, 'text'=>$levelname.' '.$gameheaderreturn['SubSeasonName']);

		$menuArray[] = array('link'=>'/AHA/season?seasonid='.$currentseason.'&levelid='.$levelid.'&divid='.$division, 'text'=>$levelname.' Home');
		$menuArray[] = array('link'=>'/AHA/schedule?seasonid='.$currentseason.'&levelid='.$levelid.'&divid='.$division, 'text'=>'Scores/Schedule');
		$menuArray[] = array('link'=>'/AHA/standings?seasonid='.$currentseason.'&levelid='.$levelid.'&divid='.$division, 'text'=>'Standings');
		$menuArray[] = array('link'=>'/AHA/teamstats?seasonid='.$currentseason.'&levelid='.$levelid.'&divid='.$division, 'text'=>'Team Stats');
		$menuArray[] = array('link'=>'/AHA/seasonleaders?seasonid='.$currentseason.'&levelid='.$levelid.'&divid='.$division, 'text'=>'Player Stats');
		}
} elseif ($currentblog != 0) {
	$pdoConnect = createNDBH();
	$blogheader = $pdoConnect->prepare('SELECT idBlog, blogName FROM blog WHERE idblog = :blogid LIMIT 1');
	$blogheader->bindParam(':blogid', $currentblog, PDO::PARAM_INT);
	$blogheader->execute();
	$blogheaderreturn = $blogheader->fetch(PDO::FETCH_ASSOC);

	$header = $blogheaderreturn['blogName'];

	$ListSeason = $setDBH->prepare('SELECT SeasonDisplay, idSeason, CurrentSeason FROM season WHERE CurrentSeason = 1 ORDER BY SeasonStart DESC LIMIT 3');
	$ListSeason ->execute();

	$menuArray[] = array('link'=>NULL, 'text'=> 'Back to Stats: ' );
	while ($Seasonfetched = $ListSeason->fetch(PDO::FETCH_ASSOC))
	{
		$menuArray[] = array('link'=>'/AHA/season?seasonid='.$Seasonfetched['idSeason'], 'text'=>$Seasonfetched['SeasonDisplay']);
	}
}
	
#Creates season links

$SeasonRowCurrentSeason = '';
$SeasonRowActiveSeasons = '';
$SeasonActiveList = '';

$SeasonRowAllSeasons = '<div class="DropdownList"><button class="buttonDropList" onclick="clickDropdown(\'seasonmenu\')">Select a Different Season</button><div class="showDropdown" id="seasonmenu">';

#$SeasonLinkHTML = 'Select a Season: ';
$PresentSeason = $setDBH->prepare('SELECT SeasonDisplay, idSeason, CurrentSeason FROM season WHERE CurrentSeason <> 2 ORDER BY SeasonStart DESC');
$PresentSeason ->execute();
while ($PresentSeasonfetched = $PresentSeason ->fetch(PDO::FETCH_ASSOC))
{
	$SeasonRowAllSeasons .= '<a href="season?seasonid='.$PresentSeasonfetched['idSeason'].'">'.$PresentSeasonfetched['SeasonDisplay'].'</a>';
	
	if ($PresentSeasonfetched['CurrentSeason'] == 1) 
		{$SeasonActiveList .= ' <a href="season?seasonid='.$PresentSeasonfetched['idSeason'].'">'.$PresentSeasonfetched['SeasonDisplay'].'</a>  ';}

	if ($PresentSeasonfetched['idSeason'] == $currentseason) {
		#$SeasonRowCurrentSeason .= '<b>Current Season: <a href="/AHA/season?seasonid='.$PresentSeasonfetched['idSeason'].'">'.$PresentSeasonfetched['SeasonDisplay'].'</a></b>';
		if ($PresentSeasonfetched['CurrentSeason'] != 1) {		
			$SeasonRowActiveSeasons .= '&emsp;(This season is archived. Current active seasons: '.$SeasonActiveList.')'; 
		}
	}
}
if (empty($SeasonRowCurrentSeason)) {$SeasonRowCurrentSeason = '<b>Active Seasons: '.$SeasonActiveList.'</b>';}
$SeasonRowAllSeasons .= '</div></div>';
#Outputs Season Dropdown selector on right side of menu
#$SeasonRowAllSeasonsdiv = divBuilder('float-right','class',$SeasonRowAllSeasons);
#Outputs left side Current Season and any archive message with link back to active season(s)
$SeasonsLink = $SeasonRowCurrentSeason.$SeasonRowActiveSeasons;

#Include All Level/Divisions Navigation

function createLevelNav($originallink) {
$currentseason = ( isset( $_GET['seasonid'] ) && is_numeric( $_GET['seasonid'] ) ) ? intval( $_GET['seasonid'] ) : 0;
$setDBH = createDBH();

$PresentSeasonLevels = $setDBH->prepare('SELECT DISTINCT idLevel, Level, DivisionsNumber, level.SortPriority FROM SeasonLevels JOIN level ON SeasonLevels.idLevel = level.idLevelSeason WHERE idSeason = :seasonid GROUP BY level.SortPriority ORDER BY level.SortPriority');
$PresentSeasonLevels->bindParam(':seasonid', $currentseason, PDO::PARAM_INT);
$PresentSeasonLevels->execute();

#Start Construction of dropdown link
$LevelSortChangeMenu = '<div class="DropdownList"><button class="buttonDropList" onclick="clickDropdown(\'levelmenu\')">Change Level/Division</button><div class="showDropdown" id="levelmenu">';
#Inserts an ALL level link
$LevelSortChangeMenu .= '<a href="'.$originallink.'">All Levels</a>';

while ($PresentLevelfetched = $PresentSeasonLevels->fetch(PDO::FETCH_ASSOC))
{
	$addonLevelLink = '&levelid='.$PresentLevelfetched['idLevel'];
	$LevelSortChangeMenu .= '<a href="'.$originallink.$addonLevelLink.'">'.$PresentLevelfetched['Level'].'</a>';
	if ($PresentLevelfetched['DivisionsNumber'] > 1)
	{
		$fetchDivisions = $setDBH->prepare('SELECT DISTINCT TeamDivision FROM teamstatassignment JOIN teamassignment ON teamstatassignment.idTeamAssignmentkey = teamassignment.idTeamAssignment WHERE idSeasonkey = :seasonid AND idLevelSeasonkey = :levelid');
		$fetchDivisions->bindParam(':seasonid', $currentseason, PDO::PARAM_INT);
		$fetchDivisions->bindParam(':levelid', $PresentLevelfetched['idLevel'], PDO::PARAM_INT);
		$fetchDivisions->execute();
		while ($Divisionsfetched = $fetchDivisions->fetch(PDO::FETCH_ASSOC))
		{
			if($Divisionsfetched['TeamDivision'] != '') {
				$addonDivisionLink = '&divid='.$Divisionsfetched['TeamDivision'];
				$LevelSortChangeMenu .= '<a href="'.$originallink.$addonLevelLink.$addonDivisionLink.'">'.$PresentLevelfetched['Level'].' '.$Divisionsfetched['TeamDivision'].'</a>';
			}
		}
	}
}
#Finish Dropdown
$LevelSortChangeMenu .= '</div></div>';
return $LevelSortChangeMenu;
}

echo json_encode(array(
	'header'=>$header,
	'subHeader'=>$subheaderArray,
	'headerMenu'=>$menuArray,
	'headerSubMenu'=>$submenuArray,
	'HeaderDropMenu'=> $submenuDropNav,
	'largeImage' => $setImage, 
	'colorArray' => $setColors,
	));
			
?>