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.

[jdrakopo]

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

[bzcomputers]

Originally Posted by jdrakopo

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.

[jdrakopo]

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

[jdrakopo]

hey - can anybody help out here ?
Thanks.

[Jakeman]

Try finding that CREATE TABLE query in the files and change:

TYPE=MyISAM

...to:

ENGINE=MyISAM

[Rob Graves]

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

[Rob Graves]

Engine did it - thanks man!

[Rob Graves]

A big thanks - 133 spammers were stopped just last night!

[jdrakopo]

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 ?

[Bernd Glasstett]

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?