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

  Sections

  Player Rankings

Find a player:
Ranking View


ERROR
Database Error

Server Address: localhost
Server Username: hlstatsx

Error Diagnostic:
Bad query.

Server Error: (144) Table './hlstatsx/hlstats_Players' is marked as crashed and last (automatic?) repair failed

Last SQL Query:
				SELECT
					SQL_CALC_FOUND_ROWS
					hlstats_Players.playerId,
					hlstats_Players.connection_time,
                                        unhex(replace(hex(hlstats_Players.lastName), 'E280AE', '')) as lastName,
					hlstats_Players.flag,
					hlstats_Players.country,
					hlstats_Players.skill,
					hlstats_Players.kills,
					hlstats_Players.deaths,
					hlstats_Players.last_skill_change,
					ROUND(hlstats_Players.kills/(IF(hlstats_Players.deaths=0, 1, hlstats_Players.deaths)), 2) AS kpd,
					hlstats_Players.headshots,
					ROUND(hlstats_Players.headshots/(IF(hlstats_Players.kills=0, 1, hlstats_Players.kills)), 2) AS hpk,
					IFNULL(ROUND((hlstats_Players.hits / hlstats_Players.shots * 100), 1), 0) AS acc,
					activity
				FROM
					hlstats_Players
				WHERE
					hlstats_Players.game = 'css'
					AND hlstats_Players.hideranking = 0
					AND hlstats_Players.kills >= 1
				ORDER BY
					skill desc,
					kpd desc,
					hlstats_Players.lastName ASC
				LIMIT
					0,
					50