vbStopForumSpam - known spammer lookup for new registrations

[Tmart]

Used this mod for months now and it works great. I did an update last week to 4.0.3. And noticed more spam. I checked my log and had no new info. So i uninstalled the mod. Reinstalled and the spammers are still getting thru, and there is no log. I can't for the life of me get this very important mod to work. I can access the options, and the log is option is showing up under statistics. Is there anything in the new version of VB that I have to change?

Tmart

[ikaro]

It's working perfeclty, great job.

[EcoForumZ]

Awesome product! I am finally able to stop using my .htaccess file to block out whole countries. On a side note I do not recommend using .htaccees to do this as it impacts the forum performance BIG time.

[fivestar2000]

note: runs super on vB CMS 4.0.3

[Chimpie]

IP addresses show up for some users but not others.

Thoughts?

Chimpie

[Floris]

Maybe they are ipv6 ?

[pedigree]

It seems that someone has written a script of some sort that go through every IP in the database, user, posts, I dont know, but some forums have hit the database 80,000 times in a couple of hours.

This has resulted in perm bans from the API for abuse.

Please dont abuse the API. If you require more than 5000 queries a day, ask us first.

[pedigree]

Used this mod for months now and it works great. I did an update last week to 4.0.3. And noticed more spam. I checked my log and had no new info. So i uninstalled the mod. Reinstalled and the spammers are still getting thru, and there is no log. I can't for the life of me get this very important mod to work. I can access the options, and the log is option is showing up under statistics. Is there anything in the new version of VB that I have to change?

Tmart

Nope, its exactly the same code for v3 and v4

[Nicke71]

I installed this mod now, I used a different hack against the database before (When running vb3.8x)

How to submit a spammer to the database? I have API key and did it manually in the past.

[AndrewRich]

Pedigree, I messed around w/ your code snippet for a bit, and made it into a plugin. No edit needed, wahoo!

It puts the box at the end of the first column. One plugin is for JUST the USER ID of 1, the other is for the admin usergroup (6 by default). Looking at it more, it needs some tweaking to use the default themes, but otherwise it works fine. Having this built into the "delete as spam" would be awesome. IIRC, someone has already suggested this, right?

I wanted the "submit as spam" button to open a new tab so as not to blow away the AdminCP, so I changed the code thusly:

Was:

<input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.submit()" type="button" class="button" value="' . $vbphrase['submit'] . '"/>

Now:

<input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.target=\'_blank\';this.form.su bmit()" type="button" class="button" value="' . $vbphrase['submit'] . '"/>

Added:

this.form.target=\'_blank\';

[Chimpie]

I just have to say that I'm very pleased with this mod. According to the logs it appears to be working quite well.

[Naan-Kadavul]

Thanks for the mod, I have installed this. but one problem I am facing.

my friend is having multiple internet connections. he is not able to register in my forum and has been listed as SPAMMER. any ways to solve this issue ?? what about those people who are in cybercafe etc. ???

[rsuplido]

This mod only activates during registration. If they have a legit account already, they can use a computer with a blocked IP anytime.

A workaround for those registering for the first time is to set their account manually, when they report about the problem.

[pedigree]

I recently update the stopforumspam.com website. some one has reported that this broke the postbit reporting. It hasnt but when you submit, there is no page or response. The data goes into the database just fine and Im working on a method to report this back without breaking anything else.

[KW802]

After upgrading my vB 3.x sites to vB 3.8.5 it meant, of course, that I lost the manual edits to submit the user to StopForumSpam.com from directly in the ACP.

So... I came up with a very quick & very dirty plugin to add an option in the postbit. That way if a spammer does make it through and posts something, I can view the post, click on their name in the postbit, hit the 'Submit' button from the drop-down list (which then takes my browser window to the StopForumSpam.com site and shows me the result of submitting the info), hit the browser 'Back' button, and then continue BAU on cleaning up the spam.

Only Super Mods & above should be able to see the 'Submit' button but, for your own sanity, test it out on your site. ;)

Attached is the plugin XML and a screen shot of how it'll look. Notice this is a plugin and not a product! That means you import via ACP => Plugins & Products => Download/Upload Plugins and *not* through the Manage Products screen.

Yes, it's quick & dirty but it serves my purposes.

I recently update the stopforumspam.com website. some one has reported that this broke the postbit reporting. It hasnt but when you submit, there is no page or response. The data goes into the database just fine and Im working on a method to report this back without breaking anything else.

You had me going there for a minute. :D

Try this version instead.... slightly different code but seems to be working with the new site format and will open a new tab/window instead (if people still want it to stay in the same window, let me know).

[djbaxter]

After upgrading my vB 3.x sites to vB 3.8.5 it meant, of course, that I lost the manual edits to submit the user to StopForumSpam.com from directly in the ACP.

So... I came up with a very quick & very dirty plugin to add an option in the postbit. That way if a spammer does make it through and posts something, I can view the post, click on their name in the postbit, hit the 'Submit' button from the drop-down list (which then takes my browser window to the StopForumSpam.com site and shows me the result of submitting the info), hit the browser 'Back' button, and then continue BAU on cleaning up the spam.

Only Super Mods & above should be able to see the 'Submit' button but, for your own sanity, test it out on your site.


How do I change it so that only superadmins or admins can see this option?

[djbaxter]

Actually, I've just installed this and I don't see a link anywhere in the postbit to report as a spammer (I am a superAdmin). Where is this supposed to be set?

[KW802]

Actually, I've just installed this and I don't see a link anywhere in the postbit to report as a spammer (I am a superAdmin). Where is this supposed to be set?
It's in the drop-down. Click on the user's name.

[djbaxter]

Actually, I've just installed this and I don't see a link anywhere in the postbit to report as a spammer (I am a superAdmin). Where is this supposed to be set?

Oops. :o

Never mind. I have a 3.8x forum not yuet upgraded but I was adding this to the 4.06 forum. I just realized I'm in the 3.x thread for this add-on. :o

[KW802]

Oops. :o

Never mind. I have a 3.8x forum not yuet upgraded but I was adding this to the 4.06 forum. I just realized I'm in the 3.x thread for this add-on. :oI posted a 4.x version also in the 4.x thread; I'll update that shortly. My public vB sites are still 3.8.x so that is why you usually see me do vB 3.x versions first.

[Thomas P]

Thanks and kuddos to KW802, nice AddOn to this hack :)
My public vB sites are still 3.8.x so that is why you usually see me do vB 3.x versions first.Great ;)

[tattooz]

FYI, www.stopforumspam.com was down for a while due to the bandwidth being exceeded.

Also, add a space after the // (like below) to find the edit location (which is on line 522 on v3.7.3 PL1)
// QUICK LINKS SECTION



Pedigree, I messed around w/ your code snippet for a bit, and made it into a plugin. No edit needed, wahoo!

It puts the box at the end of the first column. One plugin is for JUST the USER ID of 1, the other is for the admin usergroup (6 by default). Looking at it more, it needs some tweaking to use the default themes, but otherwise it works fine. Having this built into the "delete as spam" would be awesome. IIRC, someone has already suggested this, right?

Not sure I understand this right. I see the box it added at the end of the profile in the adminCP, but, if the spammer is blocked before they have the chance to actually register, what's the point?

Is there a mod, that will submit ALL the blocked spammer that try to register? That's what I need.

By the way, thank you for your hard work and awesome mod!!

[AndrewRich]

Is the blank screen on submitting to stopforumspam.com a known issue?

[KW802]

Is the blank screen on submitting to stopforumspam.com a known issue?
Go back just one page and read posts #1015 onward.

[AndrewRich]

Go back just one page and read posts #1015 onward.
Thanks, but I was referring to submitting from the Admin CP (https://vborg.vbsupport.ru/showpost.php?p=1650801&postcount=289), not the postbit menu. I'll take a look at merging your changes with that plugin.

[AndrewRich]

I've merged KW802's changes into Wired1's supplemental plugin (which adds a "submit to stopforumspam" block in the AdminCP) and submitting from the AdminCP now works, and the resulting window shows the submission.

Thanks to both Wired1 and KW802.

[Zookie]

You had me going there for a minute. :D

Try this version instead.... slightly different code but seems to be working with the new site format and will open a new tab/window instead (if people still want it to stay in the same window, let me know).

Sorry but I'm a novice with vBulletin. I set up my forum a year ago and make changes to it so seldom that I really don't remember how to do anything. I downloaded the file plugin_vBStopFormSpam.xml and followed the quoted instructions that said to "import via ACP => Plugins & Products => Download/Upload Plugins". I went to that page, clicked the Browser button, selected the file and clicked the Import button. It supposedly imported successfully. But when I click the Submit button in the vbStopForumSpam area of the User Manager page I still get a blank page (no new tab). I'm using vBulletin 3.8.4 Patch Level 2. Am I doing something wrong?

[KW802]

Sorry but I'm a novice with vBulletin. I set up my forum a year ago and make changes to it so seldom that I really don't remember how to do anything. I downloaded the file plugin_vBStopFormSpam.xml and followed the quoted instructions that said to "import via ACP => Plugins & Products => Download/Upload Plugins". I went to that page, clicked the Browser button, selected the file and clicked the Import button. It supposedly imported successfully. But when I click the Submit button in the vbStopForumSpam area of the User Manager page I still get a blank page (no new tab). I'm using vBulletin 3.8.4 Patch Level 2. Am I doing something wrong?
The plugin I posted is for the user's postbit while viewing a thread (eg: click on a user's name in the postbit while viewing a thread and you'll see a new option there to submit the user to Stop Forum Spam).

For submitting users directly from within the ACP, try the plugin updated by AndrewRich a few posts up. :)

