MyBB Community Forums

Full Version: Deleting guests' posts (SPAM)
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello,

I'am rebuliding the forum and after updating MyBB to latest version something strange happend because "Guest" have got the option to replay in topics (I checked options and that was disabled). So now I have lots of sex related posts on the forum. I would like to delete all posts after 12.06.2016 but I cannot find that option (if it somwhere) or delete all posts from the certain IP.
"Guests" are not user also so I cannot find among users and delete all user posts. And what is more I cannot even delete those posts manualy.

I would be very gratful for any help.
A
Guest ID is 0; therefore easiest way is to crack open phpMyAdmin (or SQL shell) and execute the following:

delete from mybb_posts where uid=0 and timestamp>1466035200;

Take a full backup (or retain your existing one) before you execute this. I'm not sure if the syntax is right. I don't use MyBB so much anymore.