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

  Clan Information

Statistics Summary
Clan: hi
Home Page:
Activity: 100.00%
Members: 1 active members (1 total)
Avg. Member Points: 979,618
Total Kills: 187,883
Total Deaths: 8,081
Avg. Kills: 187,883
Kills per Death: 23.25
Kills per Minute: 3.86
Total Connection Time: 33d 20:11:49h
Avg. Connection Time: 33d 20:11:49h
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  PhilippinesReshyyy ` elorank 979,618 33d 20:11:49h 187,883 100.00% 8,081 23.25




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 46,516 times 46,516
2 Domination 5,733 times 28,665
3 Round MVP 2,820 times 0
4 God Like (12+ kills) 1,546 times 17,006
5 Start Defusing the Bomb With a Defuse Kit 859 times 0
6 Defuse the Bomb 721 times 7,210
7 Touch a Hostage 720 times 0
8 Ownage (7 kills) 708 times 4,248
9 Ultra Kill (8 kills) 587 times 4,109
10 Mega Kill (6 kills) 534 times 2,670
11 Killing Spree (9 kills) 499 times 3,992
12 Rampage (5 kills) 484 times 1,936
13 Monster Kill (10 kills) 479 times 4,311
14 Rescue a Hostage 474 times 2,370
15 Domination (4 kills) 411 times 1,233
16 Unstoppable (11 kills) 398 times 3,980
17 Triple Kill (3 kills) 388 times 776
18 Double Kill (2 kills) 348 times 348
19 Kill a Hostage 131 times -1965




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Revenge 285 times -855




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Counter-Terrorist 1,105 times 40.90%




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