HLstatsX Community Edition
  • Contents
  • Search
  • Help

  Sections

  Clan Information

Statistics Summary
Clan: Studio089.de
Home Page:
Activity: 96.00% 96.00%
Members: 5 active members (13 total)
Avg. Member Points: 148,281
Total Kills: 202,425
Total Deaths: 195,213
Avg. Kills: 40,485
Kills per Death: 1.04
Kills per Minute: 1.76
Total Connection Time: 80d 02:20:09h
Avg. Connection Time: 16d 00:28:02h
Favorite Server:* -= GG-Studio089.de =- Turbo GunGame Simpsons
Favorite Map:* gg_simpsons_house
Favorite Weapon:* Bundeswehr Advanced Combat Knife
Player Locations

  Members

Rank Name sort-descending.gif Points Activity Time Kills Clan Kills % Deaths Kpd
1  GermanyJennabolika 132,242 12d 01:34:54h 33,637 16.62% 35,746 0.94
2  SwitzerlandHiddigeigei 166,850 7d 06:59:07h 22,776 11.25% 18,502 1.23
3  GermanyDonDaCapo2 29,793 1d 17:57:18h 1,819 0.90% 2,702 0.67
4  Germanyalkoholkonsum 195,879 24d 04:54:19h 51,793 25.59% 49,426 1.05
5  United kingdomAds 216,640 34d 18:54:31h 92,400 45.65% 88,837 1.04




  Player Actions *

Rank Action Achieved sort-ascending.gif Points Bonus
1 Drop the Bomb 1 times -2
2 Killing Spree (9 kills) 1 times 8
3 Pick up the Bomb 1 times 2
4 Unstoppable (11 kills) 1 times 10
5 Ownage (7 kills) 3 times 18
6 Ultra Kill (8 kills) 5 times 35
7 Mega Kill (6 kills) 11 times 55
8 Rampage (5 kills) 31 times 124
9 Revenge 44 times 132
10 Domination (4 kills) 75 times 225
11 Domination 113 times 565
12 Triple Kill (3 kills) 150 times 300
13 for WIN the Round! 330 times 16,500
14 Double Kill (2 kills) 369 times 369
15 Headshot 15,500 times 15,500




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-ascending.gif Points Bonus
1 Domination 73 times -365
2 Revenge 243 times -729




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Terrorist 471 times 25.20%
2 Counter-Terrorist 435 times 23.27%




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