= 0 GROUP BY hlstats_Countries.flag "; $db->query($SQL); if ($db->num_rows() != 1) error("No such countryclan '$flag'."); $clandata = $db->fetch_array(); $db->free_result(); $cl_name = str_replace(' ', ' ', htmlspecialchars($clandata['name'])); $cl_tag = str_replace(' ', ' ', htmlspecialchars($clandata['tag'])); $cl_full = "$cl_tag $cl_name"; $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, 'Country Details', $cl_full), array( $gamename=>$g_options['scripturl'] . "?game=$game", 'Country Rankings'=>$g_options['scripturl'] . "?mode=countryclans&game=$game", 'Country Details'=>'' ), $clandata['name'] ); ?>

Statistics Summary
Country:	'; echo '' . $clandata['name'] . ''; ?>
	40) $bar_type = 6; elseif ($clandata['activity'] > 30) $bar_type = 5; elseif ($clandata['activity'] > 20) $bar_type = 4; elseif ($clandata['activity'] > 10) $bar_type = 3; elseif ($clandata['activity'] > 5) $bar_type = 2; echo ' $\"".$clandata['activity'].'%"$ '; ?>
Members:	active members
Total Kills:
Total Deaths:
Avg. Kills:
Kills per Death:	' . '%0.2f', $clandata['kills'] / $clandata['deaths']) . ''; } else { echo '-'; } ?>
Kills per Minute:	0) { echo sprintf('%.2f', ($clandata['kills'] / ($clandata['connection_time'] / 60))); } else { echo '-'; } ?>
Avg. Member Points:	' . number_format($clandata['avgskill']) . ''; ?>
Avg. Connection Time:	0) { echo timestamp_to_str($clandata['connection_time'] / ($clandata['nummembers'])); } else { echo '-'; } ?>
Total Connection Time:

'; } else { echo '

'; } ?>

query(" SELECT hlstats_Players.playerId, hlstats_Players.lastName, hlstats_Players.country, hlstats_Players.flag, hlstats_Players.skill, hlstats_Players.connection_time, hlstats_Players.kills, hlstats_Players.deaths, ROUND(hlstats_Players.kills / IF(hlstats_Players.deaths = 0, 1, hlstats_Players.deaths), 2) AS kpd, ROUND(hlstats_Players.kills / IF(" . $clandata['kills'] . " = 0, 1, " . $clandata['kills'] . ") * 100, 2) AS percent, IF(".$g_options['MinActivity']." > (UNIX_TIMESTAMP() - last_event), ((100/".$g_options['MinActivity'].") * (".$g_options['MinActivity']." - (UNIX_TIMESTAMP() - last_event))), -1) as activity FROM hlstats_Players WHERE flag='$flag' AND hlstats_Players.hideranking = 0 AND hlstats_Players.game='$game' GROUP BY hlstats_Players.playerId HAVING activity >= 0 ORDER BY $tblMembers->sort $tblMembers->sortorder, $tblMembers->sort2 $tblMembers->sortorder, lastName ASC LIMIT $tblMembers->startitem,$tblMembers->numperpage "); $resultCount = $db->query(" SELECT playerId, IF(".$g_options['MinActivity']." > (UNIX_TIMESTAMP() - last_event), ((100/".$g_options['MinActivity'].") * (".$g_options['MinActivity']." - (UNIX_TIMESTAMP() - last_event))), -1) as activity FROM hlstats_Players WHERE flag='$flag' AND hlstats_Players.hideranking = 0 AND hlstats_Players.game='$game' GROUP BY hlstats_Players.playerId HAVING activity >= 0 "); $numitems = $db->num_rows($resultCount); ?>

draw($result, $numitems, 95); ?>