UseBB Community

Hi folks,

I wonder if there is a way to erase all the messages posted by some member, say a spam bot that posted ads in every forum. Sorry if this has been asked before, I couldn't see it.
Thanks!

I don't think deleting them from the ACP actually removes the posts, it would just place them as Guest posts. Are they topics you want removed or actual posts? You can remove posts by a single user by getting their user ID and running this MySQL query from ACP -> SQL Toolbox or PHPMyAdmin

DELETE * FROM `usebb_posts` WHERE `poster_id` = $id;

If you want to remove topics, it will be a bit more difficult. It would probably be easier to just delete each topic manually.

Well, they were new topics. I erased them manually, but it is a bit of a pain and it might be a cool feature to be added in the future, if it is not too hard to implement.
The spammer must be one hell of a bot to bypass the security question in the registration... That actually makes me think that it was registered manually.
Anyway, thanks a lot for your reply!

Be careful with the SQL query. Pruning posts this way might break the data shown on the forum index, topic listing and/or topic view.