Database Error
Server Address: localhost
Server Username: hlstats
Error Diagnostic:
Bad query.
Server Error: (1194) Table 'hlstats_Players' is marked as crashed and should be repaired
Last SQL Query:
SELECT
hlstats_Players.playerId,
hlstats_Players.connection_time,
unhex(replace(hex(hlstats_Players.lastName), 'E280AE', '')) as lastName,
hlstats_Players.country,
hlstats_Players.city,
hlstats_Players.flag,
hlstats_Players.clan,
hlstats_Players.fullName,
hlstats_Players.email,
hlstats_Players.homepage,
hlstats_Players.icq,
hlstats_Players.game,
hlstats_Players.hideranking,
hlstats_Players.blockavatar,
hlstats_Players.skill,
hlstats_Players.kills,
hlstats_Players.deaths,
IFNULL(kills / deaths, '-') AS kpd,
hlstats_Players.suicides,
hlstats_Players.headshots,
IFNULL(headshots / kills, '-') AS hpk,
hlstats_Players.shots,
hlstats_Players.hits,
hlstats_Players.teamkills,
IFNULL(ROUND((hits / shots * 100), 1), 0) AS acc,
CONCAT(hlstats_Clans.name) AS clan_name,
activity
FROM
hlstats_Players
LEFT JOIN
hlstats_Clans
ON
hlstats_Clans.clanId = hlstats_Players.clan
WHERE
hlstats_Players.playerId = '111525'
LIMIT
1
|