HLstatsX Community Edition
  • Contents
  • Search
  • Help

  Sections

  Clan Information

Statistics Summary
Clan: [The ba
Home Page:
Activity: 92.33% 92.33%
Members: 3 active members (3 total)
Avg. Member Points: 66,306
Total Kills: 9,647
Total Deaths: 12,892
Avg. Kills: 3,216
Kills per Death: 0.75
Kills per Minute: 0.88
Total Connection Time: 7d 15:22:04h
Avg. Connection Time: 2d 13:07:21h
Favorite Server:* -= GG-Studio089.de =- Turbo GunGame Simpsons
Favorite Map:* gg_crush_crew
Favorite Weapon:* Steyr Scout
Player Locations

  Members

Rank Name Points Activity Time Kills sort-descending.gif Clan Kills % Deaths Kpd
1  France[The bastards] Psyco 63,481 3d 01:01:46h 3,597 37.29% 5,927 0.61
2  France[The bastards] Selassi 70,538 2d 19:25:32h 3,512 36.41% 4,366 0.80
3  Spain[The bastards] thxraph 64,899 1d 18:54:46h 2,538 26.31% 2,599 0.98




  Player Actions *

Rank Action Achieved sort-ascending.gif Points Bonus
1 Ultra Kill (8 kills) 1 times 7
2 Mega Kill (6 kills) 2 times 10
3 Drop the Bomb 4 times -8
4 Pick up the Bomb 4 times 8
5 Rampage (5 kills) 9 times 36
6 Domination 22 times 110
7 Domination (4 kills) 22 times 66
8 Revenge 26 times 78
9 Triple Kill (3 kills) 41 times 82
10 Double Kill (2 kills) 161 times 161
11 for WIN the Round! 206 times 10,300
12 Headshot 13,181 times 13,181




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Revenge 142 times -426
2 Domination 57 times -285




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Terrorist 621 times 49.05%
2 Counter-Terrorist 12 times 0.95%




ERROR
Database Error

Server Address: localhost
Server Username: hl1148

Error Diagnostic:
Bad query.

Server Error: (1267) Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='

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