PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > PhotoPost Pro Support Forums > Photopost Pro How Do I...?

Photopost Pro How Do I...? Wondering how to do things in PhotoPost?

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old March 5th, 2013, 09:41 PM   #1 (permalink)
Member
Verified Customer
 
Join Date: May 2006
Posts: 34
Comment Spam by Unregistered

My PP gallery is integrated with my UBB forums and registrations are restricted so imagine my surprise to find hundreds of spam comments made by "Unregistered" today. I know this has nothing to do with my forums but rather a simple oversight in my PhotPost settings which I have corrected and I turned on CAPCHA.

But now how can I search for, list or delete all comments made by user "unregistered" ??? Right now I have to go through every picture and individually delete these spam comments. Uhhg!

Need advice and help
__________________
My site information:

UBB Threads 7.5
PhotoPost 8.23 installed
forddoctor is offline   Reply With Quote
Old March 6th, 2013, 07:56 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,702
How about running a query like so in phpmyadmin

DELETE FROM pp_comments WHERE userid=0
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old March 6th, 2013, 04:42 PM   #3 (permalink)
Member
Verified Customer
 
Join Date: May 2006
Posts: 34
Thank you Chuck. I suppose that would have worked if I knew how to put together an SQL Query... I went into the database and searched pp_comments for username "Unregistered" broke the results into bunches of 1000 and deleted them. All 8,400 of them!

Spam is so stupid. I don't get the benefit as all it does is piss people off.
__________________
My site information:

UBB Threads 7.5
PhotoPost 8.23 installed
forddoctor is offline   Reply With Quote
Old March 6th, 2013, 04:51 PM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,702
Yeah I have all the spam things on in our vb3 site here even my vb4 personal site have captcha enabled and all other prevention matters and I still get occassional spam on my forum so spammers seem to get through if they want.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Voting & Comment for unregistered Users? vFranky Photopost Pro How Do I...? 5 April 8th, 2010 01:46 PM
Lots of Comment SPAM Billyo Photopost Pro Bug Reports 3 February 25th, 2009 10:56 AM
blank name on unregistered comment and upload skidpics General Discussion 3 January 29th, 2009 07:45 PM
Tons of comment spam, permissions not working... Swanny Photopost Pro Bug Reports 4 October 1st, 2008 06:59 PM
Photos and comment Stats Don't report unregistered uploads and comments Johnny Doomo Photopost Pro Bug Reports 7 October 12th, 2005 04:48 PM


All times are GMT -5. The time now is 12:27 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0