Description:
----------------
This Mod will allow you to check the StopForumSpam.com database for Usernames, Email Addresses and IP Addresses on registration, guest posting, broadcast message, alert moderator and send topic. If any details match a spammers details in their database then registration or guest posting will not be allowed.

You can also allow Administrators to submit details to the database when spammers get through who haven't already been submitted (you will need an API Key from their website for the submit feature to work).

Note: The following modules need to be installed on your server for this mod to work. There is a module checker built in so you can easily see if any modules are missing. Also, you won't be able to enable the settings if any modules are missing.

LWP::UserAgent
XML::Simple
XML::SAX

German translations are available to download from this post (thanks pyragony):

http://www.boardmod.org/yabb2/YaBB.pl?num=1315522544/167#167

Screenshots:
-----------------
Admin Center - Antispam Settings - StopForumSpam:


Error Message:


View Profile:


Board Index:


Admin Center - Registration Log:


Admin Center - Forum Statistics:


Response Page:


Admin Center - Forum Stats - StopForumSpam Log:


Zip Package:
-----------------
StopForumSpam_Mod_V0_6.mod
html_root/yabbfiles/Templates/Admin/default/admincatbg.gif
html_root/yabbfiles/Templates/Forum/default/sfs.png
cgi-bin/Admin/StopForumSpamLog.pl
cgi-bin/Languages/English/StopForumSpam.lng
cgi-bin/Sources/StopForumSpam.pl

Installation:
----------------
1) Modify YaBB files using BoardMod or manually.
2) Upload modified files to your server in ASCII mode.
3) Upload StopForumSpam.pl and StopForumSpam.lng to their relevant directories in ASCII mode.
4) Upload admincatbg.gif and sfs.png to their relevant directories in binary mode.
5) Go to Admin Center - Antispam Settings - StopForumSpam to configure the settings.

Files to edit:
----------------
AdminIndex.pl
Admin/Admin.pl
Admin/AdminSubList.pl
Admin/ModList.pl
Admin/ModuleChecker.pl
Admin/NewSettings.pl
Admin/RegistrationLog.pl
Admin/Settings_Antispam.pl
Languages/English/Admin.lng
Languages/English/Error.lng
Languages/English/Register.lng
Sources/BoardIndex.pl
Sources/Post.pl
Sources/Profile.pl
Sources/Register.pl
Sources/SendTopic.pl
Sources/SubList.pl
Templates/default/BoardIndex.template
Templates/yabb21/BoardIndex.template

Mod History:
----------------
V0.1 - First release - 8th September 2011
V0.1.1 - Optimized to only send one request - 13th September 2011
V0.1.2 - Fixed small syntax error - 16th October 2011
V0.2 - Added Admin options to choose which details to check against the database - 20th October 2011
V0.2.1 - Added error message if unable to connect to the SopForumSpam database and moved code below other checks on registration page - 26th October 2011
V0.2.2 - Added a timeout and Admin option to choose how registration should behave if the StopForumSpam database is unavailable and added a custom URL option to redirect spammers to another page/website - 31st October 2011
V0.3 - Added to the Module Check in Admin Center - 1st November 2011
V0.3.1 - Added module checks to the Register page so there will be no spam checks or errors if the required modules are not installed, and added module checks to the settings page so that the settings cannot be enabled if the required modules are not installed - 2nd November 2011
V0.4 - Added Auto-banning for IP Addresses and Email Addresses - 7th November 2011
V0.5 - Added ability for Administrators to submit spam to the StopForumSpam database from user profiles and the registration log, added option to block IPs on server level and moved code to a separate file - 16th November 2011
V0.5.1 - Fixed bug with auto-adding email addresses and added StopForumSpam Statistics to Admin Center and Board Index - 24th November 2011
V0.5.2 - Tidied up Statistics code - 24th November 2011
V0.6 - Added StopForumSpam registration log and added checks to guest posting, broadcast message, alert moderator and send topic - 27th November 2011

Sadly, this mod will not work here on boardmod, because any outbound communitcation from the webserver is blocked. Some kind of offline version of this mod would help though.

Administrator wrote on Sep 10^th, 2011 at 10:01am:

Actually Michael, did you test it to see if it works or not?

I obviously don't fully understand the limits with your outbound communications being blocked, but there's no real communication going on - All it does is get an XML file using LWP::Simple, for example:

    use LWP::Simple;
   
    $check_reg_username = "http://www.stopforumspam.com/api?username=$member{'regusername'}";

    $check_user = get($check_reg_username); 

And then reads the XML file using XML::Simple...

Edited:

Oh just noticed that it is indeed possible to download the database. Maybe this is an option after all. The "manual download" and reupload to the webserver could be done via a cron job on a local machine.

Administrator wrote on Sep 11^th, 2011 at 3:30pm:

Is that the .csv files you are looking at? To be honest, I have no experience whatsoever with cron jobs - I assume it would be something you would have to do specifically for BoardMod?

Administrator wrote on Sep 11^th, 2011 at 2:58pm:

Ah, I've got you. Thanks for explaining.

batchman wrote on Sep 11^th, 2011 at 4:00pm:

I wouldn't have thought it would cause more of them to come to your forums - did you check the IP's to see if some of them are the same ones? Good to know it's working anyway.

batchman wrote on Sep 12^th, 2011 at 6:58pm:

I've just registered with no problems. I guess you can delete that account now if you like - 'DB the 2nd'...

It might be a good idea to optimize the mod so that it will only send one request per registration instead of three. You can do that like so:

http://www.stopforumspam.com/api?ip=91.186.18.61&email=g2fsehis5e@mail.ru

This will speed up the process and will also reduce the server load for stopforumspam.com.

Another good idea might be to use DNS queries instead of a full HTTP request. This reduces server load even more. You can find a very basic description here:
http://dnsbl.tornevall.org/index.php?do=usage

Hi Michael,

First off, thank you very much for your feedback on this. I enjoy making simple Mods for YaBB, but will never be up to the standards of guys like yourself and Carsten, so I very much appreciate your input.

Administrator wrote on Sep 12^th, 2011 at 10:11pm:

Yep. I'll sort this out in the next day or so (one too many ciders right now). The main reason I did them separate originally was because I had planned on having an admin option to choose which fields should be checked - for example, usernames like 'berry' and 'test2' are in the database, so some admins might not want usernames checked - but in the scope of this mod and unless there's any other interest in doing that, then you're obviously right - I'll get onto it. That would mean only one error message too.

Administrator wrote on Sep 12^th, 2011 at 10:11pm:

I'll have a look at that Michael, but like I say, I'm not a expert at these things (just a small time YaBB hacker)...

L_ith wrote on Sep 12^th, 2011 at 10:04pm:

Hi L_ith,

It's only a two step Mod (and one of those is a language file), so I'm 99.999999999% sure that it will already work with 2.4.

batchman wrote on Sep 12^th, 2011 at 10:53pm:

He he - I was thinking about those earlier on when I was over at your board, and how the purple template somehow seems to belong there. I think you deserve 'squatters rights' on them.