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();
pageHeader(
array($gamename, "Weapon Statistics"),
array($gamename=>"%s?game=$game", "Weapon Statistics"=>"")
);
$tblWeapons = new Table(
array(
new TableColumn(
"weapon",
"Weapon",
"width=21&type=weaponimg&align=center&link=" . urlencode("mode=weaponinfo&weapon=%k&game=$game")
),
new TableColumn(
"modifier",
"Points Modifier",
"width=10&align=right"
),
new TableColumn(
"kills",
"Kills",
"width=12&align=right"
),
new TableColumn(
"percent",
"Percentage of Kills",
"width=40&sort=no&type=bargraph"
),
new TableColumn(
"percent",
"%",
"width=12&sort=no&align=right&append=" . urlencode("%")
)
),
"weapon",
"kills",
"weapon",
true,
9999,
"weap_page",
"weap_sort",
"weap_sortorder"
);
$db->query("
SELECT
COUNT(*)
FROM
hlstats_Events_Frags
LEFT JOIN hlstats_Players ON
hlstats_Players.playerId = hlstats_Events_Frags.killerId
WHERE
hlstats_Players.game = '$game'
");
list($totalkills) = $db->fetch_row();
$result = $db->query("
SELECT
hlstats_Events_Frags.weapon,
IFNULL(hlstats_Weapons.modifier, 1.00) AS modifier,
COUNT(hlstats_Events_Frags.weapon) AS kills,
COUNT(hlstats_Events_Frags.weapon) / $totalkills * 100 AS percent
FROM
hlstats_Events_Frags
LEFT JOIN hlstats_Weapons ON
hlstats_Weapons.code = hlstats_Events_Frags.weapon
LEFT JOIN hlstats_Players ON
hlstats_Players.playerId = hlstats_Events_Frags.killerId
WHERE
hlstats_Players.game='$game'
AND (hlstats_Weapons.game='$game' OR hlstats_Weapons.weaponId IS NULL)
GROUP BY
hlstats_Events_Frags.weapon
ORDER BY
$tblWeapons->sort $tblWeapons->sortorder,
$tblWeapons->sort2 $tblWeapons->sortorder
");
?>
| From a total of kills (Last Days) |
Back to "> |
draw($result, $db->num_rows($result), 90);
?>