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

  Clan Information

Statistics Summary
Clan: RSPKTSCHELLE
Home Page:
Activity: 90.33%
Members: 21 active members (37 total)
Avg. Member Points: 34,023
Total Kills: 251,550
Total Deaths: 186,221
Avg. Kills: 11,979
Kills per Death: 1.35
Kills per Minute: 0.65
Total Connection Time: 270d 12:28:42h
Avg. Connection Time: 12d 21:09:56h
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  AustriaLuckyshO† ²high²fly elorank 56,553 16d 23:18:52h 19,275 7.66% 9,213 2.09
2  GermanyPiLziPiLz elorank 53,010 34d 04:21:44h 35,352 14.05% 25,842 1.37
3  GermanyLe`FuXx elorank 51,999 15d 18:56:23h 20,959 8.33% 9,879 2.12
4  Germanyᶨᵘᶨᵘ ♥ elorank 51,967 13d 04:12:29h 15,373 6.11% 6,922 2.22
5  Germany[PL] Apfelasch elorank 48,216 17d 06:51:55h 16,929 6.73% 10,903 1.55
6  GermanyT Y S O N elorank 45,627 44d 14:59:24h 39,386 15.66% 31,254 1.26
7  GermanySchwento elorank 45,228 24d 02:04:43h 19,640 7.81% 15,948 1.23
8  GermanyNebu elorank 44,017 13d 19:39:57h 14,025 5.58% 8,671 1.62
9  GermanySaiya'7 elorank 43,005 13d 10:51:29h 12,795 5.09% 9,553 1.34
10  GermanyG1NGH1SKHAN^ elorank 41,906 25d 23:22:36h 24,499 9.74% 21,295 1.15
11  Germanyrkiii @ Mundgeruch elorank 32,746 3d 01:24:09h 3,585 1.43% 2,159 1.66
12  Germany// sucio kɾL´ᶻ elorank 30,637 18d 04:51:17h 7,351 2.92% 13,366 0.55
13  GermanyF1R3 elorank 29,554 2d 01:26:19h 2,744 1.09% 1,226 2.24
14  GermanyDaDa Life elorank 27,242 5d 05:55:29h 4,728 1.88% 3,906 1.21
15  GermanyS 1 N O X x elorank 22,727 2d 06:52:46h 2,209 0.88% 1,630 1.36
16  Germany戦士 M K C | #Gooolazo elorank 21,358 8d 03:22:10h 5,199 2.07% 5,688 0.91
17  Germanymonu elorank 21,116 4d 01:06:47h 3,544 1.41% 2,970 1.19
18  GermanyH8Machine elorank 20,678 5d 13:14:44h 2,038 0.81% 4,081 0.50
19  GermanyĐДЯKŜPΞΞĐЎ[GER] elorank 12,698 0d 17:49:46h 689 0.27% 445 1.55
20  GermanyLuRod elorank 11,331 1d 14:59:20h 1,114 0.44% 1,101 1.01


Page: 1 2




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 5,756 times 5,756
2 Double Kill (2 kills) 1,828 times 1,828
3 Triple Kill (3 kills) 911 times 1,822
4 Pick up the Bomb 899 times 2,697
5 Drop the Bomb 495 times -1485
6 Domination (4 kills) 381 times 1,143
7 Plant the Bomb 348 times 2,088
8 Start Defusing the Bomb With a Defuse Kit 154 times 0
9 Rampage (5 kills) 124 times 496
10 Defuse the Bomb 91 times 910
11 Mega Kill (6 kills) 35 times 175
12 Ownage (7 kills) 11 times 66
13 Ultra Kill (8 kills) 4 times 28
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 689 times 28.27%
2 Terrorist 672 times 27.57%




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