Administrative and Maintenance Tools - vbStopForumSpam

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. This queries the StopForumSpam database (where I am a coder and administrator) to see if a new users IP address/email address/IP number are listed as known spammer sources.

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.

Currently, I would say this is an beta codebase. Please treat it as such.

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.

This is the exact same version that is on the 3.6 forums because it works with 3.54 to 3.84 (at time of wriing, the latest version)

Changes to vB
- 3 new database tables
- 2 database table alternations
- No new templates.
- 2 Hook (register_addmember_process & register_addmember_complete)

Known to work - tested by me
- vBulletin 3.6.8 on Apache 2.2 / PHP 5.1.2 on Linux using cUrl
- vBulletin 3.7 Gold on Apache 2.0 / PHP 4.4.3 on Windows without cUrl (template changes wont work on 3.7 - thats in the next version with auto template changes)

For code to submit spammers to the database, check this post for code changes
https://vborg.vbsupport.ru/showp...&postcount=288

Reported in the thread to work
- 3.5.4 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

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+

If you want to submit data directly from the user admincp to the database, then you can install an addon mod (Coded by Wired1) here https://vborg.vbsupport.ru/showpost....&postcount=288

You need to have an API key from www.stopforumspam.com in order to submit data, its free and easy to get... The code above is a quick hack that changes the pages "form" so that it submits to the database. As its a quick hack, this relies 100% on javascript being enabled and makes no tests that it is enabled.

Please click Installed

[ETDC]

Add 'IsBot' too and it'll be even fewer.

[toneloc]

I've just now installed that too. Thanks for the tip!

[tylercruz]

Originally Posted by popowich

If you are trying a new install of this addon in a vB 3.8.x forum powered by MySQL Server 5.5.x :

• Download the zip file
• Extract and edit the product XML file
  • Change the (3) lines that have :

) TYPE=MyISAM;"

• and make them look like :

);"

With that change the product appears to install and function correctly.

Thank you for this. Works perfectly!

[tylercruz]

Originally Posted by popowich

If you are trying a new install of this addon in a vB 3.8.x forum powered by MySQL Server 5.5.x :

• Download the zip file
• Extract and edit the product XML file
  • Change the (3) lines that have :

) TYPE=MyISAM;"

• and make them look like :

);"

With that change the product appears to install and function correctly.

I just wanted to clarify that you will need to do this regardless of which vBulletin version you're using, but just if you have MySQL 5.5+. You will need to implement this tweak whether you're installing on vB 3.7.x or vB 3.8.x for example.

[CoffeeLovesYou]

Instead of removing TYPE=MyISAM if it is giving you a SQL error, change TYPE to ENGINE
ENGINE=MyISAM
Type was eradicated in SQL 5.5