Topic: Delete all guest posts

My board got spammed with "guests" posting. None of the usernames of the "guest"s come up in user searches. I would ultimately like to delete all guest post from the forum (350 or so of them) but there does not a seem to be a way to do this in admin other than delete all the posts one by one. Any suggestions?

Maybe a mysql script to automatically delete all posts by "guests"? But i cannot seem to find the table to correllate  the posts with the "guests".  Can anyone direct me here?

Thanks.

Re: Delete all guest posts

hello

if you go to phpmyadmin
go to _posts
sort by id (1 is guest I believe)
then choose 100 or so at a time... you'll have them deleted in 2min....

Extension Directory
Over 1.8 Million URLs checked in September 2012 with URL Checker extension.
Is your website being spammed? Send me the URL (entire post). Or post at http://url-checker.org

Re: Delete all guest posts

Thanks for the quick reply. I'll give it a shot.

Re: Delete all guest posts

This is what I get:

mysql> select * from _posts where id = 1;
ERROR 1146 (42S02): Table 'punbb._posts' doesn't exist
mysql> select * from posts where id = 1;
Empty set (0.00 sec)

Any idea?

Re: Delete all guest posts

don't your tables have a prefix?

Extension Directory
Over 1.8 Million URLs checked in September 2012 with URL Checker extension.
Is your website being spammed? Send me the URL (entire post). Or post at http://url-checker.org

Re: Delete all guest posts

or check with group_id 2

edit: or poster_id 1 ....

Extension Directory
Over 1.8 Million URLs checked in September 2012 with URL Checker extension.
Is your website being spammed? Send me the URL (entire post). Or post at http://url-checker.org

Re: Delete all guest posts

No, I didn't use prefixs....

The table "posts" seems to be the one i'm looking for, but it seems every guest has a different id.

Re: Delete all guest posts

Or poster_id.

Re: Delete all guest posts

yes needs to be poster_id 1 .... sorry...

Extension Directory
Over 1.8 Million URLs checked in September 2012 with URL Checker extension.
Is your website being spammed? Send me the URL (entire post). Or post at http://url-checker.org

Re: Delete all guest posts

Thanks for the help, I got itcleaned out. I've checked all the correct boxes in the Guest account, but it is still allowing guests to post. What am i missing?

11

Re: Delete all guest posts

→ Administration → Start → Forums

edit the forum they're posting too, to see if you have guest posting enabled....

Extension Directory
Over 1.8 Million URLs checked in September 2012 with URL Checker extension.
Is your website being spammed? Send me the URL (entire post). Or post at http://url-checker.org

Re: Delete all guest posts

That was it, thank a million for your help.