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

[MikesSite]

Downloaded and installed, thanks.

[409industries]

Originally Posted by HotLink

It gives this errors on posting new thread:

Parse error: syntax error, unexpected T_BOOLEAN_OR in /home/******/public_html/forums/includes/functions_newpost.php(414) : eval()'d code on line 5

I too was getting these errors when trying to post new threads. I went back and noticed that i downloaded Spam-o-matic 1.2.0 because i just saw the VB3-8 in the description. Not thinking that 1.2.8 was appropriate for my forum (vb 3.8.5) i went back and read some other posts... after downloading and installing 1.2.8, the parse errors are gone!

Now, its time to see if its working to keep spammers out. I've got a Stop Forum Spam API key configured, but haven't done anything with Akismet.com just yet. I'm still kind of confused how they force you to use a Wordpress login in order to get a paid / commercial API key? Can anyone explain how this works exactly? Do i just sign up as if i'm using Wordpress but then plug my Akismet API key into the vBulletin options for Spam-o-matic?

Thanks a bunch guys.

[reflekt]

I've accrued 8 million rows in a few months, and noticed that it's running very slow queries against the log with no indexes...

# User@Host: xxxx[xxxxx] @ localhost []
# Query_time: 14.945075  Lock_time: 0.000062 Rows_sent: 0  Rows_examined: 8553148
use xxxxxxx;
SET timestamp=1369595005;
UPDATE glowhostspamomatic_log SET `user_id` = "279880" WHERE `user_hash` = "1a63b3c7499deefee4b121c5672f883d";
# Time: 130526 15:09:39
# User@Host: xxxxxxx[xxxxxxxxxxx] @ localhost []
# Query_time: 15.324704  Lock_time: 0.000042 Rows_sent: 0  Rows_examined: 8553240
SET timestamp=1369595379;
UPDATE glowhostspamomatic_log SET `user_id` = "279881" WHERE `user_hash` = "acb81e895baacbef488a6a6ab07c8a7b";

This was version 1.2.4. I have just upgraded to 1.2.8 - is this issue fixed in the newer version? Should I be truncating my log every 24 hours? What is the log used for?

Thanks!

[M.C.]

Originally Posted by hqlman

Tested working fine with VB3.8.7 patch level 2

Had to make a small change to the XML files sql syntax for it to import, so if you get SQL error whilst importing the XML file, make the changes mentioned below.

In product-glowhostspamomatic.xml

FIND:

) TYPE=MyISAM; ');

REPLACE WITH:

) TYPE=ENGINE; ');

SAVE AND RE IMPORT XML FILE, ENJOY

Hmm... didn't work for me... I have DB error with both above syntax's

Database error in vBulletin 3.8.7:

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=ENGINE;;

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 'TYPE=ENGINE' at line 10
Error Number  : 1064

[squidsk]

Originally Posted by M.C.

Hmm... didn't work for me... I have DB error with both above syntax's

Database error in vBulletin 3.8.7:

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=ENGINE;;

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 'TYPE=ENGINE' at line 10
Error Number  : 1064

Replace Type=MyISAM with Engine=MyISAM.

[M.C.]

Thanks! This one worked fine

[roadguide]

doesn't work on 3.8.7 pl3.
a shame because it worked great on 3.8.4

[squidsk]

Originally Posted by roadguide

doesn't work on 3.8.7 pl3.
a shame because it worked great on 3.8.4

It works just fine on 3.8.7PL3.

[MikesSite]

Originally Posted by roadguide

doesn't work on 3.8.7 pl3.
a shame because it worked great on 3.8.4

Yes it does, it works fine.

Originally Posted by squidsk

It works just fine on 3.8.7PL3.

+1

[roadguide]

Originally Posted by squidsk

It works just fine on 3.8.7PL3.

Originally Posted by MikesSite

Yes it does, it works fine.




+1

truly doesn't....
threads wont post properly , screen hangs. (the thread actually posts but the screen goes to a blank page)
the "submit to stopforum spam" doesn't show when you open a user in cpadmin...

i'd like to know how you guys got it to work in 3.8.7 PL3 (version 1.2.7)
php 5.3.24
mysql 5.5.30-30.2