vBulletin Mods

ouch, well it seems china it hitting alot of vbulletin forums over the last week
i added an antispam register to my forum found here
http://www.vbulletin.org/forum/showthread.php?t=288742
if you follow it step by step, it stops the registration from spammers, harvesters etc
its somthing i added the other day to the mods

Thank you, simonhind. Believe me, China is hitting other forum software just as hard.

Since I posted earlier today, we decided to supplement with NoSpam! Image Enhancement (New version of No Spam! for Custom Image Verification) and will see how that goes.

In the meantime, I'll share information about AbyssGuard with the rest of the Admin Team to consider.

I have been using this one and it really works well.

http://www.vbulletin.org/forum/showthread.php?t=282704

I installed this three weeks ago after one day coming on and having over 100 pending accounts most of which were spam, in those three weeks it has stopped 6987 Spammers which is an insane number, still though 20/30 are getting through per day but as I have members on approval then we catch them away.

Running VB 4.2.0 - and am getting this error message when trying to upload the product-glowhostspamomatic.xml file:

Database error in vBulletin 4.2.0:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `glowhostspamomatic_log`(
`date` DATETIME NOT NULL,
`ip` VARCHAR(15) NOT NULL,
`email` VARCHAR(255) NOT NULL,
`username` VARCHAR(255) NOT NULL,
`message` VARCHAR(255) NOT NULL,
`is_blocked` TINYINT NOT NULL DEFAULT "0",
`user_hash` VARCHAR(50) NOT NULL,
`user_id` INT NOT NULL
) TYPE=MyISAM;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10
Error Number : 1064
Request Date : Thursday, October 11th 2012 @ 07:54:55 PM
Error Date : Thursday, October 11th 2012 @ 07:54:56 PM
Script : http://yyyyyyyyyyyyyyy.com/forum/adm...=productimport
Referrer : http://yyyyyyyyyyyyyy.com/forum/admi...?do=productadd
IP Address : 70.139.218.237
Username : HIIIIIIIII
Classname : vB_Database
MySQL Version : 5.5.20-log

Any thoughts or tips, tricks on how to get this fixed?
Thanks!!!!!!!!

Just needed to read a few posts back...

You can find the answer to this in posts: 2047, 2049, 2083, 2096, 2097.

Ughhh, I can't believe I missed those. THANK YOU for helping out a fellow Texan. :) I'm multi tasked too thin since I missed all of these...

Works now!:D

im getting a database error upon importing the product. what is wrong?

Thanks for this, helped me out huge

I've just read this in the read me file

'' ==
* Please note, for this plugin to work, cURL must be installed on the server
or allow_url_fopen enable in PHP settings '' What does this mean?

Its a server setting, you would need to speak with your hosts or if you run your own server you would need to make sure these settings are available.

Thanks for the help bluefin.

First of all I would like to say that this is a fantastic piece of software, thank you very much for sharing this with everybody. I installed it 1 day ago and when I tested it some more I will definitely donate to the author, much deserved!

Question: Is it possible to check the current user database to see if users match the stopforumspam database? I have a forum with over 500,000 users and I'd like to check if there are spammers amongst them.

this is designed for new user registrations

Perhaps it would be possible to add the feature I described?