<?
	function CalcLeague($comp, $season) {
		print "calculating league for $comp $season";

		$sql = "update Football_MA_MatchArchive set MA_Competition = 'EL2' where MA_Competition = 'Championship'"; mysql_query($sql);
		
		$yrs = explode("-", $season); if (!is_numeric($yrs[0])) exit; if (!is_numeric($yrs[1])) exit;
		$date1 = "{$yrs[0]}-07-01"; $date2 = "{$yrs[1]}-06-01"; 
		
		switch ($comp) {
			case "premier-league": 	$div = "EL1"; break;
			case "championship": 	$div = "EL2"; break;
			case "league-one": 	$div = "EL3"; break;
			case "league-two": 	$div = "EL4"; break; }

		$sql = "delete from Football_LG_Leagues where LG_League = '$div' and LG_Season = '$PARM_SEASON'"; mysql_query($sql);
	
		$sql = "select distinct(MA_HomeTeam) from Football_MA_MatchArchive where MA_Date >= '$date1' and MA_Date <= '$date2' and MA_Competition = '$div' order by MA_HomeTeam";
		$res = mysql_query($sql);
		while ($row = mysql_fetch_array($res)) {
			$teamname = $row['MA_HomeTeam'];
			$league_played[$teamname] = 0;
			$league_home_won[$teamname] = 0;
			$league_home_draw[$teamname] = 0;
			$league_home_loss[$teamname] = 0;
			$league_home_for[$teamname] = 0;
			$league_home_against[$teamname] = 0;
			$league_away_won[$teamname] = 0;
			$league_away_draw[$teamname] = 0;
			$league_away_loss[$teamname] = 0;
			$league_away_for[$teamname] = 0;
			$league_away_against[$teamname] = 0;
			$league_points[$teamname] = 0;
			$league_goaldifference[$teamname] = $league_home_for[$teamname] + $league_away_for[$teamname] - $league_home_against[$teamname] - $league_away_against[$teamname];
			$total_form_points[$teamname] = 0;
		}

		$sql = "select distinct(MA_HomeTeam) from Football_MA_MatchArchive where MA_Date >= '$date1' and MA_Date <= '$date2' and MA_Competition = '$div' order by MA_HomeTeam";
		$res = mysql_query($sql);
		while ($row = mysql_fetch_array($res)) {
			$sql2 = "select * from Football_MA_MatchArchive where MA_Date >= '$date1' and MA_Date <= '$date2' and (MA_AwayTeam = \"" . $row['MA_HomeTeam'] . "\") and MA_Competition = '$div'";
			$res2 = mysql_query($sql2);
			while ($row2 = mysql_fetch_array($res2)) {
				$awayteam = $row2['MA_AwayTeam'];
				$hometeam = $row2['MA_HomeTeam'];

				$league_played[$hometeam] = $league_played[$hometeam] + 1;
				$league_home_for[$hometeam] = $league_home_for[$hometeam] + $row2['MA_HomeScore'];
				$league_home_against[$hometeam] = $league_home_against[$hometeam] + $row2['MA_AwayScore'];
				if ($row2['MA_HomeScore'] > $row2['MA_AwayScore']) {
					$league_home_won[$hometeam] = $league_home_won[$hometeam] + 1;
				} else if ($row2['MA_HomeScore'] < $row2['MA_AwayScore']) {
					$league_home_loss[$hometeam] = $league_home_loss[$hometeam] + 1;
				} else if ($row2['MA_HomeScore'] == $row2['MA_AwayScore']) {
					$league_home_draw[$hometeam] = $league_home_draw[$hometeam] + 1;
				}
				$league_goaldifference[$hometeam] = $league_home_for[$hometeam] + $league_away_for[$hometeam] - $league_home_against[$hometeam] - $league_away_against[$hometeam];
				$league_points[$hometeam] = (3 * $league_home_won[$hometeam]) + (3 * $league_away_won[$hometeam]) + $league_home_draw[$hometeam] + $league_away_draw[$hometeam];

				$league_played[$awayteam] = $league_played[$awayteam] + 1;
				$league_away_for[$awayteam] = $league_away_for[$awayteam] + $row2['MA_AwayScore'];
				$league_away_against[$awayteam] = $league_away_against[$awayteam] + $row2['MA_HomeScore'];
				if ($row2['MA_HomeScore'] > $row2['MA_AwayScore']) {
					$league_away_loss[$awayteam] = $league_away_loss[$awayteam] + 1;
				} else if ($row2['MA_HomeScore'] < $row2['MA_AwayScore']) {
					$league_away_won[$awayteam] = $league_away_won[$awayteam] + 1;
				} else if ($row2['MA_HomeScore'] == $row2['MA_AwayScore']) {
					$league_away_draw[$awayteam] = $league_away_draw[$awayteam] + 1;
				}

				$league_goaldifference[$awayteam] = $league_home_for[$awayteam] + $league_away_for[$awayteam] - $league_home_against[$awayteam] - $league_away_against[$awayteam];
				$league_points[$awayteam] = (3 * $league_home_won[$awayteam]) + (3 * $league_away_won[$awayteam]) + $league_home_draw[$awayteam] + $league_away_draw[$awayteam];
			}
		}

		$sql = "select distinct(MA_HomeTeam) from Football_MA_MatchArchive where MA_Date >= '$date1' and MA_Date <= '$date2' and MA_Competition = '$div' order by MA_HomeTeam";
		$res = mysql_query($sql);
		while ($row = mysql_fetch_array($res)) {
			$teamname = $row['MA_HomeTeam'];
			$sql_ins = "insert into Football_LG_Leagues values (\"0\", '$season', '$div', 'L', \"" . $teamname . "\", " . $league_played[$teamname] . ", " . intval($league_home_won[$teamname]) . ", " . intval($league_home_draw[$teamname]) . ", " . intval($league_home_loss[$teamname]) . ", " . intval($league_home_for[$teamname]) . ", " . intval($league_home_against[$teamname]) . ", " . intval($league_away_won[$teamname]) . ", " . intval($league_away_draw[$teamname]) . ", " . intval($league_away_loss[$teamname]) . ", " . intval($league_away_for[$teamname]) . ", " . intval($league_away_against[$teamname]) . ", " . intval($league_goaldifference[$teamname]) . ", " . intval($league_points[$teamname]) . ")"; mysql_query($sql_ins);
		} }

	include("fb_start.php");
	$STYLESHEET = "#submenu{ padding: 0 5px 0 0; width: 100%; background: transparent; voice-family: inherit;}
		#submenu ul{ font: bold 10pt Calibri; margin:0; margin-left: 0px; padding: 0; list-style: none; }
		#submenu li{ display: inline; margin: 0 2px 0 0; padding: 0; }
		#submenu a{ float: left; display: block; color: white; margin: 0 1px 0 0; padding: 5px 10px; text-decoration: none; letter-spacing: 1px; background-color: black; border-bottom: 1px solid white; border-top: 1px solid white; }
		#submenu a:hover{ background-color: #$TP_BORDER2; }
		#submenu #current a{ background-color: #$TP_BORDER1; border-color: #$TP_BORDER1; }
		#submenuline {clear:both; padding:0 5px 0 0; height:5px; line-height:5px; background:#$TP_BORDER1; margin-bottom:0px; }
		label { width: 160px; float: left; text-align: left; margin-right: 0.5em; display: block; font-weight: bold }";
	$STYLESHEET .= ".r1 { border-bottom:1px dotted black; background-color: #eeeeee; } .r2 { border-bottom:1px dotted black; background-color: #dddddd;}  .sel { border-bottom:1px dotted black; background-color: #$TP_BORDER2; color: white; }
		.leaguetable td{ height:25px; padding:3px 5px 4px 5px; text-align:center; border-bottom:1px dotted #003399; vertical-align:middle;}
		.leaguetablehead td{ background: #$TP_BORDER1; color:#fff; font-weight:bold; margin-bottom:20px; border-bottom: 0px solid #fff !important; }
		.leaguetable { width:785px; border-collapse:collapse; }
		.leaguetable .teamname { text-align:left; font-weight:bold !important }";

	if (isset($_POST['ADate']) or isset($_POST['matches'])) { 
		$url = "$PATH/league-tables/competition:$PARM_COMPETITION/";
		if (isset($_POST['ADate'])) $url .= "daterange/fromdate:". date("Y-M-d", strtotime($_POST['ADate'])) . "/todate:". date("Y-M-d", strtotime($_POST['BDate'])) . "/"; else $url .= "form/matches:" . intval($_POST['matches']) . "/";
		if ($_POST['venue'] == "h") $url .= "type:home/"; else if ($_POST['venue'] == "a") $url .= "type:away/"; else $url .= "type:home-and-away/";
		header("location: $url");
		exit;
	}
	
	foreach ($QUERYSTRINGS as $x => $v) { # process matches and type parameters
		if (substr($QUERYSTRINGS[$x], 0, 8) == "matches:")	{ $PARM_MATCHES = substr($QUERYSTRINGS[$x], 8, 2); if (!is_numeric($PARM_MATCHES)) exit; } # get match number if supplied
		if (substr($QUERYSTRINGS[$x], 0, 5) == "type:")		{ $PARM_TYPE = substr($QUERYSTRINGS[$x], 5, 20); } # get match number if supplied
	}

	if (!isset($PARM_FROMDATE) or $PARM_FROMDATE == "") { $PARM_FROMDATE = strtoupper(date("j-M-Y", strtotime($MINDATE))); $PARM_TODATE = strtoupper(date("j-M-Y", strtotime($MAXDATE))); }
	if (!isset($PARM_SEASON)) $PARM_SEASON = $SEASON;
	if (!isset($PARM_COMPETITION)) { 
		switch ($DIVISION) {
			case "1": $PARM_COMPETITION = "premier-league"; break;
			case "2": $PARM_COMPETITION = "championship"; break;
			case "3": $PARM_COMPETITION = "league-one"; break;
			case "4": $PARM_COMPETITION = "league-two"; break; 
			case "1000": $PARM_COMPETITION = "conference-north"; break;
			case "1001": $PARM_COMPETITION = "ryman-premier"; break;
			case "1002": $PARM_COMPETITION = "ryman-north"; break;
			case "1003": $PARM_COMPETITION = "thurlow-nunn-premier"; break;
		}}
	
	switch ($PARM_COMPETITION) {
		case "premier-league": 		$divname = "Premier League"; 		$div = "1"; 	$imgsrc = "eng_premier.png"; break;
		case "championship": 		$divname = "Championship"; 		$div = "2"; 	$imgsrc = "eng_championship.png"; break;
		case "league-one": 		$divname = "League One"; 		$div = "3"; 	$imgsrc = "eng_leagueone.png"; break;
		case "league-two": 		$divname = "League Two"; 		$div = "4"; 	$imgsrc = "eng_leaguetwo.png"; break;
		case "conference-north": 	$divname = "Conference North"; 		$div = "1000"; 	$imgsrc = "eng_confnorth.gif"; break;
		case "ryman-premier": 		$divname = "Ryman Premier"; 		$div = "1001"; 	$imgsrc = "eng_rymanpremier.gif"; break;
		case "ryman-north": 		$divname = "Ryman North";	 	$div = "1002"; 	$imgsrc = "eng_rymannorth.gif"; break;
		case "thurlow-nunn-premier": 	$divname = "Thurlow Nunn Premier"; 	$div = "1003"; 	$imgsrc = "eng_thurlownunnpremier.gif"; break;
	}

	$PARM_FROMDATE = strtoupper(date("j-M-Y", strtotime($PARM_FROMDATE)));
	$PARM_TODATE   = strtoupper(date("j-M-Y", strtotime($PARM_TODATE)));

	if ($PARAMETER2 == "daterange") { # calculate temporary league based on from/todate
		$sql = "delete from Football_LG_Leagues where LG_Season = '{$_SERVER['REMOTE_ADDR']}'";
		$res = mysql_query($sql);
		if (isset($PARM_TODATE)) $todate = date("Ymd", strtotime($PARM_TODATE)); else $PARM_TODATE = strtoupper(date("j-M-Y", strtotime($MAXDATE)));
		if (isset($PARM_FROMDATE)) $fromdate = date("Ymd", strtotime($PARM_TODATE)); else $PARM_FROMDATE = strtoupper(date("j-M-Y", strtotime($MINDATE)));
		$todate = date("Ymd", strtotime($PARM_TODATE));
		$fromdate = date("Ymd", strtotime($PARM_FROMDATE));
		$currentseason = $_SERVER['REMOTE_ADDR'];
		$PARM_SEASON = $_SERVER['REMOTE_ADDR'];
		$form = intval($PARM_MATCHES); if ($form == 0) $form = 6;

		$sql = "select * from Football_GA_Games where PLG_Date >= $fromdate and PLG_Date <= $todate and PLG_HomeScore > -1 and PLG_Type = 'L' and PLG_Round = $div order by PLG_Date desc";
		$res = mysql_query($sql);
		while ($row = mysql_fetch_array($res)) { # reset values
			$teamname = $row['PLG_HomeTeam']; $home_form_played[$teamname] = 0; $home_form_won[$teamname] = 0; $home_form_draw[$teamname] = 0; $home_form_loss[$teamname] = 0; $home_form_for[$teamname] = 0; $home_form_against[$teamname] = 0; $away_form_played[$teamname] = 0; $away_form_won[$teamname] = 0; $away_form_draw[$teamname] = 0; $away_form_loss[$teamname] = 0; $away_form_for[$teamname] = 0; $away_form_against[$teamname] = 0; $total_form_played[$teamname] = 0; $total_form_won[$teamname] = 0; $total_form_draw[$teamname] = 0; $total_form_loss[$teamname] = 0; $total_form_for[$teamname] = 0; $total_form_against[$teamname] = 0; $league_played[$teamname] = 0; $league_home_won[$teamname] = 0; $league_home_draw[$teamname] = 0; $league_home_loss[$teamname] = 0; $league_home_for[$teamname] = 0; $league_home_against[$teamname] = 0; $league_away_won[$teamname] = 0; $league_away_draw[$teamname] = 0; $league_away_loss[$teamname] = 0; $league_away_for[$teamname] = 0; $league_away_against[$teamname] = 0; $league_points[$teamname] = 0; $league_goaldifference[$teamname] = $league_home_for[$teamname] + $league_away_for[$teamname] - $league_home_against[$teamname] - $league_away_against[$teamname]; $total_form_points[$teamname] = 0;
			$teamname = $row['PLG_AwayTeam']; $home_form_played[$teamname] = 0; $home_form_won[$teamname] = 0; $home_form_draw[$teamname] = 0; $home_form_loss[$teamname] = 0; $home_form_for[$teamname] = 0; $home_form_against[$teamname] = 0; $away_form_played[$teamname] = 0; $away_form_won[$teamname] = 0; $away_form_draw[$teamname] = 0; $away_form_loss[$teamname] = 0; $away_form_for[$teamname] = 0; $away_form_against[$teamname] = 0; $total_form_played[$teamname] = 0; $total_form_won[$teamname] = 0; $total_form_draw[$teamname] = 0; $total_form_loss[$teamname] = 0; $total_form_for[$teamname] = 0; $total_form_against[$teamname] = 0; $league_played[$teamname] = 0; $league_home_won[$teamname] = 0; $league_home_draw[$teamname] = 0; $league_home_loss[$teamname] = 0; $league_home_for[$teamname] = 0; $league_home_against[$teamname] = 0; $league_away_won[$teamname] = 0; $league_away_draw[$teamname] = 0; $league_away_loss[$teamname] = 0; $league_away_for[$teamname] = 0; $league_away_against[$teamname] = 0; $league_points[$teamname] = 0; $league_goaldifference[$teamname] = $league_home_for[$teamname] + $league_away_for[$teamname] - $league_home_against[$teamname] - $league_away_against[$teamname]; $total_form_points[$teamname] = 0;
		}
		$res = mysql_query($sql);	
		while ($row = mysql_fetch_array($res)) {
			$awayteam = $row['PLG_AwayTeam'];
			$hometeam = $row['PLG_HomeTeam'];
			$league_played[$hometeam] = $league_played[$hometeam] + 1;
			$league_home_for[$hometeam] = $league_home_for[$hometeam] + $row['PLG_HomeScore'];
			$league_home_against[$hometeam] = $league_home_against[$hometeam] + $row['PLG_AwayScore'];
			if ($row['PLG_HomeScore'] > $row['PLG_AwayScore']) {
				$league_home_won[$hometeam] = $league_home_won[$hometeam] + 1;
			} else if ($row['PLG_HomeScore'] < $row['PLG_AwayScore']) {
				$league_home_loss[$hometeam] = $league_home_loss[$hometeam] + 1;
			} else if ($row['PLG_HomeScore'] == $row['PLG_AwayScore']) {
				$league_home_draw[$hometeam] = $league_home_draw[$hometeam] + 1;
			}

			$league_goaldifference[$hometeam] = $league_home_for[$hometeam] + $league_away_for[$hometeam] - $league_home_against[$hometeam] - $league_away_against[$hometeam];
			$league_points[$hometeam] = (3 * $league_home_won[$hometeam]) + (3 * $league_away_won[$hometeam]) + $league_home_draw[$hometeam] + $league_away_draw[$hometeam];

			$league_played[$awayteam] = $league_played[$awayteam] + 1;
			$league_away_for[$awayteam] = $league_away_for[$awayteam] + $row['PLG_AwayScore'];
			$league_away_against[$awayteam] = $league_away_against[$awayteam] + $row['PLG_HomeScore'];
			if ($row['PLG_HomeScore'] > $row['PLG_AwayScore']) {
				$league_away_loss[$awayteam] = $league_away_loss[$awayteam] + 1;
			} else if ($row['PLG_HomeScore'] < $row['PLG_AwayScore']) {
				$league_away_won[$awayteam] = $league_away_won[$awayteam] + 1;
			} else if ($row2['PLG_HomeScore'] == $row2['PLG_AwayScore']) {
				$league_away_draw[$awayteam] = $league_away_draw[$awayteam] + 1;
			}
			$league_goaldifference[$awayteam] = $league_home_for[$awayteam] + $league_away_for[$awayteam] - $league_home_against[$awayteam] - $league_away_against[$awayteam];
			$league_points[$awayteam] = (3 * $league_home_won[$awayteam]) + (3 * $league_away_won[$awayteam]) + $league_home_draw[$awayteam] + $league_away_draw[$awayteam];
		}
	
		foreach ($league_played as $teamname => $value) {
			$sql_ins = "insert into Football_LG_Leagues values (\"$currentseason\", " . $div . ", \"L\", \"" . $teamname . "\", " . $league_played[$teamname] . ", " . intval($league_home_won[$teamname]) . ", " . intval($league_home_draw[$teamname]) . ", " . intval($league_home_loss[$teamname]) . ", " . intval($league_home_for[$teamname]) . ", " . intval($league_home_against[$teamname]) . ", " . intval($league_away_won[$teamname]) . ", " . intval($league_away_draw[$teamname]) . ", " . intval($league_away_loss[$teamname]) . ", " . intval($league_away_for[$teamname]) . ", " . intval($league_away_against[$teamname]) . ", " . intval($league_goaldifference[$teamname]) . ", " . intval($league_points[$teamname]) . ")"; mysql_query($sql_ins);
		} }




	if ($PARAMETER2 == "form") { # calculate temporary league based on from/todate
		$sql = "delete from Football_LG_Leagues where LG_Season = '{$_SERVER['REMOTE_ADDR']}'";
		$res = mysql_query($sql);
		if (isset($PARM_TODATE)) $todate = date("Ymd", strtotime($PARM_TODATE)); else $PARM_TODATE = strtoupper(date("j-M-Y", strtotime($MAXDATE)));
		if (isset($PARM_FROMDATE)) $fromdate = date("Ymd", strtotime($PARM_TODATE)); else $PARM_FROMDATE = strtoupper(date("j-M-Y", strtotime($MINDATE)));
		$todate = date("Ymd", strtotime($PARM_TODATE));
		$fromdate = date("Ymd", strtotime($PARM_FROMDATE));
		$currentseason = $_SERVER['REMOTE_ADDR'];
		$PARM_SEASON = $_SERVER['REMOTE_ADDR'];
		$form = intval($PARM_MATCHES); if ($form == 0) $form = 6;

		$sql = "select * from Football_TM_Teams where TM_Div = $div order by TM_TeamName";
		$res = mysql_query($sql);
		while ($row = mysql_fetch_array($res)) { # reset values
			$teamname = $row['TM_TeamName'];
	
			$home_form_played[$teamname] = 0;
			$home_form_won[$teamname] = 0;
			$home_form_draw[$teamname] = 0;
			$home_form_loss[$teamname] = 0;
			$home_form_for[$teamname] = 0;
			$home_form_against[$teamname] = 0;
	
			$away_form_played[$teamname] = 0;
			$away_form_won[$teamname] = 0;
			$away_form_draw[$teamname] = 0;
			$away_form_loss[$teamname] = 0;
			$away_form_for[$teamname] = 0;
			$away_form_against[$teamname] = 0;
	
			$total_form_played[$teamname] = 0;
			$total_form_won[$teamname] = 0;
			$total_form_draw[$teamname] = 0;
			$total_form_loss[$teamname] = 0;
			$total_form_for[$teamname] = 0;
			$total_form_against[$teamname] = 0;
	
			$league_played[$teamname] = 0;
			$league_home_won[$teamname] = 0;
			$league_home_draw[$teamname] = 0;
			$league_home_loss[$teamname] = 0;
			$league_home_for[$teamname] = 0;
			$league_home_against[$teamname] = 0;
			$league_away_won[$teamname] = 0;
			$league_away_draw[$teamname] = 0;
			$league_away_loss[$teamname] = 0;
			$league_away_for[$teamname] = 0;
			$league_away_against[$teamname] = 0;
			$league_points[$teamname] = 0;
			$league_goaldifference[$teamname] = $league_home_for[$teamname] + $league_away_for[$teamname] - $league_home_against[$teamname] - $league_away_against[$teamname];
			$total_form_points[$teamname] = 0;
		}
	
		$sql = "select * from Football_TM_Teams where TM_Div = $div order by TM_TeamName";
		$res = mysql_query($sql);
		while ($row = mysql_fetch_array($res)) {
			$team = $row['TM_TeamName'];
			$sql2 = "select * from Football_GA_Games where PLG_Date >= $fromdate and PLG_Date <= $todate and PLG_HomeScore > -1 and (PLG_AwayTeam = \"" . $row['TM_TeamName'] . "\") and PLG_Type = 'L' order by PLG_Date desc";
			if (isset($PARM_MATCHES) and $PARM_TYPE == "home") $sql2 = "select * from Football_GA_Games where PLG_Date >= $fromdate and PLG_Date <= $todate and PLG_HomeScore > -1 and (PLG_HomeTeam = \"$team\") and PLG_Type = 'L' order by PLG_Date desc limit $form";
			if (isset($PARM_MATCHES) and $PARM_TYPE == "away") $sql2 = "select * from Football_GA_Games where PLG_Date >= $fromdate and PLG_Date <= $todate and PLG_HomeScore > -1 and (PLG_AwayTeam = \"$team\") and PLG_Type = 'L' order by PLG_Date desc limit $form";
			if (isset($PARM_MATCHES) and $PARM_TYPE == "home-and-away") $sql2 = "select * from Football_GA_Games where PLG_Date >= $fromdate and PLG_Date <= $todate and PLG_HomeScore > -1 and (PLG_HomeTeam = \"$team\" or PLG_AwayTeam = \"$team\") and PLG_Type = 'L' order by PLG_Date desc limit $form";
			$res2 = mysql_query($sql2);
			while ($row2 = mysql_fetch_array($res2)) {
				$awayteam = $row2['PLG_AwayTeam'];
				$hometeam = $row2['PLG_HomeTeam'];
				if ($row['TM_TeamName'] == $hometeam or $PARAMETER2 != "form") {
					$league_played[$hometeam] = $league_played[$hometeam] + 1;
					$league_home_for[$hometeam] = $league_home_for[$hometeam] + $row2['PLG_HomeScore'];
					$league_home_against[$hometeam] = $league_home_against[$hometeam] + $row2['PLG_AwayScore'];
					if ($row2['PLG_HomeScore'] > $row2['PLG_AwayScore']) {
						$league_home_won[$hometeam] = $league_home_won[$hometeam] + 1;
					} else if ($row2['PLG_HomeScore'] < $row2['PLG_AwayScore']) {
						$league_home_loss[$hometeam] = $league_home_loss[$hometeam] + 1;
					} else if ($row2['PLG_HomeScore'] == $row2['PLG_AwayScore']) {
						$league_home_draw[$hometeam] = $league_home_draw[$hometeam] + 1;
					}
				}
				$league_goaldifference[$hometeam] = $league_home_for[$hometeam] + $league_away_for[$hometeam] - $league_home_against[$hometeam] - $league_away_against[$hometeam];
				$league_points[$hometeam] = (3 * $league_home_won[$hometeam]) + (3 * $league_away_won[$hometeam]) + $league_home_draw[$hometeam] + $league_away_draw[$hometeam];

				if ($row['TM_TeamName'] == $awayteam or $PARAMETER2 != "form") {
					$league_played[$awayteam] = $league_played[$awayteam] + 1;
					$league_away_for[$awayteam] = $league_away_for[$awayteam] + $row2['PLG_AwayScore'];
					$league_away_against[$awayteam] = $league_away_against[$awayteam] + $row2['PLG_HomeScore'];
					if ($row2['PLG_HomeScore'] > $row2['PLG_AwayScore']) {
						$league_away_loss[$awayteam] = $league_away_loss[$awayteam] + 1;
					} else if ($row2['PLG_HomeScore'] < $row2['PLG_AwayScore']) {
						$league_away_won[$awayteam] = $league_away_won[$awayteam] + 1;
					} else if ($row2['PLG_HomeScore'] == $row2['PLG_AwayScore']) {
						$league_away_draw[$awayteam] = $league_away_draw[$awayteam] + 1;
					}
				}
				$league_goaldifference[$awayteam] = $league_home_for[$awayteam] + $league_away_for[$awayteam] - $league_home_against[$awayteam] - $league_away_against[$awayteam];
				$league_points[$awayteam] = (3 * $league_home_won[$awayteam]) + (3 * $league_away_won[$awayteam]) + $league_home_draw[$awayteam] + $league_away_draw[$awayteam];
			}
		}
	
		$sql = "select * from Football_TM_Teams where TM_Div = $div order by TM_TeamName";
		$res = mysql_query($sql);
		while ($row = mysql_fetch_array($res)) {
			$teamname = $row['TM_TeamName'];
			################ Points deductions
#if ($teamname == "Rotherham United") $league_points[$teamname] = $league_points[$teamname] - 9;
		#		if ($teamname == "Port Vale") $league_points[$teamname] = $league_points[$teamname] - 10;
			#if ($teamname eq "Crystal Palace") {$league_points{$teamname} = $league_points{$teamname} - 10;}
			#if ($teamname eq "Portsmouth") {$league_points{$teamname} = $league_points{$teamname} - 9;}
	
			#$sql_ins = "insert into Football_LG_Leagues values (\"0\", \"$currentseason\", {$row['TM_Div']}, \"H\", \"$teamname\", {$home_form_played[$teamname]}, {$home_form_won[$teamname]}, {$home_form_draw[$teamname]}, {$home_form_loss[$teamname]}, {$home_form_for[$teamname]}, {$home_form_against[$teamname]}, 0, 0, 0, 0, 0, {$home_form_goaldifference[$teamname]}, {$home_form_points[$teamname]})"; mysql_query($sql_ins);
			#$sql_ins = "insert into Football_LG_Leagues values (\"0\", \"$currentseason\", {$row['TM_Div']}, \"A\", \"$teamname\", {$away_form_played[$teamname]}, {$away_form_won[$teamname]}, {$away_form_draw[$teamname]}, {$away_form_loss[$teamname]}, {$away_form_for[$teamname]}, {$away_form_against[$teamname]}, 0, 0, 0, 0, 0, {$away_form_goaldifference[$teamname]}, {$away_form_points[$teamname]})"; mysql_query($sql_ins);
			#$sql_ins = "insert into Football_LG_Leagues values (\"0\", \"$currentseason\", {$row['TM_Div']}, \"T\", \"$teamname\", {$total_form_played[$teamname]}, {$total_form_won[$teamname]}, {$total_form_draw[$teamname]}, {$total_form_loss[$teamname]}, {$total_form_for[$teamname]}, {$total_form_against[$teamname]}, 0, 0, 0, 0, 0, {$total_form_goaldifference[$teamname]}, {$total_form_points[$teamname]})"; mysql_query($sql_ins);
			$sql_ins = "insert into Football_LG_Leagues values (\"$currentseason\", " . $row['TM_Div'] . ", \"L\", \"" . $teamname . "\", " . $league_played[$teamname] . ", " . intval($league_home_won[$teamname]) . ", " . intval($league_home_draw[$teamname]) . ", " . intval($league_home_loss[$teamname]) . ", " . intval($league_home_for[$teamname]) . ", " . intval($league_home_against[$teamname]) . ", " . intval($league_away_won[$teamname]) . ", " . intval($league_away_draw[$teamname]) . ", " . intval($league_away_loss[$teamname]) . ", " . intval($league_away_for[$teamname]) . ", " . intval($league_away_against[$teamname]) . ", " . intval($league_goaldifference[$teamname]) . ", " . intval($league_points[$teamname]) . ")"; mysql_query($sql_ins);
		} }

	if ($PARAMETER2 == "form") {
		if ($PARM_TYPE == "home") $PAGE_TITLE = "Current $YEARDESC $divname Form Table, Last $form Home Matches";
		 else if ($PARM_TYPE == "away") $PAGE_TITLE = "Current $YEARDESC $divname Form Table, Last $form Away Matches";
		  else $PAGE_TITLE = "Current $YEARDESC $divname Form Table, Last $form Matches, Home and Away";
	} else if ($PARAMETER2 == "daterange") {
		$PAGE_TITLE = "$YEARDESC $divname Date Range: $PARM_FROMDATE to $PARM_TODATE";
	} else { $PAGE_TITLE = "Current $YEARDESC $divname League Table"; }

	$JAVASCRIPT = "<script type=\"text/javascript\" src=\"/addons/calendarDateInput.js\">/* Jason's Date Input Calendar- By Jason Moon http://calendar.moonscript.com/dateinput.cfm Script featured on and available at http://www.dynamicdrive.com </script>";
	include("fb_top.php");

	$yearselector = "";
	#$s = "2014-2015"; $yearselector .= "<option value=\"$PATH/league-tables/competition:$PARM_COMPETITION/season:$s\""; if ($s == $PARM_SEASON) $yearselector .= " selected "; $yearselector .= ">$s</option>";
	#$s = "2011-2012"; $yearselector .= "<option value=\"$PATH/league-tables/competition:$PARM_COMPETITION/season:$s\""; if ($s == $PARM_SEASON) $yearselector .= " selected "; $yearselector .= ">$s</option>";
	#$s = "2010-2011"; $yearselector .= "<option value=\"$PATH/league-tables/competition:$PARM_COMPETITION/season:$s\""; if ($s == $PARM_SEASON) $yearselector .= " selected "; $yearselector .= ">$s</option>";
	#$s = "2009-2010"; $yearselector .= "<option value=\"$PATH/league-tables/competition:$PARM_COMPETITION/season:$s\""; if ($s == $PARM_SEASON) $yearselector .= " selected "; $yearselector .= ">$s</option>";
	#$s = "2008-2009"; $yearselector .= "<option value=\"$PATH/league-tables/competition:$PARM_COMPETITION/season:$s\""; if ($s == $PARM_SEASON) $yearselector .= " selected "; $yearselector .= ">$s</option>";
	#$s = "2007-2008"; $yearselector .= "<option value=\"$PATH/league-tables/competition:$PARM_COMPETITION/season:$s\""; if ($s == $PARM_SEASON) $yearselector .= " selected "; $yearselector .= ">$s</option>";
	#$yearselect = "\n<li style=\"float:right\"><form name=\"jump1\"><select name=\"myjumpbox\" onchange=\"location.href=jump1.myjumpbox.options[selectedIndex].value\">$yearselector</select></form></li>\n";

	if (!isset($PARM_MATCH)) {
		print "<div style=\"width:100%; margin-right:5px\"><div id=\"submenu\"><ul>\n";
		if ($PREFIX == "suffolkfootball") {
			print "<li "; if ($PARM_COMPETITION == "conference-north") 	print "id=\"current\""; print "><a href=\"$PATH/league-tables/competition:conference-north/\">Conference North</a></li>\n";
			print "<li "; if ($PARM_COMPETITION == "ryman-premier") 	print "id=\"current\""; print "><a href=\"$PATH/league-tables/competition:ryman-premier/\">Ryman Premier</a></li>";
			print "<li "; if ($PARM_COMPETITION == "ryman-north") 		print "id=\"current\""; print "><a href=\"$PATH/league-tables/competition:ryman-north/\">Ryman North</a></li>";
			print "<li "; if ($PARM_COMPETITION == "thurlow-nunn-premier") 	print "id=\"current\""; print "><a href=\"$PATH/league-tables/competition:thurlow-nunn-premier/\">Thurlow Nunn Premier</a></li>";
			print "$yearselect </ul></div><div id=\"submenuline\">&nbsp;</div></div>";
			print "<div style=\"width:100%; margin-right:5px;\"><div id=\"submenu\" style=\"\">";
			if ($PARAMETER2 == "daterange") { print "<div style=\"float:right\"><form action=\"$PATH/league-tables/competition:$PARM_COMPETITION/daterange/\" method=\"post\" style=\"margifn-top:5px\"><table cellpadding=0 cellspacing=0><tr><td>&nbsp;&nbsp;Date Range: </td><td><script>DateInput('ADate', true, 'DD-MON-YYYY', '{$PARM_FROMDATE}')</script></td><td> - </td><td><script>DateInput('BDate', true, 'DD-MON-YYYY', '{$PARM_TODATE}')</script></td><td><input type=submit value=\"Go\"></td></tr></table></form></div>"; }
			if ($PARAMETER2 == "form") { print "<div style=\"float:right\"><form action=\"$PATH/league-tables/competition:$PARM_COMPETITION/form/\" method=\"post\" style=\"margin-top:5px\">&nbsp;&nbsp;<input type=text name=\"matches\" style=\"width:15px\" value=$form> Matches <input type=\"radio\" name=\"venue\" value=\"t\" "; if ($PARM_TYPE == 'home-and-away') print " checked"; print ">Home & Away <input type=\"radio\" name=\"venue\" value=\"h\""; if ($PARM_TYPE == 'home') print " checked"; print "> Home only<input type=\"radio\" name=\"venue\" value=\"a\""; if ($PARM_TYPE == 'away') print " checked"; print ">Away only <input type=submit value=\"Go\"></form></div>"; }
			print "<ul>";
			print "<li "; if ($PARAMETER2 != "form" and $PARAMETER2 != "daterange") print "id=\"current\""; print "><a href=\"$PATH/league-tables/competition:$PARM_COMPETITION\" title=\"Current $divname League Table\">Current Table</a></li>";
			print "<li "; if ($PARAMETER2 == "form") print "id=\"current\""; print "><a href=\"$PATH/league-tables/competition:$PARM_COMPETITION/form/matches:6/type:home-and-away\" title=\"$divname form table\">Form Table</a></li>";
			print "<li "; if ($PARAMETER2 == "daterange") print "id=\"current\""; print "><a href=\"$PATH/league-tables/competition:$PARM_COMPETITION/daterange/fromdate:\" title=\"$divname table comprising of matches in a date range\">Date Range</a></li>";
			if (isset($PARM_MATCH)) print "</ul></div></div><div id=\"submenuline\">&nbsp;</div>\n"; else print "</ul></div></div><div style=\"clear:both;\"></div>\n";		
		} else {
			print "<li "; if ($PARM_COMPETITION == "premier-league") 	print "id=\"current\""; print "><a href=\"$PATH/league-tables/competition:premier-league/\">Premier League</a></li>\n";
			print "<li "; if ($PARM_COMPETITION == "championship") 		print "id=\"current\""; print "><a href=\"$PATH/league-tables/competition:championship/\">Championship</a></li>";
			print "<li "; if ($PARM_COMPETITION == "league-one") 		print "id=\"current\""; print "><a href=\"$PATH/league-tables/competition:league-one/\">League One</a></li>";
			print "<li "; if ($PARM_COMPETITION == "league-two") 		print "id=\"current\""; print "><a href=\"$PATH/league-tables/competition:league-two/\">League Two</a></li>";
			print "$yearselect </ul></div><div id=\"submenuline\">&nbsp;</div></div>";
			print "<div style=\"width:100%; margin-right:5px;\"><div id=\"submenu\" style=\"\">";
			if ($PARAMETER2 == "daterange") { print "<div style=\"float:right\"><form action=\"$PATH/league-tables/competition:$PARM_COMPETITION/daterange/\" method=\"post\" style=\"margifn-top:5px\"><table cellpadding=0 cellspacing=0><tr><td>&nbsp;&nbsp;Date Range: </td><td><script>DateInput('ADate', true, 'DD-MON-YYYY', '{$PARM_FROMDATE}')</script></td><td> - </td><td><script>DateInput('BDate', true, 'DD-MON-YYYY', '{$PARM_TODATE}')</script></td><td><input type=submit value=\"Go\"></td></tr></table></form></div>"; }
			if ($PARAMETER2 == "form") { print "<div style=\"float:right\"><form action=\"$PATH/league-tables/competition:$PARM_COMPETITION/form/\" method=\"post\" style=\"margin-top:5px\">&nbsp;&nbsp;<input type=text name=\"matches\" style=\"width:15px\" value=$form> Matches <input type=\"radio\" name=\"venue\" value=\"t\" "; if ($PARM_TYPE == 'home-and-away') print " checked"; print ">Home & Away <input type=\"radio\" name=\"venue\" value=\"h\""; if ($PARM_TYPE == 'home') print " checked"; print "> Home only<input type=\"radio\" name=\"venue\" value=\"a\""; if ($PARM_TYPE == 'away') print " checked"; print ">Away only <input type=submit value=\"Go\"></form></div>"; }
			print "<ul>";
			print "<li "; if ($PARAMETER2 != "form" and $PARAMETER2 != "daterange") print "id=\"current\""; print "><a href=\"$PATH/league-tables/competition:$PARM_COMPETITION\" title=\"Current $divname League Table\">Current Table</a></li>";
			print "<li "; if ($PARAMETER2 == "form") print "id=\"current\""; print "><a href=\"$PATH/league-tables/competition:$PARM_COMPETITION/form/matches:6/type:home-and-away\" title=\"$divname form table\">Form Table</a></li>";
			print "<li "; if ($PARAMETER2 == "daterange") print "id=\"current\""; print "><a href=\"$PATH/league-tables/competition:$PARM_COMPETITION/daterange/fromdate:\" title=\"$divname table comprising of matches in a date range\">Date Range</a></li>";
			if (isset($PARM_MATCH)) print "</ul></div></div><div id=\"submenuline\">&nbsp;</div>\n"; else print "</ul></div></div><div style=\"clear:both;\"></div>\n";		
		}		
		$highlight1 = $TEAM_NAME; $highlight2 = "";
	} else {
		$sql = "select PLG_HomeTeam, PLG_AwayTeam from Football_GA_Games where PLG_ID = " . mysql_real_escape_string($PARM_MATCH) . " limit 1";
		$res = mysql_query($sql);
		while ($row = mysql_fetch_array($res)) { $highlight1 = $row['PLG_HomeTeam']; $highlight2 = $row['PLG_AwayTeam']; }
		
		subMenu('league-table', $PARM_MATCH, 0);
	}
	print '<table width=100% cellpadding=0 cellspacing=0><tr><td valign=top>';

	print "<div style=\"text-align:right; padding: 5px 0 5px 20px;\"><img src=\"/images/competitions/$imgsrc\" style=\"height:50px\"></div><h1>$PAGE_TITLE</h1><table style=\"text-align:center; margin-top:5px\" cellspacing=0 cellpadding=3 class=\"leaguetable\">";
	print "<tr class=\"leaguetablehead\"><td width=20>Pos</td><td align=left>Team</td><td width=20>P</td><td width=5>&nbsp;</td><td width=20>W</td><td width=20>D</td><td width=20>L</td><td width=20>GF</td><td width=20>GA</td><td width=5>&nbsp;</td><td width=20>W</td><td width=20>D</td><td width=20>L</td><td width=20>GF</td><td width=20>GA</td><td width=5>&nbsp;</td><td width=20>GD</td><td width=20>Pts</td></tr>\n";
	$sql = "select *, (LG_HF + LG_AF) as GS from Football_LG_Leagues where LG_Season = '$PARM_SEASON' and LG_Type = 'L' and LG_League = '$div' order by LG_PTS desc, LG_GD desc, GS desc, LG_Team";
	if (isset($PARAMETER2) and $PARAMETER2 == "form") $sql = "select *, (LG_HF + LG_AF) as GS from Football_LG_Leagues where LG_Season = '$PARM_SEASON' and LG_Type = 'L' and LG_League = '$div' order by LG_PTS desc, LG_GD desc, GS desc, LG_Team";
	if (isset($PARAMETER2) and $PARAMETER2 == "daterange") $sql = "select *, (LG_HF + LG_AF) as GS from Football_LG_Leagues where LG_Season = '$PARM_SEASON' and LG_Type = 'L' and LG_League = '$div' order by LG_PTS desc, LG_GD desc, GS desc, LG_Team";
	$res = mysql_query($sql);
	$pos = 0;
	$cls = "";
	while ($row = mysql_fetch_array($res)) {
		$pos = $pos + 1;
		if ($cls != "r1") $cls = "r1"; else $cls = "r2"; 
		if ($row['LG_Team'] == $highlight1 or $row['LG_Team'] == $highlight2) $cls = "sel";
		print "<tr class=\"$cls\"><td>$pos</td><td class=\"teamname\"><a href=\"$PATH/$RESULTS/" . storyTitle($row['LG_Team']) . "\">{$row['LG_Team']}</td><td>{$row['LG_P']}</td><td>&nbsp;</td><td>{$row['LG_HW']}</td><td>{$row['LG_HD']}</td><td>{$row['LG_HL']}</td><td>{$row['LG_HF']}</td><td>{$row['LG_HA']}</td><td>&nbsp;</td><td>{$row['LG_AW']}</td><td>{$row['LG_AD']}</td><td>{$row['LG_AL']}</td><td>{$row['LG_AF']}</td><td>{$row['LG_AA']}</td><td>&nbsp;</td><td>{$row['LG_GD']}</td><td>{$row['LG_PTS']}</td></tr>\n";
	}
	print "</table>";
	
	print "</td><td valign=top width=160 style=\"padding-left:5px\">"; $adtype = "Skyscraper"; include("adserver.php"); echo '</td></tr></table>';

	$sql = "delete from Football_LG_Leagues where LG_Season = '{$_SERVER['REMOTE_ADDR']}'"; mysql_query($sql);

	include("fb_bottom.php");
?>