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

  Clan Information

Statistics Summary
Clan: RSPKTSCHELLE
Home Page:
Activity: 76.07%
Members: 14 active members (20 total)
Avg. Member Points: 20,200
Total Kills: 96,272
Total Deaths: 69,337
Avg. Kills: 6,877
Kills per Death: 1.39
Kills per Minute: 0.64
Total Connection Time: 103d 17:22:46h
Avg. Connection Time: 7d 09:48:46h
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  Germanyᶨᵘᶨᵘ ♥ elorank 39,526 8d 00:43:58h 9,396 9.76% 4,296 2.19
2  GermanyT Y S O N elorank 36,071 34d 15:50:34h 30,833 32.03% 24,241 1.27
3  GermanyLe`FuXx elorank 34,055 9d 20:29:57h 13,081 13.59% 6,170 2.12
4  GermanySchwento elorank 32,151 15d 00:35:43h 12,205 12.68% 10,079 1.21
5  GermanySaiya'7 elorank 31,164 9d 05:19:19h 8,764 9.10% 6,534 1.34
6  GermanyGerryB elorank 27,393 5d 09:42:42h 5,135 5.33% 3,380 1.52
7  GermanyɔɌɨΜϩοή τίᴅᴇ™ elorank 24,634 7d 19:48:22h 7,044 7.32% 4,923 1.43
8  Germany戦士 M K C | #Gooolazo elorank 21,247 8d 02:42:00h 5,183 5.38% 5,667 0.91
9  Germanymonu elorank 20,098 3d 20:26:33h 3,410 3.54% 2,840 1.20
10  GermanyLuRod elorank 10,449 1d 12:03:53h 1,052 1.09% 1,050 1.00
11  Germanyn1 elorank 2,620 0d 03:00:17h 98 0.10% 78 1.26
12  Germany™→Panda←™ elorank 1,162 0d 01:25:58h 34 0.04% 46 0.74
13  GermanyEvel elorank 1,141 0d 00:49:17h 27 0.03% 22 1.23
14  GermanyBob Lee elorank 1,092 0d 00:24:13h 10 0.01% 11 0.91




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 2,400 times 2,400
2 Double Kill (2 kills) 876 times 876
3 Triple Kill (3 kills) 366 times 732
4 Pick up the Bomb 344 times 1,032
5 Drop the Bomb 197 times -591
6 Domination (4 kills) 152 times 456
7 Plant the Bomb 133 times 798
8 Rampage (5 kills) 55 times 220
9 Start Defusing the Bomb With a Defuse Kit 50 times 0
10 Defuse the Bomb 30 times 300
11 Mega Kill (6 kills) 8 times 40
12 Ownage (7 kills) 6 times 36
13 Killing Spree (9 kills) 1 times 8




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Terrorist 286 times 31.57%
2 Counter-Terrorist 242 times 26.71%




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