From d12035b5eca9b55ae887519ee6bac5cbde2a97e7 Mon Sep 17 00:00:00 2001
From: Patrick Davison <snapwilliam@gmail.com>
Date: Sat, 4 Feb 2012 22:43:37 -0800
Subject: Fixes for the scoreboard.

Added colors for display names in the "Overall" section.
Added links to achievement pages for users.
---
 pages/leaderboard.php | 16 +++++++++++++---
 1 file changed, 13 insertions(+), 3 deletions(-)

diff --git a/pages/leaderboard.php b/pages/leaderboard.php
index 248f334..1e3110b 100644
--- a/pages/leaderboard.php
+++ b/pages/leaderboard.php
@@ -71,12 +71,18 @@ function getStat ($type, $daysago = 1) {
 	$sql = "SELECT 
 		users.displayName as Name, 
 		SUM(solutions.moves) as Moves,
-		timediff(MAX(dateModified), maps.dateCreated) as Timetaken
+		timediff(MAX(dateModified), maps.dateCreated) as Timetaken,
+		userData.wallColor,
+		userData.wallEmblem,
+		userData.displayColor,
+		users.ID as userID
 	FROM `maps` 
 	JOIN `solutions`
 		ON maps.ID = solutions.mapID
 	JOIN `users`
 		ON solutions.userID = users.ID
+	LEFT JOIN `userData`
+		ON users.ID = userData.userID
 	WHERE $where
 	GROUP BY solutions.userID
 	ORDER BY Moves DESC, MAX(dateModified) ASC
@@ -125,7 +131,8 @@ function displayPastMaze($mapType, $name, $daysago = 1) {
 		timediff(solutions.dateModified, maps.dateCreated) as Timetaken,
 		userData.wallColor,
 		userData.wallEmblem,
-		userData.displayColor
+		userData.displayColor,
+		users.ID as userID
 	FROM `maps` 
 	JOIN `solutions`
 		ON maps.ID = solutions.mapID
@@ -204,6 +211,8 @@ function displaystats($result, $caption = NULL) {
 		$wallColor = $row['wallColor'];
 		$wallEmblem = $row['wallEmblem'];
 		$displayColor = $row['displayColor'];
+		$displayName = $row['Name'];
+		$userID = $row['userID'];
 		
 		//Default
 		if ($wallColor == '')
@@ -211,7 +220,8 @@ function displaystats($result, $caption = NULL) {
 		
 		$r .= "<tr class='lbrow' onmouseover='changeWallEmblem(\"$wallEmblem\"); changeWallColor(\"$wallColor\"); loadSol(\"$mapid:$solution\");'>\n";
 		$r .= "<td>$i</td>";
-		$r .= "<td style='color:$displayColor';>" . $row['Name'] . '</td>';
+		$r .= "<td><span title='UserID: $userID'><a href='achievements?id=$userID' style='color:$displayColor'>$displayName</a></span></td>";
+		//$r .= "<td style='color:$displayColor';>" . $row['Name'] . '</td>';
 		$r .= '<td><a href="javascript:void(0)">' . $row['Moves'] . '</a></td>';
 		$r .= '<td>' . $row['Timetaken'] . '</td>';
 		$r .= "</tr>";
-- 
cgit v1.2.3