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.

[ForceHSS]

Originally Posted by Toshinobu

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

https://vborg.vbsupport.ru/showthread.php?t=248042
use this one

[WillisB]

This is the best. Simple and does what is says. Thanks

[DAMINK]

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.

[djbaxter]

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?

[AusPhotography]

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

[alhidaya]

Hello,

It 's ok for vbulletin 4.1.1.1 ?

[Eq4bits]

Originally Posted by DAMINK

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.

having the same problem with 4.1.12, disabled for now =(

[Sage Knight]

Originally Posted by alhidaya

Hello,

It 's ok for vbulletin 4.1.1.1 ?

Can anyone currently running 4.1.11 confirm this?

[N75]

I've been getting lots of emails lately with new registration problems - seems like way too many emails are being flagged as spam. Going to look for another solution.

[vidmarc]

Disabled due to same reason above.