[Zookie]

For submitting users directly from within the ACP, try the plugin updated by AndrewRich a few posts up. :)
No joy. I again went to ACP > Plugins & Products > Download / Upload Plugins , clicked the Browse button, selected the "vbstopforumspam_usergroup_6_fixed.xml" file I downloaded from post you referenced, and I'm still getting a blank page when I submit from the User Manager page.

Can anyone else confirm that the vbstopforumspam_usergroup_6_fixed.xml update fixed the blank page response when submitting from the User Manager page?

[KW802]

No joy. I again went to ACP > Plugins & Products > Download / Upload Plugins , clicked the Browse button, selected the "vbstopforumspam_usergroup_6_fixed.xml" file I downloaded from post you referenced, and I'm still getting a blank page when I submit from the User Manager page.

Can anyone else confirm that the vbstopforumspam_usergroup_6_fixed.xml update fixed the blank page response when submitting from the User Manager page?
I'll check that version sometime this weekend. I do most of my submits from the postbit so I haven't installed Andrew's version yet.

[whatsthegoodwor]

I'm not sure if the mod is working because no log entry says denied or blocked. Right now it's set to block based on only email and not username/ip. The mod is set to "log and block registration" but allow registration for query connection errors.

The way I can tell who is a spammer is because the user name isn't linked and there's no account made - but the log for those entries still says "allowed registration". I think my vbulletin human verification is what's blocking the spam entries.

Also, what does "Result on field email - [REMOTEERR] Unverfied but allowed by policy" mean?

[adwade]

The way I can tell who is a spammer is because the user name isn't linked and there's no account made - but the log for those entries still says "allowed registration". I think my vbulletin human verification is what's blocking the spam entries.


I've noticed this happening as well, and wondered what was going on? :confused: Thanxx for the explanation, as I think my board is doing the same as well.


Otherwise, I must say: THIS IS THE SINGLE MOST IMPRESSIVE WORKING MODIFICATION I'VE EVER WITNESSED. The Logs are just amazing to read through. :eek:

:D Kudos to pedigree for such a fine product! :up:

[JesterP]

OK, Ive been nagged and nagged and nagged (and not by my wife this time).

Here is a small change to 0.61 that will be worked on in 0.7 that will allow you to submit spammer details to the database from the admin control panel. It requires editting admincp/user.php

http://www.fizzleblood.net/quickadd.png

These line numbers are for my 3.71 dev install, they might be a bit different depending on the version. Ive only tested it in 3.71

Find (about line 524)


// QUICK LINKS SECTION


Insert ABOVE that (but below the if ($vbulletin->GPC['userid']) { )


// VBSTOPFORUMSPAM MOD
if ($vbulletin->GPC['userid'] > 1) { // we dont want to ban our admin account now do we
print_table_header("vbStopForumSpam");
if ($vbulletin->options["vbstopforumspam_apikey"])
print_label_row('Submit these details to www.stopforumspam.com ban list<BR><table><tr><td>Username:</td><td><input type="text" name="username" size="30" value="'. $user['username'] . '"></td></tr><tr><td>Email:</td><td><input type="text" name="email" size="30" value="' . $user['email'] . '"></td></tr><tr><td>IP:&nbsp;</td><td><input type="text" name="ip_addr" value="' .$user['ipaddress'] . '"></td></tr></table><input name="api_key" type="hidden" value="' . $vbulletin->options['vbstopforumspam_apikey'] . '"><input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.submit()" type="button" class="button" value="' . $vbphrase['submit'] . '"/>');
else
print_label_row('You need an API key from www.stopforumspam.com before you can submit to the database' ,'');
print_table_break('', $INNERTABLEWIDTH);
}



You need to have an API key... This is a quick hack that changes the pages form so that it submits to the database. As its a quick hack, this relies 100% on javascript being enabled and makes no tests that it is enabled.

if all goes well, then Ill update the first post with a copy/paste of this. Now, stop PMing me about "can I submit data directly" please :D

I have been confronted by a white page in the ACP main frame when manually submitting. It used to show the spam site telling me it was successful. What could cause the white page upon submit suddenly?

Thanks!

[Wired1]

1. That code was turned into a plugin (by me) a couple of days later, so there's no need to edit anything. Link's in the main post, but here it is again: https://vborg.vbsupport.ru/showpost.php?p=1650801&postcount=289

2. White page is normal for the time being. Happened after they upgraded the StopForumSpam site. If you get that page, it was successfully submitted.

[Alfa1]

Pedigree, what do you think of the following idea?

Many spammers use temporary / fake email providers. i.e. harry1234@trashmail.net
Most fake / temporary email addresses disappear after 1 day or even 5 minutes.
Serious registration use real email providers. There are many temporary email providers and they keep changing their domain names to dodge or

I believe it would help against spam and trolls if there would be a database of temporary email domains. So that if a user registers with such an email domain, the registration is denied. Like with SFS: admins could submit the temporary domains. A system could be used that when an email domain is submitted by more than X vbulletin sites, the domain is marked as a temporary/fake email.

Admins who moderate their new registrations could submit such domains with the click of a button if the 'new users moderation' queue would have a button for it. Other admins could submit trough an adminCP/modcp option.

[Wired1]

A system could be used that when an email domain is submitted by more than X vbulletin sites, the domain is marked as a temporary/fake email.That would block sites like gmail, yahoo, hotmail, etc.

Now keeping track of sites w/ throwaway email addresses and/or super secret ones (e.g. hushmail, etc) might not be a bad idea. Could give admins the option to block registration based upon having an email address from one of those sites, and use a custom phrase for the denied reason (e.g. "You are attempting to register with a temporary email address. We require that our members use real email addresses so that if we need to contact them we can."

[Alfa1]

Popular email domains like gmail, hotmail, yahoo, etc could be white-listed. Additional checks can be built in. For example by having a small group of volunteers double-check each throwaway email domain submission. Im sure there are admins/moderators that are willing to do that, as there will not be that many new domains a month.

Another reason for this suggestion is bouncing email. If your users can sign up with fake email, then this will cause a mass of bounces to be sent to your server.
Bouncing email can cause your site to be listed as a spammer. Its bizarre but true.

[djbaxter]

Another reason for this suggestion is bouncing email. If your users can sign up with fake email, then this will cause a mass of bounces to be sent to your server. Bouncing email can cause your site to be listed as a spammer. Its bizarre but true.

How is bouncing email from fake email addresses going to get you listed as a spammer? Email to the fake email address never gets anywhere to be listed as spam.

The bottom line for me is that i do not want and will not use ANY scheme which autospams bounced email. I don't even use autodelete for spam on my server because of the potential for false positives, however low that may be. I want the option to scan what's being flagged.

[GlowHost.com]

Or you could just use Spam-O-Matic...

I hope Pedigree does not mind me posting here, but it sounds like he is busy maintaining the code for SFS instead of interfaces to the data that he provides.

https://vborg.vbsupport.ru/showthread.php?t=248042

It does all of that without code mods. The 1.x version should be fine for your vB3 boards.

[JesterP]

1. That code was turned into a plugin (by me) a couple of days later, so there's no need to edit anything. Link's in the main post, but here it is again: https://vborg.vbsupport.ru/showpost.php?p=1650801&postcount=289

2. White page is normal for the time being. Happened after they upgraded the StopForumSpam site. If you get that page, it was successfully submitted.

What a relief. :) Thank you. Was hoping it wasn't me.

I would think I need to undo those edits before installing the plugin, correct? I don't think it was a lot.....memory fuzzy. :)

J

[Gav-n-Tn]

Wasn't there a 3.8 mod -back when- to pedigree's hack that auto-submitted to SFS if the registrar failed due to being listed on SFS already?

[Alfa1]

How is bouncing email from fake email addresses going to get you listed as a spammer? Email to the fake email address never gets anywhere to be listed as spam.
While bounces from obvious trashmail domains do not get you on the blacklist, other temporary email domains can get you on the blacklist. Blacklists are shared between email providers. As such your site can be marked as a spammer and then subscription emails stop arriving at various email domains.

The bottom line for me is that i do not want and will not use ANY scheme which autospams bounced email. I don't even use autodelete for spam on my server because of the potential for false positives, however low that may be. I want the option to scan what's being flagged.
You mean auto-bans bounced email?

I do not want to autoban bounced email. I want to autoban fake email domains and their aliases. I see this as one further step to make spamming a little more difficult.

[Dozer826]

Installed and within 2 hours it stopped 6 bots and did not let any in! I've been deleting about 20-25 Bots a day and it is such a pain in the butt.

Thanks so much for this, it's exactly what we were looking for!

*marked as installed! Great work!

[AusPhotography]

It works in vB4.0.7 !!

[SᴩiDᴇЯ]

If you can't provide the service of giving the API key then don't provide the mod.

I will be completely removing it from my server and never will I use this mod.

I have uninstalled this mod due to this: Message from your site,

Sorry

Due to abuse by certain people, we are currently limiting API signups to members of the forum. We are sorry that we have had to take this course of action but we hope to have things back to normal shortly

[BadgerDog]

If you can't provide the service of giving the API key then don't provide the mod.

I will be completely removing it from my server and never will I use this mod.

I have uninstalled this mod due to this: Message from your site,

Sorry

Due to abuse by certain people, we are currently limiting API signups to members of the forum. We are sorry that we have had to take this course of action but we hope to have things back to normal shortly

What the heck does this mean? :confused:

So, even if you have an API key, vbStopforumSpam site no longer checks for spammers unless you join their forums?

Regards,
Badger

[GlowHost.com]

Where did you see this written? Do you have a link?

[pedigree]

Firstly, SᴩiDᴇЯ has zero idea what hes talking about

I stopped the system from being able to bulk issue API keys to anonymous users who simply provided an email address. We made it so that you needed to sign up to the forum, to validate your email address and thus record where you were coming from IN ORDER TO SUBMIT DATA

Then you could get an API key to SUBMIT to the database. You DONT NEED an api key in order to use the api.

I believe that you simply didnt read the mod details as it says "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." Just under the big red letters. Unlike other lists of spammers, BotScout, project honeypot etc, where you are required to register to read the database, we dont do that.

If you want to remove the mod, then please do. Infact, I hope that you do, so that I dont have to deal with you again. Can you say "gift horse mouth"

As someone who obviously runs a forum, would you let people post on your forum without logging in or registering? No? Well, now, neither do we. For all the pain of joining our community to use a service provided for free, is that just perhaps a little too much to ask huh?

[Gav-n-Tn]

I don't know why anyone wouldn't want to join the SFS forum anyway. Lots of great folks and plenty of good community advice. My plug for SFS :)

