Arcade Problem

[atrljoe]

Can anyone help me this error message any user gets it once the game is completed, when the game is over it wants to load the next page but then this happens any ideas?

Database error in vBulletin 3.0.6:

Invalid SQL: UPDATE user) SET uttpoints)=uttpoints)+25 WHERE userid='1'
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 ') SET uttpoints)=uttpoints)+25 WHERE userid='1'' at line 1

mysql error number: 1064

Date: Sunday 20th of February 2005 07:49:27 PM
Script: http://www.theURLofmyforums.com/forums/arcade.php
Referer: http://www.theURLofmyforums/forums/a...=play&gameid=6
Username: myuser
IP Address: xx.xx.xx.xx

[Osterling]

this is not the area for support.. please read the title and description for this forum

[atrljoe]

My mistake, made a mistake thought I was in another forum feel free to move this anyone.

[Marco van Herwaarden]

Change your query to:
[sql]UPDATE user SET uttpoints=uttpoints+25 WHERE userid='1'[/sql]

I don't know why you put all those ) in there

[atrljoe]

Found the problem the program was for some reason placing those ) in there, I looked at the settings and for somereason the default values all ended with ) thanks again!

[Marco van Herwaarden]

What "program" are you using then?

[atrljoe]

what i meant was the install program place those values into there for some reason, it placed a ) after every value.