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
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,290 24d 02:24:32h 19,656 7.81% 15,960 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,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