HLstatsX Community Edition
  • CSS
  • CLASSIC
  • Contents
  • Search
  • Help
Style:

  Player Information

Player Profile

Steam Community Avatar
Russia C0JI9PA
Location: Tomsk, Russia
Steam: STEAM_0:1:506747678
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:* Sat. Apr. 2nd, 2022 @ 06:10:21
Total Connection Time: 0d 02:40:11h
Average Ping:* -
Favorite Server:*
Favorite Map:* de_westwood
Favorite Weapon:* Kalashnikov AK-47

Statistics Summary

Activity: 100%
Points: 1,092
Rank: 27
Kills per Minute: 0.89
Kills per Death: 1.2544 (1.25*)
Headshots per Kill: 0.0000 (0.0000*)
Shots per Kill: -
Weapon Accuracy: 0.0% (0%*)
Headshots: 0 (0*)
Kills: 143 (143*)
Deaths: 114 (114*)
Longest Kill Streak: 4
Longest Death Streak: 7
Suicides: 0
Teammate Kills: 0 (0*)

  History C0JI9PA'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 C0JI9PA 0d 02:02:37h 2022-04-02 06:10:32 117 97 1.21 0 0.00 0 0.0%
2 C0JI9PA (Лёва) 0d 00:37:34h 2022-03-21 21:43:26 26 17 1.53 0 0.00 0 0.0%




ERROR
Database Error

Server Address: db.hlstatsx
Server Username: hl

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