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

  Sections

  Clan Information

Statistics Summary
Clan: SAC
Home Page:
Activity: 67.68% 67.68%
Members: 16 active members (53 total)
Avg. Member Points: 761
Total Kills: 7,964
Total Deaths: 8,934
Avg. Kills: 498
Kills per Death: 0.89
Kills per Minute: 2.13
Total Connection Time: 2d 14:14:25h
Avg. Connection Time: 0d 03:53:24h
Favorite Server:* Adult Gamers Community - DOD:S Gungame
Favorite Map:* dod_gg_toil_b1
Favorite Weapon:* Spade Entrenchment Tool
Player Locations

  Members

Rank Name Points Activity Time Kills Clan Kills % Deaths sort-ascending.gif Kpd
1  United statesCasanova Funkenstein[SAC] 1,000 66% 0d 00:00:05h 0 0.00% 0.00% 0 0.00
2  DenmarkDStriker [SAC] 1,028 8% 0d 00:10:38h 15 0.19% 0.19% 4 3.75
3  United statesRunner_11 [SAC] 994 59% 0d 00:02:40h 3 0.04% 0.04% 6 0.50
4  CanadaPannloo [SAC] 1,007 63% 0d 00:08:52h 18 0.23% 0.23% 18 1.00
5  United statesLittle Toe [SAC] 1,024 95% 0d 00:12:05h 34 0.43% 0.43% 32 1.06
6  United kingdomMad Dash [SAC] 978 85% 0d 00:37:32h 47 0.59% 0.59% 69 0.68
7  United statesFiveseveN [SAC] 663 85% 0d 01:01:15h 149 1.87% 1.87% 127 1.17
8  United statesGrateful transporter [SAC] 609 26% 0d 01:06:34h 120 1.51% 1.51% 175 0.69
9  DenmarkDark Simon DK [SAC] 785 8% 0d 02:01:19h 334 4.19% 4.19% 241 1.39
10  Iran, islamic republic ofCopperfield [SAC] 576 22% 0d 03:32:09h 374 4.70% 4.70% 441 0.85
11  United statesGOMER==>> [SAC] 398 89% 0d 02:43:56h 301 3.78% 3.78% 445 0.68
12  United statesLithium [SAC] 583 92% 0d 04:33:41h 534 6.71% 6.71% 446 1.20
13  United statesElky_WarEagle [SAC] 975 100% 0d 04:00:30h 868 10.90% 10.90% 595 1.46
14  United statesMaj. DonnieBaker [SAC] 502 100% 0d 06:36:24h 805 10.11% 10.11% 1,022 0.79
15  United statesCaptavenger [SAC] 683 97% 0d 10:43:40h 2,184 27.42% 27.42% 1,730 1.26
16  United statesBob FroM AcccountinG [SAC] 373 88% 1d 00:43:05h 2,178 27.35% 27.35% 3,583 0.61




  Player Actions *

Rank Action Achieved sort-ascending.gif Points Bonus
1 Bomb Planted 1 times 2
2 God Like (12+ kills) 1 times 11
3 Killing Spree (9 kills) 1 times 8
4 Ownage (7 kills) 1 times 6
5 Ultra Kill (8 kills) 1 times 7
6 Rampage (5 kills) 6 times 24
7 Mega Kill (6 kills) 11 times 55
8 Domination (4 kills) 16 times 48
9 Triple Kill (3 kills) 33 times 66
10 Double Kill (2 kills) 65 times 65




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Allies 35 times 25.74% 25.74%
2 Axis 32 times 23.53% 23.53%




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(67 = 0, 1, 67) * 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=17
			AND (hidden <>'1' OR hidden IS NULL)
			AND hlstats_Roles.game = 'dods'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			deathsTotal desc,
			name desc