Apparently someone was fatigued when reading the message about the API.

[biftek]

not sure if this has been answered and i don't feel like reading the whole 70 posts
i have this mod installed on my site , every so often it blocks legit people , is there anyway around this ?

[djbaxter]

not sure if this has been answered and i don't feel like reading the whole 70 posts
i have this mod installed on my site , every so often it blocks legit people , is there anyway around this ?

Yes. Have it check email addresses only. If you want to screen out more spammers but increase the risk of blocking non-spammers, have it also check IP adresses. Don't have it check names.

[Gav-n-Tn]

not sure if this has been answered and i don't feel like reading the whole 70 posts
i have this mod installed on my site , every so often it blocks legit people , is there anyway around this ? Technically, they are not legite in one of the three areas that it checks or they would not get rejected. Alot of persons use roaming IPs or have had their IPs "piggy backed" by spammers. The only way around that is to allow registrations even though they fail the check OR register them manually through your CP.

[djbaxter]

Technically, they are not legite in one of the three areas that it checks or they would not get rejected. Alot of persons use roaming IPs or have had their IPs "piggy backed" by spammers. The only way around that is to allow registrations even though they fail the check OR register them manually through your CP.

IP addresses may be legimately shared in a number of circumstances:


AOL uses a limited number of proxies for all their users
college and university students typically have shared IP addresses
in countries with limited internet access users will commonly share IP addresses
etc.

That's why barring according to IP address isn't a great idea.

[Gav-n-Tn]

Even so, if those IPs have been reported to SFS as a spammers' IP, it will reject them.

[djbaxter]

Even so, if those IPs have been reported to SFS as a spammers' IP, it will reject them.

Only if you check the option to scan for IP addresses. See my post above.

[Gav-n-Tn]

Only if you check the option to scan for IP addresses. See my post above. True. You can do that. I've found that -in just my own experience- very few legite registrants are turned down though.

[thespi]

This is great but it stops Facebook connect

[Gav-n-Tn]

This is great but it stops Facebook connect I just added the social networks myself. I don't use the one provided. Mine is in each thread at the top. Good info here for those using it though.

[AusPhotography]

I cant' access www.stopforumspam.com ?? Anyone else having problems?

[kylek]

Yup, looks like its down, just banned 10 in the last half hour.

[Chimpie]

Down for me as well, but nothing on their Twitter page.

www.twitter.com/stopforumspam

[AusPhotography]

ping www.stopforumspam.com
Ping request could not find host www.stopforumspam.com. Please check the name and try again.

Looks bad.

[Chimpie]

I'm sure the problem is only temporary. I've sent an email listed in the whois. Hopefully it's up to date.

[Chimpie]

It appears to be back up at this time.

[Gav-n-Tn]

LOL. You can tell when they're down too. Database errors and registrations with those typically stupid spammer usernames.

[Delphiprogrammi]

