HLstatsX Community Edition
  • Contents
  • Search
  • Help

  Sections

  Clan Information

Statistics Summary
Clan: Shooter
Home Page:
Activity: 100.00% 100.00%
Members: 1 active members (2 total)
Avg. Member Points: 108,414
Total Kills: 17,180
Total Deaths: 17,139
Avg. Kills: 17,180
Kills per Death: 1.00
Kills per Minute: 0.95
Total Connection Time: 12d 11:51:12h
Avg. Connection Time: 12d 11:51:12h
Favorite Server:* -= GG-Studio089.de =- Turbo GunGame Simpsons
Favorite Map:* gg_simpsons_funfreaks_v2
Favorite Weapon:* Bundeswehr Advanced Combat Knife
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  TunisiaSHOOTER"try to remember" 108,414 12d 11:51:12h 17,180 100.00% 17,139 1.00




  Player Actions *

Rank Action Achieved sort-ascending.gif Points Bonus
1 Drop the Bomb 1 times -2
2 Pick up the Bomb 1 times 2
3 Ultra Kill (8 kills) 1 times 7
4 Killing Spree (9 kills) 2 times 16
5 Mega Kill (6 kills) 4 times 20
6 Ownage (7 kills) 4 times 24
7 Rampage (5 kills) 7 times 28
8 Revenge 14 times 42
9 Domination (4 kills) 54 times 162
10 Domination 62 times 310
11 Triple Kill (3 kills) 73 times 146
12 Double Kill (2 kills) 179 times 179
13 for WIN the Round! 260 times 13,000
14 Headshot 8,346 times 8,346




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Counter-Terrorist 295 times 26.01%
2 Terrorist 285 times 25.13%




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