query("SELECT name FROM hlstats_Games WHERE code='$game'");
if ($db->num_rows() < 1) error("No such game '$game'.");
list($gamename) = $db->fetch_row();
$db->free_result();
if (isset($HTTP_GET_VARS["minmembers"]))
{
$minmembers = intval($HTTP_GET_VARS["minmembers"]);
}
else
{
$minmembers = 2;
}
pageHeader(
array($gamename, "Clan Rankings"),
array($gamename=>"%s?game=$game", "Clan Rankings"=>"")
);
?>
query("
SELECT
hlstats_Clans.clanId,
hlstats_Clans.name,
hlstats_Clans.tag,
COUNT(hlstats_Players.playerId) AS nummembers,
SUM(hlstats_Players.kills) AS kills,
SUM(hlstats_Players.deaths) AS deaths,
ROUND(AVG(hlstats_Players.skill)) AS skill,
IFNULL(SUM(hlstats_Players.kills)/SUM(hlstats_Players.deaths), '-') AS kpd
FROM
hlstats_Clans
LEFT JOIN hlstats_Players ON
hlstats_Players.clan=hlstats_Clans.clanId
WHERE
hlstats_Clans.game='$game'
GROUP BY
hlstats_Clans.clanId
HAVING
nummembers >= $minmembers
ORDER BY
$table->sort $table->sortorder,
$table->sort2 $table->sortorder,
name ASC
LIMIT $table->startitem,$table->numperpage
");
$resultCount = $db->query("
SELECT
hlstats_Clans.clanId
FROM
hlstats_Clans
LEFT JOIN hlstats_Players ON
hlstats_Players.clan=hlstats_Clans.clanId
WHERE
hlstats_Clans.game='$game'
GROUP BY
hlstats_Clans.clanId
HAVING
COUNT(hlstats_Players.playerId) >= $minmembers
");
$table->draw($result, $db->num_rows($resultCount), 90);
?>