HLstatsX Community Edition
  • Contents
  • Search
  • Help

  Sections

  Clan Information

Statistics Summary
Clan: Studio089.de
Home Page:
Activity: 90.80% 90.80%
Members: 5 active members (13 total)
Avg. Member Points: 146,509
Total Kills: 201,622
Total Deaths: 194,544
Avg. Kills: 40,324
Kills per Death: 1.04
Kills per Minute: 1.75
Total Connection Time: 79d 19:01:48h
Avg. Connection Time: 15d 23:00:21h
Favorite Server:* -= GG-Studio089.de =- Turbo GunGame Simpsons
Favorite Map:* gg_simpsons_winter_2018_v2
Favorite Weapon:* Steyr Scout
Player Locations

  Members

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




  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) 22 times 88
6 Revenge 27 times 81
7 Domination (4 kills) 49 times 147
8 Domination 75 times 375
9 Triple Kill (3 kills) 115 times 230
10 for WIN the Round! 232 times 11,600
11 Double Kill (2 kills) 250 times 250
12 Headshot 11,380 times 11,380




  Victims of Player-Player Actions *

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




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Terrorist 349 times 24.53%
2 Counter-Terrorist 322 times 22.63%




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