HLstatsX Community Edition
  • L4D
  • L4D2
  • Contents
  • Search
  • SourceBans
  • Help

Banner
  Sections

  Player Information

Player Profile

Steam Community Avatar
Greece [GR]rex44dx
Location: Lárisa, Greece
Steam: STEAM_0:1:530199142
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)
Last Connect:* (Unknown)
Total Connection Time: 0d 00:34:16h
Average Ping:* -
Favorite Server:*
Favorite Map:*
Favorite Weapon:*
ERROR
Database Error

Server Address: localhost
Server Username: root

Error Diagnostic:
Bad query.

Server Error: ()

Last SQL Query:
								SELECT
									hlstats_Events_Frags.weapon,
									hlstats_Weapons.name,
									COUNT(hlstats_Events_Frags.weapon) AS kills,
									SUM(hlstats_Events_Frags.headshot=1) as headshots
								FROM
									hlstats_Events_Frags
								LEFT JOIN
									hlstats_Weapons
								ON
									hlstats_Weapons.code = hlstats_Events_Frags.weapon
								WHERE
									hlstats_Events_Frags.killerId=17140
								GROUP BY
									hlstats_Events_Frags.weapon
								ORDER BY
									kills desc, headshots desc
								LIMIT
									1