[Tracer Gun Kata]

Originally Posted by GlitterKill

Hmm I have run into a strange error. When trying to assign an award to any member with a ' in their name it returns an error and the award is not given. For instance, the member name "rockin'male" return an error because of the apostrophe. All other usernames with apostrophes return errors as well when trying to give them awards.

Any ideas how to fix this?

Same problem here.. attempt to give the user with an apostrophe in there name an award and it gives the following error -

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT userid, username
FROM user
WHERE username = 'Pain'NDass';

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 'NDass'' at line 3
Error Number : 1064
Date : Tuesday, February 7th 2006 @ 09:55:19 AM
Script : http://www.onlinewarfare.net/forum/admincp/award.php
Referrer : http://www.onlinewarfare.net/forum/a...rs&award_id=15
IP Address : [Removed]
Username : [Removed]
Classname : vb_database