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

  Clan Information

Statistics Summary
Clan: RSPKTSCHELLE
Home Page:
Activity: 87.85%
Members: 21 active members (37 total)
Avg. Member Points: 34,025
Total Kills: 251,566
Total Deaths: 186,233
Avg. Kills: 11,979
Kills per Death: 1.35
Kills per Minute: 0.65
Total Connection Time: 270d 12:48:31h
Avg. Connection Time: 12d 21:10:52h
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
21  Germany| Ξx⊂ΞLLΞ∩T ™ ♛ elorank 2,858 0d 04:46:23h 116 0.05% 169 0.69


Page: 1 2




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 5,544 times 5,544
2 Double Kill (2 kills) 1,748 times 1,748
3 Triple Kill (3 kills) 870 times 1,740
4 Pick up the Bomb 855 times 2,565
5 Drop the Bomb 469 times -1407
6 Domination (4 kills) 367 times 1,101
7 Plant the Bomb 332 times 1,992
8 Start Defusing the Bomb With a Defuse Kit 139 times 0
9 Rampage (5 kills) 119 times 476
10 Defuse the Bomb 82 times 820
11 Mega Kill (6 kills) 34 times 170
12 Ownage (7 kills) 11 times 66
13 Ultra Kill (8 kills) 3 times 21
14 Start Defusing the Bomb Without a Defuse Kit 1 times 0




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Counter-Terrorist 664 times 28.22%
2 Terrorist 649 times 27.58%




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