CS.GEN.TR | Gaming network
  • 1V1
  • CSGO
  • CSGO5
  • CSGO2
  • TAC
  • Contents
  • Search
  • SourceBans
  • Forum
  • Help

  Sections

  Player Rankings

Find a player:
Ranking View


ERROR
Database Error

Server Address: localhost
Server Username: root

Error Diagnostic:
Bad query.

Server Error: (3) Error writing file '/tmp/MYkxNRah' (Errcode: 28)

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 = 'csgo2'
					AND hlstats_Players.hideranking = 0
					AND hlstats_Players.kills >= 1
				ORDER BY
					skill desc,
					kpd desc,
					hlstats_Players.lastName ASC
				LIMIT
					0,
					50