Anti-Spam Options - [GlowHost] Spam-O-Matic for vB 3.8 (StopForumSpam, Akismet, Auto-Moderation and more)

We have released a mod for your vBulletin 3.8 that should stop almost all forum spam on your vBulletin boards. It is basically an (anti)Social Networking RBL to keep your forums clean!

This version is BETA and was developed specifically for vBulletin 4. However we believe this should work on vBulletin 3.8 so we have put it here for you in case you want to try a more robust Spam solution than what is currently available.

BETA is not a good word, this is more of an "Unsupported Backport" for earlier versions of vB.

The "REAL" Spam-O-Matic system was developed for vB4. This version is for you guys and gals that need to spend less time managing the spamers on your board(s). We hope it helps! The important features should work.

The original mod for vB 4 is located here:
https://vborg.vbsupport.ru/showthread.php?t=248042

IF YOU RUN vB4, MAKE SURE YOU ARE IN THE RIGHT THREAD!
Look at the URL above,
(sorry for caps)

This version is for vBulletin 4.x though has been reported to work on 3.6+
We only offer support on vBulletin 4.x as the 4.x version will have features not possible in the 3.x series.

This module has the ability to submit new spammer details to the StopForumSpam or Akismet databases automatically, all without any new templates or manual template modifications! :up:

Just install the product in the product manager, upload a few files, configure the system and you are done. (Estimated time: 5-10 minutes)

How it works:
New registrations are checked against the known spammer database at StopForumSpam.com. If the email, IP, or username exists in their database, the user (or bot as the case may be) is denied registration on your forums. If they make it past the SFS check, they are checked against several Automatic Moderation rules, and are also checked against the Akismet service for known comment spam.

A) StopForumSpam:
The StopForumSpam Module lets you:

• Check a registrant's IP address.
• Check a registrant's email address.
• Check a registrants Username.
• Disable or enable any of the above checks.
• Block and log, or, allow and log known spammers.
• All registration attempts are logged for your viewing pleasure.
• Several other performance tuning options

If they are not found in the StopForumSpam database or are allowed registration by your rules, their registration details are passed to the built-in vBulletin registration system. (Human verification, etc)

It is completely invisible to humans who are registering that this process is taking place. Bots are stopped dead in their tracks.

If a spammer is able to sneak past the first line of defense, and manages to post, then there are secondary and tertiary protections.

B) Auto-Moderation:
Auto Moderation lets you:

• Define how many URLs a new member can post before being sent to moderation.
• Define keywords that will send a post to Auto-moderation (viagra, porn, meds, etc)
• Define minimum post count to avoid Auto-moderation.
• Excludes admin and moderators from Auto-moderation.
• Completely disable Auto-moderation if you don't want it.

B) Akismet Service
Spammers that make it past the StopForumSpam and Auto-Moderation will be checked against the Akismet service. If they manage to make a post, and then are found on Akismet, they can be auto-moderated.

The Akismet settings let you:

• Set the number of posts that Akismet will check from each user. After this number is exceeded, Akismet checking will be disabled for that user.
• Auto-Submit spammers that post on your boards back to the Akismet service so that other forums and blogs do not do not receive the same spam.
• Completely disable the Akismet service.

Punitive Actions:
If you find a spammer has made it past your 3 lines of defense, and has managed to post on your forum, then you can help the community...

The spammer's details can be sent to the Stop Forum Spam and Akismet databases automatically, preventing them from registering or posting on other forums. When other forums do the same, the protection is reciprocated.

Simply moderate a post and choose the option to "Delete Posts As Spam..." an then choose the option to "Ban User." Banning the user sends their details to either Akismet, StopForumSpam, (or both) depending on how you set it up.

The next version will add a "Spam-O-Matic" option to the Postbit Moderation Tools menu to better streamline the process and make it two-click process instead of the long and cumbersome way that vBulletin Ban options are presented now. This new menu option will be available only for vBulletin 4.x series.

API Keys:
API Keys are NOT required for this system to stop spammers on your forums.

A StopForumSpam API key is required if you want to contribute to the StopForumSpam blacklists by adding your spammers to their database. By submitting spammers you help keep other forums and blogs clean.

An Akismet API key is required if you want to enable any Akismet auto-moderation features in this module.

You can obtain a Stop Forum Spam API key which is free from stopforumspam.com.

Get your StopForumSpam API Key Here

You can obtain an Akismet API key from Akismet.com.
Akismet offers free and paid API keys so choose your version based on your situation.

