QdbS - Quote database System: Forums / QdbS Support / 1.08 to 1.09

Forums

QdbS - Quote database System :: Forums :: QdbS Support

<< Previous thread | Next thread >>

1.08 to 1.09

Author

Post

Mark

Thu Jul 24 2008, 22:38:35

Registered Member #11
Joined: Thu Jul 24 2008, 22:20:55
Posts: 3

Hi Jobe, not been able to get on IRC for a while to speak to you. Dunno what's wrong there.

Could you tell me what the upgrade process is like from 1.08 to 1.09 please as I can't find anything in the Docs about upgrade.?

Is it as simple as upload the files and overwrite or do I need to go in and play about in there a bit.

Also does this upgrade solve the /'.../' problem that I seem to have with it...
pls see http://www.cruelworld.co.uk/qdb/?356 for example :)

There is this site someone pointed to me..
http://www.htmlite.com/php004.php
That starts to address the subject but i'm not sure if I should be editing my files or if you need to look at yours...
Have you had any more people commenting on this ?

Regards,
Mark :)

Jobe

Tue Jul 29 2008, 00:40:57

Joined: Mon Oct 08 2007, 15:54:30
Posts: 32

OK, the upgrade process is as simple as just over-writing the files. If there is ever any more to it then that then that will start with Version 2 due to it being a bigger change.

As for the \' issue, that's due to a PHP configuration issue. There will be a fix for that in the next release when I actually have time to work on it but for now a temporary fix is to either A) change your PHP configuration, either via .htaccess or in php.ini or B) to edit the source, and use stripslashes() in the appropriate places (Sorry I haven't got time to find those places).

You should be able to add the following to the top of settings.php after the "<?php"


ini_set("magic_quotes_gpc", false);

Mark

Sun Aug 03 2008, 21:25:49

Registered Member #11
Joined: Thu Jul 24 2008, 22:20:55
Posts: 3

Hi mate, thanks for the reply.

Unfortunately the ini_set("magic_quotes_gpc", false); line did nothing and i'm still getting lines like (@Blak) and i\'m busy playing with css .

I've looked all over the place and can't find anything on it for .htaccess either but I don't think it's really that big of an issue, I could always manually delete all the 's or indeed the offending /'s through phpMyAdmin.
Bit of a long drawn out pain but it's do-able ;-)

Either that or I could ignore it :)

Looking forward to v2 anyway :D

Regards,
Mark.

Jobe

Sat Aug 09 2008, 14:36:06

Joined: Mon Oct 08 2007, 15:54:30
Posts: 32

OK, 1 simple changes to fix it for now.

Fine the following line in index.php:


$sql = "INSERT INTO ".$_qdbs[tpfx]."queue (id,quote) VALUES ('NULL', '".mysql_real_escape_string($quote)."')";

and change it to:


$sql = "INSERT INTO ".$_qdbs[tpfx]."queue (id,quote) VALUES ('NULL', '".mysql_real_escape_string(stripslashes($quote))."')";

If that doesn't solve it also find the following in admin/index.php:


$sql = "INSERT INTO ".$_qdbs[tpfx]."quotes (id,quote,rating) VALUES ('NULL', '".mysql_real_escape_string($row['quote'])."', '0')";

and change it to:


$sql = "INSERT INTO ".$_qdbs[tpfx]."quotes (id,quote,rating) VALUES ('NULL', '".mysql_real_escape_string(stripslashes($row['quote']))."', '0')";

but that second change shouldnt be needed.

Future versions will check the state of the magic_quotes_gpcsetting and use stripslashes apropriately as needed.

[ Edited Sat Aug 09 2008, 14:37:54 ]

Mark

Sat Aug 16 2008, 23:34:42

Registered Member #11
Joined: Thu Jul 24 2008, 22:20:55
Posts: 3

Sorry it's been a while, been kinda busy.
The first fix from those 2 seems to have done the job :D

You sir are a genius ;-)
Thanks.

Jobe

Mon Aug 25 2008, 13:40:36

Joined: Mon Oct 08 2007, 15:54:30
Posts: 32

Thanks for the update.

Moderators: Jobe, Eck