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.

[howard007]

I've been running this fine and all of the sudden:

All of the sudden I get these errors and I've been running vbstopforumspam for a couple months. How do I fix?


Database error in vBulletin 4.0.3:

Invalid SQL:
INSERT INTO vbstopforumspam_log (date, ipaddress, email, username, message, blocked,
userhash) VALUES (now(), '91.121.85.126' , 'larrypae@gmail.com', 'Unregistered',
'Result on field username - Unregistered [REMOTEERR] Unverfied but allowed by
policy', 0, '677850e24e7b5900768632062e50c3f7');;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Sunday, June 6th 2010 @ 12:55:52 AM
Error Date : Sunday, June 6th 2010 @ 12:56:59 AM
Script : http://www.website.com/forums/register.php?do=addmember
Referrer : http://www.website.com/forums/register.php
IP Address : 91.121.85.126
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :

[Fireagle]

Log sort by IP:

Datenbankfehler in vBulletin 4.0.3:

Invalid SQL:

SELECT * FROM vb_vbstopforumspam_log AS logs

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

MySQL-Fehler : Unknown column 'ip' in 'order clause'
Fehler-Nr. : 1054
Fehler-Zeit : Sunday, 06.06.2010 @ 15:16:20
Datum : Sunday, 06.06.2010 @ 15:16:20
Skript : http://*********/admincp/vbstopforum...erby=ip&page=1
Referrer : http://*********/admincp/vbstopforum...sername&page=1
IP-Adresse : ************
Benutzername : Fireagle
Klassenname : vB_Database
MySQL-Version : 5.0.83-log

[howard007]

Is there any way that I can whitelist an IP? If I was a coder, I'd do it.

Can't we have an over ride option to enter an IP? PLEASE???

Thanks

[Mrdby]

well i added it and seems to be fine for now.

[JHUMON]

hm working well

[Mrdby]

diamonds sparkles 2010-06-10 12:52:28 ******@hotmail.com 96.50.97.44 Allowed registration

It allowed her, but she still was rejected because of the spam policy. why is that?

All other members that were allowed are now on the site and their name is clickable when i run this log report except for her.

[Dragonsys]

Originally Posted by Mrdby

diamonds sparkles 2010-06-10 12:52:28 ******@hotmail.com 96.50.97.44 Allowed registration

It allowed her, but she still was rejected because of the spam policy. why is that?

All other members that were allowed are now on the site and their name is clickable when i run this log report except for her.

maybe because of the space in her name? Check your username Regular expression and see if spaces are allowed.

[Mrdby]

Originally Posted by Dragonsys

maybe because of the space in her name? Check your username Regular expression and see if spaces are allowed.

where do i find that? I want to change people from adding spaces or certain characters when joining my site.

[fxwoody]

Tks for the plugins! Will make us feel safer

[Mrdby]

same problem with somone else but they were allowed and still is not a registered member.

Unregistered 2010-06-14 15:24:05 thelordof.the.rings2k@gmail.com 85.186.255.233 Result on field username - Unregistered - Spammer and rejected by policy
Unregistered 2010-06-14 15:05:42 gogogogoass@gmail.com 94.19.191.183 Result on field username - Unregistered - Spammer and rejected by policy
Unregistered 2010-06-14 14:43:54 neltocount@land.ru 91.212.226.15 Result on field username - Unregistered - Spammer and rejected by policy
Unregistered 2010-06-14 14:04:15 afd-4444@yandex.ru 91.214.44.233 Result on field username - Unregistered - Spammer and rejected by policy
Unregistered 2010-06-14 08:59:56 mail@sextoys-diskret.com 79.237.89.141 Result on field username - Unregistered - Spammer and rejected by policy
rosieado 2010-06-14 08:57:08 rosieado@yahoo.com 71.179.101.243 Allowed registration
rosieado 2010-06-14 08:56:32 rosieado@yahoo.com 71.179.101.243 Allowed registration
rosieado 2010-06-14 08:55:37 rosieado@yahoo.com 71.179.101.243 Allowed registration