MyBB Community Forums
MyBB Community Forums
>
Community Archive
>
Archived Forums
>
Archived Development and Support
>
MyBB 1.6
>
1.6 General Support
> Query to delete all posts by guests in specific forum
Full Version:
Query to delete all posts by guests in specific forum
You're currently viewing a stripped down version of our content.
View the full version
with proper formatting.
Renegader
2011-04-15, 05:36 AM
What will be the query to do that? The posts by guests are in FID 66, and it's like 500 and full of spam, how do I delete them all from that forum?
Thanks.
Yaldaram
2011-04-15, 06:26 PM
Backup your database table first, then run this query;
DELETE FROM `mybb_posts` WHERE `fid` = 'X' AND `uid` = '0';
Replace mybb_ with your table prefix.
X = Forum ID from where you want to delete from
MyBB Community Forums
>
Community Archive
>
Archived Forums
>
Archived Development and Support
>
MyBB 1.6
>
1.6 General Support
> Query to delete all posts by guests in specific forum