diff options
Diffstat (limited to 'includes/datas.php')
| -rw-r--r-- | includes/datas.php | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/includes/datas.php b/includes/datas.php index 912eea8..2a47a4c 100644 --- a/includes/datas.php +++ b/includes/datas.php @@ -11,7 +11,8 @@ function topScores($mapid, $top = 5) { timediff(solutions.dateModified, TIMESTAMP(CURDATE())) as diff, users.displayName as display, solutions.moves as m, - users.ID as ID + users.ID as ID, + solutions.dateModified as cdate FROM `users` JOIN `solutions` @@ -28,19 +29,21 @@ function topScores($mapid, $top = 5) { $output .= "<th>Rank</th>"; $output .= "<th>Name</th>"; $output .= "<th>Moves</th>"; - $output .= "<th>Time taken</th>"; + $output .= "<th title='Time since map generated'>Time</th>"; $output .= "</tr>"; - while (list($diff, $display, $moves, $userID) = mysql_fetch_row($result)) { + while (list($diff, $display, $moves, $userID, $cdate) = mysql_fetch_row($result)) { $i++; if ($_SESSION['userID'] == $userID) $output .= "<tr style='background-color: #356;'>"; else $output .= "<tr>"; + $cdate = date("g:i A", strtotime($cdate)); + $output .= "<td>$i</td>"; $output .= "<td><span title='UserID: $userID'>$display</span></td>"; $output .= "<td>$moves</td>"; - $output .= "<td>$diff</td>"; + $output .= "<td title='Improved $cdate (EST)'>$diff</td>"; //$output .= "<b>$i. <span title='UserID: $userID'>$display</span> with $moves moves. In $diff<br /></b>"; $output .= "</tr>"; } |