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.

[Bob_R]

I have a friend who tried to register to my site and this hack denied him. I know this guy is legit. How can I push him thru?

[Mungo5]

Seeing a bug/sql error when I try to re-order the log view on IP address..

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT * FROM vbstopforumspam_log AS logs

ORDER BY ip ASC, date DESC
LIMIT 0, 50;

MySQL Error : Unknown column 'ip' in 'order clause'
Error Number : 1054
Request Date : Wednesday, February 10th 2010 @ 08:32:13 AM
Error Date : Wednesday, February 10th 2010 @ 08:32:13 AM
Script : http://www.thisforum.com/admincp/vbs...erby=ip&page=1
Referrer : http://www.thistvforum.com/admincp/v...y=email&page=1
IP Address : xxxxxxxxxxx
Username : root
Classname : vB_Database
MySQL Version : 5.0.89-community

Thanks..

[utahraves]

Originally Posted by Bob_R

I have a friend who tried to register to my site and this hack denied him. I know this guy is legit. How can I push him thru?

Figure out what about his registration it didn't like. Go to the logs and look up vbstopforumspam logs. I use it all the time. This stops over 2000 registrations a day on my board

[utahraves]

<span style="text-decoration: line-through">Question: How do I submit these spammers without going to the StopForumSpam site?</span>
Just kidding. I found it.

[vb4newb]

I just tried to sign up for a test account and your mod told me i was a spammer, so I uninstalled it and found 20 members who it blocked and not one of them is in any Spam database including the Stop Forum Spam database. Your mod does not work!

[meissenation]

vb4newb, check your settings. Do you have "Connection Query Errors" set to "Allow" or "Block" ? If you scroll down in the Admin CP navigation and click "Statistics & Logs" and then click the vbStopForumSpam log, you'll see why it's blocking their registrations... if it says anything about connection error or any error messages, then it's denying the registration because of the "Connection Query Errors" setting.

[migowebdesign]

Originally Posted by pedigree

Strange, I just tried to register on a test forum and got

sjq234ssys 2009-12-28 10:15:06 wogold1454@gmail.com 192.168.0.10 Result on field username - sjq234ssys - Spammer and rejected by policy

Not unregistered or EMAIL

I maybe know what's the reason.

Something has changed since vb3. The Spammer uses Tools which automatically fill out all the fields on the website. But so far I can see, the Tools doesn't find the username field now. If you submit a test registration without the username, you will get also an UNREGISTERED in the Logfile.

So imho we can't do anything, because the spammer doesn't submit a username, so nothing to display in the Logfile...

Cheers
Mike

[nazgulhunter]

Having an issue displaying Profiles. Have "Rebuilt Bit Fields" as explained in the Txt, and the bitfield is not present in my Includes/xml folder.

See here: http://devilnetwork.com/Forum/member.php?1-[Nazzeth]

My host uses MySQL Version 5.1.43

Memberlist loads correctly also -

[MOTweb]

In the past 48 hours since installed, 13 of 13 spammer stops, no problems with legit registrations. Fixed our #1 problem.

AWESOME install!

[DaleM]

Working fine for me. Haven't had one spam registration go through since I installed it 10 days ago, 15 valid registrations were allowed. At least nobody has written any emails regarding not being able to register.