MyBB Community Forums

Full Version: Why you should never leave a forum for a while
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
I own halo-universe.com, and I haven't been on it for about a month. I just left it to die.

Now look at it: http://halo-universe.com

There are over 5000 spam posts XD

Anyone know of a plugin to nuke that spam?
EDIT: turns out two spammers have posted 4500 + between them XD
Ouch, my work's proxy blocked your site. Sad

Quote:Reason: Spam URLs sites are blocked
Site: http://halo-universe.com/

If it's the same users then you can easily remove their posts from phpMyAdmin (unless MyBB has a pruning feature I forgot about).
DELETE FROM `database`.`prefix_threads` WHERE `prefix_threads`.`uid` = USERID;
DELETE FROM `database`.`prefix_posts` WHERE `prefix_posts`.`uid` = USERID;
Matt has a plugin for nuking spammers. Check it out here: http://mods.mybb.com/view/goodbye-spammer
I had a similar situation sometime back, I left a forum alone for a while and it had close to 1000 spam registrations and their posts. I ended up writing a multi-part script, the first part checked all the existing users against stopforumspam database, I had to throttle this to 4 records/minute so as to avoid getting blocked by SFS for hammering their site with all those requests and cache them in the database to be used in the next part.
The second part worked like the goodbye spammer, it checked the cached records from SFS and from pruned the users that had appeared multiple times in the SFS database and cleaned out their profile/posts and banned them.

It worked great and cleared out I'd say 95% of the spammers. The ones left were so old and I guess they weren't added to SFS database because it probably wasn't that popular back then.

I should still have the scripts somewhere if you want to use them Wink
I did this with my forum. Went from 2k to like 20k+ posts in like a few months. Toungue I love my community! Big Grin

(if only it wasn't spam)
Wow that sucks. I had that happen to one of my forums but not nearly that bad. But that is a nice theme you have there!
My spam site never got this much. I think advertising you want spam is a good protection.
Hey Mark, you want mine? XD
(2011-05-07, 05:12 PM)Aristotle Wrote: [ -> ]My spam site never got this much. I think advertising you want spam is a good protection.

....

Lolwut?

This makes 0 sense xD hahaha
(2011-05-07, 05:18 PM)Tom K. Wrote: [ -> ]Hey Mark, you want mine? XD

I'm considering reopening Tm0 :p.
(2011-05-07, 05:25 PM)wethegreenpeople Wrote: [ -> ]
(2011-05-07, 05:12 PM)Aristotle Wrote: [ -> ]My spam site never got this much. I think advertising you want spam is a good protection.

....

Lolwut?

This makes 0 sense xD hahaha

I tried it twice. Firestryke duplicated my theory
Pages: 1 2