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

  Sections

  Clan Information

Statistics Summary
Clan: 247
Home Page:
Activity: 92.00% 92.00%
Members: 5 active members (15 total)
Avg. Member Points: 646
Total Kills: 194,320
Total Deaths: 177,046
Avg. Kills: 38,864
Kills per Death: 1.10
Kills per Minute: 3.09
Total Connection Time: 43d 16:18:11h
Avg. Connection Time: 8d 17:39:38h
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 745 99% 29d 23:10:22h 144,223 74.22% 74.22% 125,082 1.15
2  Canada[247] Maj Gen. TriggerFinger 533 100% 13d 05:43:02h 48,945 25.19% 25.19% 49,970 0.98
3  United states[247]Brig Gen. Toynbert 970 99% 0d 00:16:57h 45 0.02% 0.02% 57 0.79
4  United states[247] LTC. Barf 607 93% 0d 01:47:18h 146 0.08% 0.08% 239 0.61
5  United states[247] Maj.Gen. Snivel 377 69% 0d 09:20:32h 961 0.49% 0.49% 1,698 0.57




  Player Actions *

Rank Action Achieved Points Bonus sort-ascending.gif
1 Unstoppable (11 kills) 3 times 30
2 Bomb Planter Killed 20 times 40
3 Bomb Planted 28 times 56
4 Monster Kill (10 kills) 7 times 63
5 God Like (12+ kills) 12 times 132
6 Killing Spree (9 kills) 18 times 144
7 Ultra Kill (8 kills) 34 times 238
8 Ownage (7 kills) 63 times 378
9 Mega Kill (6 kills) 108 times 540
10 Rampage (5 kills) 186 times 744
11 Domination (4 kills) 413 times 1,239
12 Double Kill (2 kills) 1,641 times 1,641
13 Triple Kill (3 kills) 843 times 1,686




  Team Selection *

Rank Team sort-ascending.gif Joined Percentage of Times %
1 Allies 227 times 13.75% 13.75%
2 Axis 609 times 36.89% 36.89%




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(940 = 0, 1, 940) * 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