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

ERROR
Database Error

Server Address: 178.250.45.237
Server Username: hlx_csgo_arena

Error Diagnostic:
Bad query.

Server Error: (145) Table './hlx_csgo_arena/hlstats_Players' is marked as crashed and should be repaired

Last SQL Query:
		SELECT
			hlstats_Countries.flag,
			hlstats_Countries.name,
			COUNT(hlstats_Players.playerId) AS nummembers,
			SUM(hlstats_Players.kills) AS kills,
			SUM(hlstats_Players.deaths) AS deaths,
			SUM(hlstats_Players.connection_time) AS connection_time,
			ROUND(AVG(hlstats_Players.skill)) AS skill,
			ROUND(AVG(hlstats_Players.last_skill_change)) AS last_skill_change,
			ROUND(SUM(hlstats_Players.kills) / IF(SUM(hlstats_Players.deaths) = 0, 1, SUM(hlstats_Players.deaths)), 2) AS kpd,
			TRUNCATE(AVG(activity), 2) AS activity
		FROM
			hlstats_Countries 
		LEFT JOIN
			hlstats_Players
		ON
			hlstats_Players.flag = hlstats_Countries.flag
		WHERE
			hlstats_Players.game = 'csgo'
			AND hlstats_Players.hideranking = 0
			AND IF(2419200 > (UNIX_TIMESTAMP() - hlstats_Players.last_event), ((100 / 2419200) * (2419200 - (UNIX_TIMESTAMP() - hlstats_Players.last_event))), -1) >= 0
		GROUP BY
			hlstats_Countries.flag
		HAVING
			activity >= 0
			AND nummembers >= 3
		ORDER BY
			skill desc,
			kpd desc,
			hlstats_Countries.name ASC
		LIMIT
			0,
			50