i try to import from this file --product-vbstopforumspam.xml

from this direction
http://beneficiofamily.com/asd.jpg

and is show

Database error in vBulletin 3.6.9:
Invalid SQL:
CREATE TABLE IF NOT EXISTS `vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
ExcludeIPs VARCHAR( 5000 ) NOT NULL ,
ExcludeNames VARCHAR( 5000 ) NOT NULL ,
ExcludeEmails VARCHAR( 5000 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) TYPE=MyISAM;;
MySQL Error : Too big column length for column 'ExcludeIPs' (max = 255). Use BLOB instead
Error Number : 1074
Date : Friday, April 18th 2008 @ 03:28:16 PM
Script : http://www.beneficiofamily.com/new/a...=productimport
Referrer : http://www.beneficiofamily.com/new/a...?do=productadd
IP Address : 87.111.36.43
Username : avi
Classname : vB_Database

i ask in vbulletin.com forums and the say

Gomjaba
Senior Member

You will have to ask the author who actually gave you the product (probably vb.org)

what version of mySQL are you using? Ill try to back port to non-v5 (but really, v4 is ending for end-of-live support)

Currently, those fields are there to support an upcoming version. Ill remove them in 0.3 (tonight) and attempt to support mySQL4. I dont have it installed and I cant really start installing multiple versions when v4 is so old. The 1.0 release will only support mySQL5...

If you get that error, open the XML file in notepad and delete these three lines (line 21-23) or just install v0.3

ExcludeIPs VARCHAR( 5000 ) NOT NULL ,
ExcludeNames VARCHAR( 5000 ) NOT NULL ,
ExcludeEmails VARCHAR( 5000 ) NOT NULL ,

save and then import the XML

This mod appears to be incomplete and dependent on data returned from the StopForumSpam site. I would be very nervous to install it in its present condition, maybe ever. I think the premise is okay but the implementation was not thought out as well as it might have been. Its dependency on StopForumSpam is troublesome in that they are but a single incomplete resource for IP addresses of forum spammers. I have been running a pilot spambuster for several months using their IP list for a starter lookup table and they are not as "uptodate" as you would think. I get a huge number of hits from spammers that are not in their list at all. Using only the IP address is also troublesome in that some spammer footprints get through simply because they are "not on the list".

Good idea though...

do you provide an IP list that I can make the mod work with, either downloadable or accessible?

The mod is completely dependant on SFS website, its just a RBL check. spamhaus isnt always uptodate as some would like but in stops billions of spam each day and it had to start somewhere.

With the mod installed, a spammer wll bypass its checks if not known about. Without the mod, it would get on regardless, this just puts one more step in the way.

great work, I'll give it atry.

One thing that concerns me is what happens if the SFS is down, does the registration just timeout or is their an expiry on the db call which if no return is made from the SFS site registration continues regardless of username used?

If the SFS website is down, the query will time out, adding about 10-20 seconds to the registration process but the script handles that.

You can configure the action to be taken if it times out, either allowing the registration or denying it with a configurable error, which defaults to something like "We verify new registrations against a database but its currently down, please try again later, sorry for the inconvenience"

Sounds interesting. Maybe I'll give it a try later.

Well, its blocking between 2-10 registrations per day on my small site, so it does work as another annoyance for the spammers

Great mod!

Quick question: Is the check for username/ip/email an "AND" check or an "OR" check? In other words, do all 3 have to match in order for someone to be blocked, or can any one match for a block? If it's an "OR" check, I probably will turn off username check as that could block a lot of potentially legit users.

Thanks!
-vissa