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

  #301  
Old 29 Jul 2011, 08:24
mavortium's Avatar
mavortium mavortium is offline
 
Join Date: Apr 2007
Same problem here.

Originally Posted by chrisxp View Post
Hi there,

since updating to 4.1.4, the "Add Spammer" box doesnt show on editing users..

could this be updated, or tell me how to?

thanks,

chrisxp
Reply With Quote
  #302  
Old 29 Aug 2011, 13:13
odie3 odie3 is offline
 
Join Date: Mar 2007
hope this MOD keeps running cause it has blocked 80+ registrations! My forum is made up of a old gaming team and we hardly get new registrations anymore but it's nice to have registration enabled again in case we get a someone that needs to register.
Reply With Quote
  #303  
Old 01 Sep 2011, 08:30
businessmeet businessmeet is offline
 
Join Date: May 2009
awesome plugin ..
__________________
Coming soon | http://www.businessconsultant.net - Are you special ? Get yourself interviewed.
Reply With Quote
  #304  
Old 14 Sep 2011, 11:26
Abfabmedia Abfabmedia is offline
 
Join Date: Dec 2009
Question Need someone

to install on my forum at http://www.plymouthbuzz.co.uk

I have a small budget

David
Reply With Quote
  #305  
Old 16 Oct 2011, 21:30
misericorde misericorde is offline
 
Join Date: May 2011
Please Uptated for vb 4.1.7
Reply With Quote
  #306  
Old 16 Oct 2011, 22:09
djbaxter djbaxter is offline
 
Join Date: Aug 2006
Location: Ottawa, Canada
Originally Posted by misericorde View Post
Please Uptated for vb 4.1.7
It works fine in 4.1.7.
Reply With Quote
  #307  
Old 17 Oct 2011, 07:18
ngocol ngocol is offline
 
Join Date: Jul 2011
thanks installed
Reply With Quote
  #308  
Old 17 Oct 2011, 18:51
ffaat ffaat is offline
 
Join Date: Apr 2010
Currently, only Admins can access the vbStopForumSpam Logs in the back end.

Is there any way I can add this to Moderators as well?

Thanks,

-Rob A>
Reply With Quote
  #309  
Old 19 Nov 2011, 17:28
motorola motorola is offline
 
Join Date: May 2009
Real name: Gabriel
How to uninstall this mod ?
Reply With Quote
  #310  
Old 07 Dec 2011, 13:27
Toshinobu Toshinobu is offline
 
Join Date: Oct 2006
I'm getting the following error message when I try to import the product XML file:

Database error in vBulletin 4.1.8:

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

Any help would be appreciated, thanks. I looked at the SQL script it's complaining about and it looks fine.

**EDIT**
Replace the word TYPE with ENGINE on lines 22, 35, and 45 and product imported successfully

Last edited by Toshinobu; 07 Dec 2011 at 13:34.
Reply With Quote
  #311  
Old 07 Dec 2011, 14:21
ForceHSS's Avatar
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Originally Posted by Toshinobu View Post
I'm getting the following error message when I try to import the product XML file:

Database error in vBulletin 4.1.8:

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

Any help would be appreciated, thanks. I looked at the SQL script it's complaining about and it looks fine.

**EDIT**
Replace the word TYPE with ENGINE on lines 22, 35, and 45 and product imported successfully
http://www.vbulletin.org/forum/showthread.php?t=248042
use this one
Reply With Quote
  #312  
Old 14 Feb 2012, 15:16
WillisB WillisB is offline
 
Join Date: Feb 2012
This is the best. Simple and does what is says. Thanks
Reply With Quote
  #313  
Old 25 Feb 2012, 15:22
DAMINK DAMINK is offline
 
Join Date: Jun 2010
Just got denied registration on my test account.
Running 4.1.10
Checked against database and no ip entry or email as i just made the email address for the test.
Is this a common problem?
Uninstalled until further notice.
__________________
FTW Forum <- Home of the damned!
Reply With Quote
  #314  
