HLstatsX Community Edition
  • CSTRIKE
  • CSTRIKEGG
  • CSTRIKER
  • Contents
  • Search
  • Forum
  • Help

Banner
  Player Information

Player Profile

Steam Community Avatar
Denmark Johnnymagrethe
Location: Copenhagen, Denmark
Steam: STEAM_0:1:498304327
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:* (Unknown)
Total Connection Time: 0d 01:04:37h
Average Ping:* -
Favorite Server:*
Favorite Map:*
Favorite Weapon:*

Statistics Summary

Activity: -1%
Points: 1,154
Rank: Not active
Kills per Minute: 0.57
Kills per Death: 1.3704 (-*)
Headshots per Kill: 0.2703 (-*)
Shots per Kill: -
Weapon Accuracy: 25.1% (0%*)
Headshots: 10 (0*)
Kills: 37 (0*)
Deaths: 27 (0*)
Longest Kill Streak: 3
Longest Death Streak: 3
Suicides: 0
Teammate Kills: 0 (0*)

  History Johnnymagrethe's History:
  Events | Sessions | Awards (0) | 
  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: Recruit
Recruit
Kills needed: 13 (74%)
Rank history


  Awards (hover over image to see name)

Ribbons
Supreme AK47 Supreme Top Assassin Supreme AWP Sniper Supremef Desert Eagle Supreme Bomb Defuser Supreme Dual Beretta Elites Supreme Fusil Automatique Supreme Galil Supreme Glock Supreme Grenade Supreme Combat Knife Supreme Lowpinger Supreme M3 Super Supreme Colt M4A1 Supremef P90 Supreme Bomb Planter Supreme Hostage Rescuer Supreme Scout Elite Supreme USP
Global Awards


  Aliases

Rank Name Time Last Use Kills Deaths K:D Headshots HS:K sort-descending.gif Suicides Accuracy
1 Johnnymagrethe 0d 00:11:46h 2020-03-27 22:14:11 1 4 0.25 1 1.00 0 26.0%
2 whatismr 0d 00:01:20h 2020-03-27 21:12:11 3 1 3.00 2 0.67 0 41.7%
3 Johan 0d 00:09:16h 2020-03-27 22:00:57 4 6 0.67 2 0.50 0 27.0%
4 hvahelvedmandetvardauhygligniel 0d 00:05:59h 2020-03-27 21:47:16 3 4 0.75 1 0.33 0 22.8%
5 teameasyoff 0d 00:03:12h 2020-03-27 21:15:23 3 1 3.00 1 0.33 0 37.5%
6 ph-premium-any-good? 0d 00:14:08h 2020-03-27 21:41:18 8 4 2.00 2 0.25 0 23.0%
7 EGE 0d 00:04:20h 2020-03-27 21:51:36 5 3 1.67 1 0.20 0 37.5%
8 missen.fra.amsterdam 0d 00:01:33h 2020-03-27 21:10:51 1 0 1.00 0 0.00 0 0.0%
9 ååååchampselysee 0d 00:11:41h 2020-03-27 21:27:06 9 4 2.25 0 0.00 0 18.0%
10 Die Schwartze Katze [DK] 0d 00:01:22h 2020-03-27 22:02:18 0 0 0.00 0 - 0 0.0%




ERROR
Database Error

Server Address: localhost
Server Username: hlstats

Error Diagnostic:
Bad query.

Server Error: (1267) Illegal mix of collations (utf8mb4_german2_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 = 2400
			AND
			(
				hidden <> '1'
				OR hidden IS NULL
			)
			AND hlstats_Roles.game = 'cstriker'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			rolecount desc,
			name desc