vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Administrative and Maintenance Tools - vbStopForumSpam - known spammer lookup for new registrations (https://vborg.vbsupport.ru/showthread.php?t=176481)

Chris of Arabia 01-14-2011 12:32 PM

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 01-15-2011 04:43 PM

Quote:

Originally Posted by Chris of Arabia (Post 2148909)
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 01-15-2011 05:16 PM

Quote:

Originally Posted by Talking Poker (Post 2149575)
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 01-15-2011 06:08 PM

Quote:

Originally Posted by Talking Poker (Post 2149591)
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 01-16-2011 12:27 PM

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 01-20-2011 08:55 PM

Lee brought something important to my attention regarding SFS:
http://www.vbulletin.com/forum/showt...=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.

Quote:

Originally Posted by TacticalNuke (Post 2149980)
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 01-24-2011 11:29 AM

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 01-24-2011 11:38 AM

Quote:

Originally Posted by Alfa1 (Post 2152125)
Lee brought something important to my attention regarding SFS:
http://www.vbulletin.com/forum/showt...=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 01-24-2011 06:10 PM

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. 01-27-2011 02:28 AM

Quote:

Originally Posted by StopForumSpam
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 01-29-2011 06:27 PM

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 02-01-2011 04:23 AM

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 02-16-2011 10:41 AM

Does this work on 4.1.2?

Stefan118 02-21-2011 09:38 PM

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 02-22-2011 01:06 PM

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 02-22-2011 01:23 PM

Quote:

Originally Posted by gr8dude (Post 2165400)
NO CARRIER

ATS11=1 ;)

JamesC70 02-22-2011 02:11 PM

Quote:

Originally Posted by Stefan118 (Post 2165162)
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 02-22-2011 02:52 PM

Quote:

Originally Posted by gr8dude (Post 2165400)
...between this plugin and 3.6.0, please po

NO CARRIER

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

SamirDarji 02-22-2011 02:56 PM

Quote:

Originally Posted by Arkham (Post 2165412)
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 03-12-2011 06:22 AM

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

Code:

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 03-12-2011 07:10 AM

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 03-14-2011 01:20 PM

Quote:

Originally Posted by rob4448585 (Post 2172480)
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

Code:

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 03-14-2011 05:19 PM

Quote:

Originally Posted by thbertram (Post 2173215)
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 03-15-2011 01:23 AM

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

Phaedrus 03-18-2011 10:55 PM

*edit: Sorry, posted in wrong thread.

steven s 03-27-2011 04:44 PM

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

Simon Lloyd 03-27-2011 08:04 PM

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

steven s 03-27-2011 08:12 PM

Quote:

Originally Posted by Simon Lloyd (Post 2178091)
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....&postcount=288 is a dead link.

newguy 03-28-2011 12:23 AM

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 03-28-2011 12:56 AM

Quote:

Originally Posted by newguy (Post 2178160)
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 03-28-2011 03:36 AM

Quote:

Originally Posted by rob4448585 (Post 2178169)
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 04-26-2011 07:24 PM

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

Gav-n-Tn 04-26-2011 07:32 PM

Quote:

Originally Posted by edie (Post 2188996)
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 04-26-2011 09:26 PM

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 04-26-2011 11:54 PM

Quote:

Originally Posted by edie (Post 2189039)
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 04-27-2011 01:50 AM

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

edie 04-27-2011 11:33 PM

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 04-27-2011 11:50 PM

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 04-28-2011 06:51 AM

Quote:

Originally Posted by edie (Post 2189472)
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 05-01-2011 11:28 AM

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?


All times are GMT. The time now is 10:55 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02321 seconds
  • Memory Usage 1,852KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (18)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete