Comment Spam by Unregistered

forddoctor · March 5th, 2013, 09:41 PM

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

Chuck S · March 6th, 2013, 07:56 AM

How about running a query like so in phpmyadmin

DELETE FROM pp_comments WHERE userid=0

forddoctor · March 6th, 2013, 04:42 PM

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.

Chuck S · March 6th, 2013, 04:51 PM

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.