HLstatsX Community Edition
  • Contents
  • Search
  • Help

  Sections

  Clan Information

Statistics Summary
Clan: [The ba
Home Page:
Activity: 99.00% 99.00%
Members: 3 active members (3 total)
Avg. Member Points: 68,695
Total Kills: 9,861
Total Deaths: 13,102
Avg. Kills: 3,287
Kills per Death: 0.75
Kills per Minute: 0.87
Total Connection Time: 7d 21:28:26h
Avg. Connection Time: 2d 15:09:28h
Favorite Server:* -= GG-Studio089.de =- Turbo GunGame Simpsons
Favorite Map:* gg_simpsons_castle_fixed
Favorite Weapon:* Steyr Scout
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  France[The bastards] Selassi 71,786 2d 20:14:48h 3,512 35.62% 4,366 0.80
2  Spain[The bastards] thxraph 69,718 1d 22:22:20h 2,672 27.10% 2,711 0.99
3  France[The bastards] Psyco 64,580 3d 02:51:18h 3,677 37.29% 6,025 0.61




  Player Actions *

Rank Action Achieved sort-ascending.gif Points Bonus
1 Mega Kill (6 kills) 2 times 10
2 Ultra Kill (8 kills) 2 times 14
3 Drop the Bomb 6 times -12
4 Pick up the Bomb 6 times 12
5 Rampage (5 kills) 6 times 24
6 Domination (4 kills) 17 times 51
7 Domination 18 times 90
8 Revenge 19 times 57
9 Triple Kill (3 kills) 33 times 66
10 Double Kill (2 kills) 138 times 138
11 for WIN the Round! 198 times 9,900
12 Headshot 11,096 times 11,096




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Revenge 130 times -390
2 Domination 43 times -215




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Terrorist 533 times 49.58%
2 Counter-Terrorist 5 times 0.47%




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