From 4dfa3bb62317d1268eaf84b94fd19c97e36e1796 Mon Sep 17 00:00:00 2001
From: Patrick Davison <snapwilliam@gmail.com>
Date: Fri, 18 Nov 2011 23:10:14 -0800
Subject: Leaderboard can now show further back than yesterday.

---
 pages/leaderboard.php | 67 +++++++++++++++++++++++++++++++++++++++------------
 1 file changed, 51 insertions(+), 16 deletions(-)

(limited to 'pages/leaderboard.php')

diff --git a/pages/leaderboard.php b/pages/leaderboard.php
index 290f23b..13f5518 100644
--- a/pages/leaderboard.php
+++ b/pages/leaderboard.php
@@ -13,14 +13,22 @@ include('./includes/datas.php');
 
 include_once ('./includes/db.inc.php');
 
-$tStats = getStat(1);
-$yStats = getStat(2);
+//Display stats for how many days ago?
+$daysago = 1;
+if (($_GET['daysago'] * 1) > 1) {
+	$daysago = ($_GET['daysago'] * 1);
+}
+
+
+
+$tStats = getStat(1, $daysago);
+$yStats = getStat(2, $daysago);
 
-$wStats = getStat(3);
-$mStats = getStat(4);
+$wStats = getStat(3, $daysago);
+$mStats = getStat(4, $daysago);
 
 
-function getStat ($type) {
+function getStat ($type, $daysago = 1) {
 	switch ($type) {
 	
 		//Todays
@@ -36,12 +44,15 @@ function getStat ($type) {
 		//Yesterdays
 		case 2:
 		$where = "
-		DATE_ADD(CURDATE(), INTERVAL -1 DAY) =	
+		DATE_ADD(CURDATE(), INTERVAL -$daysago DAY) =	
 		DATE_FORMAT(solutions.dateModified,'%Y-%m-%d')
-		AND DATE_ADD(CURDATE(), INTERVAL -1 DAY) =	
+		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 = "
@@ -78,6 +89,19 @@ function getStat ($type) {
 
 <div class="wrapper">
 
+
+<div id="daynav">
+<?
+if ($daysago > 1) {
+	$nextday = $daysago - 1;
+	echo "<a href='?page=leaderboard&daysago=1' title='Now'>Current Day</a>";
+	echo "<a href='?page=leaderboard&daysago=$nextday' title='Newer'>Next Day</a>";
+}
+	$prevday = $daysago + 1;
+	echo "<a href='?page=leaderboard&daysago=$prevday' title='Older'>Previous Day</a>";
+?>
+</div>
+	
 <div id="difficulties">
 <a href="javascript:showStats(0)" id="dl-0">Overall</a>
 <a href="javascript:showStats(1)" id="dl-1">Simple</a>
@@ -97,7 +121,11 @@ function getStat ($type) {
 </div>
 
 <?
-function yesterdayMaze($mapType, $name) {
+function displayPastMaze($mapType, $name, $daysago = 1) {
+	//Ensure no cheating
+	if ($daysago < 1)
+		return;
+	
 	$sql = "SELECT 
 		maps.ID as mapID,
 		solution,
@@ -111,19 +139,24 @@ function yesterdayMaze($mapType, $name) {
 		ON solutions.userID = users.ID
 	JOIN `mapOfTheDay`
 		ON maps.ID = mapOfTheDay.mapID
-	WHERE DATE_ADD(CURDATE(), INTERVAL -1 DAY) =	
+	WHERE DATE_ADD(CURDATE(), INTERVAL -$daysago DAY) =	
 		DATE_FORMAT(solutions.dateModified,'%Y-%m-%d')
-		AND DATE_ADD(CURDATE(), INTERVAL -1 DAY) =	
+		AND DATE_ADD(CURDATE(), INTERVAL -$daysago DAY) =	
 		DATE_FORMAT(maps.dateCreated,'%Y-%m-%d')
 		AND `mapType` = '$mapType'
 	GROUP BY solutions.userID
 	ORDER BY Moves DESC, `dateModified` ASC
 	";
 	$result = mysql_query($sql);
-	$stats = displayStats($result, "Yesterday's Best $name:");
+	
+	$statname = "Yesterday's Best $name:";
+	if ($daysago > 1) {
+		$statname = "$daysago days ago's Best $name:";
+	}
+	$stats = displayStats($result, $statname);
 
 
-	$pastMap = pastMap($mapType, 1);
+	$pastMap = pastMap($mapType, $daysago);
 	$mapID = $pastMap;
 	$mapcode = getMapCode($mapID);
 	$map = GenerateMapByCode($mapcode);
@@ -199,10 +232,12 @@ function mysql_field_array( $query ) {
 
 // $data[1]['columnname'] == 'my data';
 
-yesterdayMaze(1, 'Simple');
-yesterdayMaze(2, 'Normal');
-yesterdayMaze(3, 'Complex');
-yesterdayMaze(4, 'Special');
+
+
+displayPastMaze(1, 'Simple', $daysago);
+displayPastMaze(2, 'Normal', $daysago);
+displayPastMaze(3, 'Complex', $daysago);
+displayPastMaze(4, 'Special', $daysago);
 
 ?>
 
-- 
cgit v1.2.3