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

Banner
  Player Information

Player Profile

Steam Community Avatar
Sweden JOHAN 123 DÖÖÖÖD
Location: Tidaholm, Sweden
Steam: STEAM_0:0:26992468
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 00:31:40h
Average Ping:* -
Favorite Server:*
Favorite Map:*
Favorite Weapon:*

Statistics Summary

Activity: -1%
Points: 1,027
Rank: Not active
Kills per Minute: 0.63
Kills per Death: 0.8333 (-*)
Headshots per Kill: 0.3000 (-*)
Shots per Kill: -
Weapon Accuracy: 23.8% (0%*)
Headshots: 6 (0*)
Kills: 20 (0*)
Deaths: 24 (0*)
Longest Kill Streak: 3
Longest Death Streak: 6
Suicides: 0
Teammate Kills: 0 (0*)

  History JOHAN 123 DÖÖÖÖD's History:
  Events | Sessions | Awards (1) | 
  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: 30 (40%)
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 sort-descending.gif Kills Deaths K:D Headshots HS:K Suicides Accuracy
1 JOHAN 123 DÖÖÖÖD 0d 00:02:28h 2020-12-26 22:41:48 1 2 0.50 1 1.00 0 50.0%
2 JOHAN69FOLKÖL 0d 00:01:01h 2020-12-26 22:39:20 1 1 1.00 0 0.00 0 19.2%
3 JOHANNA57MAGNET 0d 00:02:22h 2020-12-26 22:38:18 3 4 0.75 1 0.33 0 52.9%
4 Jonas57Magnus 0d 00:00:30h 2020-12-26 22:35:55 1 0 1.00 0 0.00 0 0.0%
5 MHMHMHMJAAUUU Get-Katt 0d 00:02:16h 2020-12-26 22:35:26 0 2 0.00 0 - 0 100.0%
6 FÖRHUDS-FRIKTION 0d 00:07:45h 2020-12-26 22:33:11 3 2 1.50 2 0.67 0 6.3%
7 Skadeskjuten stjärtmes 0d 00:01:33h 2020-12-26 22:25:21 0 2 0.00 0 - 0 100.0%
8 Johan Rehnborg 0d 00:02:43h 2020-12-26 22:23:49 1 3 0.33 0 0.00 0 28.0%
9 LAMA ROHADES 0d 00:08:11h 2020-12-26 22:21:07 9 5 1.80 2 0.22 0 29.1%
10 SmulaN 0d 00:01:18h 2020-12-26 22:12:56 0 1 0.00 0 - 0 0.0%
11 Big-O 0d 00:01:33h 2020-12-26 22:11:36 1 2 0.50 0 0.00 0 34.8%




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