ping www.stopforumspam.com (http://www.stopforumspam.com)
Ping request could not find host www.stopforumspam.com (http://www.stopforumspam.com). Please check the name and try again.

Looks bad.

that says nothing this can also being caused by a firewall blocking ping requests

[tryckj?vel]

installed... so easy to do btw.

Snagged up 3 spammers registering within 5 minutes of being installed... that alone was worth it... awesome!!1

[relaxiha]

hello
plz upgrade this plugin

[djbaxter]

hello
plz upgrade this plugin

Why? It doesn't need upgrading.

Use the version in this thread for vBulletin 3.x.

For vBulletin 4.x, use the version at https://vborg.vbsupport.ru/showthread.php?t=230921

[SamirDarji]

hello
plz upgrade this pluginAnd if you're having problems with the plugin, you can still look up spammers manually at stopforumspam.com. Great plugin, great idea. I've been able to eliminate 100% of potential spammers.

[jbird310]

This mod is awesome! I was having a problem with spam bots signing up and posting links 10-20 times a day, but after installing this mod, I haven't had ONE spam bot registration in over 3 months. Amazing!!!!

I also combined it with another hack to moderate any post with [URL] in it if the user has less than 5 posts. This double defense works like a charm!!

[chrisvonc]

Thank you for this mod. It seems like the spambots kicked it into high gear last week because I suddenly started seeing 100's of accounts being created. I installed it last night and not even 24 hours later, its blocked over 500 spam accounts. I had anohter 10 that got through but I caught them with my additional required question.

The only thing on my personal wish list for this would be the ability to add a trigger to block these when a certain entry is made in that question field.

Again thank you very much!

[AndyN]

I have installed this mod on our forum due to the recent increase in spammers - and is working great. Question: any links to code to quickly submit spammers that get through to stopforumspam? thanks.

[tarot]

Thank you for your work, this has saved the day :)

[Suiram]

It seems that someone has written a script of some sort that go through every IP in the database, user, posts, I dont know, but some forums have hit the database 80,000 times in a couple of hours.

This has resulted in perm bans from the API for abuse.

Please dont abuse the API. If you require more than 5000 queries a day, ask us first.

ping www.stopforumspam.com
Ping request could not find host www.stopforumspam.com. Please check the name and try again.

Looks bad.

the perfect solution would be to not have to rely on any 3rd party for the database. why not have an option to have forum owners create and use their own database? (since their forum already uses one, it's a no brainer) whilst some would prefer to have a frequently updated "general" database as it is now, you could still import a new list of usernames/ip's/email addresses each week/month if you wanted. or at least have two versions. one as it is, and the other 99% the same except that it would use your own servers/database.

[GlowHost.com]

the perfect solution would be to not have to rely on any 3rd party for the database. why not have an option to have forum owners create and use their own database? (since their forum already uses one, it's a no brainer) whilst some would prefer to have a frequently updated "general" database as it is now, you could still import a new list of usernames/ip's/email addresses each week/month if you wanted. or at least have two versions. one as it is, and the other 99% the same except that it would use your own servers/database.

Someone doesn't understand the idea behind this mod I guess.

So today, you see a new spammer on your forum, then you ban him, and he is in your internal database. Tomorrow, he changes his post, username, and IP, and spams your board again. Then you ban him manually again. And you do this every day. Maybe several times per day.

You probably do not need this mod if you do not understand why it is so useful or how spam works, in general. There is absolutely no question that this type of service must rely on a 3rd party database and an internal DB is going to be 100% useless for almost every site out there.

[Suiram]

Someone doesn't understand the idea behind this mod I guess.

So today, you see a new spammer on your forum, then you ban him, and he is in your internal database. Tomorrow, he changes his post, username, and IP, and spams your board again. Then you ban him manually again. And you do this every day. Maybe several times per day.

You probably do not need this mod if you do not understand why it is so useful or how spam works, in general. There is absolutely no question that this type of service must rely on a 3rd party database and an internal DB is going to be 100% useless for almost every site out there.

i understand perfectly. it's about control. i did say you could have it on a user's forum but still get updates from a centrally maintained database. the point IS, the site goes down or shuts down bit by bit and the mod is useless too. what i'm suggesting is that we not have to rely on a 3rd party. and do you think some jerks don't submit genuine emails and such just for fun? and i did not look at the names in the list but does it mean if some spammer uses John or any other real and popular name it's blacklisted?

whatever man, you rage against the machine. whilst the site now (still) offers free "support", how long will it last? and not just how long, but why rely on it hosting this "valuable" database?

again, you don't understand. it could work just like it does now except the forum also keeps a local database that gets daily/weekly updates.

[Rik Brown]

Fantastic mod! Works great. Thanks. -- Rik

[zaine68]

Thanks for the mod, it seems to work a treat but either I've missed it some where in the install or the mod replies but I cant find the log file. Its not listed under Stats and Logs. I've uploaded everything in the upload folder as instructed to do and made sure they got the right permissions too. Any ideas? Forum is 3.8.2 at present.

Cheers, Chris

[ETDC]

Don't forget folks, the efficiency of this mod and the database relies on you submitting manually to SFS all those spammers who aren't in the database.

[Chris of Arabia]

I've just uploaded the files to our server, but on Step 2 (Import XML into products), I get a message saying "Invalid File Specified".

Is there any reason why I would be expected to see this. We're currently running 3.8.2

[Talking Poker]

I've just uploaded the files to our server, but on Step 2 (Import XML into products), I get a message saying "Invalid File Specified".

Is there any reason why I would be expected to see this. We're currently running 3.8.2

Same problem here (3.8.1), and need this mod badly after a huge rise in spammer registrations recently.

[Talking Poker]

Same problem here (3.8.1), and need this mod badly after a huge rise in spammer registrations recently.

Figured it out... was following the directions too closely, d assumed the XML file referred to was the one I had just uploaded. In fact, it's the one I didn't even notice: product-vbstopforumspam.xml (in the zip, outside of the upload directory).

[Chris of Arabia]

Figured it out... was following the directions too closely, d assumed the XML file referred to was the one I had just uploaded. In fact, it's the one I didn't even notice: product-vbstopforumspam.xml (in the zip, outside of the upload directory).

Hmmm.... I'll go try that then. Possibly a little more clarity needed in the instructions then.

Thanks for the help :D

[TacticalNuke]

I don't know if it has been asked yet, but is there a mod for auto-submitting spammers to the database when we use the delete as spam function?

[Alfa1]

Lee brought something important to my attention regarding SFS:
http://www.vbulletin.com/forum/showthread.php/370200-Creating-a-vbulletin-scraper-and-spammer-trap?p=2104854&viewfull=1#post2104854
SFS is very successful at blocking spam bots from registrations. But that causes another issue. These spammer registration scripts can try to register again in millions of a second. Hitting the server many times and causing high server loads. This is also why SFS logs show so many blocked spammer accounts.

So while SFS resolves the spam problem it relocates the problem to server issues.

Have you thought about analyzing the http fingerprint of blocked spammers and blocking them from the site? Or even adding a temporary IP block for those IPs.

I don't know if it has been asked yet, but is there a mod for auto-submitting spammers to the database when we use the delete as spam function?
Yes, you can do that with spam-o-matic, which includes SFS.

[ilrglen]

I FINALLY got around to installing this on my forum and it WORKS WONDERFULLY! In the past 24 hours it stopped 761 registrations. I love it. These registrations were such a waste of my time that I can now spend on other things. Thanks.

[ilrglen]

Lee brought something important to my attention regarding SFS:
http://www.vbulletin.com/forum/showthread.php/370200-Creating-a-vbulletin-scraper-and-spammer-trap?p=2104854&viewfull=1#post2104854
SFS is very successful at blocking spam bots from registrations. But that causes another issue. These spammer registration scripts can try to register again in millions of a second. Hitting the server many times and causing high server loads. This is also why SFS logs show so many blocked spammer accounts. So while SFS resolves the spam problem it relocates the problem to server issues.

In going through my logs from the past 24 hours I can see that this is exactly what is happening. Rejected spam bots tried again and again to register. But for now I'd much rather have that problem.

[Simon Lloyd]

There is a problem with this mod, take a look at your logs and the registrations it allows through, it's allowing email addresses that are not email addresses, i've had loads of spammers get through and they are supplying email addresses like "xYrkS", "nMWDZj"..........etc and many many more like it, i had turned of email confirmation as it can be a bit hit and miss but i've had to turn it on now :(

[Don Z.]

This version doesnt have
- whitelisting or the ability to submit users to the database but it will within the next week.Was this feature ever added? Is there any way to add to the database directly from the vBulletin Admin CP?

By the way, this mod works great with my vBulletin 3.8.6 PL1 installation. It rejected over 300 spammer registrations in the first 24 hours!

[R34GTT]

Sorry if this has been answered before, but I dont fancy reading the 73 pages of posts to find out!

I installed this a few weeks ago after an influx of spam registrations. All seemed to install fine with no issues.

It then came to my attention that other admin were being emailed saying they can not register. Not only that, when I go in to the logs to see if any have been 'caught' and shows as no results.

Is this an issue on vb 4.x or is it something stupid which ive not done. Im getting loads of ear ache from the mods on the forum now.

Thanks!

[z0diac]

vb 3.8.6

Uploaded files.
Went to import xml and go this:

vBulletin Message

XML Error: Empty document at Line 1

------------

- not showing up in AdminCP -> vBulletin Options -> vbStopForumSpam
- not even showing up in installed products

EDIT: Re-installed again and it imported fine. Not sure what happened first time 'round. Will continue to check it out and see how she goes. Cheers.

[Fuzzy Orange]

Does this work on 4.1.2?

[Stefan118]

Does anyone know how to erase the data?
I installed this mod last night, and allready there are 317 log entries!

Is there a simple way to delete this data from the database?

[gr8dude]

I've installed this on 3.6.0; in case someone is in the same situation as myself - I will share my experience.

The description says it is "reported to work in 3.6.1"; and that the 3.54 XML must only be used for versions prior to 3.6.0. I interpreted that as "great, it works in 3.6.0".

The XML itself, on the other hand, indicates 3.6.2 as a minimal version. I edited that to 3.6.0, attempted to install it again - all went well.

I ran a few tests - the behaviour is as expected.

So I can say that it works in 3.6.0, though I believe I will need a bit more time to make sure everything is flawless.

I hope this 'manual intervention' will not cause the universe to fold upon itself, and that a dinosaur won't come out from under my desk to eat me.

If someone is aware of some issues between this plugin and 3.6.0, please po

NO CARRIER

[Arkham]

NO CARRIER

ATS11=1 ;)

[JamesC70]

Does anyone know how to erase the data?
I installed this mod last night, and allready there are 317 log entries!

Is there a simple way to delete this data from the database?

AdminCP -> Statistics & Logs -> vbStopForumSpam Logs -> Delete

It's directly below the option where you view the SFS logs. :up:

[SamirDarji]

...between this plugin and 3.6.0, please po

NO CARRIERWow, I haven't seen this happen since the old days of BBS chat.

[SamirDarji]

ATS11=1 ;)I forgot what that one was and had to look it up. I used to know all the Hayes commands from memory. I would've done an atdt and check if the call waiting was disabled. That would knock off a modem every time.

[rob4448585]

Added this mod to my 3.8.1 board.

Everything works great, catches and logs spammers trying to sign up.

Only issue I have is when I go into the log and sort it by IP address it throws a database error

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT * FROM vbstopforumspam_log AS logs

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

MySQL Error : Unknown column 'ip' in 'order clause'
Error Number : 1054
Request Date : Saturday, March 12th 2011 @ 12:22:11 AM
Error Date : Saturday, March 12th 2011 @ 12:22:11 AM
Script : http://forums/admincp/vbstopforumspam.php?do=view&pp=15&orderby=ip&page=1
Referrer : http://forums/admincp/vbstopforumspam.php?do=view
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.49-log


Any help with getting this resolved?

[SamirDarji]

I don't have this installed, but it looks like the ip column isn't be found in the log table. Go into phpmyadmin and see what the table structure looks like. Either the clause could be incorrect or the table is missing information (which I highly doubt since it seems you can see the ip addresses).

[thbertram]

Added this mod to my 3.8.1 board.

Everything works great, catches and logs spammers trying to sign up.

Only issue I have is when I go into the log and sort it by IP address it throws a database error

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT * FROM vbstopforumspam_log AS logs

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

MySQL Error : Unknown column 'ip' in 'order clause'
Error Number : 1054
Request Date : Saturday, March 12th 2011 @ 12:22:11 AM
Error Date : Saturday, March 12th 2011 @ 12:22:11 AM
Script : http://forums/admincp/vbstopforumspam.php?do=view&pp=15&orderby=ip&page=1
Referrer : http://forums/admincp/vbstopforumspam.php?do=view
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.49-log


Any help with getting this resolved?

Something is wonky here... the column name in that table is 'ipaddress.' This error is occurring from the Log Viewer?

[rob4448585]

Something is wonky here... the column name in that table is 'ipaddress.' This error is occurring from the Log Viewer?

yes only when i go into the log viewer and sort by ip address

[SamirDarji]

Sounds like something is wrong in the query. Does anyone else have this same problem?

[Phaedrus]

*edit: Sorry, posted in wrong thread.

[steven s]

Where has the instructions to submit spammers to the database gone?
The link in the first post no longer works.

[Simon Lloyd]

http://www.stopforumspam.com/ works fine for me just like in the first post :)

[steven s]

http://www.stopforumspam.com/ works fine for me just like in the first post :)
It works fine for me too.
I am looking for the additional mod to submit spammers to the [stopforumspam] database.

For code to submit spammers to the database, check this post for code changes
https://vborg.vbsupport.ru/showpost.php?p=1646247&postcount=288 is a dead link.

[newguy]

Just installed and two were blocked with in 10 minuets, although I only have the "test IP address against the ban list", since so many legit people use numbers in there user name on my site.

I tested registering with a few numbers in the user name and I used a legit email address, I was blocked due to the user name, that was reason in the log file anyway.

[rob4448585]

Just installed and two were blocked with in 10 minuets, although I only have the "test IP address against the ban list", since so many legit people use numbers in there user name on my site.

I tested registering with a few numbers in the user name and I used a legit email address, I was blocked due to the user name, that was reason in the log file anyway.

I have had mine installed for 16 days and it has blocked 2,019 entries.

SINGLE best mod for Vbulletin

[ilrglen]

I have had mine installed for 16 days and it has blocked 2,019 entries.

SINGLE best mod for Vbulletin

It has stopped some 43,000 on mine since the middle of January. I have only had 3 legit users blocked who I had to manually set up myself. This mod is awesome!

[edie]

How do you rebuild your postbit?
- Edith Williams (newbee)

[Gav-n-Tn]

How do you rebuild your postbit?
- Edith Williams (newbee) Not sure why you're asking in this thread but you do it in the Maintenance section of your AdminCP.

[edie]

I posted it here because it says the following above:
"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"

So now, I'm nervous because I installed the software pluggin, but I have no idea about the "postbit" part. Why was this not deleted for us? And why do we need to delete this file, ourselves after we install it?

- uneasy.
- Edith Williams.

(thank you for your patience, I'm VERY new at all this)

[Gav-n-Tn]

I posted it here because it says the following above:
"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"

So now, I'm nervous because I installed the software pluggin, but I have no idea about the "postbit" part. Why was this not deleted for us? And why do we need to delete this file, ourselves after we install it?

- uneasy.
- Edith Williams.

(thank you for your patience, I'm VERY new at all this) Ok. Makes sense. Don't sweat it too much. We've all been newbs and all need help from time to time. Do as instructed and rebuild your postbit in the maintenance area of the AdminCP (bottom left in the list) IF YOU ACTUALLY NEED TO. You may not have had any affect on your postbit.

[skooby]

Works like a charm. I owe you a beer or 12.

[edie]

I have not been able to find out how or where to rebuild a postbit.
Can you direct me?

Thank you sssoooo much!
- Edith

[edie]

I installed, vbStopForumSpam, and then uninstalled it when I found out it had a Facebook incompatibility issued. I deleted the xml and function files from the xml and includes directories.

I installed Glowhost as the recommended substitute / upgrade.

Now my Facebook does not work, and my Blog section looks like this:

Fatal error: is_member_of_blog(): $bloginfo['permissions'] not defined. in [path]/includes/blog_functions_shared.php on line 275
#0 vb_error_handler(256, is_member_of_blog(): $bloginfo['permissions'] not defined., /home/content/s/f/r/sfrkedie/html/dancerhangout/includes/blog_functions_shared.php, 275, Array ([userinfo] => Array ([userid] => 1,[temp] => ,[field1] => www.salsafreak.com/bio,[field2] => USA,[field3] => Salsa,[field4] => Instructor,[field5] => ,[subfolders] => ,[pmfolders] => ,[buddylist] => 4,[ignorelist] => ,[signature] => ,[searchprefs] => a:1:{s:20:"cmsadmin_showperpage";i:200;},[rank] => ,[usergroupid] => 6,[membergroupids] => ,[displaygroupid] => 6,[username] => edie,[password] => 5a1efb36e35373667817d9071ad65127,[passworddate] => 1303628400,[email] => wowedie@yahoo.com,[styleid] => 1,[parentemail] => ,[homepage] => http://www.SalsaFreak.com,[icq] => ,[aim] => ,[yahoo] => ,[msn] => ,[sk

etc. (location: http://www.dancerhangout.com/blog.php)

Can you tell me what I may have done wrong?

I feel like my entire board is messed up now.
thx.
- Edith Williams

[thincom2000]

I have not been able to find out how or where to rebuild a postbit.
Can you direct me?

Thank you sssoooo much!
- Edith

He means Rebuild Bitfields. Rebuilding post bits does something entirely different that is not related to permissions.

After adding / deleting a permissions file, you need to rebuild bitfields. Or you'll get a database error whenever you try to update your usergroups.

In vBulletin 3, go to /admincp/index.php?do=buildbitfields
In vBulletin 4, go to Rebuild > Rebuild Bitfields

[vidmarc]

I just had to disable this mod as new members were unable to register - will there be a version that works with 3.8.5?

[thbertram]

I just had to disable this mod as new members were unable to register - will there be a version that works with 3.8.5?

It worked fine for me under 3.8.5. I'm running 3.8.7 vB now without any issues as well.

[Alfa1]

We regularly get complaints from legitimate users that are blocked by SFS. We tell them that their IP was contaminated and they need to request a new IP from their ISP. I very much doubt that people actually do that.

Please add a way for legitimate users to get their IP off the blacklist. Or for admins to do this for them.

[edie]

What is it that I have done then... I am running VB Publisher's suite - latest, I believe (vBulletin 4.1.3).

I can't even log in under a fake username. I have no idea why this thing is so air-tight right now. I got rid of the Re-Captcha, and using the "standard" one, but that still is not allowing anyone in. Not even me. I love it that all the Spam is gone now... but so are all my USERS!!

Any ideas?

- Edith Williams wowedie@yahoo.com

[Simon Lloyd]

Edith, wrong thread, if you have installed this one you will be in trouble as it is not for vB4, you want this one https://vborg.vbsupport.ru/showthread.php?threadid=230921

[Panzer Max]

Have anyone tried to log into their forum using a known spammer name, to check the end user side of this? And if I do, will my IP be banned?

[Gav-n-Tn]

And if I do, will my IP be banned? 1. It definitely works -as testified by so many posts here- as long as they have been submitted to the SFS database. 2. Only you can ban your own IP. It does not ban them.

[jscowen]

It works fine for me too.
I am looking for the additional mod to submit spammers to the [stopforumspam] database.

For code to submit spammers to the database, check this post for code changes
https://vborg.vbsupport.ru/showpost.php?p=1646247&postcount=288 is a dead link.

Not sure if you found it - I manage to locate it at post #1015 in this thread (ie. https://vborg.vbsupport.ru/showpost.php?p=2093392&postcount=1015)

[TROLL]

Is there a way to allow a certain user to register even if this mod is blocking it? The only way I can think is to deactivate it temporarily but that will also let others pass through.

I have someone from 138.162.0.45 trying to register which is a US Military base. He contacted me saying he's being blocked and I'd rather let him through to see if he's real then just saying "F off" to him...

[steven s]

Is there a way to allow a certain user to register even if this mod is blocking it? The only way I can think is to deactivate it temporarily but that will also let others pass through.

I have someone from 138.162.0.45 trying to register which is a US Military base. He contacted me saying he's being blocked and I'd rather let him through to see if he's real then just saying "F off" to him...
This is what I do.
Look in the vbStopForumSpam log for his username or ip address.
Create a new membership for him. Use his username and email. Create a password for him.
Email him that information. Have him log in and change the password.

Much simpler than disabling the mod and makes the member happier.

[Chimpie]

This is what I do.
Look in the vbStopForumSpam log for his username or ip address.
Create a new membership for him. Use his username and email. Create a password for him.
Email him that information. Have him log in and change the password.

Much simpler than disabling the mod and makes the member happier.

I concur. This is what we do.

[TROLL]

Thanks, great idea...

[Gav-n-Tn]

This is what I do.
Look in the vbStopForumSpam log for his username or ip address.
Create a new membership for him. Use his username and email. Create a password for him.
Email him that information. Have him log in and change the password.

Much simpler than disabling the mod and makes the member happier. That's what I was going to suggest also.

[chrisxp]

Hi there,

since updating to 4.1.4, the "Add Spammer" box doesnt show on editing users..

could this be updated, or tell me how to?

thanks,

chrisxp

[bigmuz7]

Hi Ive noticed a few people being 'allowed registration' but they dont actually get registered, any idea as to whats happening (excellent mod btw)

cheers

[Fenriz]

How to disable vbStopForumSpam Logs? It would be great to have such option in admincp to switch the logs on and off.

[sarasotarepub]

Hi everyone,

I'm trying to install this mod but am running into an error then I run the Import Product in vbulletin.

I get "Importing Product...please wait" and then "Invalid File Specified"

I have all the install files in the right dirs on the server. Any ideas??? Thanks.

Apache version
2.0.63

PHP version
5.2.5

MySQL version
5.0.92-community

vbull Version 3.7.0

NEVERMIND, I got it to run!!!

SR

[Hornstar]

I had to uninstall this. I was getting many emails of people saying they could not register as this was saying they were a spammer and it was making them mad and my site lose members.

[ETDC]

Hi Ive noticed a few people being 'allowed registration' but they dont actually get registered, any idea as to whats happening (excellent mod btw)

cheers
This, I'd like to know, too.

[JesterP]

I had to uninstall this. I was getting many emails of people saying they could not register as this was saying they were a spammer and it was making them mad and my site lose members.

When they use your contact us form, reply with this:

Hello there,

If the system is telling you that you are a spammer, please try again with a different username. There is a chance that your name choice is blacklisted in a third-party database we subscribe to.

If you'd like, you could go to http://www.stopforumspam.com/search.php and search for your information to see why you might have been restricted.

Thank you


9 times out of ten, they come back and register.

[ETDC]

Don't tell them about SFS - they'll only join up there and b**ch and whine about it. Just tell them to get in touch with you in order for you to remove a 'false positive'. 99.99999999999999999999999999999999999999999999999 999999999999 wont.

...because they're spammers.

[djbaxter]

When they use your contact us form, reply with this:

Hello there,

If the system is telling you that you are a spammer, please try again with a different username. There is a chance that your name choice is blacklisted in a third-party database we subscribe to.

If you'd like, you could go to http://www.stopforumspam.com/search.php and search for your information to see why you might have been restricted.

Thank you


9 times out of ten, they come back and register.

A better solution is not to screen member names. Way too many false positives. Just check email and IP address.

[Gav-n-Tn]

Don't tell them about SFS - they'll only join up there and b**ch and whine about it. Just tell them to get in touch with you in order for you to remove a 'false positive'. 99.99999999999999999999999999999999999999999999999 999999999999 wont.

...because they're spammers. Exactly.

[ForumUserStarte]

I got the following error when I try to install
=====================
Plugin & Products System
Importing Product, Please Wait...

[:::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::]

Database error
The The Speak Logic Forum database has encountered a problem.

--------------------------------------------------------------------------------

Please try the following:
•Load the page again by clicking the Refresh button in your web browser.
•Open the www.speaklogic.org:88 home page, then try to open another page.
•Click the Back button to try another link.

The www.speaklogic.org:88 forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 4.1.3:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vb_vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) 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 4
Error Number : 1064
Request Date : Tuesday, November 15th 2011 @ 01:10:09 AM
Error Date : Tuesday, November 15th 2011 @ 01:10:09 AM
Script : http://www.speaklogic.org:88/forum/admincp/plugin.php?do=productimport
Referrer : http://www.speaklogic.org:88/forum/admincp/plugin.php?do=productadd
IP Address : 144.90.1.18
Username : admin
Classname : vB_Database
MySQL Version : 5.5.8

as well as

Database error in vBulletin 4.1.3:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vb_vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) 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 4
Error Number : 1064
Request Date : Tuesday, November 15th 2011 @ 01:10:09 AM
Error Date : Tuesday, November 15th 2011 @ 01:10:09 AM
Script : http://www.speaklogic.org:88/forum/admincp/plugin.php?do=productimport
Referrer : http://www.speaklogic.org:88/forum/admincp/plugin.php?do=productadd
IP Address : 144.90.1.18
Username : admin
Classname : vB_Database
MySQL Version : 5.5.8

========================
I am using xamp; hosting in windows

[ForumUserStarte]

I follow the direction by copying the files to the right directory

[Mark_Zuckerberg]

i think this mod should be updated again for newer versions

[djbaxter]

i think this mod should be updated again for newer versions

It's still working fine for me on 4.1.7

[Simon Lloyd]

I believe it's something to do with MySql 5.5 and deprocations, this:
The only two you need worry about are ;

admincp\repair.php(157): $vbulletin->db->query_write("ALTER TABLE `$value` TYPE=MyISAM");
includes\class_dbalter.php(441): TYPE = " . $this->db->escape_string(strtoupper($type));

Change TYPE to ENGINE. Is from this thread https://www.vbulletin.com/forum/showthread.php/390237-MySQL5-5-does-not-support-current-DBalter-class

[TitanJeff]

Outstanding! It caught four spam registrations within the first 10 minutes of being installed.

I might nominate it for "Mod of the Month" again. ;)

[enci]

i've had this installed for years and it's done a great job. i recently checked my site on sucuri and noticed it was detecting malware in the forum. after a lot of testing, it seems disabling vbstopforumspam takes care of the problem. when i then enable vbstopforumspam again, my site is still free of malware. so that makes me think vbstopforumspam is the route malware is being injected into my site.

has anyone had this experience? what can i do to solve the problem while still using vbstopforumspam? thanks.

[DAMINK]

edited......

Posted in wrong thread.

[Simon Lloyd]

No ip or email would indicate a bot so the software is working :)

