HLstatsX Community Edition
  • Contents
  • Search
  • Help

  Sections

  Clan Information

Statistics Summary
Clan: [The ba
Home Page:
Activity: 100.00% 100.00%
Members: 3 active members (3 total)
Avg. Member Points: 63,007
Total Kills: 9,161
Total Deaths: 12,301
Avg. Kills: 3,054
Kills per Death: 0.74
Kills per Minute: 0.87
Total Connection Time: 7d 06:44:56h
Avg. Connection Time: 2d 10:14:58h
Favorite Server:* -= GG-Studio089.de =- Turbo GunGame Simpsons
Favorite Map:* gg_crush_crew
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 69,477 2d 18:25:25h 3,480 37.99% 4,319 0.81
2  France[The bastards] Psyco 60,273 2d 20:53:11h 3,403 37.15% 5,618 0.61
3  Spain[The bastards] thxraph 59,271 1d 15:26:20h 2,278 24.87% 2,364 0.96




  Player Actions *

Rank Action Achieved sort-ascending.gif Points Bonus
1 Drop the Bomb 1 times -2
2 Ownage (7 kills) 1 times 6
3 Pick up the Bomb 1 times 2
4 Mega Kill (6 kills) 3 times 15
5 Rampage (5 kills) 12 times 48
6 Domination (4 kills) 23 times 69
7 Domination 25 times 125
8 Revenge 27 times 81
9 Triple Kill (3 kills) 61 times 122
10 Double Kill (2 kills) 141 times 141
11 for WIN the Round! 266 times 13,300
12 Headshot 14,938 times 14,938




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Revenge 168 times -504
2 Domination 52 times -260




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Terrorist 688 times 49.11%
2 Counter-Terrorist 11 times 0.79%




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