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

  Player Information

Player Profile

Steam Community Avatar
Germany [PL] Apfelasch
Location: Essen, Germany
Steam: STEAM_0:0:104783325
Status: Offline
Click here to add as friend
Karma: In good standing
Member of Clan:  RSPKTSCHELLE
Real Name: (Not Specified)
E-mail Address: (Not Specified)
Home Page: (Not Specified)
MM Rank: rank
Last Connect:* Fri. Mar. 7th, 2025 @ 19:23:35
Total Connection Time: 6d 22:15:26h
Average Ping:* -
Favorite Server:* * SchlachtHof :|: Dust2 Only :|: *Test* // noAim.eu
Favorite Map:* de_dust2
Favorite Weapon:* Desert Eagle .50AE

Statistics Summary

Activity: 85%
Points: 18,921
Rank: 29
Kills per Minute: 0.69
Kills per Death: 1.5413 (1.39*)
Headshots per Kill: 0.5668 (0.6350*)
Shots per Kill: -
Weapon Accuracy: 22.8% (0%*)
Headshots: 3,912 (167*)
Kills: 6,902 (263*)
Deaths: 4,478 (189*)
Longest Kill Streak: 9
Longest Death Streak: 10
Suicides: 0
Teammate Kills: 0 (0*)

  History [PL] Apfelasch's History:
  Events | Sessions | Awards (23) | Chat
  Search Find other players with the same name


  Miscellaneous Statistics

Player Trend
Player Trend Graph
Forum Signature


forum sig image

bbCode 1 (phpBB, SMF) | bbCode 2 (IPB) | Direct Image


  Ranks

Current rank: Colonel
Colonel
Kills needed: 348 (54%)
Rank history
Recruit Private Private First Class Lance Corporal Corporal Sergeant Staff Sergeant Gunnery Sergeant Master Sergeant First Sergeant Master Chief Sergeant Major Ensign Third Lieutenant Second Lieutenant First Lieutenant Captain Group Captain Senior Captain Lieutenant Major Major Group Major Lieutenant Commander Commander Group Commander Lieutenant Colonel


  Awards (hover over image to see name)

Ribbons
Sharpshooter Connection Time 150 Hours Supreme AK47 Supreme Steyr Aug Supreme AWP Sniper Bronze Desert Eagle Award of Bomb Defuser Supreme Dual Beretta Elites Award of Famas Supreme Five-Seven Supreme G3 SG1 Supreme Galil Award of Glock Award of Headshots Award of HE Grenades Supreme Hostage Killer Award of Combat Knife Supreme Lowpinger Supreme M249 Para Supreme M3 Shotgun Supreme Colt M4A1 Award of MAC 10 Award of Most Kills Supreme MP5 Navy Supreme Sig P228 Award of P90 Award of Bomb Planter Supreme Hostage Rescuer Supreme Scout Elite Supreme SG 550 Supreme SG 552 Supreme Suicides Supreme Team Kills Supreme TMP Supreme UMP 45 Supreme USP Supreme XM Shotgun
Global Awards


  Aliases

Rank Name Time Last Use sort-descending.gif Kills Deaths K:D Headshots HS:K Suicides Accuracy
1 [PL] Apfelasch 6d 21:40:46h 2025-03-07 21:10:49 6,881 4,465 1.54 3,905 0.57 0 22.8%
2 [PL] SuperApfelasch 0d 00:34:40h 2025-01-25 21:46:16 21 13 1.62 7 0.33 0 0.0%




  Player Actions *

Rank Action Earned sort-descending.gif Accumulated Points
1 Headshot 167 times 167
2 Double Kill (2 kills) 47 times 47
3 Pick up the Bomb 18 times 54
4 Triple Kill (3 kills) 17 times 34
5 Drop the Bomb 15 times -45
6 Rampage (5 kills) 5 times 20
7 Domination (4 kills) 5 times 15
8 Start Defusing the Bomb With a Defuse Kit 4 times 0
9 Plant the Bomb 3 times 18
10 Defuse the Bomb 3 times 30




  Team Selection *

Rank Team Joined sort-descending.gif % Ratio
1 Terrorist 13 times 36.11%
2 Counter-Terrorist 8 times 22.22%




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,
			hlstats_Frags_as_res.killsTotal,
			hlstats_Frags_as_res.deathsTotal,
			ROUND(hlstats_Frags_as_res.killsTotal / IF(hlstats_Frags_as_res.deathsTotal = 0, 1, hlstats_Frags_as_res.deathsTotal), 2) AS kpd
		FROM
			hlstats_Events_ChangeRole
		LEFT JOIN
			hlstats_Roles
		ON
			hlstats_Events_ChangeRole.role = hlstats_Roles.code
		LEFT JOIN
			hlstats_Frags_as_res
		ON
			hlstats_Frags_as_res.role = hlstats_Events_ChangeRole.role
		WHERE
			hlstats_Events_ChangeRole.playerId = 188
			AND
			(
				hidden <> '1'
				OR hidden IS NULL
			)
			AND hlstats_Roles.game = 'css'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			rolecount desc,
			name desc