Sections
Player Rankings| ERROR |
| Database Error Server Address: localhost Server Username: hlstatsx Error Diagnostic: Bad query. Server Error: (3) Error writing file '/tmp/MY9dPfK2' (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 = 'dmc'
AND hlstats_Players.hideranking = 0
AND hlstats_Players.kills >= 1
ORDER BY
skill desc,
kpd desc,
hlstats_Players.lastName ASC
LIMIT
200,
50
|