[rpgamersnet]

Works perfectly, flawless install. Thanks for a great mod. Using 3.8.x

[stobby256]

Hi All,

This looked promising until any new registrants get this...

Warning: require_once(includes/functions_vbsfs.php) [function.require-once]: failed to open stream: No such file or directory in [path]/register.php(338) : eval()'d code on line 3

Fatal error: require_once() [function.require]: Failed opening required 'includes/functions_vbsfs.php' (include_path='.:/usr/lib/php5') in /homepages/2/d398979007/htdocs/register.php(338) : eval()'d code on line 3

I disabled it.... and now it seems fine... but no spam checking!

[kylek]

Check that you uploaded all the files, especially functions_vbsfs.php which should be in the includes folder.

[stobby256]

I feel somewhat embarrased :eek:

All sorted and running on 4.1.10!

Thank you!

[vidmarc]

A legit user says he is unable to sign up as he is being notified he is a potential spammer - how do I unblock him? I just searched for his IP address in the database but couldn't find it.

[thbertram]

The block could be on the username he tried to register with. When I get that situation, I tell them to use a more unique username.

[DAMINK]

A legit user says he is unable to sign up as he is being notified he is a potential spammer - how do I unblock him? I just searched for his IP address in the database but couldn't find it.

Had the same problem while i was creating a test account for myself.
Had to uninstall until i can fix this problem or find a result here.

