MyBB Community Forums

Hi,

I got thousands of spam on my forum, all the spam has been posted after a certain date.

Can I delete all posts and users that joined after a certain date?

I'm using "Googbye Spammer" plugin but it's taking forever for it to delete a user that has 2,000-4,000 posts.

Get a timestamp of the time you want the posts, etc deleted from. http://www.unixtimestamp.com/index.php

Run these SQL queries:

DELETE FROM mybb_posts WHERE dateline > 'unix timestamp of the time'
DELETE FROM mybb_threads WHERE dateline > 'unix timestamp of the time'
DELETE FROM mybb_users WHERE regdate > 'unix timestamp of the time'

(2011-10-03, 07:06 PM)PJGIH Wrote: [ -> ]Get a timestamp of the time you want the posts, etc deleted from. http://www.unixtimestamp.com/index.php

Run these SQL queries:

DELETE FROM mybb_posts WHERE dateline > 'unix timestamp of the time'
DELETE FROM mybb_threads WHERE dateline > 'unix timestamp of the time'
DELETE FROM mybb_users WHERE regdate > 'unix timestamp of the time'

Thanks seems simple enough, but now goodbye spammer messed up my forum LOL = http://community.mybb.com/thread-105189.html