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, "Map Details", $map), array( $gamename=>$g_options["scripturl"] . "?game=$game", "Map Statistics"=>$g_options["scripturl"] . "?mode=maps&game=$game", "Map Details"=>"" ), $map ); $table = new Table( array( new TableColumn( "killerName", "Player", "width=60&align=left&icon=player&link=" . urlencode("mode=playerinfo&player=%k") ), new TableColumn( "frags", "Kills on $map", "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.map) AS frags FROM hlstats_Events_Frags LEFT JOIN hlstats_Players ON hlstats_Players.playerId = hlstats_Events_Frags.killerId WHERE hlstats_Events_Frags.map='$map' 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.map='$map') FROM hlstats_Events_Frags LEFT JOIN hlstats_Players ON hlstats_Players.playerId = hlstats_Events_Frags.killerId WHERE hlstats_Events_Frags.map='$map' AND hlstats_Players.game='$game' "); list($numitems, $totalkills) = $db->fetch_row($resultCount); ?>

From a total of kills (Last Days)

Back to ">Map Statistics

draw($result, $numitems, 100, "center"); ?> "; } if ($g_options["map_dlurl"]) { $map_dlurl = str_replace("%MAP%", $map, $g_options["map_dlurl"]); $map_dlurl = str_replace("%GAME%", $game, $map_dlurl); echo "
Download this map...
"; } echo $g_options["fontend_normal"]; ?>

draw($result, $numitems, 70, "center"); } ?>