[kylek]

Disable username check.

[vidmarc]

He tried using a different username and he's still unable to register. Makes me wonder how many other users are being denied and not reporting it to me.

[watchxchange]

My forum suddenly stop new member registration by VBStopForumSpam. Registration resume when I temporarily turned off the Plugin. If I turn on, there are lots of spam posting on the forum.

It affects all registrations. I have tried turning on and off several times to test the registration and therefore confirmed this is the case.

What can I do? Why it happen suddenly?

Forum version: vBulletin 4.1.9 Admin Control Panel

Appreciate your advise.

[edie]

I am having the same problem. No one can register. But when I turn off Glowhost, they can register now.

I had TONS OF MALWARE on my site.. it was all over my Forum, and Google displayed that my site was "not safe". Freaks me out that you guys posted here that VBStopForumSpam is the culprit.

Anything being done about this guys?
- Super Concerned. :(

[ozmazdaclub]

how can i report a spammer directly from the product instead of manually having to go and enter their details in.

[DAMINK]

The coder has not been on since last year so i suspect this mod will be getting uninstalled on many forums.
Sucks really as its a damn good mod.

[hotshot]

Does it still work?

[rob4448585]

Does it still work?

yes works great

[cronjob78]

A lot of genuine users are getting rejected lately so I am considering disabling this plugin, even though it has served the forum well for a few years.

Our forum is a local one so ideally I'd like to block the usual suspect countries.

[pmkb]

AdminCP -> Statistics & Logs -> vbStopForumSpam Logs -> Delete

It's directly below the option where you view the SFS logs. :up:

Excellent. Anyone know if it is possible to have vB automate the log pruning? I've had this mod running for a few years now and just checked the log today to find over 100K entries.

[b3zra1y]

So.... the upshot of recent posts on this plugin suggest that it can no longer be relied on as a stable plugin.

Which begs the question... what are vBulltin customers supposed to do to keep out the 'bad guys' ???

[rob4448585]

So.... the upshot of recent posts on this plugin suggest that it can no longer be relied on as a stable plugin.

Which begs the question... what are vBulltin customers supposed to do to keep out the 'bad guys' ???


Works fine for me. Haven't had an issue for years.

[Barteh]

No issues here either. Pulled the stats, and of our last 1000 reg attempts, 94.5% are obvious spammers and get rejected by vBSFS right away. Remaining regs are predominantly repeat attempts by the same two spambots tripping over my other measures. The result is that of the succesful regs that arrive in my new user moderation queue, only very few are spammers.

*EDIT*

Heh, one attempt even has "[c:\one.112233445566@gmail.com.txt,5,l]" as the email address :rolleyes:

[desmomax]

very nice mod! thanks..

i saw a pic of log file in your post.. where can i found the log file in my admincp?

[rob4448585]

very nice mod! thanks..

i saw a pic of log file in your post.. where can i found the log file in my admincp?

https://www.sugarsync.com/piv/D9679127_69674693_6969748

[desmomax]

I cant see this voice in my log menu

[desmomax]

I followed the install instruction and the mod look like working fine but i see no log menu option.
thanks for your reply

[rob4448585]

I followed the install instruction and the mod look like working fine but i see no log menu option.
thanks for your reply

You didn't install it correctly.

[desmomax]

yes, solved. thanx

[st.charles]

I'm trying to reinstall the vbstopforumspam mod after an upgrade from vbulletin 3.86 to 3.87.

After the upgrade, the database was throwing errors and I repaired it by removing some plugins.
vbstopforum spam was one of the plugins removed.
I reinstalled the other plugins and they're working fine.

When I go to import the new plugin after re-uploading the files correctly I get this MySQL error in the admincp backend:

Database error in vBulletin 3.8.7:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) 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 4
Error Number : 1064
Request Date : Thursday, September 20th 2012 @ 12:35:57 PM
Error Date : Thursday, September 20th 2012 @ 12:35:57 PM
Script : http://__mysite__/admincp/plugin.php?do=productimport
Referrer : http://__mysite__/admincp/plugin.php?do=productadd
IP Address : __my ip
Username : __my username
Classname : vB_Database
MySQL Version : 5.5.25-cll

