diff options
| author | Patrick Davison <snapwilliam@gmail.com> | 2012-02-02 23:02:32 -0800 |
|---|---|---|
| committer | Patrick Davison <snapwilliam@gmail.com> | 2012-02-02 23:02:32 -0800 |
| commit | c93e11aa3c9255468d2a5250b11cae0023850e69 (patch) | |
| tree | 2b2c6eeb969fcd5be3b22ce574c3ab9432073a44 | |
| parent | 418f53fa5ac1601175fa6a937690a0c70efae446 (diff) | |
| download | pathery-c93e11aa3c9255468d2a5250b11cae0023850e69.tar.xz | |
WallColor & wallEmblems in scoreboard
| -rw-r--r-- | pages/leaderboard.php | 20 |
1 files changed, 16 insertions, 4 deletions
diff --git a/pages/leaderboard.php b/pages/leaderboard.php index 2c057a6..248f334 100644 --- a/pages/leaderboard.php +++ b/pages/leaderboard.php @@ -1,5 +1,5 @@ <?php
-htmlHeader(array('stats'));
+htmlHeader(array('stats'), 'Pathery Scores');
?>
<body>
@@ -122,7 +122,10 @@ function displayPastMaze($mapType, $name, $daysago = 1) { solution,
users.displayName as Name,
SUM(solutions.moves) as Moves,
- timediff(solutions.dateModified, maps.dateCreated) as Timetaken
+ timediff(solutions.dateModified, maps.dateCreated) as Timetaken,
+ userData.wallColor,
+ userData.wallEmblem,
+ userData.displayColor
FROM `maps`
JOIN `solutions`
ON maps.ID = solutions.mapID
@@ -130,6 +133,8 @@ function displayPastMaze($mapType, $name, $daysago = 1) { ON solutions.userID = users.ID
JOIN `mapOfTheDay`
ON maps.ID = mapOfTheDay.mapID
+ LEFT JOIN `userData`
+ ON users.ID = userData.userID
WHERE DATE_ADD(CURDATE(), INTERVAL -$daysago DAY) =
DATE_FORMAT(solutions.dateModified,'%Y-%m-%d')
AND DATE_ADD(CURDATE(), INTERVAL -$daysago DAY) =
@@ -196,10 +201,17 @@ function displaystats($result, $caption = NULL) { $rowcontent = '';
$mapid = $row['mapID'];
$solution = $row['solution'];
+ $wallColor = $row['wallColor'];
+ $wallEmblem = $row['wallEmblem'];
+ $displayColor = $row['displayColor'];
- $r .= "<tr class='lbrow' onmouseover='javascript:loadSol(\"$mapid:$solution\")'>";
+ //Default
+ if ($wallColor == '')
+ $wallColor = '#666666';
+
+ $r .= "<tr class='lbrow' onmouseover='changeWallEmblem(\"$wallEmblem\"); changeWallColor(\"$wallColor\"); loadSol(\"$mapid:$solution\");'>\n";
$r .= "<td>$i</td>";
- $r .= '<td>' . $row['Name'] . '</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>";
|