Detomah |
01-21-2004 10:15 AM |
I don't think this is a bug as it's not causing a propblem for 99% of my users, but every now and then the odd user PM's me saying their score has not been added to the high score table, which is then follwed by me recieving an email from my server stating the following:
Quote:
Database error in vBulletin 3.0.0 Release Candidate 2:
Invalid SQL:
SELECT COUNT(*) + 1 AS scoresAbove
FROM gamesessions
WHERE score > AND valid=1 AND gamename=''
mysql error: 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 'AND valid=1 AND gamename=''' at line 3
mysql error number: 1064
|
As I said, most of the time the scores are included and everything is fine, so i don't know if it's just th odd connectivity probelm or what?
Any idea what may be causing this and how I could possibly fix it?
Ohh and great hack, my users are well happy with it, although I do suspect the odd member of figuring out some way to cheat with the copter game as some rediculous scores like 3500+ have come in.
|