For obvious reasons I replaced my site, username and ip above with "__my ip" etc.
Is it just not confirmed working with vb3.8.7?
Or am I missing something obvious in the plugin xml I can fix.

Thanks in advance to the thread contributors for ideas and help. :)

[desmomax]

After a while testing this mod i can say it works great. It happens that few real users are rejected by the mod. What shall i do in this case? is it possibile to bypass certain ip address?
thanx

[mattballew]

Im getting this error when i try to install.. http://puu.sh/1nTWu Anyone else have this issue?

[SRobbins1977]

hello, I am getting this error:

Database error in vBulletin 4.2.0:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) 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 4
Error Number : 1064
Request Date : Saturday, November 17th 2012 @ 11:55:32 AM
Error Date : Saturday, November 17th 2012 @ 11:55:32 AM
Script : http://mydomain.com/admincp/plugin.php?do=productimport
Referrer : http://mydomain.com/admincp/plugin.php?do=productadd
IP Address : 74.101.113.163
Username : Administrator
Classname : vB_Database
MySQL Version : 5.5.23-55

Please help!

[zylstra]

Replace all TYPE=MyISAM with ENGINE=MyISAM in the xml file.

[ApexSpeed]

I am getting a similar error, but not exact:


Database error in vBulletin 3.8.0:

Invalid SQL:
SELECT DATEDIFF(NOW(), '2012-12-20 02:18:04') AS DAYS;;

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 '(NOW(), '2012-12-20 02:18:04') AS DAYS' at line 1
Error Number : 1064
Request Date : Wednesday, December 19th 2012 @ 09:21:31 PM
Error Date : Wednesday, December 19th 2012 @ 09:21:32 PM
Script : http://www.apexspeed.com/forums/register.php?do=addmember
Referrer : http://www.apexspeed.com/forums/register.php?
IP Address : 195.190.13.102
Username : rchuano130
Classname : vB_Database
MySQL Version :



Everything is working VERY well other than the db error e-mail for every spam registration, which is at anywhere between 300-400 a day now.

Same or similar fix?

[ApexSpeed]

Ahhh, I just realized my server is running MySQL V 4.0.27. Guess this isn't going to work after all... :(

[ApexSpeed]

A nightmare to get the MySQL updated in the past 24 hours that led to 2,451 database errors in my Inbox at lunchtime today, but we finally got it updated to 5.0.+ MySQL version to run this plug-in. And I have to say, it's been 100% effective already blocking 44 spam user account registrations and allowing 3 legitimate users to register.


THANK YOU FOR THIS PLUG-IN! It's fantastic so far and relatively easy to install. Nice work! :up: :up:

[ApexSpeed]

Everything is updated on the server, we're running vB 3.8.0 and while the plug-in is working, we are still getting about 20-30 very strange database errors per day. When the plug-in is shut off, it all stops, so it's something being driven by vbStopForumSpam.

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Error Number : 1267
Request Date : Thursday, December 27th 2012 @ 06:29:06 AM
Error Date : Thursday, December 27th 2012 @ 06:29:07 AM
Script : http://www.apexspeed.com/forums/register.php?do=addmember
Referrer : http://www.apexspeed.com/forums/register.php?
IP Address : 176.53.43.226
Username : ****
Classname : vB_Database
MySQL Version : 5.0.51a-log

They all have the "Swedish" and "Latin" notes in the errors, and we can't figure out what is causing them. I'm going to attempt to find 3.8.7 forum software when I get a chance today, but their current system for older software updates leaves me itch, so we'll see what I can come up with. It might help the issues with the database errors.

If anyone else notices something obvious, I'd appreciate any input.



doug

[jimsflies]

At some point in the past couple days (since 12/28) guests have not been able to register because they are apparently being tagged as a spammer. I confirmed this by trying to register myself and also was denied.

Has anyone else had this problem in the past couple days?

I checked my info against stopforumspam.com database and it is not in their database. So registration should be allowed.

[kapoor22]

Could anyone please let me know how to access vbStopForumSpam Log Viewer page shown in this image (below)?

https://vborg.vbsupport.ru/attachment.php?attachmentid=78902&d=1208476300

Thank you!

[ApexSpeed]

It the Admin Control Panel, go to Statistics & Logs --> vbStopForumSpam Logs

Still getting loads of vB database errors mentioning Swedish & Latin language issues. Anyone?

[kapoor22]

It the Admin Control Panel, go to Statistics & Logs --> vbStopForumSpam Logs




Still getting loads of vB database errors mentioning Swedish & Latin language issues. Anyone?

Thanks ApexSpeed! This is helpful.

Wish I could have assist with the vb DB errors issue.

[Lpspider]

How are you guys dealing with members contacting you saying they're not spammers but can't sign in? Obviously they were banned elsewhere, but I'm afraid I'm missing out on many members because of this.

[abhimation]

Ive been using this wonderfully with one of my VB 3.8.2 forum. But facing lot of spammers still finding ther way in my other VB 4.1.10. Am I missing out something? Please help..

http://img717.imageshack.us/img717/1801/vbstop.jpg

[steven s]

Ive been using this wonderfully with one of my VB 3.8.2 forum. But facing lot of spammers still finding ther way in my other VB 4.1.10. Am I missing out something? Please help..
I noticed the same thing beginning last week.
I installed spam-o-matic thinking something was wrong.
Same results with that.

It just seems that these new registrants are not listed in the sfs database yet.

[rharbison]

If you're running VB4, what you're missing is Spam-o-Matic. Works great, adds an excellent ban and report button to the forum, and is currently supported.

I definitely would (and do) choose it over this one if you're running VB4.

[fworth]

i'M getting this error:

CREATE TABLE IF NOT EXISTS `vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) TYPE=MyISAM;;

Nevermind i got it working.

[jdrakopo]

Does this plugin work with VB version 4.1.9 ?

[gabrielt]

Hi guys,

I created a plugin for this product in order to manually report a user from inside the admin control panel, while seeing the user's full profile/editing screen.

I needed that in order to manually report offenders that were blocked by the Multiple Account Registration Prevention (https://vborg.vbsupport.ru/showthread.php?p=1085503) product and automatically moved to the "Users Awaiting Moderation" group.

I hope this little add-on is useful for other user who need a reporting tool inside the admin CP.

PS: You need to import this file as a PLUGIN and not as a product.

Thanks.

[ApexSpeed]

Nice addition... instead of just deleting the users that make it through the filters, we can add them. Excellent.

Now, all we need is a way to whitelist those users who are trying to register and can't because their preferred username is on a blacklist somewhere keeping them out.

[hotshot]

This blocks too many legitimate users. Unfortunate. The User Agent block works the best by blocking IE6 and below and well as other bot spiders.

[ETDC]

This blocks too many legitimate users.
Only if you have 'User Names' enabled. Otherwise, it denies registrations from people on the SFS spammers database - what is there not to like?

[hotshot]

Only if you have 'User Names' enabled. Otherwise, it denies registrations from people on the SFS spammers database - what is there not to like?

Ahh, didn't know that. I didn't have any options for my plugin under VBoptions, but I removed and reinstalled and the options are there now. Thanks!

[hotshot]

i'M getting this error:

CREATE TABLE IF NOT EXISTS `vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) TYPE=MyISAM;;