Old 27 Feb 2012, 13:59
djbaxter djbaxter is offline
 
Join Date: Aug 2006
Location: Ottawa, Canada
Question

Dedicated server with lots of resources, RAM, disk space, and bandwidth.

Three vBulletin 4.1.10 forums running, two with vbstopforumspam installed.

ONLY ONE of these (and not the most active one) has lately been throwing frequent errors like the following (these started just 2 or 3 weeks ago - prior to that, all was fine):

Database error in vBulletin 4.1.10:

Invalid SQL:
INSERT INTO vbstopforumspam_log (date, ipaddress, email, username, message, blocked, userhash) VALUES (now(), '91.207.5.126' , 'kinotru@gmail.com', 'UsasseSaf', 'Result on field ip - 91.207.5.126 [REMOTEERR] Unverfied but allowed by policy', 0, 'b70728cf449d36b0ad5f2f7f713814ec');;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, February 27th 2012 @ 08:35:37 AM
Error Date : Monday, February 27th 2012 @ 08:36:07 AM
Script : http://domain.com/register.php?do=addmember
Referrer : http://domain.com/register.php
IP Address : 91.207.5.126
Username : UsasseSaf
Classname : vB_Database
Database error in vBulletin 4.1.10:

Invalid SQL:
INSERT INTO vbstopforumspam_log (date, ipaddress, email, username, message,
blocked, userhash) VALUES (now(), '72.64.146.136' , 'sunnie2088@gmail.com',
'usbflashdriveppx', 'Result on field ip - 72.64.146.136 [REMOTEERR]
Unverfied but allowed by policy', 0, '781be45ede1bf941343ca68fd875b7ec');;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, February 27th 2012 @ 05:53:45 AM
Error Date : Monday, February 27th 2012 @ 05:54:15 AM
Script : http://domain.com/register.php?do=addmember
Referrer : http://domain.com/register.php
IP Address : 72.64.146.136
Username : usbflashdriveppx
Classname : vB_Database
Normal registrations are still succeeding on that forum and as noted it is not a very active forum as yet. All of the errors are for usernames that look spammy but I have it set so that only email and IP are checked against the database, so it's not the username that's triggering this.

Also, despite the "MySQL server has gone away", there are no MySQL errors coming from several other sites on that server using MySQL incoluding at the same time that these errors are appearing, so the error seems to be misleading, i.e., it seems it's the invalid SQL statement that is throwing the error, not MySQL crashing.

Any idea what is causing this?
Reply With Quote
  #315  
Old 22 Mar 2012, 22:43
AusPhotography's Avatar
AusPhotography AusPhotography is offline
 
Join Date: Nov 2007
Real name: Rick-owner, Kym-admin
I know why you get database errors....

Lets say a new member (or hacker) tries to register...
  • The register vB PHP script opens the database (with a (say) a 30 second time out (wait_timeout=30) set in MySQL my.cnf)
  • The SFS plugin then goes off to check the credentials against the remote SFS service (3 times) using curl in my case
  • SFS is either very slow or offline
  • SFS plugin times out, then then retries using another method (silly really)
  • The retry also times out
  • The total SFS time out is > 30 seconds
  • The plugin tries to update the database, which has 'disappeared' due to its own 30 second time out, and vB traps it as a DB error

So I've fixed the problem by ...
a) when using cURL not failing back to file access
b) changed the cURL time out to 8 seconds
c) changed to cURL time out from string to integer (time outs were not working at all)
d) also... changed split to explode for PHP 5.3 compatibility

Replace the functions_vbsfs.php file with the one attached here.

Enjoy! (permission given for the code to be added to the main product)

Kym
Attached Files
File Type: php functions_vbsfs.php (8.8 KB, 12 views)
__________________
www.AusPhotography.net.au a.k.a. AP is a photography forum where members share their photography, photo editing skills and techniques. We run regular photographic competitions; Rick (site owner) and Kym (site tech) using this account
*** Home of the AP fully comprehensive vb4 photographic competition management solution ***
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 14:09.

Layout Options | Width: Wide Color: