HLstatsX Community Edition
  • Contents
  • Search
  • Help

  Sections

  Clan Information

Statistics Summary
Clan: Studio089.de
Home Page:
Activity: 90.00% 90.00%
Members: 5 active members (13 total)
Avg. Member Points: 146,465
Total Kills: 201,587
Total Deaths: 194,510
Avg. Kills: 40,317
Kills per Death: 1.04
Kills per Minute: 1.75
Total Connection Time: 79d 18:38:49h
Avg. Connection Time: 15d 22:55:45h
Favorite Server:* -= GG-Studio089.de =- Turbo GunGame Simpsons
Favorite Map:* gg_simpsons_winter_2018_v2
Favorite Weapon:* Steyr Scout
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  United kingdomAds 212,758 34d 15:15:06h 91,957 45.62% 88,535 1.04
2  Germanyalkoholkonsum 195,879 24d 04:54:19h 51,793 25.69% 49,426 1.05
3  SwitzerlandHiddigeigei 166,784 7d 06:52:00h 22,774 11.30% 18,500 1.23
4  GermanyJennabolika 127,340 11d 22:07:33h 33,281 16.51% 35,382 0.94
5  GermanyDonDaCapo2 29,566 1d 17:29:51h 1,782 0.88% 2,667 0.67




  Player Actions *

Rank Action Achieved sort-ascending.gif Points Bonus
1 Unstoppable (11 kills) 1 times 10
2 Ownage (7 kills) 2 times 12
3 Ultra Kill (8 kills) 4 times 28
4 Mega Kill (6 kills) 7 times 35
5 Rampage (5 kills) 21 times 84
6 Revenge 27 times 81
7 Domination (4 kills) 46 times 138
8 Domination 72 times 360
9 Triple Kill (3 kills) 114 times 228
10 for WIN the Round! 227 times 11,350
11 Double Kill (2 kills) 249 times 249
12 Headshot 11,221 times 11,221




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Revenge 174 times -522
2 Domination 47 times -235




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Terrorist 343 times 24.41%
2 Counter-Terrorist 319 times 22.70%




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