Nevermind i got it working.


Resolution is to edit the XML file and find and replace on TYPE=MyISAM to ENGINE=MyISAM

[Phongvanlau]

Hello,

Igot this message below and how do I fix it? Thanks

Fatal error: Could not open [path]/includes/xml/bitfield_vbulletin.xml in [path]/includes/class_bitfield_builder.php on line 130
#0 vb_error_handler

[ForceHSS]

Hello,

Igot this message below and how do I fix it? Thanks

Fatal error: Could not open [path]/includes/xml/bitfield_vbulletin.xml in [path]/includes/class_bitfield_builder.php on line 130
#0 vb_error_handler
opendir failed or bitfield_vbulletin.xml is missing or it has a parse error

[Phongvanlau]

Hello,

Here is the whole message, please help me to fix it. Thanks

Fatal error: Could not open [path]/includes/xml/bitfield_vbulletin.xml in [path]/includes/class_bitfield_builder.php on line 130
#0 vb_error_handler(256, Could not open /var/www/vhosts/mysite.com/httpdocs/includes/xml/bitfield_vbulletin.xml, /var/www/vhosts/mysite.com/httpdocs/includes/class_bitfield_builder.php, 130, Array ([layout] => ,[include_disabled] => ,[obj] => vB_Bitfield_Builder Object ([data] => Array (),[datastore] => Array (),[errors] => Array (),[datastore_total] => Array ()),[temp] => Array (),[handle] => Resource id #18,[file] => ,[matches] => Array ())) #1 trigger_error(Could not open /var/www/vhosts/mysite.com/httpdocs/includes/xml/bitfield_vbulletin.xml, 256) called at [/var/www/vhosts/mysite.com/httpdocs/includes/class_bitfield_builder.php:130]

[Phongvanlau]

opendir failed or bitfield_vbulletin.xml is missing or it has a parse error

I was using this plugin, but it was the old version, I uninstalled it and try this newer version. When I tried to import the product xml, I got this parsing error, my vBulletin 3.8.3. What does it cause it and how do I fix it?

Thanks

[ForceHSS]

I was using this plugin, but it was the old version, I uninstalled it and try this newer version. When I tried to import the product xml, I got this parsing error, my vBulletin 3.8.3. What does it cause it and how do I fix it?

Thanks

first replace all default vb files with unmodded ones then remove this mod and all the files to do with the mod from the ftp then check to see if error is still there

[ESADCG]

Have upgraded to MySQL 5.5.30 and this will not install any longer. Any chance of getting it updated?


Database error in vBulletin 3.8.7:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) 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 4
Error Number : 1064

[puncol]

Hi! Is it working on vB 4.2.1 ?

[djbaxter]

Hi! Is it working on vB 4.2.1 ?

Yes it is.

[puncol]

Thank you.

Can you help me with that mod, please?

What I have done so far:
- Uploaded the contents of the upload folder into the root of my forum (I am sure I have done it 100% right)
- Imported the xml into products. I have uploaded that file product-vbstopforumspam.xml (without overwriting).
- Edit the options. (AdminCP -> vBulletin Options -> vbStopForumSpam) - I do not have this options :(

So.... should I rebuild/refresh something?

[djbaxter]

- Edit the options. (AdminCP -> vBulletin Options -> vbStopForumSpam) - I do not have this options :(

Double check. If it's really not there, try reimporting the product file.

[joe1989]

I have obtained an API from SFS and entered it into my VB options in the appropriate field, but I cannot figure out what to do next to start submitting my spammers to the DB.

Thanks! Keep up the great work on a fantastic mod!

[djbaxter]

See https://vborg.vbsupport.ru/showpost.php?p=2425881&postcount=453

[Simon Lloyd]

Have upgraded to MySQL 5.5.30 and this will not install any longer. Any chance of getting it updated?


Database error in vBulletin 3.8.7:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vbstopforumspam` (
APIKey VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( APIKey )
) 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 4
Error Number : 1064In the xml and or php files that come with this mod change TYPE=MyISAM for ENGINE=MyISAM

[djbaxter]

4.2.1 here. Doesn't seem to work.

This user should have been blocked on username and email

https://vborg.vbsupport.ru/external/2013/09/68.png

I'm guess "remote error" means it couldn't hook into the API (which I've set it to allow registration in that case), but API services were up at the time of this request.

No it is working. It did exactly what it should do when the SFS database isn't available - allow registration.

The SFS database is having intermittent problems with a server, so there has been more of this than normal the past week or so.

The fact that you could access the database to submit a spam report is entirely consistent with the problems they are having with that server.

See Stop Forum Spam announcement (http://www.stopforumspam.com/forum/viewtopic.php?id=5521) .

[metalguy639]

New issues with this mod. Out of nowhere my client is now getting this error when a new person tries to register on their site.

Registration denied. We check new registrations against a database of known forum spammers. At this time, we are unable to contact this database to verify your registration. We are sorry for the inconvenience but please do try again later.

For now I have disabled the hack and registrations work again, but that is not optimal as we need to keep spammers out. Please help. Thanks.

[djbaxter]

New issues with this mod. Out of nowhere my client is now getting this error when a new person tries to register on their site.



For now I have disabled the hack and registrations work again, but that is not optimal as we need to keep spammers out. Please help. Thanks.

1. The SFS server is having intermittent issues. See Stop Forum Spam announcement (http://www.stopforumspam.com/forum/viewtopic.php?id=5521).

2. AdminCP >> Settings >> Options >> vBStopForumSpam

Query Connection Errors
What should happen if the remote connection times out when querying the new registration?

Set this to Allow Registration. You have yours set to Block Registration.

[metalguy639]

1. The SFS server is having intermittent issues. See Stop Forum Spam announcement (http://www.stopforumspam.com/forum/viewtopic.php?id=5521).

2. AdminCP >> Settings >> Options >> vBStopForumSpam

Query Connection Errors
What should happen if the remote connection times out when querying the new registration?

Set this to Allow Registration. You have yours set to Block Registration.

Thanks that worked.

[theforumist]

This plugin = awesome. I wish I had found it long ago on past forums that I've owned/operated. Since I implemented it about a week ago, 109 registrations have occur ed and 100 of which have been blocked due to matching a database entry.

[zzSQL]

This is the coolest plugin there is!

Of the last 40 forum spammer attempted registration, 38 were prevented.

It compares new registrants against stopForumSpam.com's databases of IP, username and email addresses of known spammers and prevents their registraiotn.
VBulletin should have this feature included as the default install.
Nice work!

[Joe Siegler]

You know, in all my time running this mod, I never thought to ask this.

How do you override for a single user who you know isn't a spammer, but is still being flagged by one of the triggers? I'm not aware of a way you can whitelist specific terms, but ONLY for your local forum install. I wouldn't want to corrupt the main db with that, but for specific instances I'd like to override just for my local install.

How do you do that, short of creating the user yourself?

[jagtpf]

Was installed on our Forum running 3.8.7 - Since upgrade to 4.2.3 we've had a flood of spammers so I've enabled this to see if there's any change. No errors thrown up, so hopefully it's working 'nicely'.

[hotshot]

Was installed on our Forum running 3.8.7 - Since upgrade to 4.2.3 we've had a flood of spammers so I've enabled this to see if there's any change. No errors thrown up, so hopefully it's working 'nicely'.

Bad move going to 4.x you should have googled "Vbulletin Reviews" first. We are creatures of habit but sometimes enough is enough.

[jagtpf]

Bad move going to 4.x you should have googled "Vbulletin Reviews" first. We are creatures of habit but sometimes enough is enough.

We did extensive reading etc of all the reviews, bad, indifferent and the odd good one!

Not being creatures of habit we, eventually, decided to stay where are - but upgrade so our Host could install PHP5.5/5.6.
So far, apart from some good plugins that don't translate across, we and our members are happy.

Funny, this, you coming into vB.org and criticising vBulletin software....but thanks for your thoughts.

[jagtpf]

Was installed on our Forum running 3.8.7 - Since upgrade to 4.2.3 we've had a flood of spammers so I've enabled this to see if there's any change. No errors thrown up, so hopefully it's working 'nicely'.

Report :

Has 'sorted' our spammers - so it works adequately in vB 4.2.3...

[hotshot]

Funny, this, you coming into vB.org and criticising vBulletin software....but thanks for your thoughts.

I previously used Vbulletin and was subscribed to this topic. I unsubscribed from all topics now.

[oldengine]

Is this one a copy of that one or is that one a copy of this one?

https://vborg.vbsupport.ru/showthread.php?t=248470

[Makc666]

Is this one a copy of that one or is that one a copy of this one?

https://vborg.vbsupport.ru/showthread.php?t=248470

If you read the most last sentence of that thread #248470 you will find:
Original concept credits go to the authors of vBStopForumSpam and MonkeyStop