BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => BeBot 0.3 support => Topic started by: Reduce on July 11, 2007, 12:51:16 am

Title: Apostrophe in guild name = mysql error
Post by: Reduce on July 11, 2007, 12:51:16 am

I didn't see a topic with this, but I'm sure it's occured before :)
Just got home & checked the bot, and saw this error.
http://ab.sytes.net/mysql_error.gif
I haven't written any SQL statements in awhile, but could double quotes be used to prevent this error, or would it cause problems elsewhere? hehe

Title: Re: Apostrophe in guild name = mysql error
Post by: Alreadythere on July 11, 2007, 01:03:39 am

That's a sure case of a missing mysql_escape_string() call.

Title: Re: Apostrophe in guild name = mysql error
Post by: Alreadythere on July 11, 2007, 12:30:54 pm

Corrected in SVN, thanks for reporting.