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: 1200
Released: 23 Dec 2009 Last Update: 27 Dec 2009 Downloads: 6125
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

  #451  
Old 05 Jun 2013, 02:45
joe1989 joe1989 is offline
 
Join Date: Apr 2008
How do I submit data to the database? I have created an API and entered it in the appropriate location. Just not sure what to do now with my spammer data.
Reply With Quote
  #452  
Old 05 Jun 2013, 04:02
djbaxter djbaxter is offline
 
Join Date: Aug 2006
Location: Ottawa, Canada
Originally Posted by joe1989 View Post
How do I submit data to the database? I have created an API and entered it in the appropriate location. Just not sure what to do now with my spammer data.
For vBulletin 4.x, create a new plugin:

Product: vBulletin (or vBStopForumSpam)

Hook: useradmin_edit_column1 (or useradmin_edit_column2 if you prefer)

Title: Submit to StopForumSpam.com

Execution order: 5

Plugin code:

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

Insert your own API code where it says "YOUR API KEY HERE"

Plugin is Active: Yes
Reply With Quote
  #453  
Old 05 Jun 2013, 04:49
joe1989 joe1989 is offline
 
Join Date: Apr 2008
Awesome! Thanks! Works like a charm
Reply With Quote
  #454  
Old 29 Jun 2013, 23:22
jdrakopo jdrakopo is offline
 
Join Date: Jun 2010
Question y'all:
The instructions.txt file says to "Upload the contents of the upload folder into the root of your forums. DOnt upload the "upload" folder itself, just the contets of the upload folder."

Does that mean that *EACH* of the files in the sub-folders under 'Upload' (i.e., admincp, includes) should get dropped right into the root folder ? --> /public_html/staging/forums

Or... does that mean that files in admincp should get dropped into:
/public_html/staging/forums/admincp

... and that files in includes should get dropped into:
/public_html/staging/forums/includes

I tried both but got 'Invalid File Specified' when I clicked 'Import' in the 'Import Product' admincp screen.

THANKS !
PS - I'm using VB 4.1.9

Last edited by jdrakopo; 29 Jun 2013 at 23:49.
Reply With Quote
  #455  
Old 30 Jun 2013, 03:40
bzcomputers's Avatar
bzcomputers bzcomputers is offline
 
Join Date: Apr 2012
Originally Posted by jdrakopo View Post
Or... does that mean that files in admincp should get dropped into:
/public_html/staging/forums/admincp

... and that files in includes should get dropped into:
/public_html/staging/forums/includes
It means the above.
Reply With Quote
  #456  
Old 30 Jun 2013, 12:28
jdrakopo jdrakopo is offline
 
Join Date: Jun 2010
Thanks.
This is the error I'm receiving (below)
I must be missing something simple ?

- - -
Database error in vBulletin 4.1.9:
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 : Sunday, June 30th 2013 @ 05:24:53 AM
Error Date : Sunday, June 30th 2013 @ 05:24:53 AM
Script : http://www.<<mysite>>.com/staging/forums/admincp/plugin.php?do=productimport
Referrer : http://www.<<mysite>>.com/staging/forums/admincp/plugin.php?do=productadd
IP Address : xxx.xx.xxx.xxx
Reply With Quote
  #457  
Old 06 Jul 2013, 16:10
jdrakopo jdrakopo is offline
 
Join Date: Jun 2010
hey - can anybody help out here ?
Thanks.
Reply With Quote
  #458  
Old 08 Jul 2013, 03:57
Jakeman's Avatar
Jakeman Jakeman is offline
 
Join Date: Nov 2001
Try finding that CREATE TABLE query in the files and change:

TYPE=MyISAM

...to:

ENGINE=MyISAM
__________________
lamo mac boy
Reply With Quote
  #459  
Old 08 Jul 2013, 04:12
Rob Graves Rob Graves is offline
 
Join Date: May 2011
I am getting the exact same error:

Database error in vBulletin 4.1.12:

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 : Sunday, July 7th 2013 @ 11:00:39 PM
Error Date : Sunday, July 7th 2013 @ 11:00:39 PM

SQL version is 5.5.23-55
Reply With Quote
  #460  
Old 08 Jul 2013, 04:21
Rob Graves Rob Graves is offline
 
Join Date: May 2011
Engine did it - thanks man!
Reply With Quote
  #461  
Old 08 Jul 2013, 14:46
Rob Graves Rob Graves is offline
 
Join Date: May 2011
A big thanks - 133 spammers were stopped just last night!
Reply With Quote
  #462  
Old 10 Jul 2013, 05:32
jdrakopo jdrakopo is offline
 
Join Date: Jun 2010
Yeah - big thanks to jakeman on this.

I certainly would not have picked up on the need to change TYPE to ENGINE.
Is this an issue that needs to get addressed in the next ver of this module ?
Reply With Quote
  #463  
Old 10 Jul 2013, 07:35
Bernd Glasstett's Avatar
Bernd Glasstett Bernd Glasstett is offline
 
Join Date: Sep 2002
Real name: Bernd Glasstetter
It seems, that version 0.61 doesn't work with vBulletin 4.1.11. Is there a way to get an older version, which works with that version of vBulletin 4.1?
__________________
Comicforum.de - The largest comicboard in Germany
Reply With Quote
  #464  
Old 28 Jul 2013, 14:45
gsk8's Avatar
gsk8 gsk8 is offline
 
Join Date: Jun 2003
It doesn't appear to work on 4.2.1 either...
Reply With Quote
  #465  
Old 20 Aug 2013, 07:28
hmdyilmaz hmdyilmaz is offline
 
Join Date: Aug 2013
Originally Posted by gsk8 View Post
It doesn't appear to work on 4.2.1 either...
Yea, Thats right.

it was my post in somewhere else :

Hi Guys

We are the one of vBulletin users. We are having trouble, nowadays. Becasue of spams. I have added vbStopForumSpam_v0.61.zip into the our forum. But, after that Nobody registered to our forum.
How we gonna solve this issue ?

Please, Anyone knows how to solve it?

Thanks a lot
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 11:16.

Layout Options | Width: Wide Color: