From f65cf9406397ac688ec4060ba070e172af0cd90b Mon Sep 17 00:00:00 2001
From: Patrick Davison <snapwilliam@gmail.com>
Date: Thu, 14 Feb 2013 00:42:29 -0800
Subject: Lots'n Lots of work on the scoreboard...

---
 pages/scores.php | 644 +++++++++++++++----------------------------------------
 1 file changed, 167 insertions(+), 477 deletions(-)

(limited to 'pages/scores.php')

diff --git a/pages/scores.php b/pages/scores.php
index 43bc7dc..118dfa7 100644
--- a/pages/scores.php
+++ b/pages/scores.php
@@ -45,7 +45,8 @@ $datePrevDay = date('Y-m-d', strtotime("-1 day", $dateAgo));
 if ($daysAgo < 1)
 	die("You must specify a date previous to today.");
 
-
+//!! TODO: 
+$timeUntilNewDailyMap = strtotime("tomorrow") - strtotime("now");
 ?>
 
 <script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
@@ -59,44 +60,60 @@ playerWallEmblem = '<?PHP echo isset($wallEmblem) ? $wallEmblem : ''; ?>';
 <script>
 
 
-//Contra
-$(document).bind('keystrokes', {
-keys: ['arrow up', 'arrow up', 'arrow down', 'arrow down', 'arrow left', 'arrow right', 'arrow left', 'arrow right', 'b', 'a', 'enter']
-}, function(){
-alert('You unlocked awesomeness!');
-});
+var tomorrow = new Date();
+tomorrow.setTime(tomorrow.getTime() + <? echo $timeUntilNewDailyMap; ?> * 1000);
+var serverTomorrow = '<? echo $dateNextDay; ?>';
 
+var serverTime = new Date();
+serverTime.setTime(<? echo time() * 1000; ?>);
 
-var daysAgo = <? echo $daysAgo; ?>;
+var pointerTime = new Date();
+pointerTime.setTime(serverTime.getTime())
 
-$.ajaxSetup ({  
-	cache: false  
-});
-var ajax_load = "<img src='images/loading.gif' alt='loading...' />";  
-//  load() functions  
-var loadUrl = "ajax/load.php";
 
-$("#load_basic").click(function(){
-	$("#result").html(ajax_load).load(loadUrl);  
-});  
+setTimeout("start();", 500);
 
-var loadUrl = "ajax/load.php";
+var pointerMapID = -1;
+var goToPointer = true;
+function start() {
+	var hash = window.location.hash.substring(1);
+	console.log("HASH:", hash);
+	if (hash !== '') {
+		hashParts = hash.split('_')
+		dateSplit = hashParts[0].split("-");
+		if (typeof(hashParts[1]) !== 'undefined') {
+			pointerMapID = hashParts[1];
+		}
+		//+1 because i'm gonna use prev.
+		pointerTime = new Date(dateSplit[0],dateSplit[1]-1,dateSplit[2]-0+1);
+	} 
+	getMapIDs('prev');
+}
+//$(window).on('hashchange', function() {
 
