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 sort-descending.gif Kpd
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] Maj.Gen. Snivel 377 69% 0d 09:20:32h 961 0.49% 0.49% 1,698 0.57
4  United states[247] LTC. Barf 607 93% 0d 01:47:18h 146 0.08% 0.08% 239 0.61
5  United states[247]Brig Gen. Toynbert 970 99% 0d 00:16:57h 45 0.02% 0.02% 57 0.79




  Player Actions *

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




  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