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

  Clan Information

Statistics Summary
Clan: wKm[2S]
Home Page:
Activity: 100.00%
Members: 1 active members (1 total)
Avg. Member Points: 114,424
Total Kills: 11,350
Total Deaths: 980
Avg. Kills: 11,350
Kills per Death: 11.58
Kills per Minute: 3.45
Total Connection Time: 2d 06:47:53h
Avg. Connection Time: 2d 06:47:53h
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 ofImop elorank 114,424 2d 06:47:53h 11,350 100.00% 980 11.58




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 1,690 times 1,690
2 Domination 369 times 1,845
3 Round MVP 277 times 0
4 Ownage (7 kills) 191 times 1,146
5 Defuse the Bomb 77 times 770
6 Start Defusing the Bomb With a Defuse Kit 66 times 0
7 Mega Kill (6 kills) 64 times 320
8 Double Kill (2 kills) 53 times 53
9 Touch a Hostage 50 times 0
10 Rampage (5 kills) 47 times 188
11 Ultra Kill (8 kills) 44 times 308
12 Triple Kill (3 kills) 43 times 86
13 Rescue a Hostage 41 times 205
14 Start Defusing the Bomb Without a Defuse Kit 30 times 0
15 Domination (4 kills) 30 times 90
16 Killing Spree (9 kills) 19 times 152
17 Unstoppable (11 kills) 10 times 100
18 Monster Kill (10 kills) 10 times 90
19 Kill a Hostage 10 times -150
20 God Like (12+ kills) 10 times 110




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Revenge 59 times -177




  Team Selection *

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




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=713
			AND (hidden <>'1' OR hidden IS NULL)
			AND hlstats_Roles.game = 'css'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			rolecount desc,
			name desc