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

  Clan Information

Statistics Summary
Clan: GM-Guys
Home Page:
Activity: 100.00%
Members: 1 active members (1 total)
Avg. Member Points: 208,619
Total Kills: 24,796
Total Deaths: 2,467
Avg. Kills: 24,796
Kills per Death: 10.05
Kills per Minute: 3.44
Total Connection Time: 5d 00:14:47h
Avg. Connection Time: 5d 00:14:47h
Favorite Server:* [KR] 봇전쟁 (플레이어 VS 봇) ☆★
Favorite Map:* de_dust2
Favorite Weapon:* Colt M4A1 Carbine
Player Locations

  Members

Rank Name Rank Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  Korea, republic ofDAJEONGDAGAM elorank 208,619 5d 00:14:47h 24,796 100.00% 2,467 10.05




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 5,641 times 5,641
2 Domination 901 times 4,505
3 Round MVP 416 times 0
4 Ownage (7 kills) 237 times 1,422
5 Mega Kill (6 kills) 193 times 965
6 Double Kill (2 kills) 191 times 191
7 Rampage (5 kills) 178 times 712
8 Domination (4 kills) 174 times 522
9 Triple Kill (3 kills) 163 times 326
10 God Like (12+ kills) 116 times 1,276
11 Start Defusing the Bomb With a Defuse Kit 112 times 0
12 Ultra Kill (8 kills) 109 times 763
13 Defuse the Bomb 102 times 1,020
14 Killing Spree (9 kills) 83 times 664
15 Monster Kill (10 kills) 52 times 468
16 Unstoppable (11 kills) 49 times 490
17 Start Defusing the Bomb Without a Defuse Kit 34 times 0
18 Touch a Hostage 18 times 0
19 Rescue a Hostage 11 times 55
20 Kill a Hostage 2 times -30




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Revenge 114 times -342




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Counter-Terrorist 319 times 46.71%




ERROR
Database Error

Server Address: localhost
Server Username: hlstatsx

Error Diagnostic:
Bad query.

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