Anti-Spam Options - Spam Decimator

Description
Handle spam with two fast clicks.

Features
- Ban user
- Delete all forum threads by user (soft or permanent)
- Delete all forum posts by user (soft or permanent)
- Delete all blog comments by user (soft or permanent)
- Delete all blogs by user (soft or permanent)
- Delete all cms comments by user (soft or permanent)
- Move soft deleted threads to specific forum (option)
- Send auto mail to spammer
- Send auto mail to webmaster
- Set maximum posts for display spam button

Install
1.) Upload all files from the "upload" folder to your forum root
2.) Import the product
3.) Done

Update
1.) Upload all files from the "upload" folder to your forum root (override existing files)
2.) Import the product (override the existing)
3.) Done

Changelog


2.0.1
[BUGFIX] - Blog entries deletion

2.0 Beta 2
[UPDATE] - Improved Decimator view (See: Attachment #3)
[FEATURE] - Added checkbox for blog entry deletion
[BUGFIX] - Textarea (send mail to spammer) only visible if setting is on now

2.0 Beta
[UPDATE] - Updated to vBulletin 4.1.5
[UPDATE] - Made full XHTML valid
[UPDATE] - Updated delete_blog_entries() function (for soft and permanent delete)
[UPDATE] - Replaced all hardcoded text with phrases
[UPDATE] - Various changes
[FEATURE] - ON/OFF Setting for send mail to spammer
[BUGFIX] - Fixed wrong forum/thread rebuilding (reported here: #125)

Note
This is only a beta. Update will follow. Please report bugs and issues in this thread.

Credits
Special thanks to RaidenDAWG2, who's written the original addon. He gave me the permission to update & release it here.

[Hostboard]

Originally Posted by amin

Hi

I kind like this Mod at beging but on private message there is an icon you can spam any user! one if my moderator spammed himself!!!!
sorry I have to uninstall it until this bug get fixed

I have this installed on multiple VB4 sites. The SPAM button is the exact same as the ones listed after each thread and brings up the decimator window as shown in the modifications description:

https://vborg.vbsupport.ru/attachmen...4&d=1317579819

It does nothing else. Double checked and working as designed.

[Scyther]

Good mod..thanks marked installed.

[MediaHound]

I installed the mod.
I did not visit the settings to REALLY enable blog post spam deletion.
I ran the tool against a user.
His blog spam was still there.
I figured out I REALLY needed to enable the blog spam removal.
I enabled that.
I visited the thread where the post was soft deleted of the user who I ran the tool against.
I ran the tool against him again, this time I was sure I would delete all his blog spam.
All the blog posts on my site were deleted.
I am more than pissed right now, need to restore blog table from most recent incremental rsoft backup.

BE CAREFUL WITH THIS!
Developer should patch to prevent that.

[MediaHound]

Here is a very quick and dirty fix for anyone who might do that to themself.
Restore the deleted posts to be visible:

UPDATE  `forum`.`blog` SET  `state` =  'visible' WHERE  `blog`.`blogid` =1;

and if you are happy,

UPDATE  `forum`.`blog` SET  `state` =  'visible' WHERE  `blog`.`blogid` >1;

and then restore the deleted comments to be visible:

UPDATE  `forum`.`blog_text` SET  `state` =  'visible' WHERE  `blog_text`.`blogtextid` =1;

and if you are happy,

UPDATE  `forum`.`blog_text` SET  `state` =  'visible' WHERE  `blog_text`.`blogtextid` >1;

[MediaHound]

Well I just ran it again on a fresh spammer and again all my blog posts are deleted.

[MediaHound]

Once you restore all the blog posts, you can go in and delete just the offending blog posts and comments, using a query like this

UPDATE  `forum`.`blog_text` SET  `state` =  'deleted' WHERE  `blog_text`.`userid` =7870

and

UPDATE  `forum`.`blog` SET  `state` =  'deleted' WHERE  `blog`.`userid` =7870;

just change the userid to the correct one you want to clean up.

[Fraxter]

Bug confirmed. I will take a look. Thanks for reporting.

[Hostboard]

Hopefully an update fixing this bug and re-palcement of the SPAM button as requested here: https://vborg.vbsupport.ru/showpost....4&postcount=20
can be done soon. More or less will put the finishing touches on this awsome mod

[mrthe]

ip ban. would be a perfect idea

great mod ... congrats

[Fraxter]

MediaHound found a huge bug which was related to blog post deletion.
I fixed and updated the mod. It's not the best solution, but for more i haven't time yet.

Sorry for the delay, i hope 2013 i can come back with more features and faster updates. Atm my real life really sucks.