View Single Post
Old November 18th, 2010, 08:45 PM   #1 (permalink)
Swanny
Member
Verified Customer
 
Swanny's Avatar
 
Join Date: Jun 2002
Location: Western Canada
Posts: 382
How to delete all comments from a user [spam]

This happens from time to time on my PP Pro installation (phpBB 3 forum integration).

A spammer signs up, doesn't actually post in my forums. But he goes into the photo galleries and spams up 50 or more photos with the same spam comment, complete with spammy links.

Now, here's an example that was brought to my attention today.

One of the 50 comments he's left: Smiling at you - Ford F150 Photos

His PP profile page: Member Profile - Ford F150 Photos

Now.... here's the problem. I click on the PP admin link on his PP profile page, the link titled Delete All User Photos. Now, he doesn't have any photos, but I am able to click in there where I check off Check to delete all comments by this user and click DELETE PHOTOS button.

The problem is it doesn't actually delete his comments. Remember he doesn't have any photos uploaded, but I still expect it to delete his comments, which it doesn't do.

So now I have to manually click each of the 50 photos, and manually delete each comment.

So....
1) Is this normal behavior?
2) Why doesn't the Check to delete all comments by this user option work in this case?
3) Do you guys have any plans in the future to enable spam checking through something like Akismet (available in WordPress)?
4) Can I just delete the comments directly from the PP database, something like DELETE FROM pp_comments WHERE username = 'aguo'? Or does that have negative consequences somewhere else in the DB? That would save me a lot of time!
__________________
My PhotoPost Installations are at:
FordF150.net - Ford Truck Enthusiast Site
FordFlex.net - Ford Flex Enthusiast Site
FordTaurus.net - Ford Taurus Enthusiast Site
FordFusion.net - Ford Fusion Enthusiast Site
Swanny is offline   Reply With Quote