<?php

$urlname = $_GET['team'];
$match = $_GET['match'];

if (($urlname == "kitbag") and ($match == "home")) {

			$location = "http://www.awin1.com/cread.php?awinmid=686&awinaffid=46526&clickref=Banner_Kitbag&p=http://www.kitbag.com/stores/kitbag/en/c/football";
			header('Location: ' . $location);
}

elseif ($urlname && $match) { 

					// connect to database
					$connection = mysql_connect("localhost", "ianmonta_sql", "e6{6lw[b+G;r") or die("Failed to connect to database");

					// select database
					mysql_select_db("ianmonta_footballbet",$connection) or die("Failed to database connection");

					// find link by urlname & match

					if ($match == "home")
						 { 

							$topdetails = "select homelink from locks where teamurl = '$urlname'";
							$topresult = mysql_query($topdetails,$connection) or die("Error in $topdetails search");
							while($topdata = mysql_fetch_array($topresult)) 
								{
							extract($topdata);
							$location = "http://www.awin1.com/cread.php?awinmid=686&awinaffid=46526&clickref=1516_Home_" . $urlname . "&p=" . $homelink;
							header('Location: ' . $location); 
								}

						}
					elseif ($match == "away")
						 { 

							$topdetails = "select awaylink from locks where teamurl = '$urlname'";
							$topresult = mysql_query($topdetails,$connection) or die("Error in $topdetails search");
							while($topdata = mysql_fetch_array($topresult)) 
								{
							extract($topdata);
							$location = "http://www.awin1.com/cread.php?awinmid=686&awinaffid=46526&clickref=1516_Away_" . $urlname . "&p=" . $awaylink;
							header('Location: ' . $location); 
								}
						}

					elseif ($match == "third")
						 { 

							$topdetails = "select thirdlink from locks where teamurl = '$urlname'";
							$topresult = mysql_query($topdetails,$connection) or die("Error in $topdetails search");
							while($topdata = mysql_fetch_array($topresult)) 
								{
							extract($topdata);
							$location = "http://www.awin1.com/cread.php?awinmid=686&awinaffid=46526&clickref=1516_Third_" . $urlname . "&p=" . $thirdlink;
							header('Location: ' . $location); 
								}
						}

}
elseif ($match == "retro") {

			$location = "http://www.awin1.com/cread.php?awinmid=686&awinaffid=46526&clickref=Retro_Kitbag&p=http://www.kitbag.com/stores/kitbag/en/c/football/retro-lounge";
			header('Location: ' . $location);
}
elseif ($urlname == "kitbag") {

			$location = "http://www.awin1.com/cread.php?awinmid=686&awinaffid=46526&clickref=Banner_Kitbag&p=http://www.kitbag.com/stores/kitbag/en/c/football";
			header('Location: ' . $location);
}

elseif ($urlname == "lovell") {

			$location = "http://www.awin1.com/cread.php?awinmid=2518&awinaffid=46526&clickref=Banner_Lovell&p=http://www.lovellsoccer.co.uk/Football-Replica-Shirts";
			header('Location: ' . $location);
}


else {

?>Sorry but that isn't allowed!<?php

}