query("
SELECT
name
FROM
hlstats_Weapons
WHERE
code='$weapon'
AND game='$game'
");
if ($db->num_rows() != 1)
{
$wep_name = ucfirst($weapon);
}
else
{
$weapondata = $db->fetch_array();
$db->free_result();
$wep_name = $weapondata["name"];
}
$db->query("SELECT name FROM hlstats_Games WHERE code='$game'");
if ($db->num_rows() != 1)
error("Invalid or no game specified.");
else
list($gamename) = $db->fetch_row();
pageHeader(
array($gamename, "Weapon Details", htmlspecialchars($wep_name)),
array(
$gamename=>$g_options["scripturl"] . "?game=$game",
"Weapon Statistics"=>$g_options["scripturl"] . "?mode=weapons&game=$game",
"Weapon Details"=>""
),
$wep_name
);
$table = new Table(
array(
new TableColumn(
"killerName",
"Player",
"width=60&align=left&icon=player&link=" . urlencode("mode=playerinfo&player=%k")
),
new TableColumn(
"frags",
ucfirst($weapon) . " kills",
"width=35&align=right"
),
),
"killerId", // keycol
"frags", // sort_default
"killerName", // sort_default2
true, // showranking
50 // numperpage
);
$result = $db->query("
SELECT
hlstats_Events_Frags.killerId,
hlstats_Players.lastName AS killerName,
COUNT(hlstats_Events_Frags.weapon) AS frags
FROM
hlstats_Events_Frags
LEFT JOIN hlstats_Players ON
hlstats_Players.playerId = hlstats_Events_Frags.killerId
WHERE
hlstats_Events_Frags.weapon='$weapon'
AND hlstats_Players.game='$game'
AND hlstats_Players.hideranking<>'1'
GROUP BY
hlstats_Events_Frags.killerId
ORDER BY
$table->sort $table->sortorder,
$table->sort2 $table->sortorder
LIMIT $table->startitem,$table->numperpage
");
$resultCount = $db->query("
SELECT
COUNT(DISTINCT hlstats_Events_Frags.killerId),
SUM(hlstats_Events_Frags.weapon='$weapon')
FROM
hlstats_Events_Frags
LEFT JOIN hlstats_Players ON
hlstats_Players.playerId = hlstats_Events_Frags.killerId
WHERE
hlstats_Events_Frags.weapon='$weapon'
AND hlstats_Players.game='$game'
");
list($numitems, $totalkills) = $db->fetch_row($resultCount);
?>
draw($result, $numitems, 70, "center");
?>