[The Librarian]

More about #2 above:

Originally Posted by The Librarian

2) I got a database error when I tried to give an award to a member with an apostrophe in her name. I'm working on a fix but if someone has information on that it would be appreciated.

Here's the deal... when I try to award another user (5peaches) I get "you have successfully given MA'AM the award"- so it's giving 5peaches award to MA'AM... and then if I try to give MA'AM an award I get this error message:

Invalid SQL:

SELECT userid, username
FROM vb_user
WHERE username = 'MA'AM';

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 'AM'' at line 3
Error Number : 1064
Date : Thursday, July 19th 2007 @ 08:43:42 PM
Script : http://www.website.com/forum/admincp...do=dogiveaward
Referrer : http://www.website.com/forum/admincp...ers&award_id=9

I'm sure it's because of the appostrophe... does anybody have a fix for this, please?!