query("
SELECT
hlstats_Clans.tag,
hlstats_Clans.name,
hlstats_Clans.homepage,
hlstats_Clans.game,
SUM(hlstats_Players.kills) AS kills,
SUM(hlstats_Players.deaths) AS deaths,
COUNT(hlstats_Players.playerId) AS nummembers,
ROUND(AVG(hlstats_Players.skill)) AS avgskill
FROM
hlstats_Clans
LEFT JOIN hlstats_Players ON
hlstats_Players.clan = hlstats_Clans.clanId
WHERE
hlstats_Clans.clanId=$clan
GROUP BY
hlstats_Clans.clanId
");
if ($db->num_rows() != 1)
error("No such clan '$clan'.");
$clandata = $db->fetch_array();
$db->free_result();
$cl_name = ereg_replace(" ", " ", htmlspecialchars($clandata["name"]));
$cl_tag = ereg_replace(" ", " ", htmlspecialchars($clandata["tag"]));
$cl_full = $cl_tag . " " . $cl_name;
$game = $clandata["game"];
$db->query("SELECT name FROM hlstats_Games WHERE code='$game'");
if ($db->num_rows() != 1)
$gamename = ucfirst($game);
else
list($gamename) = $db->fetch_row();
pageHeader(
array($gamename, "Clan Details", $cl_full),
array(
$gamename=>$g_options["scripturl"] . "?game=$game",
"Clan Rankings"=>$g_options["scripturl"] . "?mode=clans&game=$game",
"Clan Details"=>""
),
$clandata["name"]
);
?>
 /downarrow.gif" width=9 height=6 border=0 align="middle" alt="downarrow.gif"> Clan Profile and Statistics Summary |
| |
|
|
/rightarrow.gif" width="6" height="9" border="0" align="middle" alt="downarrow.gif">
Clan has no active members to display.
|
query("
SELECT
playerId,
lastName,
skill,
kills,
deaths,
IFNULL(kills/deaths, '-') AS kpd,
(kills/" . $clandata["kills"] . ") * 100 AS percent
FROM
hlstats_Players
WHERE
clan=$clan
ORDER BY
$tblMembers->sort $tblMembers->sortorder,
$tblMembers->sort2 $tblMembers->sortorder,
lastName ASC
LIMIT $tblMembers->startitem,$tblMembers->numperpage
");
$resultCount = $db->query("
SELECT
COUNT(*)
FROM
hlstats_Players
WHERE
clan=$clan
");
list($numitems) = $db->fetch_row($resultCount);
?>
|
/downarrow.gif" width=9 height=6 border=0 align="middle" alt="downarrow.gif"> Members |
| |
draw($result, $numitems, 100);
?> |