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: 1,191,794
Total Kills: 230,184
Total Deaths: 9,408
Avg. Kills: 230,184
Kills per Death: 24.47
Kills per Minute: 4.43
Total Connection Time: 36d 01:08:16h
Avg. Connection Time: 36d 01:08:16h
Favorite Server:* [KR] 봇전쟁 (플레이어 VS 봇) ☆★
Favorite Map:* de_dust2
Favorite Weapon:* Kalashnikov AK-47
Player Locations

  Members

Rank Name Rank Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  Korea, republic ofHero elorank 1,191,794 36d 01:08:16h 230,184 100.00% 9,408 24.47




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 47,877 times 47,877
2 Domination 5,364 times 26,820
3 Round MVP 2,522 times 0
4 God Like (12+ kills) 1,214 times 13,354
5 Ownage (7 kills) 906 times 5,436
6 Ultra Kill (8 kills) 645 times 4,515
7 Mega Kill (6 kills) 601 times 3,005
8 Start Defusing the Bomb With a Defuse Kit 592 times 0
9 Domination (4 kills) 509 times 1,527
10 Defuse the Bomb 507 times 5,070
11 Rampage (5 kills) 499 times 1,996
12 Killing Spree (9 kills) 486 times 3,888
13 Touch a Hostage 433 times 0
14 Monster Kill (10 kills) 419 times 3,771
15 Triple Kill (3 kills) 387 times 774
16 Unstoppable (11 kills) 381 times 3,810
17 Double Kill (2 kills) 379 times 379
18 Rescue a Hostage 285 times 1,425
19 Kill a Hostage 102 times -1530
20 Start Defusing the Bomb Without a Defuse Kit 4 times 0
21 Revenge 3 times 9




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Revenge 342 times -1026
2 Domination 3 times -15




  Team Selection *

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




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