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

  Sections

  Clan Information

Statistics Summary
Clan: EC
Home Page:
Activity: 29.73% 29.73%
Members: 19 active members (193 total)
Avg. Member Points: 1,454
Total Kills: 3,619
Total Deaths: 53
Avg. Kills: 190
Kills per Death: 68.28
Kills per Minute: 6.65
Total Connection Time: 0d 09:04:32h
Avg. Connection Time: 0d 00:28:39h
Favorite Server:* Gunnys Hooch
Favorite Map:* dc2025_1
Favorite Weapon:* Fireaxe
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  EcuadorDan2010 [EC] 3,285 55% 0d 01:47:42h 920 25.42% 25.42% 4 230.00
2  EcuadorTuikTuik [EC] 2,865 48% 0d 01:28:27h 678 18.73% 18.73% 8 84.75
3  EcuadorSEBASTIAN [EC] 1,981 65% 0d 00:29:40h 377 10.42% 10.42% 1 377.00
4  Ecuadorsamuelito [EC] 1,693 18% 0d 01:08:42h 393 10.86% 10.86% 7 56.14
5  United statesarro con chicle [EC] 1,650 18% 0d 01:07:43h 304 8.40% 8.40% 9 33.78
6  Ecuador(1) [EC] 1,528 4% 0d 00:27:53h 225 6.22% 6.22% 3 75.00
7  No Countrycucusclan [EC] 1,384 15% 0d 00:19:14h 158 4.37% 4.37% 5 31.60
8  JapanElFausto01 [EC] 1,332 4% 0d 00:21:05h 127 3.51% 3.51% 2 63.50
9  EcuadorResidentMind [EC] 1,306 100% 0d 00:32:33h 136 3.76% 3.76% 3 45.33
10  EcuadorBlackout [EC] 1,279 7% 0d 00:11:17h 94 2.60% 2.60% 2 47.00
11  EcuadorThetxmx [EC] 1,147 1% 0d 00:04:56h 61 1.69% 1.69% 0 61.00
12  EcuadorSebasGg_Play [EC] 1,094 42% 0d 00:06:53h 38 1.05% 1.05% 0 38.00
13  Japancesaraz2001 [EC] 1,075 4% 0d 00:18:49h 27 0.75% 0.75% 1 27.00
14  BrazilBillie ❤ [EC] 1,069 18% 0d 00:16:43h 23 0.64% 0.64% 3 7.67
15  Ecuadorgarvinces64 [EC] 1,065 5% 0d 00:04:06h 24 0.66% 0.66% 2 12.00
16  EcuadorJosstin [EC] 1,019 18% 0d 00:06:21h 34 0.94% 0.94% 3 11.33
17  EcuadorPEMEX [EC] 1,000 25% 0d 00:03:13h 0 0.00% 0.00% 0 0.00
18  No Countryprivitogg [EC] 994 93% 0d 00:05:35h 0 0.00% 0.00% 0 0.00
19  EcuadorDr Terry. [EC] 854 25% 0d 00:03:40h 0 0.00% 0.00% 0 0.00




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot Kill 284 times 852
2 Friendly Fire 282 times -846
3 Protected Teammate 99 times 297
4 Revived Teammate 34 times 102
5 Killed a Boomer 34 times 34
6 Killed a Charger 33 times 99
7 Killed a Jockey 27 times 81
8 Killed a Hunter 26 times 52
9 Killed a Spitter 25 times 75
10 Killed a Tank 21 times 84
11 Killed a Smoker 20 times 40
12 Killed a Witch 17 times 85
13 Healed Teammate 17 times 85
14 Startled the Witch 15 times -75
15 Used Adrenaline 12 times 24
16 Tank Bilebombed 4 times 20
17 Hunter Punter (Melee a Hunter Mid-jump) 3 times 15
18 Defibrillated Teammate 2 times 20
19 Rescued Teammate 1 times 3
20 No Survivors Died/Incapped by Tank 1 times 1




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Survivors 64 times 44.76% 44.76%
2 Infected 1 times 0.70% 0.70%




ERROR
Database Error

Server Address: localhost
Server Username: gunnys2

Error Diagnostic:
Bad query.

Server Error: (1055) Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'gunnys2.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(22 = 0, 1, 22) * 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='l4d2'
			AND hlstats_Players.clan=631
			AND (hidden <>'1' OR hidden IS NULL)
			AND hlstats_Roles.game = 'l4d2'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			rolecount desc,
			name desc