[Opensim-users] Offline mesages bug found

[M.E. Verhagen]

This sounds like the mysql query in not properly escaped.

Try to insert on line 25 in the Offline.php script the following line:

$data = mysql_escape_string($data);

This line will fix the issue so you can use the ' in the messages :)


2011/9/9 InuYasha Meiji <inuyasha.meiji at gmail.com>

>  Sorry for tossing this in during a long talk on IARs and OAR files but I
> have just found a problem with my offline messages that you all migth have
> too.  Depends on while one you use.  It don't happen all the time and now I
> know why.
>
> I use the one Created by DEVI (dev José Vera - Jor3l).  It seems to work
> great but now and then gives me the mesage "Message not saved".  I never
> understood why.  Maybe someone out here can help me.  It only happens when I
> write a sentance with an apostrophe in it.  If I rewrite the sentance "It
> won't work" with "It will not work." it saves.  Any other words with an
> apostrophe also causes the message to not be saved.  It there anyway to
> change the field holding the message in MySQL 5.1.41 to hold a apostrophe
> when it seems to be having issues at the moment?
>
> Thanks again for your time.
> InuYasha
>
>
> --
> ________________________________________________________________
> Opensim User: Standalone Grid on Version 0.7.1.1 with 49 Regions
> on Windows 7, 64-bit. Phenom 9500 2.2 ghz Quad Core, Terabyte Hard
> Drive, 8gig DDR2 RAM.  Used XAMPP to load PHP Version 5.3.0, Apache
> and MySQL 5.1.41-community edition.  Modules not yet successful
> ________________________________________________________________
>
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20110909/74a63601/attachment.html>