Backslashs comments bug

[caliman]

I've noticed that if you use apostrophes in comments, it adds a backslash before the apostrophe when you post. I guess an expression is needed here.
I think this also occurs with reviews.

[Chuck S]

Interesting thing is yes slashes are suppose to be added to the comment when it goes to the database and I show we strip them out in showphoto when they are displayed.

$commenttextline = convert_markups(stripslashes($commenttextline));

What does a typical database comment look like in your database? Is your comment being entered with multiple slashes?

[caliman]

Sorry Omega, please move this to the reviews bug page.

"Pros: Easy to use, small foot print, good price.
Cons: It\'s good, but I think it"

[paratek]

I am getting this same thing in Photopost. Attached is what my database looks like with the slashes in the comments.

[caliman]

I think it's supposed to do that. I think it handles general comments in posts ok and when it displays them it looks fine.

But the PROS/CONS fields are another story.

[paratek]

No, it is not handling them right....the slashes are dispalyed as well. I have to go through the database and take them out.

[caliman]

Ugh. That's a little different than my problem. Do you get them in the Pro/Con fields too?

[Chuck S]

I asked a question above noone ever answered.

I show the proper use of addslashes and stripslashes in the comments.

How many stripslashes are in your database for a typical character that needs it. There is some users who have some mysql setting that like triples the normal use of addslash and that might be the issue

Same thing on pro's and con's I show this in showproduct

$cons[$itemnum] = stripslashes($consline);
$pros[$itemnum] = stripslashes($prosline);


so I really need to see an example of how the database is storing it

[paratek]

Chuck,

I attached a screen shot in my post a few above of my database as it looks through myphpadmin that shows the slashes. I'm sorry, i thought that was what you asked for.

Originally Posted by omegatron

I asked a question above noone ever answered.

so I really need to see an example of how the database is storing it

[Chuck S]

Paratek yep did not see your attachment. You have one slash when is normal and we remove that upon install

Do you not have this in showproduct.php

$commenttextline = convert_markups(stripslashes($commenttextline));

[paratek]

Oh shoot, Chuck i thought i was in the photopost forum on this. I did a search and posted this in the wrong spot. My problem is with photopost. Sorry

but i do have this in showphoto.php

$commenttextline = convert_markups(stripslashes($commenttextline));

[Chuck S]

No problem but you should not have slashes if you only have one slash which is normal in the database. Can you post a url to look at?

[paratek]

You know what, I added another comment with an apostrophe. when i view it in photopost it displays correctly, the slash has been stripped. When i view it using Toney's comshow.php is when it is showing up. So it is Toney's fault, not yours..lol
I'll check with him. Sorry for the trouble Chuck.

[Chuck S]

No Problem LOL Now you know why companies dont support hacking

[caliman]

omega what table has the pros/cons info? I'd like to see how it's storing the slashes.

[Chuck S]

Same table reviews

couple fields over the the review itself

[memobug]

Originally Posted by omegatron

show the proper use of addslashes and stripslashes in the comments.

The comment field itself is okay but I think it's the exception. Unfortunately there are still some addslashes problems with various fields. (Review PRO & CON, user-specified fields,) Try entering these in a review.

Positive aspects of the product (pros): it's a test
Negative aspects of the product (cons): it's a test

Now click Edit and it looks like this:

it\'s a test
it\'s a test

Submit it and it's like this

Pros: it\'s a test
Cons: it\'s a test


Edit it and it's like this

Pros: it\\\'s a test
Cons: it\\\'s a test

etc.

[Michael P]

In reviews.php at line 133, find and add the code in bold:

Content visible to verified customers only.

[memobug]

Thanks Michael

[caliman]

Cool. Thanks.