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

  Clan Information

Statistics Summary
Clan: 긔엽긔
Home Page:
Activity: 100.00%
Members: 1 active members (1 total)
Avg. Member Points: 164,856
Total Kills: 21,188
Total Deaths: 1,421
Avg. Kills: 21,188
Kills per Death: 14.91
Kills per Minute: 3.96
Total Connection Time: 3d 17:11:23h
Avg. Connection Time: 3d 17:11:23h
Favorite Server:* [KR] 봇전쟁 (플레이어 VS 봇) ☆★
Favorite Map:* de_dust2
Favorite Weapon:* M249 PARA Light Machine Gun
Player Locations

  Members

Rank Name Rank Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  Korea, republic ofdr.bae elorank 164,856 3d 17:11:23h 21,188 100.00% 1,421 14.91




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 9,400 times 9,400
2 Domination 1,291 times 6,455
3 Round MVP 809 times 0
4 Ownage (7 kills) 344 times 2,064
5 Defuse the Bomb 231 times 2,310
6 Start Defusing the Bomb With a Defuse Kit 212 times 0
7 God Like (12+ kills) 209 times 2,299
8 Ultra Kill (8 kills) 205 times 1,435
9 Mega Kill (6 kills) 203 times 1,015
10 Rampage (5 kills) 170 times 680
11 Triple Kill (3 kills) 155 times 310
12 Killing Spree (9 kills) 148 times 1,184
13 Domination (4 kills) 146 times 438
14 Double Kill (2 kills) 138 times 138
15 Start Defusing the Bomb Without a Defuse Kit 105 times 0
16 Monster Kill (10 kills) 103 times 927
17 Unstoppable (11 kills) 75 times 750
18 Kill a Hostage 72 times -1080
19 Touch a Hostage 60 times 0
20 Rescue a Hostage 38 times 190
21 Revenge 2 times 6




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Revenge 121 times -363
2 Domination 2 times -10




  Team Selection *

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




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