Anti-Spam Options - vbStopForumSpam

vbStopForumSpam

Mod of the month winner October 2009.... That cant be bad :up:

Apologies in advance, this is a copy of the 3.6/3.7/3.8 mod that has been verified to work in 4.0 (its so that I dont get a billion PMs asking if it works in 4.0)

This provides access to a RBL type system for forum admins, listing known spam IP / email / usernames. The RBL database is provided by www.stopforumspam.com. You do NOT need an API key from the website in order to access the database. only to submit data if you should wish to do so.

At the point of user registration, the mod checks if the IP number / provided username / email addresses appear on a block list and can block the registration.

Whilst this isnt the most perfect way to stop all forum spam, its another step that spammers have to overcome.

What it does

It checks with a remote database of known forum spammers. Their IP number, email address and forum username are tested and based on your configuration, you can reject / log / accept user registrations based on what you get back.

This version doesnt have
- whitelisting or the ability to submit users to the database but it will within the next week.
- automatic user deletion / post / PM purging. There are good tools out there already, this does something else.

Instructions are included in the installation.txt file - PLEASE read it first and dont forget to actually upload the files in the upload folder, otherwise it WILL kill your registration progress and you wont see the log file options in admincp.

Changes to vB
- 3 new database tables
- 2 database table alternations
- No new templates.
- 2 Hook (register_addmember_process & register_addmember_complete)

Ive tested it but had feedback that it works with versions as old as 3.6.2... Support should go back to older versions, as long as they have hook support for register_addmember_process / register_addmember_complete

For code to submit spammers to the database, check this post for code changes
https://vborg.vbsupport.ru/showpost....&postcount=288

Reported to work
- 3.6.1, 3.6.2, 3.6.9, 3.6.10, 3.7.0, 3.7.1, 3.7.2, 3.7.3, 3.74, 3.80, 3.81, 3.82, 3.83, 3.8.4, 4.0beta3, 4.0 Gold, 4.2pl1,2

Installers should remember to refresh their ACP navigation window when they first install it so they can see the new log file menu item.

REQUIRES MySQL 4.1.1+

There is a small mod, coded by Wired1 that will allow you to submit spammer details to the database from the admin control panel, here https://vborg.vbsupport.ru/showpost....&postcount=289 This relies 100% on javascript being enabled and makes no tests that it is enabled.

You need to have an API key from www.stopforumspam.com in order to submit data, its free and easy to get... You DONT need an API key in order to use this mod however, only to submit spammer data.

Issues are
- The usergroup permissions / view details etc DONT work. I jumped the gun and put the permissions controls in there before I put the code in. Please delete the includes/xml/bitfield_vbstopforumspam.xml file and rebuild your postbit

Installation
- Follow the instructions in the zip file, that includes the file upload the correct folders.

Please click Installed

The original thread is at https://vborg.vbsupport.ru/showthread.php?t=176481 where there is a wealth of knowledge about the mod, please ask questions in there.

[MagiKelly]

Originally Posted by GamerPerfection

This mod is breaking. It's letting registrations through when IPs and emails are listed on the StopForumSpam database.

Are you sure they are not being added to the database after they have registered with your forum but before you check? If you are one of the first forum you start on this can be the case.

[GamerPerfection]

Originally Posted by MagiKelly

Are you sure they are not being added to the database after they have registered with your forum but before you check? If you are one of the first forum you start on this can be the case.

I am sure. There were a couple of instances where it was added to the database approx 5 days before registering on my site.

It's only happened on two occasions in the past few weeks and all the others are getting blocked. I just find it odd that these two have got through.

[GamerPerfection]

I have Query Connection Errors set to Block Registration.

And I didn't say mine wasn't working properly, but some odd ones are getting through.

See this for example:

AssassinKn 	2012-07-23 08:31:09 	a.r.m.a.v.ir.75.643@gmail.com 	46.118.123.98 	Result on field ip - 46.118.123.98 - Spammer and rejected by policy
Objelssef 	2012-07-23 08:27:38 	lesliewalshe1982@yahoo.com 	1.161.155.243 	Result on field ip - 1.161.155.243 - Spammer and rejected by policy
LawerenceA 	2012-07-23 05:30:28 	Thresawcfdooasqx@hotmail.com 	94.46.240.203 	Allowed registration
jeawncini 	2012-07-23 05:26:42 	sff8a5aeses@gmail.com 	91.236.74.194 	Result on field ip - 91.236.74.194 - Spammer and rejected by policy
Dersalure 	2012-07-22 22:28:26 	intensityasdz@gmail.com 	117.26.202.173 	Result on field ip - 117.26.202.173 - Spammer and rejected by policy

[datoneer]

Tagged!

[jancarlo]

Database error in vBulletin 4.2.0:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) TYPE=MyISAM;;

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=MyISAM' at line 4
Error Number : 1064
Request Date : Thursday, August 30th 2012 @ 10:22:05 PM
Error Date : Thursday, August 30th 2012 @ 10:22:05 PM
Script : http://++++++++.++++.com/admincp/plu...=productimport
Referrer : http://++++++++.++++.com/admincp/plu...?do=productadd
IP Address : ++.+++.++.+
Username : ++++++++ ++++++++
Classname : vB_++++++++
MySQL Version : 5.5.23-55

I vBulletin: (vBulletin 4.2.0 Patch Level 2) ... help me? thanks

[jacksonweb]

Originally Posted by jancarlo

Database error in vBulletin 4.2.0:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) TYPE=MyISAM;;

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=MyISAM' at line 4
Error Number : 1064
Request Date : Thursday, August 30th 2012 @ 10:22:05 PM
Error Date : Thursday, August 30th 2012 @ 10:22:05 PM
Script : http://++++++++.++++.com/admincp/plu...=productimport
Referrer : http://++++++++.++++.com/admincp/plu...?do=productadd
IP Address : ++.+++.++.+
Username : ++++++++ ++++++++
Classname : vB_++++++++
MySQL Version : 5.5.23-55

I vBulletin: (vBulletin 4.2.0 Patch Level 2) ... help me? thanks

open the product xml and change TYPE to ENGINE save and import again

[Gecuba]

Originally Posted by GamerPerfection

...but some odd ones are getting through.

I have had the same problem when intalled spamomatic instead of stopforumspam. As a result - 1-2 allowed spammer registrations per day and 10-15 rejected... I just tired of spammer-hunting and istalled keycaptcha plug-in. And now I have a crystal-clear log of registrations in logs - real only.

[warlord0]

Liking this so far. So annoyed lately with the amount of spammers. vb is binning them as duplicate ips for existing banned accounts, but I'd really rather they didn't even get registered. So this is very useful.

[warlord0]

Hmm, ok some oddness

ferrywoop 	2012-09-03 23:05:15 	ferrywoop@hotmail.co.uk 	90.216.10.165 	Allowed registration
ferrywoop 	2012-09-03 23:04:34 	ferrywoop@hotmail.co.uk 	90.216.10.165 	Allowed registration
ferrywoop 	2012-09-03 23:03:38 	ferrywoop@hotmail.co.uk 	90.216.10.165 	Allowed registration

But ferrywoop isn't a registered user.

[Snowhog]

I like the idea of this MOD, and I want to install it. I am however, not well versed in vBulletin, even though I am an Administrator on our Forum.

Your Install instructions say to upload the contents of the Upload folder to the 'root of your server'. I'll beg indulgence and plead ignorance, but what is the root of our server??

Our Forum is installed on /srv/www/kubuntuforums.net/public_html

"Be kind to newbie Admins"