MyBB Community Forums

I have over 1,800 banned spam accounts. How can I easily and quickly remove all posts from these accounts and subsequently delete the accounts?

Thanks!

(2012-02-21, 03:08 AM)Mike. Wrote: [ -> ]http://mods.mybb.com/view/goodbye-spammer

That's not a fast option of deleting posts of multiple users.

(2012-02-21, 03:38 AM)Anxiety Wrote: [ -> ]

(2012-02-21, 03:08 AM)Mike. Wrote: [ -> ]http://mods.mybb.com/view/goodbye-spammer

That's not a fast option of deleting posts of multiple users.

Any other idea Craysauce?

responses here might help ...

any other ideas?

(2012-03-14, 01:50 AM)josh0322 Wrote: [ -> ]any other ideas?

You can prune them through ACP using a simple task for pruning which is already provided in Task Manager in tools and maintenance.

3,000 accounts now. Is there an SQL command I use to clear out the banned member group and then recount and rebuild??

tippity-top?

Something like

DELETE FROM mybb_users WHERE gid=7

Would handle the users. But I am not sure about posts.

You might be able to build a simple php file that grabs the banned users, then loops through each and deletes their posts and threads.