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.

[hmdyilmaz]

Hi Guys

We are the one of vBulletin users. We are having trouble, nowadays. Becasue of spams. I have added vbStopForumSpam_v0.61.zip into the our forum. But, after that Nobody registered to our forum.
How we gonna solve this issue ?

Please, Anyone knows how to solve it?

Thanks a lot

[djbaxter]

Originally Posted by hmdyilmaz

Hi Guys

We are the one of vBulletin users. We are having trouble, nowadays. Becasue of spams. I have added vbStopForumSpam_v0.61.zip into the our forum. But, after that Nobody registered to our forum.
How we gonna solve this issue ?

Please, Anyone knows how to solve it?

Thanks a lot

and also follow here : http://www.vbulletin.com/forum/forum...=1376921314163

https://vborg.vbsupport.ru/showthrea...38#post2439738

Originally Posted by TheLastSuperman

Hmm without access its hard to tell however... try this stop forum spam mod - https://vborg.vbsupport.ru/showthread.php?t=239307 then reply back here and let us know it the other mod works, if so we can surely then say it was this mod conflicting with something else on your site. That's a quick way to test imo.

Originally Posted by hmdyilmaz

Hi Guys

We are the one of vBulletin users. We are having trouble, nowadays. Becasue of spams. I have added vbStopForumSpam_v0.61.zip into the our forum. But, after that Nobody registered to our forum.
How we gonna solve this issue ?

Please, Anyone knows how to solve it?

Thanks a lot

Try reading the reply you received above before re-posting the question.

[djbaxter]

Since upgrading to vBulletin 4.2.2 and then PHP 5.4.20, I'm getting errors like this:

Database error in vBulletin 4.2.2:

Invalid SQL:
INSERT INTO vbstopforumspam_log (date, ipaddress, email, username, message, blocked, userhash) VALUES (now(), '216.244.87.218' , 'dmmt347ewq@hotmail.com', 'zeeukslzdx', 'Result on field ip - 216.244.87.218 [REMOTEERR] Unverfied but allowed by policy', 0, 'f3c419d6641f368fc5888e9c4a81d2be');;

They usually also say

MySQL server has gone away

Similar errors are being reported for the Glowhost version, where the response was this:

Originally Posted by ForceHSS

Talk to your host about this problem "MySQL server has gone away"

But it's not that simple. The "gone away" error is, I think, a red herring. I'm on a dedicated server and that is the ONLY time I'm getting these errors. There are no other MySQL issues at the times these occur and it happens on two different 4.2.2 forums.

It's the Invalid SQL error that needs attention. Note the double occurrence of ";;" at the end. That looks malformed to me.

It may well have to do with upgrading to PHP 5.4.20 after the vBulletin 4.2.2 upgrade. I'm not certain.

A satisfactory workaround for now I think would be to turn off logging since the rest of the functions seem to be still working. There is no option to do that in vbStopForumSpam and I don't recall such an option for the Glowhost mod either (I found it to be overkill for my needs so I reverted to the simpler version).

[djbaxter]

Try this - don't know if it will make any difference but see if it does:

Find in functions_vbsfs.php:

[REMOTEERR]

Change to:

REMOTEERR

i.e., remove the square brackets.

No idea if this is creating a problem or not but try it.

I'm also working on some other strategies for tracking this down.

[BlueScion]

Question, can we somehow submit their information when they attempt to signup and aren't allowed to?

Right now I can only submit members who "make it through."

Is that working as intended?

[djbaxter]

Originally Posted by BlueScion

Question, can we somehow submit their information when they attempt to signup and aren't allowed to?

Right now I can only submit members who "make it through."

Is that working as intended?

Yes. If they are already denied registration because their match an identified spammer in the database, what would be the point of adding them again? That would just bloat the database unnecessarily.

[BlueScion]

Originally Posted by djbaxter

Yes. If they are already denied registration because their match an identified spammer in the database, what would be the point of adding them again? That would just bloat the database unnecessarily.

Oh ok.

[stemmy]

im getting db errors on install. Any fix for this.

[webmastersitesi]

Originally Posted by stemmy

im getting db errors on install. Any fix for this.

me too ?

[Itworx4me]

Originally Posted by stemmy

im getting db errors on install. Any fix for this.

Originally Posted by webmastersitesi

me too ?

Open up product-vbstopforumspam.xml

Replace TYPE with ENGINE on line 22, 35, 45


Hope this helps.....

Itworx4me