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

  Clan Information

Statistics Summary
Clan: 『LOH』
Home Page:
Activity: 100.00%
Members: 1 active members (1 total)
Avg. Member Points: 35,534
Total Kills: 1,517
Total Deaths: 143
Avg. Kills: 1,517
Kills per Death: 10.61
Kills per Minute: 2.51
Total Connection Time: 0d 10:04:14h
Avg. Connection Time: 0d 10:04:14h
Favorite Server:* [KR] 봇전쟁 (플레이어 VS 봇) ☆★
Favorite Map:* drfight
Favorite Weapon:* Steyr Aug
Player Locations

  Members

Rank Name Rank Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  Korea, republic of자숙 elorank 35,534 0d 10:04:14h 1,517 100.00% 143 10.61




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 558 times 558
2 Domination 117 times 585
3 Double Kill (2 kills) 53 times 53
4 Triple Kill (3 kills) 47 times 94
5 Domination (4 kills) 41 times 123
6 Mega Kill (6 kills) 34 times 170
7 Rampage (5 kills) 25 times 100
8 Round MVP 23 times 0
9 Ownage (7 kills) 20 times 120
10 Ultra Kill (8 kills) 17 times 119
11 Killing Spree (9 kills) 15 times 120
12 Monster Kill (10 kills) 12 times 108
13 Unstoppable (11 kills) 10 times 100
14 Touch a Hostage 6 times 0
15 Start Defusing the Bomb With a Defuse Kit 6 times 0
16 God Like (12+ kills) 5 times 55
17 Defuse the Bomb 5 times 50
18 Rescue a Hostage 4 times 20
19 Start Defusing the Bomb Without a Defuse Kit 2 times 0
20 Kill a Hostage 1 times -15




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Revenge 7 times -21




  Team Selection *

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




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