[msimplay]

Originally Posted by Battle_Ring

hey i have a problem when 1 of my users try to acess the bank they get a database error and i get sent an email that is this

Database error in vBulletin 3.0.1:

Invalid SQL: UPDATE user SET uttpoints=uttpoints-20.000.00 WHERE userid='95'
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 '.00 WHERE userid='95'' at line 1

mysql error number: 1064

Date: Friday 21st of May 2004 03:03:36 PM
Script: http://battlering.net/forums/ushop....&shortname=bank
Referer: http://battlering.net/forums/
Username: Jolly Jolza
IP Address: 203.96.202.81



only 1 user has complained about this i tried and acessed the bank fine

i have a similar error which is this

Database error in vBulletin 3.0.0:

Invalid SQL: UPDATE user SET uttpoints=uttpoints-70,000 WHERE userid='75'
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 '000 WHERE userid='75'' at line 1

mysql error number: 1064

Date: Sunday 30th of May 2004 06:15:47 AM
Script: http://www.wambam.net/vbulletin/usho...shortname=bank
Referer: http://www.wambam.net/vbulletin/