Miscellany

function viewreplay(){	// Connect	mysql_connect('')	or die('Could not connect: ' . mysql_error());	mysql_select_db('') or die('Could not select database');	// Grab Replay Details	$query = "SELECT * FROM Replays WHERE ReplayID LIKE " . $_GET['rid'];	$result = mysql_query($query);	$row = mysql_fetch_assoc($result);	// Replay Data Stored in $row :-)	// For Background colors :-)	if($row['Race1'] == GDI)	{	$color1 = "#FFCC33";	}	if($row['Race2'] == GDI)	{	$color2 = "#FFCC33";	}	if($row['Race1'] == NOD)	{	$color1 = "#FF0000";	}	if($row['Race2'] == NOD)	{	$color2 = "#FF0000";	}	if($row['Race1'] == Scrin)	{	$color1 = "#990099";	}	if($row['Race2'] == Scrin)	{	$color2 = "#990099";	}	if($row['Winner'] == 1)	{		$Winner = $row['Player1'];	}	if($row['Winner'] == 2)	{		$Winner = $row['Player2'];	}	$hits = $row['Hits'] + 1;	$query = "UPDATE Replays SET Hits = '" . $hits . "' WHERE ReplayID = '" . $_GET['id'] . "'";	mysql_query($query); 	?>	<div class="player1"><? echo $row['Player1']?></div>	<div class="player2"><? echo $row['Player2']?></div>	<div class="race1"><? echo $row['Race1']?></div>	<div class="race2"><? echo $row['Race2']?></div>	<div class="version"><? echo $row['version']?></div>	<div class="showwinner" onClick="alert('<? echo "$Winner"?>');">Show Winner</div>	<div class="description"><? echo $row['Description']?></div>	<div class="map"><? echo $row['Map']?></div>	<div class="mapimage"><? map()?></div>	<div class="download"><a href="<? echo $row['Filename']?>">Download</a></div>	<div class="hits"><? echo $row['Hits']?></div>	<div class="poster"><? echo $row['Uploader']?></div>	<?php	mysql_close(mysql_connect(''));}function map(){switch ($map){case "Backwater Brawl":echo "<img src=\"map_previews/Backwater_Brawl.jpg\">";break;case "Barstow Badlands":echo "<img src=\"map_previews/Barstow_Badlands.jpg\">";break;case "Blacks Pig Battle":echo "<img src=\"map_previews/Blacks_Big_Battle.jpg\">";break;case "Bordertown Beatdown":echo "<img src=\"map_previews/Bordertown_Beatdown.jpg\">";break;case "Crater Of Carnage":echo "<img src=\"map_previews/Crater_Of_Carnage.jpg\">";break;case "Dead Six":echo "<img src=\"map_previews/Dead_Six.jpg\">";break;case "Deadly Sertao":echo "<img src=\"map_previews/Deadly_Sertao.jpg\">";break;case "Downtown Dustbowl":echo "<img src=\"map_previews/Downtown_Dustbowl.jpg\">";break;case "Pipeline Problems":echo "<img src=\"map_previews/Pipeline_Problems.jpg\">";break;case "Redzone Rampage":echo "<img src=\"map_previews/Redzone_Rampage.jpg\">";break;case "Riverside Rumble":echo "<img src=\"map_previews/Riverside_Rumble.jpg\">";break;case "Six Shooter Showdown":echo "<img src=\"map_previews/Six_Shooter_Showdown.jpg\">";break;case "Small Town USA":echo "<img src=\"map_previews/Small_Town_USA.jpg\">";break;case "The Battle For Middle Egypt":echo "<img src=\"map_previews/The_Battle_For_Middle_Egypt.jpg\">";break;case "The Rocktagon":echo "<img src=\"map_previews/The_Rocktagon.jpg\">";break;case "Tournament Arena":echo "<img src=\"map_previews/Tournament_Arena.jpg\">";break;case "Tournament Dustbowl":echo "<img src=\"map_previews/Tournament_Dustbowl.jpg\">";break;case "Tournament Tower":echo "<img src=\"map_previews/Tournament_Tower.jpg\">";break;case "Triple Threat":echo "<img src=\"map_previews/Triple_Threat.jpg\">";break;case "Unfair Advantage":echo "<img src=\"map_previews/Unfair_Advantage.jpg\">";break;}}