diff options
| author | Patrick Davison <snapwilliam@gmail.com> | 2012-02-04 22:43:37 -0800 |
|---|---|---|
| committer | Patrick Davison <snapwilliam@gmail.com> | 2012-02-04 22:43:37 -0800 |
| commit | d12035b5eca9b55ae887519ee6bac5cbde2a97e7 (patch) | |
| tree | ee83a86d70315dc082f00fd6e91c95c425ccc79d | |
| parent | b2a6b0497035c6f0b953d54ef75c4b07f306d692 (diff) | |
| download | pathery-d12035b5eca9b55ae887519ee6bac5cbde2a97e7.tar.xz | |
Fixes for the scoreboard.
Added colors for display names in the "Overall" section.
Added links to achievement pages for users.
| -rw-r--r-- | pages/leaderboard.php | 16 |
1 files 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>";
|