HLstatsX Community Edition
  • Contents
  • Search
  • SourceBans
  • Forum
  • Help

  Sections

  Clan Information

Statistics Summary
Clan: 247
Home Page:
Activity: 94.75% 94.75%
Members: 4 active members (15 total)
Avg. Member Points: 577
Total Kills: 193,344
Total Deaths: 176,106
Avg. Kills: 48,336
Kills per Death: 1.10
Kills per Minute: 3.09
Total Connection Time: 43d 10:53:08h
Avg. Connection Time: 10d 20:43:17h
Favorite Server:* Adult Gamers Community - DOD:S Gungame
Favorite Map:* cdc_mario_air_[rm]_[ob1]
Favorite Weapon:* Spade Entrenchment Tool
Player Locations

  Members

Rank Name Points Activity Time Kills Clan Kills % Deaths Kpd sort-descending.gif
1  United states[247] COL Night Raider 697 100% 29d 19:54:07h 143,550 74.25% 74.25% 124,490 1.15
2  Canada[247] Maj Gen. TriggerFinger 626 100% 13d 03:51:11h 48,687 25.18% 25.18% 49,679 0.98
3  United states[247] LTC. Barf 607 100% 0d 01:47:18h 146 0.08% 0.08% 239 0.61
4  United states[247] Maj.Gen. Snivel 377 79% 0d 09:20:32h 961 0.50% 0.50% 1,698 0.57




  Player Actions *

Rank Action Achieved Points Bonus sort-descending.gif
1 Triple Kill (3 kills) 870 times 1,740
2 Double Kill (2 kills) 1,712 times 1,712
3 Domination (4 kills) 423 times 1,269
4 Rampage (5 kills) 196 times 784
5 Mega Kill (6 kills) 122 times 610
6 Ownage (7 kills) 68 times 408
7 Ultra Kill (8 kills) 34 times 238
8 Killing Spree (9 kills) 18 times 144
9 God Like (12+ kills) 13 times 143
10 Monster Kill (10 kills) 7 times 63
11 Bomb Planted 31 times 62
12 Unstoppable (11 kills) 5 times 50
13 Bomb Planter Killed 21 times 42




  Team Selection *

Rank Team sort-ascending.gif Joined Percentage of Times %
1 Allies 237 times 13.84% 13.84%
2 Axis 629 times 36.74% 36.74%




ERROR
Database Error

Server Address: localhost
Server Username: agc

Error Diagnostic:
Bad query.

Server Error: (1055) Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'agc.hlstats_Frags_as_res.killsTotal' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Last SQL Query:
		SELECT
			IFNULL(hlstats_Roles.name, hlstats_Events_ChangeRole.role) AS name,
			IFNULL(hlstats_Roles.code, hlstats_Events_ChangeRole.role) AS code,
			COUNT(hlstats_Events_ChangeRole.id) AS rolecount,
			ROUND(COUNT(hlstats_Events_ChangeRole.id) / IF(981 = 0, 1, 981) * 100, 2) AS percent,
			killsTotal,
			deathsTotal,
			ROUND(killsTotal/if(deathsTotal=0,1,deathsTotal), 2) AS kpd
		FROM
			hlstats_Events_ChangeRole
		LEFT JOIN
			hlstats_Roles
		ON
			hlstats_Events_ChangeRole.role = hlstats_Roles.code
		LEFT JOIN
			hlstats_Servers
		ON
			hlstats_Servers.serverId = hlstats_Events_ChangeRole.serverId
		LEFT JOIN
			hlstats_Frags_as_res
		ON
			hlstats_Frags_as_res.role = hlstats_Events_ChangeRole.role
		LEFT JOIN
			hlstats_Players
		ON
			hlstats_Players.playerId = hlstats_Events_ChangeRole.playerId
		WHERE
			hlstats_Servers.game='dods'
			AND hlstats_Players.clan=9
			AND (hidden <>'1' OR hidden IS NULL)
			AND hlstats_Roles.game = 'dods'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			code desc,
			name desc