diff options
Diffstat (limited to 'pages/leaderboard.php')
| -rw-r--r-- | pages/leaderboard.php | 67 |
1 files changed, 51 insertions, 16 deletions
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);
?>
|