Get your Akismet API Key Here

Why it is better than the other anti-spam solutions on vBulletin.org:

• Works with all of vBulletin 4 functions including Facebook automatic registration.
• Report spammers that you find to the Stop Forum Spam Database.
• Report spammers that you find to the Akismet Database.
• Built-in Auto-moderation.
• Auto-moderation rules based on post count.
• Auto-moderation rules based keywords.
• Auto-moderation rules based Akismet results.
• Enable or disable any actions that you do not want.
• Customizable "Registration Rejected" message.
• Consolidates 3 popular methods of spam prevention into one product.
• No Manual Template Modifications!
• Supported!

======================
Compatibility:

vBulletin 4.0.x - but for 4.x you should GO HERE instead.

vBulletin 3x versions that have been reported to work:

*vBulletin 3.8.4 Patch Level 2
*vBulletin 3.8.5
*vBulletin 3.8.6 Patch Level 1
*vBulletin 3.8.7
*vBulletin 3.8.7 Patch Level 1
*vBulletin 3.8.7 Patch Level 2 (with this mod)



(Add your version here by sending us a PM or post in the thread!)

Should you decide to install this on an vB3, we are interested in your feedback. Let us know if it works or fails miserably.

======================
Reported Conflicts or reproducible known issues:

None at this time for this release.

======================
Modifications:

2 table alterations

9 hooks used:

- register_addmember_process
- register_addmember_complete
- userdata_presave
- useradmin_edit_column1
- userdata_delete
- userdata_postsave
- newpost_process
- threadfpdata_presave
- postdata_presave

No new templates or template modifications!

Uploads:
4 files. (2 PHP, 2 XML)
1 Product Manager Upload
======================

=====================
Donations:

If you like this mod, sure, you can donate.
But the best donation would be to nominate us for MOTM, to tell your friends and others about this mod, and if you are in need of web hosting, order it from GlowHost.com to show your thanks.

We hope you enjoy the mod, spread the word to keep all of our forums clean. :up:

=====================
Installation:

1) Download the attached file
2) Mark As Installed
3) Extract the zip file, and view the readme file.

If you like this mod, please nominate us for Mod Of The Month

=====================


Original concept credits go to the authors of vBStopForumSpam and MonkeyStop

[cube87]

Originally Posted by Alice

I'm running vBulletin 3.8.11, and I tried installing this plugin today, and got this error:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `glowhostspamomatic_log`(
        							`date` DATETIME NOT NULL,
        							`ip` VARCHAR(15) NOT NULL,
        							`email` VARCHAR(255) NOT NULL,
        							`username` VARCHAR(255) NOT NULL,
        							`message` VARCHAR(255) NOT NULL,
        							`is_blocked` TINYINT NOT NULL DEFAULT "0",
        							`user_hash` VARCHAR(50) NOT NULL,
        							`user_id` INT NOT NULL
						         ) TYPE=MyISAM;;

I have the same error

How can I resolve this?

[GlowHost.com]

It's been answered many times in the thread. I forgot the fix, but try searching this thread for

TYPE=MyISAM;;

And I am sure you will find what you are looking for.

[ccr1969]

run into a sql query
TYPE=MyISAM;
changed to
Engine=MyISAM;
working now
Runner
Classname : vB_Database_MySQLi
MySQL Version : 8.0.22

[NSanityHD]

Confirmed to be working on vB 3.8.11.

Had to modify the XML to amend the "TYPE" to "ENGINE" but it does install successfully on 3.8.11.

[buryka]

Thank you, everything works, almost ). When registering with Cyrillic logins, I get errors:

Invalid SQL:
SELECT is_spambot FROM  glowhostspamomatic_remotecache WHERE `field`="username" AND `data`="Александра " LIMIT 1;

MySQL Error   : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation '='
Error Number  : 1267
Request Date  : Sunday, October 30th 2022 @ 12:43:14 PM
Error Date    : Sunday, October 30th 2022 @ 12:43:14 PM
Script        : http://forum...../register.php?do=addmember
Referrer      : https://forum....../register.php?do=register
IP Address    : 46.211.83.184
Username      : Александра

[buryka]

He asked himself, answered himself:
f_glowhostspamomatic_remotecache 'data' - latin1_swedish_ci -> cp1251_general_ci
f_glowhostspamomatic_log 'username' - latin1_swedish_ci -> cp1251_general_ci