++ HLstatsX:CE Awards & Maintenance script version 1.6.19 starting...
++ Cleaning up database: deleting events older than 7 days... done
++ Cleaning up database: deleting player history older than 7 days... done
++ Cleaning up database: deleting stale trend samples... done
++ Cleaning up database: deleting server load history older than one year... done
++ Updating player activity... done
++ Processing awards... (generating awards for 2015-04-05 (previous: 2015-04-05))... DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
COUNT() AS awardcount
FROM
INNER JOIN hlstats_Players ON
' at line 2 at .//HLstats.plib line 185.
Unable to execute query:
SELECT
,
COUNT() AS awardcount
FROM
INNER JOIN hlstats_Players ON
hlstats_Players.playerId =
AND hlstats_Players.hideranking=0
WHERE
.eventTime < CURRENT_DATE()
AND .eventTime > DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)
AND hlstats_Players.game='csgo'
AND ='knife_default_ct'
GROUP BY
ORDER BY
awardcount DESC,
hlstats_Players.skill DESC
LIMIT 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
COUNT() AS awardcount
FROM