Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
vbStopForumSpam Details »
vbStopForumSpam
Mod Version: 0.61, by pedigree (Coder) pedigree is offline
Developer Last Online: Nov 2013 I like it Show Printable Version Email this Page

vB Version: 4.0.0 Rating: (100 votes - 4.73 average) Installs: 1205
Released: 23 Dec 2009 Last Update: 27 Dec 2009 Downloads: 6146
Not Supported DB Changes Uses Plugins Additional Files Re-usable Code External Content  

vbStopForumSpam

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


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
http://www.vbulletin.org/forum/showp...&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 http://www.vbulletin.org/forum/showp...&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 http://www.vbulletin.org/forum/showthread.php?t=176481 where there is a wealth of knowledge about the mod, please ask questions in there.

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Administrative and Maintenance Tools vbStopForumSpam - known spammer lookup for new registrations pedigree vBulletin 3.6 Add-ons 1228 26 Jan 2016 18:27
Administrative and Maintenance Tools vbStopForumSpam pedigree vBulletin 3.8 Add-ons 154 09 Apr 2013 07:54

  #346  
Old 30 Jun 2012, 17:57
pedigree pedigree is offline
 
Join Date: Jul 2005
when I do the next version, for vb5, then I will include this and a lot more. memcache / redis and APC detection and caching, form validation and reporting.
__________________
My mods vbRosterMaster | Ajax New PM Notifier | vbStopForumSpam
Reply With Quote
  #347  
Old 30 Jun 2012, 18:06
KProjects KProjects is offline
 
Join Date: Feb 2006
Awesome - glad to see you are still actively developing this!
__________________

Stop Spammers
Reply With Quote
  #348  
Old 01 Jul 2012, 08:45
GamerPerfection's Avatar
GamerPerfection GamerPerfection is offline
 
Join Date: Feb 2006
Good work!
__________________
Gamer Perfection
Reply With Quote
  #349  
Old 07 Jul 2012, 19:31
GamerPerfection's Avatar
GamerPerfection GamerPerfection is offline
 
Join Date: Feb 2006
I just had a new user sign up using the IP 173.213.108.208. Looking at it on stopforumspam there are 13 entries for it in Feb and Mar yet the registration was allowed???
__________________
Gamer Perfection
Reply With Quote
  #350  
Old 11 Jul 2012, 17:32
khronos_group khronos_group is offline
 
Join Date: Mar 2012
I've noticed that a lot of the users registering on our forums have banned IP addresses on stopforumspam. About 2/3rds of the signups are now successfully getting banned, but I would estimate that more like 4/5ths of the signups should be banned. The most recent IP address allowed to signup is 199.87.229.22. Its in the stopforumspam database several times, including 5 days ago.

Is there an adjustment I need to make to ensure that all IP addresses that appear in the stopforumspam database get banned from signing up on our forums?

Suggestions are welcome. We are running the latest 4.2 install of VB.

Thank you.
Reply With Quote
  #351  
Old 13 Jul 2012, 16:39
GamerPerfection's Avatar
GamerPerfection GamerPerfection is offline
 
Join Date: Feb 2006
This mod is breaking. It's letting registrations through when IPs and emails are listed on the StopForumSpam database.
__________________
Gamer Perfection
Reply With Quote
  #352  
Old 13 Jul 2012, 16:50
khronos_group khronos_group is offline
 
Join Date: Mar 2012
We since switched to Glowhost Spam-o-matic. It also uses the stopforumspam db, and works with registration, posts and much more. We are on 4.2.x
Reply With Quote
  #353  
Old 15 Jul 2012, 07:25
MagiKelly MagiKelly is offline
 
Join Date: Jan 2006
Originally Posted by GamerPerfection View Post
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.
Reply With Quote
  #354  
Old 21 Jul 2012, 17:19
GamerPerfection's Avatar
GamerPerfection GamerPerfection is offline
 
Join Date: Feb 2006
Originally Posted by MagiKelly View Post
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.
__________________
Gamer Perfection
Reply With Quote
  #355  
Old 24 Jul 2012, 01:06
semprot semprot is offline
 
Join Date: Mar 2010
Real name: Jeremy
Lightbulb

Originally Posted by GamerPerfection View Post
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.
It seems mine is still working


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Originally Posted by GamerPerfection View Post
I just find it odd that these two have got through.
What is your setting for "Query Connection Errors"?
__________________
Best regards,

Jeremy
Reply With Quote
  #356  
Old 26 Jul 2012, 20:44
GamerPerfection's Avatar
GamerPerfection GamerPerfection is offline
 
Join Date: Feb 2006
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:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
Gamer Perfection
Reply With Quote
  #357  
Old 31 Jul 2012, 23:49
datoneer datoneer is offline
 
Join Date: Jul 2011
Tagged!
Reply With Quote
  #358  
Old 31 Aug 2012, 03:31
jancarlo jancarlo is offline
 
Join Date: Feb 2003
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
Reply With Quote
  #359  
Old 31 Aug 2012, 08:56
jacksonweb jacksonweb is offline
 
Join Date: Aug 2012
Originally Posted by jancarlo View Post
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
Reply With Quote
  #360  
Old 31 Aug 2012, 09:12
Gecuba Gecuba is offline
 
Join Date: Sep 2010
Originally Posted by GamerPerfection View Post
...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.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 23:19.

Layout Options | Width: Wide Color: