[Twilkey]

Originally Posted by punchbowl

Db error for user names containing: '
e.g
john'sgirls

Database error in vBulletin 3.6.8:

Invalid SQL:

UPDATE user
SET casino_cash = casino_cash + 10000
WHERE username = 'john'sgirls';

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 's'' at line 3
Error Number : 1064

=================================================

The ' in the users name is messing with the database.