delete all comments made by a specific user

boatdesign · September 9th, 2010, 12:35 PM

With photopost pro running with user integration with vbulletin, is there an easy way to delete all photopost comments a specific user has made on photopost photos?

Chuck S · September 9th, 2010, 01:34 PM

The only delete all comments function in the programs is one tied to the delete all photos from a specific user under there photopost profile.

boatdesign · September 9th, 2010, 02:06 PM

OK, thanks. I had a spammer (it turns out) sign up in 2007; they posted some legitimate comments so didn't trip any flags and looked like a real user. Then this week they posted a few dozen junk comments with spam links in them, so I had to go through and delete those junk comments one by one. If they were forum posts, I could delete all such rubbish at once, so I was hoping there would be an equally easy way with photopost comments. It would be cool as admin if you could use the comments link on someone's profile and delete specific or select all comments on the page to make quick work of any spammers that get past the initial radar.

Chuck S · September 9th, 2010, 05:00 PM

Gotcha next time it happens you can upload a photo as admin as that user and then view his profile and see the link to delete all photos and you can delete everything from that specific user.

creativepart · November 1st, 2012, 10:44 PM

Hey Chuck, I've got this problem now. A spammer in the comments with 68 spam posts.

I tried what you suggested -- I logged in as the spammer, uploaded a photo to his gallery (he had no photos). I went to his profile in Photopost and clicked delete all photos. I saw the checkbox for delete all comments and checked it. Then submitted and said yes to that confirmation.

But it did not delete ANY of his comments.

Got any ideas about this??

creativepart · November 1st, 2012, 11:07 PM

So, I gave it a try a second time. This time it deleted all but 8 comments. Huh? It deleted 60 but left 8?

I then manually removed the 8 comments.

I'm grateful that it removed 60. That saved me some time. BUT!

Why did it leave 8 comments? And, there's got to be a better way to remove spam comments than this!

Chuck S · November 2nd, 2012, 10:26 AM

I have no idea why it left 8 comments. You could have tried running it again to see if it deleted the 8. It issues a global delete comment like so

DELETE FROM pp_comments WHERE userid=23

That by design would delete any comments where userid is 23 so it never would leave some.

creativepart · November 2nd, 2012, 11:08 AM

Well it seemed to delete all but 8 comments, but when I did a search today for the spam terms to see if I had any others 52 comments showed up from the guy. (They are not new they're from Feb 2012)

Can I use "DELETE FROM pp_comments WHERE userid=XX" as an SQL Query to manually removed them quickly? I wasn't sure if comments were in the Database in multiple locations or I would have tried looking in the database to begin with.

Here's a screen shot from this AMs search:

creativepart · November 2nd, 2012, 11:22 AM

I just got rid of them in the database. I can't believe I had that spam in there for the past 10 months. Is it possible to forbid URL BBCode in the comments??

Chuck S · November 2nd, 2012, 12:20 PM

My suggestion is you use the CAPTCHA system that was added in 5.x series.

creativepart · November 2nd, 2012, 01:26 PM

I'm using PP 5.31 -- I don't see an option for CAPTCHA on comments. Where would I find that?

Chuck S · November 2nd, 2012, 02:10 PM

That is in PhotoPost Pro 8.22

creativepart · November 2nd, 2012, 03:44 PM

Quote:

Originally Posted by Chuck S

My suggestion is you use the CAPTCHA system that was added in 5.x series.

Oh, so it's not in 5.X. That's why I couldn't find it.

Thanks

Chuck S · November 2nd, 2012, 04:00 PM

5.31 is like 6 years old so yeah any comments about new features would not apply to what your using.

Chuck S · November 4th, 2012, 01:47 PM

Anyone running code that old should upgrade is not for all the huge improvements in features and speed all the bug fixes if anything makes it worth while. The problem is there will come a time very soon you will have to upgrade. Your server is upgraded in the background all the time and soon running such an old version is not going to work on newer server setups.