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)

[Symmetrical?]

installed 44 well done

[hobbystoresearc]

this is a database error I get when clicking on the link to remove spam

Database error in vBulletin 3.6.8:

Invalid SQL:

		SELECT COUNT(0) FROM thread 
		WHERE postuserid = 3
		AND threadid NOT IN 
			(SELECT primaryid FROM deletionlog 
			WHERE type = 'thread');

MySQL Error  : You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT primaryid FROM deletionlog 
			WHERE type = 'thread')' 
Error Number : 1064
Date         : Wednesday, August 29th 2007 @ 09:56:39 AM
Script       : http://www.*****/forums/misc.php?do=spamcleanconfirm&u=3
Referrer     : http://www.*****.com/forums/member.php?u=3
IP Address   : *****
Username     : munsonfan15
Classname    : vB_Database

[mfyvie]

That database syntax should be correct. What version of mysql are you running?

[Alibass]

Originally Posted by mfyvie

See my answer above, you probably don't have the correct hooks in your custom skins, add them and the problem will be resolved.

In my other custom skins I see your postbit_onetouchban template installed. I did not have $template_hook[postbit_user_popup] in my custom skins postbit templates so I added it in the location you suggested and reinstalled your mod, but I still cannot get the One-touch Ban & Clean option in the postbit drop down menu of my custom skins to work.

[Alibass]

Never mind I found where to add postbit_onetouchban code in postbit to make it work.

Thanks again, great mod.

[FreshFroot]

Wow.. this should be a MOTM, great stuff mate

[hobbystoresearc]

Originally Posted by mfyvie

That database syntax should be correct. What version of mysql are you running?

mysql 4.0.27

[Apophis]

The product installed okay, but I do have a rather strange result:

In the postbit pull-down (I use the legacy postbit) I see the "One Touch Ban & Clean" option for the FIRST post in the thread. On the SECOND post in the thread I see that option twice in the pull-down, for the THIRD post I see it three times. etc. etc. etc.

Any ideas?

[Apophis]

Upon further inspection I also see that even though it displays multiple times, each iteration retains the userid of the respective poster based on the post order.

IE: On a situation where it is displayed 5 times (on the 5th post). The first occurance lists the first posters ID, the second occurance lists the second posters ID, etc. etc.

[mfyvie]

Originally Posted by Alibass

In my other custom skins I see your postbit_onetouchban template installed. I did not have $template_hook[postbit_user_popup] in my custom skins postbit templates so I added it in the location you suggested and reinstalled your mod, but I still cannot get the One-touch Ban & Clean option in the postbit drop down menu of my custom skins to work.

Hmm, strange. I don't know enough about the template hook system to comment, but I would have thought that just adding the hook would be enough, but maybe there's more to it than that. Well at least you've resolved the problem manually in any case.

Originally Posted by hobbystoresearc

mysql 4.0.27

Ok, that is a problem. I just checked and 4.0 doesn't support sub queries. I strongly suggest you upgrade to mysql 4.1 or later (or encourage your host to do so). I may change the product pre-requisites so that it won't install if you have mysql 4.0.

Originally Posted by Apophis

The product installed okay, but I do have a rather strange result:

In the postbit pull-down (I use the legacy postbit) I see the "One Touch Ban & Clean" option for the FIRST post in the thread. On the SECOND post in the thread I see that option twice in the pull-down, for the THIRD post I see it three times. etc. etc. etc.

Any ideas?

This is most strange. The relevant code can be found in the plugin called "Insert into templates" at postbit_display_start:

eval('$template_hook[postbit_user_popup] .= " ' . fetch_template('postbit_onetouchban') . '";');

The php concatenation operator ".=" is used there. This means, append the contents, rather than replace them. This seems to work correctly on other systems, but I've no idea why it isn't working on yours. Basically what is happening is that something else should resetting that hook on each iteration, but that isn't happening, so this hook keeps growing and growing as you proceed down the page. Are you running an older version of vbulletin (bug maybe?) or perhaps another hack is causing this behaviour?

You can work around it by changing the ".=" to just "=" but this will kill any other mods that might be using this template hook (though you probably don't have any).