HLstatsX Community Edition
  • Contents
  • Search
  • Help

  Player Information

Player Profile

Steam Community Avatar
 derp.
Location: (Unknown)
Steam: STEAM_0:0:161431534
Status: Offline
Click here to add as friend
Karma: In good standing
Member of Clan: (None)
Real Name: (Not Specified)
E-mail Address: (Not Specified)
Home Page: (Not Specified)
MM Rank: rank
Last Connect:* Mon. May. 25th, 2020 @ 17:39:21
Total Connection Time: 0d 03:19:01h
Average Ping:* 25 ms (Latency: 13 ms)
Favorite Server:* ✺ [PL] Sloneczny-Dust.pl [MultiArena 1vs1] [NOPRIME / 128TR / SKINY / KNIFE / GLOVES]
Favorite Map:* am_water_sm
Favorite Weapon:* Kalashnikov AK-47

Statistics Summary

Activity: 100%
Points: 948
Rank: 3,575
Kills per Minute: 1.00
Kills per Death: 0.7634 (0.76*)
Headshots per Kill: 0.4400 (0.4400*)
Shots per Kill: 14.76
Weapon Accuracy: 19.8% (20%*)
Headshots: 88 (88*)
Kills: 200 (200*)
Deaths: 262 (262*)
Longest Kill Streak: 2
Longest Death Streak: 13
Suicides: 0
Teammate Kills: 0 (0*)

  History derp.'s History:
  Events | Sessions | Awards (0) | 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:
Kills needed: 0 (0%)
Rank history


  Aliases

Rank Name Time Last Use sort-descending.gif Kills Deaths K:D Headshots HS:K Suicides Accuracy
1 derp. 0d 02:21:37h 2020-05-25 17:43:46 138 184 0.75 58 0.42 0 19.9%
2 derp.EXE 0d 00:57:24h 2020-05-08 12:50:32 62 78 0.79 30 0.48 0 19.5%




ERROR
Database Error

Server Address: 31.133.0.163
Server Username: hlstatsx

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 = 503
			AND
			(
				hidden <> '1'
				OR hidden IS NULL
			)
			AND hlstats_Roles.game = '14'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			rolecount desc,
			name desc