| "> "> |
|
|
|
query("
SELECT
hlstats_Awards.awardType,
hlstats_Awards.code,
hlstats_Awards.name,
hlstats_Awards.verb,
hlstats_Awards.d_winner_id,
hlstats_Awards.d_winner_count,
hlstats_Players.lastName AS d_winner_name
FROM
hlstats_Awards
LEFT JOIN hlstats_Players ON
hlstats_Players.playerId = hlstats_Awards.d_winner_id
WHERE
hlstats_Awards.game='$game'
ORDER BY
hlstats_Awards.awardType DESC,
hlstats_Awards.name ASC
");
$result = $db->query("
SELECT
IFNULL(value, 1)
FROM
hlstats_Options
WHERE
keyname='awards_numdays'
");
if ($db->num_rows($result) == 1)
list($awards_numdays) = $db->fetch_row($result);
else
$awards_numdays = 1;
$result = $db->query("
SELECT
DATE_FORMAT(value, '%W %e %b'),
DATE_FORMAT( DATE_SUB( value, INTERVAL $awards_numdays DAY ) , '%W %e %b' )
FROM
hlstats_Options
WHERE
keyname='awards_d_date'
");
list($awards_d_date, $awards_s_date) = $db->fetch_row($result);
if ($db->num_rows($resultAwards) > 0 && $awards_d_date)
{
?>
|
|
|
|
| query("SELECT COUNT(*) FROM hlstats_Players WHERE game='$game'"); list($num_players) = $db->fetch_row($result); $num_players = intval($num_players); $result = $db->query("SELECT COUNT(*) FROM hlstats_Clans WHERE game='$game'"); list($num_clans) = $db->fetch_row($result); $num_clans = intval($num_clans); $result = $db->query("SELECT COUNT(*) FROM hlstats_Servers WHERE game='$game'"); list($num_servers) = $db->fetch_row($result); $num_servers = intval($num_servers); $result = $db->query(" SELECT DATE_FORMAT(MAX(eventTime), '%r, %a. %e %b.') FROM hlstats_Events_Frags LEFT JOIN hlstats_Players ON hlstats_Players.playerId = hlstats_Events_Frags.serverId WHERE hlstats_Players.game='$game' "); list($lastevent) = $db->fetch_row($result); ?>
|