collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18366
  • stats Total Topics: 2501
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

Author Topic: Apostrophe in guild name = mysql error  (Read 8195 times)

0 Members and 1 Guest are viewing this topic.

Offline Reduce

  • BeBot Rookie
  • *
  • Posts: 6
  • Karma: +0/-0
Apostrophe in guild name = mysql error
« 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

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: Apostrophe in guild name = mysql error
« Reply #1 on: July 11, 2007, 01:03:39 am »
That's a sure case of a missing mysql_escape_string() call.

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: Apostrophe in guild name = mysql error
« Reply #2 on: July 11, 2007, 12:30:54 pm »
Corrected in SVN, thanks for reporting.

 

* Recent Posts
Com bot module by bitnykk
[November 25, 2024, 05:36:11 pm ]


0.8.x updates for AO by bitnykk
[June 23, 2024, 03:19:47 pm ]


0.8.x updates for AoC by bitnykk
[June 23, 2024, 03:19:44 pm ]


[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm ]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am ]

* Who's Online
  • Dot Guests: 287
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal