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, "Map Statistics"),
array($gamename=>"%s?game=$game", "Map Statistics"=>"")
);
$tblMaps = new Table(
array(
new TableColumn(
"map",
"Map Name",
"width=25&align=center&link=" . urlencode("mode=mapinfo&map=%k&game=$game")
),
new TableColumn(
"kills",
"Kills",
"width=10&align=right"
),
new TableColumn(
"percent",
"Percentage of Kills",
"width=50&sort=no&type=bargraph"
),
new TableColumn(
"percent",
"%",
"width=10&sort=no&align=right&append=" . urlencode("%")
)
),
"map",
"kills",
"map",
true,
9999,
"maps_page",
"maps_sort",
"maps_sortorder",
"maps"
);
$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
IF(hlstats_Events_Frags.map='', '(Unaccounted)', hlstats_Events_Frags.map) AS map,
COUNT(hlstats_Events_Frags.map) AS kills,
COUNT(hlstats_Events_Frags.map) / $totalkills * 100 AS percent
FROM
hlstats_Events_Frags
LEFT JOIN hlstats_Players ON
hlstats_Players.playerId = hlstats_Events_Frags.killerId
WHERE
hlstats_Players.game='$game'
GROUP BY
hlstats_Events_Frags.map
ORDER BY
$tblMaps->sort $tblMaps->sortorder,
$tblMaps->sort2 $tblMaps->sortorder
");
?>
| From a total of kills (Last Days) |
Back to "> |
draw($result, $db->num_rows($result), 90);
?>