HLstatsX Community Edition
  • Contents
  • Search
  • SourceBans
  • Forum
  • Help

  Clan Information

Statistics Summary
Clan: SaunaBROS
Home Page:
Activity: 98.00%
Members: 7 active members (9 total)
Avg. Member Points: 33,983
Total Kills: 112,279
Total Deaths: 107,742
Avg. Kills: 16,040
Kills per Death: 1.04
Kills per Minute: 0.47
Total Connection Time: 166d 19:46:38h
Avg. Connection Time: 23d 19:58:05h
Favorite Server:* * SchlachtHof :|: Dust2 Only :|: *Test* // noAim.eu
Favorite Map:* de_dust2
Favorite Weapon:* Kalashnikov AK-47
Player Locations

  Members

Rank Name Rank Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  GermanyZoo elorank 60,456 59d 22:08:43h 50,331 44.83% 32,422 1.55
2  Austria✯ghostfacekillah✯ elorank 40,258 18d 14:51:13h 14,973 13.34% 11,227 1.33
3  Germany<==[T@nkm@n]==> elorank 37,054 12d 05:12:49h 9,139 8.14% 8,223 1.11
4  Lithuaniawuffwuff elorank 29,424 21d 16:16:11h 11,596 10.33% 15,803 0.73
5  Germanyjohoe elorank 26,700 24d 21:16:01h 13,000 11.58% 18,892 0.69
6  GermanyLucky ☆ Sτя!κε elorank 24,054 22d 19:08:07h 10,092 8.99% 16,007 0.63
7  GermanyMiesaTyp elorank 19,936 6d 16:53:34h 3,148 2.80% 5,168 0.61




  Player Actions *

Rank Action Achieved sort-ascending.gif Points Bonus
1 Ownage (7 kills) 1 times 6
2 Ultra Kill (8 kills) 1 times 7
3 Start Defusing the Bomb Without a Defuse Kit 4 times 0
4 Mega Kill (6 kills) 6 times 30
5 Rampage (5 kills) 25 times 100
6 Defuse the Bomb 26 times 260
7 Start Defusing the Bomb With a Defuse Kit 38 times 0
8 Domination (4 kills) 83 times 249
9 Plant the Bomb 192 times 1,152
10 Drop the Bomb 248 times -744
11 Triple Kill (3 kills) 283 times 566
12 Pick up the Bomb 471 times 1,413
13 Double Kill (2 kills) 861 times 861
14 Headshot 2,036 times 2,036




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Counter-Terrorist 302 times 29.58%
2 Terrorist 298 times 29.19%




ERROR
Database Error

Server Address: localhost
Server Username: hlsx

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