-$("#load_basic").click(function(){  
-  $("#result").html(ajax_load).load(loadUrl);
+//Contra
+$(document).bind('keystrokes', {
+keys: ['arrow up', 'arrow up', 'arrow down', 'arrow down', 'arrow left', 'arrow right', 'arrow left', 'arrow right', 'b', 'a', 'enter']
+}, function(){
+alert('You unlocked awesomeness!');
 });
 
-
-function displayMap(mapID) {
-	//var urlString = 'ajax/scores.ajax.php?getmap=true&mapID='+mapID;
-	var urlString = 'map/'+mapID;
+function displayMap(mapID, divID, goalSize) {
 	$("#mapDisplay").fadeOut('fast');
-	//.html(ajax_load)
-	
-	//$("#mapDisplay").load(urlString, null, function() {$("#mapDisplay").fadeIn('slow');}); 
-	//urlString = 'do.php?r=reqScorePage&reqPage=1&mapID='+mapID;
-	//$("#scoreDisplay").html(ajax_load).load(urlString); 
-	
+	$.ajax({
+		type: "GET",  
+		url: 'map/'+mapID+".js",
+		cache: true,
+		data: '', 
+		//TODO: Better fail option?
+		fail: (function() { console.log("FAIL Map Download"); }),
+		complete: function(data) {$("#"+divID).html(mapAsHTML(decryptJSON(data.responseText), goalSize)).fadeIn('slow');}
+	});
+}
+
+function displayMapScores(mapID) {
+	pointerMapID = mapID;
+	updateHash();
 	if (!$('#'+mapID+',dspScore').length) {
 		var newDiv = $('<div/>', {
 			'id': mapID+',dspScore',
@@ -105,89 +122,116 @@ function displayMap(mapID) {
 		$('#scoreDisplay').empty();
 		newDiv.prependTo('#scoreDisplay');
 	}
-	scoresShowPage(mapID, 1);
-	
-	$.ajax({
-		type: "GET",  
-		url: 'map/'+mapID,  
-		data: '', 
-		success: function(data) {$("#mapDisplay").html(mapAsHTML(decryptJSON(data), 595)).fadeIn('slow');}
-	});
-		// var newDiv = $('<div/>', {
-		// 'id': mapID+',dspScore',
-		// 'class': 'my-new-list',
-		// 'style': 'display: none',
-		// html: ''
-	// });
+	scoresShowPage(1, mapID);
+	displayMap(mapID, "mapDisplay", 595);
 }
 
-//TODO:
-function getMapOnce(mapid) {
-	if (typeof(mapdata[mapid]) != 'object') {
-		return mapdata[mapid];
-	}
-}
 
-// function request_path_done() {
-	// var JO = decryptJSON(ajax.response);
-// }
+function updateHash() {
+	var tmp = document.location + '';
+	tmp = tmp.split("#");
+	var anchorTag = tmp[0]+'#'+pointerDate;
+	anchorTag += "_"+pointerMapID;
+	document.location=anchorTag;
+}
 
-function getMaplist(request) {
-	// daysAgo++
+var pointerDate;
+function getMapIDs(request) {
+	console.log("getMapIDs exe", request);
+	
+	pointerDate = request;
 	switch (request) {
 		case "next":
-		if (daysAgo <= 1)
+		if (pointerTime.getTime() + (24*60*60*1000) > serverTime.getTime()) {
+			alert("Tomorrow hasn't happened yet. Alerts are bad. - TMP!");
 			return;
-		daysAgo--;
+		}
+		pointerTime.setTime(pointerTime.getTime() + (24*60*60*1000));
+		pointerDate = pointerTime.format("yyyy-mm-dd");
 		break;
 		case "prev":
-		daysAgo++;
-		break;
-		case "yesterday":
-		if (daysAgo == 1)
+		
+		if (pointerTime.getTime() - (24*60*60*1000) > serverTime.getTime()) {
+			alert("Tomorrow hasn't happened yet. Alerts are bad. - TMP!");
 			return;
-		daysAgo = 1;
+		}
+		pointerTime.setTime(pointerTime.getTime() - (24*60*60*1000));
+		pointerDate = pointerTime.format("yyyy-mm-dd");
 		break;
 	}
 	
-	var urlString = 'ajax/scores.ajax.php?getmaplist=true&daysago='+daysAgo;
-	$("#mapNavigation").hide('fast');
-	//.html(ajax_load)
-	$("#mapNavigation").load(urlString, null, function() {$("#mapNavigation").show('slow');}); 
+	console.log("setting showdate");
+	$('#displayDate').html(pointerTime.format("dddd, mmmm ddS, yyyy"));
+	
+	var urlString = "ajax/scores.ajax.php?getmapidsbydate="+pointerDate;
+	
+	updateHash();
+
+	$.ajax({
+		type: "GET",  
+		url: urlString,
+		cache: true,
+		data: '', 
+		fail: function() { alert("error"); },
+		complete: function(data) {getMapIDsResponse(data.responseText);}
+	});
 }
 
-//TODO
-function handleJSONResponse(data) {
-	json = jQuery.parseJSON(data);
-	// $.each(json, function(key, user) {
+var mapsInNav = new Array();
+function getMapIDsResponse(response) {
+	var json = decryptJSON(response);
 	
-	// }
+	//Delete removed maps
+	//console.log("going through mapsInNav", mapsInNav);
+	mapsInNav = $.grep(mapsInNav, function(mapID, key) {
+		console.log("del: compare:", key, mapID, json, jQuery.inArray(mapID, json));
+		if (jQuery.inArray(mapID, json) < 0 && typeof(mapID) != 'undefined') {
+			removeMapFromNav(mapID);
+			return false
+		} else return true;
+	});
+	
+	//Add non-existing maps
+	//console.log("going through json", json);
+	$.each(json, function(key, mapID) {
+		//console.log("add: compare:", mapID, mapsInNav);
+		if (jQuery.inArray(mapID, mapsInNav) == -1) {
+			addMapToNav(mapID);
+			if (goToPointer == true && pointerMapID < 0) {
+				pointerMapID = mapID;
+			}
+		}
+	});
+	
+	if (goToPointer == true) {
+		goToPointer = false;
+		displayMapScores(pointerMapID);
+	}
 }
 
+function addMapToNav(mapID) {
+	//console.log("adding map to nav:", mapID);
+	var $newdiv1 = $("<div style='float:left;' id='thumb_"+mapID+"'/>");
 
-// var global = getCSSRule('.global');
-
-//TODO: Playing around with this:
-//setPlayerSettings(playerWallEmblem, playerWallColor);
-//function setPlayerSettings(wallEmblem, wallColor) {
-	//css(".playable .o:hover", "background-color", playerWallColor);
-	//css(".playable .o:hover", "background-image", "url(http://www.mazetd.4xg.net/images/marks/"+wallEmblem+")");
-//}
-// function css(selector, property, value) {
-    // for (var i=0; i<document.styleSheets.length;i++) {//Loop through all styles
-        // //Try add rule
-        // try { document.styleSheets[i].insertRule(selector+ ' {'+property+':'+value+'}', document.styleSheets[i].cssRules.length);
-        // } catch(err) {try { document.styleSheets[i].addRule(selector, property+':'+value);} catch(err) {}}//IE
-    // }
-// }
-
-
-
-
-
-//alert("I'm working on this page right now - this IS beta");
+	$("#mapNavigation").append($newdiv1);
+	
+	$.ajax({
+		type: "GET",  
+		url: 'map/'+mapID,
+		cache: true,
+		data: '', 
+		fail: function() { alert("error"); },
+		complete: function(data) {
+			$("#thumb_"+mapID).html(mapThumbnailHTML(decryptJSON(data.responseText), 100)).show('slow');
+		}
+	});
+	mapsInNav.push(mapID);
+}
 
-var mymap = {"ID":502,"teleports":0,"checkpoints":4,"width":"15","height":"9","walls":"13","name":"","flags":null,"dateCreated":null,"dateExpires":null,"isBlind":false,"isMultiPath":false,"code":null,"tiles":[[["s",""],["o"],["o"],["o"],["r",""],["o"],["o"],["o"],["o"],["o"],["o"],["r",""],["o"],["o"],["f",""]],[["s",""],["r",""],["o"],["r",""],["o"],["o"],["o"],["c",3],["r",""],["c",2],["o"],["o"],["o"],["o"],["f",""]],[["s",""],["o"],["o"],["o"],["o"],["o"],["o"],["o"],["r",""],["o"],["o"],["o"],["o"],["o"],["f",""]],[["s",""],["o"],["o"],["o"],["o"],["o"],["o"],["o"],["o"],["o"],["o"],["o"],["o"],["o"],["f",""]],[["s",""],["o"],["o"],["r",""],["o"],["o"],["o"],["o"],["r",""],["o"],["r",""],["o"],["o"],["o"],["f",""]],[["s",""],["o"],["r",""],["r",""],["o"],["o"],["r",""],["r",""],["o"],["o"],["o"],["o"],["o"],["o"],["f",""]],[["s",""],["o"],["o"],["c",4],["r",""],["r",""],["o"],["c",""],["o"],["o"],["o"],["o"],["o"],["o"],["f",""]],[["s",""],["o"],["o"],["o"],["o"],["o"],["o"],["o"],["r",""],["o"],["o"],["o"],["o"],["o"],["f",""]],[["s",""],["o"],["o"],["o"],["o"],["o"],["o"],["o"],["o"],["o"],["o"],["o"],["o"],["o"],["f",""]]]};
+function removeMapFromNav(mapID) {
+	console.log("remove map:", mapID, mapsInNav.indexOf(mapID));
+	$("#thumb_"+mapID).hide('fast', function(){ $("#thumb_"+mapID).remove(); });
+}
 
 var Tile = {"Wall" : "w",
 "Empty" : "o",
@@ -200,424 +244,70 @@ var Tile = {"Wall" : "w",
 "Unbuildable" : "o",
 "SinglePath" : "o"};
 
-
-function mapThumbnailHTML(map) {
-	var r = '<table class="map">';
+function mapThumbnailHTML(map, targetWidth) {
+	var r = '';
+	r += "<div class='mapThumbnail' onclick='displayMapScores("+map.ID+")'>";
+	r += map.name;
+	
+	if (!targetWidth) targetWidth = 100;
+	var scale = map.width / targetWidth;
+	
+	var width = parseInt(map.width / scale);
+	var height = parseInt(map.height / scale);
+	var tileWidth = parseInt(width / map.width);
+	
+	width = tileWidth * map.width;
+	
+	var mapgrid = '';
+	
+	mapgrid += '<div class="map" style="width:'+width+'px; height:'+height+'px">';
 	for (var y in map.tiles) {
-		r += '<tr>';
 		for (var x in map.tiles[y]) {
 			var type = map.tiles[y][x][0];
 			var value = map.tiles[y][x][1];
 			if (!value) value = '';
-			r += "<td class='"+type+value+"'>";
-			r += '</td>';
+		
+			mapgrid += "<div style='float:left; width:"+tileWidth+"px; height:"+tileWidth+"px; ' class='mapcell "+type+value+"'>";
+			mapgrid += "</div>";
 		}
-		r += '</tr>';
 	}
-	r += '</table>';
-	
-	//return r;
+	mapgrid += '</div>';
 	
-	//alert(r);
+	r += mapgrid;
+	r += '</div>';
 	
-	//$("#tmp").html(r).show('slow');; 
-	//$("#tmp").html(mapAsHTML(map,100)).show('slow');; 
+	return r;
 }
 
-
-
 </script>
-
-
 <body>
 
 <?php
 topbar($Links);
-
-
-
-$todaysScoreMaps = getMapsPlayed($daysAgo);
-
 ?>
 
 <div class="wrapper">
 
-<div id='tmp'>
-Work in progress
-</div>
-
-<div id='#displayDate' style='text-align:center;padding-bottom:7px;'>
-<h2 title='Maps that were played during this day'><? echo $dateAsStr; ?></h2>
+<div style='font-size: 105%;text-align:center;padding-bottom:7px;' id='displayDate'>
+Loading...
 </div>
 
 <div id="daynav">
-<a href='javascript:getMaplist("prev");' title='Older'>&lt; Previous Day</a>
-<a href='javascript:getMaplist("next");' title='Newer'>Next Day &gt;</a>
-<a href='javascript:getMaplist("yesterday");' title='Now'>Yesterday &gt;&gt;</a>
 <div class='mapNavCon'>
-	<div class='mapNavLeft mapNavBtn' onclick='$("#mapNavigation").scrollLeft(0)'>&lt;</div>
-	<div class='mapNavRight mapNavBtn' onclick='$("#mapNavigation").scrollLeft(1000)'>&gt;</div>
+	<div class='mapNavLeft mapNavBtn' onclick='javascript:getMapIDs("prev");'>&lt;</div>
+	<div class='mapNavRight mapNavBtn' onclick='javascript:getMapIDs("next");'>&gt;</div>
 	<div class='mapNavCenter'>
 		<div id='mapNavigation'>
-		<? echo getMapNavigation($todaysScoreMaps); ?>
+		Loading...
 		</div>
 	</div>
 </div>
 <div style='clear:both'></div>
 <?
 
-	
-function getMapsPlayed($daysAgo) {
-	$sql = "
-	SELECT `mapID`, `code`, `mapType`
-	FROM `mapOfTheDay`
-	INNER JOIN `maps` ON `mapID` = maps.ID
-	WHERE DATE_ADD(CURDATE(), INTERVAL -$daysAgo DAY) =    
-	mapDate AND
-	`mapType` IN (1, 2, 3, 4)
-	";
-	$result = mysql_query($sql) or die(mysql_error());
-	if (mysql_num_rows($result) == 0)
-		return -1;
-	global $mapNamesByType;
-	$r = array();
-	while($data = mysql_fetch_array($result)) {
-		$code = $data['code'];
-		$mapID = $data['mapID'];
-		$mapType = $data['mapType'];
-		$map = new map($code);
-		if ($map->name == '')
-			$map->name = $mapNamesByType[$mapType];
-		$r[$mapID] = $map;
-
-	}
-	return $r;
-}
-
-
-function getMapNavigation(&$maps) {
-	foreach ($maps as $mapID => &$map) {
-		$r .= "<div class='mapThumbnail' onclick='displayMap($mapID)'>";
-		$r .= $map->name;
-		$r .= DisplayMapThumbnail($map);
-		$r .= "</div>";;
-	}
-	return $r;
-}
-
-
-
-$time_start = microtime(true);
-
-
-$special = 'Special';
-if ($specialMapName != '')
-	$special = $specialMapName;
-
-?>
-</div>
-
-	<div style="clear: both"></div>
-	<div id=\"yms-$mapType\">
-	
-		<div id='scoreDisplay' class="col1">
-
-		</div>
-
-		<div id='mapDisplay' style='display:none' class="col2">
-
-		</div>
-	</div>
-
-<?
-
-
-//echo $statContent;
-
-
-
-
-?>
-
-<div style="clear: both"></div>
-
-<!-- 
-<div id="yms-5">
-	<div class="col1">
-		<? echo $tStats;?>
-	</div>
-	<div class="col2">
-		<? echo $yStats;?>
-	</div>
-</div>
-
-<div id="yms-6">
-	<div class="col1">
-		<? echo $wStats;?>
-	</div>
-	<div class="col2">
-		<? echo $mStats;?>
-	</div>
-</div>
--->
-
-<br class="clear">
-</div>
-
-<script>
-
-
-
-//function showStats(type) {
-	//super usefulll
-	//var anchor = window.location.hash.substring(1);
-	
-	// for (var i = 1; i <= 4; i++) {
-		// var elem = document.getElementById("yms-" + i);
-		// if (elem.className.indexOf('hidden-stats') < 0)
-			// elem.className += 'hidden-stats';
-		// elem = document.getElementById("dl-" + i);
-		// elem.className = elem.className.replace('selected', '');
-	// }
-	// elem = document.getElementById("yms-" + type);
-	// elem.className = elem.className.replace('hidden-stats', '');
-	// elem = document.getElementById("dl-" + type);
-	// if (elem.className.indexOf('selected') < 0)
-		// elem.className += 'selected';
-// }
-// showStats(1);
-</script>
-
 <script src="sounds/script/soundmanager.js"></script>
 <script type="text/javascript">soundManagerInit();</script>
 
 <?php
-
-
-
-
 htmlFooter();
-
-//TODO !! DELETE FUNCTIONS WHEN DONE!!
-function mysql_field_array( $query ) {
-	$field = mysql_num_fields( $query );
-	for ( $i = 0; $i < $field; $i++ ) {
-		$names[] = mysql_field_name( $query, $i );
-	}
-	return $names;
-}
-function displaystats($result, $caption = NULL) {
-	//Get names.
-	$headers = "<tr class='leaderboardHeaders'>";
-	$headers .= "<th class='leaderboardHeadersRank'>Rank</th>";
-	$headers .= "<th class='leaderboardHeadersName'>Name</th>";
-	$headers .= "<th class='leaderboardHeadersMoves'>Moves</th>";
-	$headers .= "<th class='leaderboardHeadersTime'>Time taken</th>";
-	$headers .= "</th>";
-	//Start table
-	//$r .= "<table style='border:1px solid #FFF'>";
-	//$r .= "<caption>$caption</caption>";
-	//Headers on the top. including Rank.
-	//$r .= "<tr>";
-	//$r .= $headers;
-	//$r .= "</tr>";
-
-	$i = 1;
-	$championPoints = null;
-	while ($row = mysql_fetch_assoc($result)) {
-		$rowcontent = '';
-		$mapid = $row['mapID'];
-		$solution = $row['solution'];
-		$wallColor = $row['wallColor'];
-		$wallEmblem = $row['wallEmblem'];
-		$displayColor = $row['displayColor'];
-		$displayName = $row['Name'];
-		$userID = $row['userID'];
-
-		//Default
-		if ($wallColor == '')
-			$wallColor = '#666666';
-		
-		$x = "<tr class='lbrow' onmouseover='changeWallEmblem(\"$wallEmblem\"); changeWallColor(\"$wallColor\"); loadSol(\"$mapid:$solution\");'>\n";
-		$x .= "<td>$i</td>";
-		$x .= "<td class='leaderboardName'><span title='UserID: $userID'><a href='achievements?id=$userID' style='color:$displayColor'>$displayName</a></span></td>";
-		//$x .= "<td style='color:$displayColor';>" . $row['Name'] . '</td>';
-		$x .= '<td><a href="javascript:void(0)">' . $row['Moves'] . '</a></td>';
-		$x .= '<td>' . $row['Timetaken'] . '</td>';
-		$x .= "</tr>";
-		
-		if ($userID == $_SESSION['userID']) {
-			$promotedContent .= $x;
-			$championPoints = $row['championPointsWorth'];
-		} else {
-			$content .= $x;
-		}
-
-		$i++;
-	}
-	
-	$r = '';
-	if($championPoints != null && $championPoints > 0)
-	{
-		$r .= "<div class='myPoints'>Points earned: <span class='myPointsValue'>$championPoints</span> <img src='../images/championpoints.png' width='16px' height='16px'></img></div>";
-	}
-	$r .= "<table style='border:1px solid #FFF'>";
-	$r .= "<caption>$caption</caption>";
-	$r .= $headers;
-	$r .= $promotedContent;
-	$r .= $content;
-	
-	$r .= "</table>";
-	return $r;
-}
-
-function day_diff($date1, $date2) {
-    $current = $date1;
-    $datetime2 = date_create($date2);
-    $count = 0;
-    while(date_create($current) < $datetime2){
-        $current = gmdate("Y-m-d", strtotime("+1 day", strtotime($current)));
-        $count++;
-    }
-    return $count;
-}
-
-
-function getStat ($type, $daysAgo = 1) {
-	switch ($type) {
-
-		//Todays
-		case 1:
-		$where = "
-		DATE_ADD(CURDATE(), INTERVAL -0 DAY) =
-		DATE_FORMAT(solutions.dateModified,'%Y-%m-%d')
-		AND DATE_ADD(CURDATE(), INTERVAL -0 DAY) =
-		DATE_FORMAT(maps.dateCreated,'%Y-%m-%d')
-		";
-		$statname = "Today's Best Overall:";
-		break;
-		//Yesterdays
-		case 2:
-		$where = "
-		DATE_ADD(CURDATE(), INTERVAL -$daysAgo DAY) =
-		DATE_FORMAT(solutions.dateModified,'%Y-%m-%d')
-		AND DATE_ADD(CURDATE(), INTERVAL -$daysAgo DAY) =
-		DATE_FORMAT(maps.dateCreated,'%Y-%m-%d')
-		";
-		$statname = "Yesterday's Best Overall:";
-		if ($daysAgo > 1) {
-			$statname = "$daysAgo days ago's Best Overall.";
-		}
-		break;
-		case 3:
-		$where = "
-		YEARweek(solutions.dateModified) = YEARweek(CURRENT_DATE)
-		";
-		$statname = "This week, starting Sunday";
-		break;
-		case 4:
-		$where = "
-		( month(solutions.dateModified) = month(CURRENT_DATE) AND year(solutions.dateModified) = year(CURRENT_DATE) )
-		";
-		$statname = "This month's Best";
-		break;
-	}
-
-	$sql = "SELECT
-		users.displayName as Name,
-		SUM(solutions.moves) as Moves,
-		timediff(MAX(dateModified), maps.dateCreated) as Timetaken,
-		users.wallColor,
-		users.wallEmblem,
-		users.displayColor,
-		users.ID as userID,
-		SUM(CASE WHEN solutions.dateModified < CURDATE()
-		    THEN solutions.championPointsWorth
-			ELSE 0 END) AS championPointsWorth
-	FROM `maps`
-	JOIN `solutions`
-		ON maps.ID = solutions.mapID
-	JOIN `users`
-		ON solutions.userID = users.ID
-	WHERE $where
-	GROUP BY solutions.userID
-	ORDER BY Moves DESC, MAX(dateModified) ASC
-	";
-	$result = mysql_query($sql);
-	return displayStats($result, $statname);
-}
-
-function displayPastMaze($mapType, $name, $daysAgo = 1) {
-	//Ensure no cheating
-	if ($daysAgo < 1)
-		return;
-
-	$pastMap = pastMap($mapType, $daysAgo);
-	$mapID = $pastMap;
-	$mapcode = getMapCode($mapID);
-	$map = GenerateMapByCode($mapcode);
-	
-	$sql = "SELECT
-		maps.ID as mapID,
-		solution,
-		users.displayName as Name,
-		SUM(solutions.moves) as Moves,
-		timediff(solutions.dateModified, maps.dateCreated) as Timetaken,
-		users.wallColor,
-		users.wallEmblem,
-		users.displayColor,
-		users.ID as userID,
-		solutions.championPointsWorth
-	FROM `maps`
-	JOIN `solutions`
-		ON maps.ID = solutions.mapID
-	JOIN `users`
-		ON solutions.userID = users.ID
-	JOIN `mapOfTheDay`
-		ON maps.ID = mapOfTheDay.mapID
-	WHERE 
-		 maps.ID = '$mapID'
-	GROUP BY solutions.userID
-	ORDER BY Moves DESC, `dateModified` ASC
-	";
-	
-	$result = mysql_query($sql) or die(mysql_error());
-	
-	$statname = "Yesterday's Best $name:";
-	if ($daysAgo > 1) {
-		$statname = "$daysAgo days ago's Best $name:";
-	}
-	$stats = displayStats($result, $statname);
-
-	//Sucky temporary solution:
-	$GLOBALS['specialMapName'] = $map[0][6];
-
-	$sql = "SELECT `moves`, `displayName`, `solution`
-		FROM `solutions`
-		LEFT JOIN `users`
-			ON solutions.userID = users.ID
-		WHERE `mapID` = '$mapID'
-		ORDER BY `moves` DESC, `dateModified` ASC
-		LIMIT 1";
-	$result = mysql_query($sql) or die(mysql_error());
-	if (mysql_num_rows($result) > 0) {
-		list($bestMoves, $byName, $solution) = mysql_fetch_row($result);
-	}
-	$r = '';
-
-	$r .=  '<div style="clear: both"></div>';
-	$r .=  "<div id=\"yms-$mapType\">";
-	$r .=  '<div class="col1">';
-	$r .=  $stats;
-	$r .=  '</div>';
-
-	$r .=  '<div class="col2">';
-	$r .=  "Best solution for this map: <b>$bestMoves by $byName </b>";
-	$r .=  DisplayMap($map, $mapID, 'normal', 2);
-	$r .=  '</div>';
-	$r .=  '</div>';
-	return $r;
-}
-
-
-?>
+?>
\ No newline at end of file
-- 
cgit v1.2.3