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["minkills"])) { $minkills = intval($HTTP_GET_VARS["minkills"]); } else { $minkills = 1; } pageHeader( array($gamename, "Player Rankings"), array($gamename=>"%s?game=$game", "Player Rankings"=>"") ); ?>

">

• Find a player:

Go to ">/clan.gif" width=16 height=16 hspace=3 border=0 align="middle" alt="clan.gif">Clan Rankings

query(" SELECT playerId, lastName, skill, kills, deaths, IFNULL(kills/deaths, '-') AS kpd FROM hlstats_Players WHERE game='$game' AND hideranking=0 AND kills >= $minkills ORDER BY $table->sort $table->sortorder, $table->sort2 $table->sortorder, lastName ASC LIMIT $table->startitem,$table->numperpage "); $resultCount = $db->query(" SELECT COUNT(*) FROM hlstats_Players WHERE game='$game' AND hideranking=0 AND kills >= $minkills "); list($numitems) = $db->fetch_row($resultCount); $table->draw($result, $numitems, 90); ?>

">

$v) { if ($k != "minkills") { echo " \n"; } } ?> • Only show players with or more kills.