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

  Player Information

Player Profile

Steam Community Avatar
 LISTERINE
Location: (Unknown)
Steam: STEAM_0:STEAM_ID_STOP_IGNORING_RETVALS
Status: Unknown
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 02:11:49h
Average Ping:* -
Favorite Server:*
Favorite Map:*
Favorite Weapon:*

Statistics Summary

Activity: 100%
Points: 1,063
Rank: 2,191
Kills per Minute: 0.00
Kills per Death: - (-*)
Headshots per Kill: - (-*)
Shots per Kill: -
Weapon Accuracy: 0.0% (0%*)
Headshots: 0 (0*)
Kills: 0 (0*)
Deaths: 0 (0*)
Longest Kill Streak: 0
Longest Death Streak: 0
Suicides: 0
Teammate Kills: 0 (0*)

  History LISTERINE'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: 100 (0%)
Rank history


  Awards (hover over image to see name)

Ribbons
Sharpshooter Connection Time 150 Hours Supreme AK47 Supreme Steyr Aug Supreme AWP Sniper Supreme Desert Eagle Supreme Bomb Defuser Supreme Dual Beretta Elites Award of Famas Supreme Five-Seven Supreme G3 SG1 Supreme Galil Supreme Glock Supreme Headshots Supreme HE Grenades Supreme Hostage Killer Supreme Combat Knife Supreme Lowpinger Supreme M249 Para Supreme M3 Shotgun Supreme Colt M4A1 Supreme MAC 10 Supreme Most Kills Supreme MP5 Navy Supreme Sig P228 Supreme P90 Supreme 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 LISTERINE 0d 00:04:56h 2025-06-06 21:45:03 0 0 0.00 0 - 0 0.0%
2 Yura Yamato 0d 00:25:11h 2025-05-07 18:42:01 0 0 0.00 0 - 0 0.0%
3 forarch 0d 00:05:10h 2025-04-07 11:59:05 0 0 0.00 0 - 0 0.0%
4 CM 0d 00:06:52h 2025-04-01 21:13:30 0 0 0.00 0 - 0 0.0%
5 Reshyyy ` 0d 00:22:01h 2025-02-17 02:11:42 0 0 0.00 0 - 0 0.0%
6 Ugandan Knuckles 0d 00:04:18h 2025-02-17 01:57:55 0 0 0.00 0 - 0 0.0%
7 kr 0d 00:10:16h 2025-01-04 23:19:17 0 0 0.00 0 - 0 0.0%
8 coaw 0d 00:12:11h 2024-12-26 04:58:21 0 0 0.00 0 - 0 0.0%
9 Naver 0d 00:01:32h 2024-12-05 17:39:54 0 0 0.00 0 - 0 0.0%
10 5henry 0d 00:12:07h 2024-11-19 20:16:28 0 0 0.00 0 - 0 0.0%
11 StatesMAN 0d 00:11:56h 2024-10-27 10:56:40 0 0 0.00 0 - 0 0.0%
12 BamBam 0d 00:05:27h 2024-10-22 20:39:20 0 0 0.00 0 - 0 0.0%
13 Ultimate 0d 00:04:57h 2024-08-24 21:33:03 0 0 0.00 0 - 0 0.0%
14 bleach heaven 0d 00:04:55h 2024-03-26 17:47:33 0 0 0.00 0 - 0 0.0%




  Team Selection *

Rank Team Joined sort-descending.gif % Ratio
1 Counter-Terrorist 1 times 25.00%




ERROR
Database Error

Server Address: localhost
Server Username: hlstatsx

Error Diagnostic:
Bad query.

Server Error: (1055) Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hlstatsx.hlstats_Frags_as_res.killsTotal' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

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