">

"> fetch_row($resultGames)) { $result = $db->query(" SELECT playerId, lastName FROM hlstats_Players WHERE game='$gamedata[0]' AND hideranking=0 ORDER BY skill DESC LIMIT 1 "); if ($db->num_rows($result) == 1) { $topplayer = $db->fetch_row($result); } else { $topplayer = false; } $result = $db->query(" SELECT hlstats_Clans.clanId, hlstats_Clans.name, AVG(hlstats_Players.skill) AS skill, COUNT(hlstats_Players.playerId) AS numplayers FROM hlstats_Clans LEFT JOIN hlstats_Players ON hlstats_Players.clan = hlstats_Clans.clanId WHERE hlstats_Clans.game='$gamedata[0]' GROUP BY hlstats_Clans.clanId HAVING skill IS NOT NULL AND numplayers > 1 ORDER BY skill DESC LIMIT 1 "); if ($db->num_rows($result) == 1) { $topclan = $db->fetch_row($result); } else { $topclan = false; } ?> "> Game "> Top Player "> Top Clan ">  ">" width="16" height="16" hspace="3" border="0" align="middle" alt="Game">  ">/player.gif" width=16 height=16 hspace=3 alt="Player Rankings" border=0 align="middle">Players    ">/clan.gif" width=16 height=16 hspace=3 alt="Clan Rankings" border=0 align="middle">Clans   ">' . htmlentities($topplayer[1], ENT_COMPAT, "UTF-8") . ''; } else { echo '-'; } echo $g_options["fontend_normal"]; ?> ">' . htmlentities($topclan[1], ENT_COMPAT, "UTF-8") . ''; } else { echo '-'; } echo $g_options["fontend_normal"]; ?>

 /downarrow.gif" width=9 height=6 border=0 align="middle" alt="downarrow.gif"> General Statistics

query("SELECT COUNT(*) FROM hlstats_Players"); list($num_players) = $db->fetch_row($result); $num_players = intval($num_players); $result = $db->query("SELECT COUNT(*) FROM hlstats_Clans"); list($num_clans) = $db->fetch_row($result); $num_clans = intval($num_clans); $result = $db->query("SELECT COUNT(*) FROM hlstats_Servers"); 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 "); list($lastevent) = $db->fetch_row($result); ?>

•	$num_players players and $num_clans clans " . "ranked in $num_games games on $num_servers" . " servers."; echo $g_options["fontend_normal"]; ?>
•	$lastevent"; echo $g_options["fontend_normal"]; ?>
•	" . DELETEDAYS . " days."; echo $g_options["fontend_normal"]; ?>