Awards';
$sql = 'SELECT award_id, award_name, award_displayname, award_type, award_field FROM awards ORDER BY award_displayname';
$res = mysql_query($sql);
while ($row = mysql_fetch_assoc($res)) {
echo '';
echo '![', $row['award_displayname'], '](', sprintf(URL_AWARD, $row['award_name']), ')
';
echo $row['award_displayname'];
echo ' — ' . getAwardDescription($row['award_type'], $row['award_field']) . '';
echo '
';
echo '';
$sql2 = '
SELECT awardwinners.player_id,
session_alias,
winner_value,
UNIX_TIMESTAMP(winner_awarded) AS ts
FROM awardwinners
NATURAL JOIN players
LEFT OUTER JOIN sessions ON players.player_id = sessions.player_id
WHERE award_id = ' . $row['award_id'] . '
GROUP BY winner_awarded
ORDER BY winner_awarded DESC
LIMIT 0,' . AWARD_NUMBER;
$res2 = mysql_query($sql2) or print(mysql_error());
while ($row2 = mysql_fetch_assoc($res2)) {
echo '- ';
echo date('F jS', $row2['ts']), ': ';
echo '' . htmlentities($row2['session_alias'], ENT_COMPAT, 'UTF-8') . '';
echo ' with ' . htmlentities($row2['winner_value']) . '
';
}
echo '
';
}
require_once('inc/footer.php');
?>