Moderators Functions - One-touch Spam Ban and Cleanup

*** Staff note: The author of this modification has passed away in a diving accident. We wish his family all strength in dealing with this tragic issue. ***

One-touch Spam Ban and Cleanup




The main purpose of this mod is to clean up after a spammer. With a minimum of fuss it will:

• Delete all threads started by the spammer
• Delete all posts made by the spammer
• Delete all PMs sent to other members by the spammer
• Delete all calendar events made by the spammer
• Ban or delete the spammer as you like
• Ignore permissions - posts can be deleted in areas that a moderator may not have access to.

The option to activate this tool appears in the drop-down menu in the postbit, as well as on the profile page. From here it is a "one-touch" operation, with the small exception that you must press a confirmation button before the cleanup is made.




See the screenshot for the various options, but some of the more interesting ones are:

• You can specify individual users (in addition to groups) who can use this tool. This means certain trusted, non-moderator users could have the ability to clean up spam and ban spammers.
• You can specify users or groups who are protected - they cannot be deleted by this tool.
• By default, users who have registered more than 30 days ago are also protected from this tool (spammers tend to be caught and removed fairly soon after registration)
• You can turn the various deletion targets (threads, posts, events, PMs) on or off
• Select between hard delete or soft delete

This mod is similar to some older mods, but improved in a number of ways:

• You also have the choice to alter the standard ban and delete reasons before you press confirm.
• Deletes more types of spam (PMs, events)
• Simple, quick, effective
• Single file import (.xml) no file edits, no template edits, no .php files to upload
• Should work on all versions of 3.6.x and future versions

Installation

Download and import the .xml file via AdminCP -> Plugins & Products -> Manage Products -> Add/Import Product. Remember to click overwrite if upgrading

Configuration

Once installed, check in your AdminCP under "VBulletin settings" and look for the configuration group called "One-touch Spam Ban & Cleanup Options". The default options should be fine for most people.

How to use

If you have rights to use this tool (i.e. are an admin or moderator, or have configured it for the relevant user or group ID) you should see the option appear on the member profile page, or in a drop-down on the postbit (see attached screenshots for an example). The idea is that as soon as you see a spammer select the "One-touch Ban & Clean" option to remove all trace of the spammer.

Support




Support will be given to those who have:

• Read these instructions (and followed them) and
• Clicked install

Version history

1.0 - initial version (28.08.2007)
1.1 - security fix (21.09.2007)
1.2b - Beta Fix to work with vb3.7.0 (20.05.2008)

[ParsianSat_Net]

Dear
hello
I'm banned user
automatic banned IP?

[cyberws]

This should make cleanup after a spammer easier. Thanks.

[weeno]

An issue that we've seen.

If you try to "one touch ban" from a user's name in the postbit, it tries to ban the 1st poster in the thread, not the user whose name you've clicked on.

Obviously, it's the wrong variable is being used.

arn

[DssCrazy]

something needs to be added!

Look at the pic! i pointed it out!

[Todecay]

seriouly a great mod...thanks a lot m8!!

[tekguru]

Any ideas why we are getting this message when trying to run?

PHP Code:

Database error in vBulletin 3.6.8:

Invalid SQL:

                DELETE FROM vb_pm WHERE pmtextid IN (SELECT pmtextid FROM vb_pmtext WHERE fromuserid = 21443);

MySQL Error  : Got error 134 from storage engine
Error Number : 1030
Date         : Monday, December 24th 2007 @ 08:37:24 PM
Script       : http://www.4winmobile.com/forums/misc.php
Referrer     : http://www.4winmobile.com/forums/misc.php?do=spamcleanconfirm&u=21443 


It's been running flawlessly for ages...

[RS25com]

Edit - admin error - one of the admins gave public access to the tool and Google/Yahoo was hitting the link and deleting everyone.

[RS25com]

Originally Posted by mfyvie

The issue you described was fixed in 1.0. Can you confirm that you are seeing that issue in version 1.1?

There is a protocol for reporting security issues with mods. It usually involves contacting the author first and/or the vbulletin.org team. I don't think it's helpful for you to announce to everyone to disable the product. I do think however it would be useful for you to liase with me if you feel this product is in any way responsible that I can also confirm that.

Please see my edit above - it turns out someone (admin?) changed one of the templates and allowed anonymous access to the tool.

I've removed it just in case, which is unfortunate as it's a great product.

[tekguru]

Just goes to show tools like this are powerful and need to be given to Mods only!

[leeman]

Installed and works like a charm.

Thnx!