MyBB Community Forums

I have deleted many users from my forums, but the only problem is that their posts are still showing..
How can I delete their posts now?

I don't want to do it one by one. :/

Run this query in phpMyAdmin:

DELETE FROM mybb_posts WHERE username='his username'

and

DELETE FROM mybb_threads WHERE username='his username'

In the future, you should use some useful plugin, example this one: http://mods.mybb.com/view/goodbye-spammer