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

  Clan Information

Statistics Summary
Clan: RSPKTSCHELLE
Home Page:
Activity: 74.80%
Members: 21 active members (33 total)
Avg. Member Points: 24,755
Total Kills: 125,101
Total Deaths: 96,212
Avg. Kills: 5,957
Kills per Death: 1.30
Kills per Minute: 0.62
Total Connection Time: 141d 02:08:27h
Avg. Connection Time: 6d 17:14:41h
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 48,092 11d 12:23:45h 13,491 10.78% 6,068 2.22
2  Germany[PL] Apfelasch elorank 45,199 15d 20:24:34h 15,592 12.46% 9,973 1.56
3  Austria✪plexx♛[♥] elorank 42,815 5d 13:37:24h 7,143 5.71% 2,980 2.40
4  GermanySchwento elorank 40,430 21d 09:40:58h 17,413 13.92% 14,145 1.23
5  GermanyNebu elorank 39,436 12d 04:31:46h 12,512 10.00% 7,647 1.64
6  Germanyg1N^ elorank 36,535 21d 13:25:08h 20,533 16.41% 17,773 1.16
7  GermanySaiya'7 elorank 33,732 10d 01:45:56h 9,608 7.68% 7,136 1.35
8  GermanySqueezzzy. elorank 32,381 3d 02:52:46h 3,475 2.78% 2,061 1.69
9  GermanyDaDa Life elorank 26,572 5d 01:47:51h 4,586 3.67% 3,790 1.21
10  Germany// k a r L ´s d1Ng elorank 25,332 13d 18:54:39h 5,742 4.59% 10,226 0.56
11  GermanyVOGELSBERGER <AᵗzεHᵃʰᵑ> elorank 21,241 4d 12:54:54h 3,206 2.56% 2,812 1.14
12  GermanyS 1 N O X x elorank 21,177 2d 01:06:34h 1,974 1.58% 1,457 1.35
13  Germanymonu elorank 20,778 3d 22:59:08h 3,487 2.79% 2,899 1.20
14  GermanyH8Machine elorank 19,993 5d 03:23:01h 1,927 1.54% 3,756 0.51
15  Germanyrkiii elorank 17,871 1d 00:44:55h 1,174 0.94% 709 1.66
16  GermanyHEADSHEET © elorank 17,003 1d 12:05:38h 1,206 0.96% 953 1.27
17  GermanyĐДЯKŜPΞΞĐЎ[GER] elorank 12,283 0d 16:42:22h 661 0.53% 413 1.60
18  GermanyLuRod elorank 10,966 1d 13:12:00h 1,089 0.87% 1,083 1.01
19  Germanyn1 elorank 4,672 0d 05:51:10h 181 0.14% 158 1.15
20  Germany187iNsaNe elorank 2,245 0d 05:12:42h 86 0.07% 157 0.55


Page: 1 2




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 4,563 times 4,563
2 Double Kill (2 kills) 1,421 times 1,421
3 Triple Kill (3 kills) 736 times 1,472
4 Pick up the Bomb 704 times 2,112
5 Drop the Bomb 404 times -1212
6 Domination (4 kills) 304 times 912
7 Plant the Bomb 273 times 1,638
8 Rampage (5 kills) 100 times 400
9 Start Defusing the Bomb With a Defuse Kit 83 times 0
10 Defuse the Bomb 51 times 510
11 Mega Kill (6 kills) 30 times 150
12 Ownage (7 kills) 10 times 60
13 Killing Spree (9 kills) 2 times 16
14 Start Defusing the Bomb Without a Defuse Kit 1 times 0




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Terrorist 485 times 28.66%
2 Counter-Terrorist 482 times 28.49%




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