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)

SFertitta72 10-14-2008 01:59 AM

Please bear with the noob here :D

I installed this into VB 3..6.10. Seems to be ok, but there is no usergroup listed as vbStopForumSpam Permissions. Was I supposed to put this in, or did I miss something?

Also, where do I find the log?

Thanks for you help. :up:

**Edit**
I just realized that this killed my registration process. I will take a screen shot and post it showing the errors. I must have screwed something up.

Gotta remember NOT to drink vodka and install mods to my site :-)

pedigree 10-14-2008 09:05 AM

Yes please do send me a link to the screenshot so that I can look at why its killing your reg.

If you cant find the log, then I suspect that you havent uploaded the files required for the mod

ChaosBurnt 10-14-2008 01:36 PM

Brilliant idea, I've been using their database for a while now and having to remember to update the blocked IP's and emails was getting hard to remember. This will ease some off the pressure on us to keep the address lists up to date, thank you.
I only found out about this mod as it's linked to from vBulletin.com on this post
http://www.vbulletin.com/forum/showp...&postcount=157
, that doesn't happen too often ;)

douffle 10-14-2008 01:41 PM

Quote:

Originally Posted by pedigree (Post 1643893)
Try this, open includes\functions_vbsfs.php, go to line 71 and change

$sql = "SELECT DATEDIFF(NOW(), '" . $lastseen . "') AS DAYS;";

to

$sql = "SELECT DATEDIFF(NOW(), '" . $lastseen . "') AS DAYS";

I made the changes to both forums but it did not resolve the problem.
Any other suggestions?

Thanks.

pedigree 10-14-2008 02:01 PM

the DATEDIFF function is in mySQL as of version 4.1.1. You are using 4.0.x which has support discontinued as of Sept 2006. Time to upgrade??

I will update the XML so that the plugin doesnt install when the SQL version is under 4.1.1

bitwise2000 10-15-2008 12:35 PM

Thanks pedigree. Excellent mod. Nabbed 30 dirty spammers in the first 12 hours. Can't wait for the submit feature.

douffle 10-15-2008 02:51 PM

Quote:

Originally Posted by pedigree (Post 1644895)
the DATEDIFF function is in mySQL as of version 4.1.1. You are using 4.0.x which has support discontinued as of Sept 2006. Time to upgrade??

I will update the XML so that the plugin doesnt install when the SQL version is under 4.1.1

As mentioned in my previous post, I have MySQL 4 on one site but I have MySQL 5 on the other site and it has the same problem with the database errors.

Wired1 10-22-2008 11:58 PM

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)
Code:

// 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?

pedigree 10-23-2008 09:28 AM

yeah, you dont want to know how much bandwidth the server used last month. Its something that were looking at addressing but I guess the site is just becoming more popular.

Thanks, I was going to make this a plugin as well but it was late :) Ill see how it can be integrated into the "delete as spam" . Im guessing a "delete as spam and submit spammer to stopforumspam.com" would be better but not so easy on the eye :)

pedigree 10-23-2008 12:44 PM

I was wondering how people would react to me including some of the One Touch Spam Ban and Cleanup util into this (https://vborg.vbsupport.ru/showthread.php?t=156444). The author sadly passed away in a tragic caving accident and it would be a shame to see something just dispear into the ether when it could be included in vbStopForumSpam in such a useful manner as to submit as well as cleanup.

Wired1 10-23-2008 10:22 PM

Just insdert a page into the spam/ban process. Don't know if there's any hooks in there though. Worst case you can make a hook and put it in there.

I see the 2 products as two parts of the spam battle. This mod is proactive (assuming they've been caught somewhere else already), whereas the other mod is retroactive (they've already spammed your forum).

I can see the One Touch Spam Ban and Cleanup growing into a major utility (assuming it is integrated into the Delete and Ban option), in that after banning, it could do some basic searching in the user DB and find similar members. I know the Delete and Ban option does this to a certain extent, but it could go a bit deeper and look for users w/ the same class C subnet or domain, etc. Maually approve bans of course. If it could let you ban multiple users from the AdminCP search result area, I'd be eternally grateful. I have tons of spammers to ban lol! Anyway, this product could definitely benefit from the plugin that sends data to vBstopforumspam.com.

pedigree 10-23-2008 10:38 PM

I can easily add an option that shows other users on the same class-c subnet when showing details about a user

afmarko99 10-24-2008 02:35 AM

Thanks for the hack.

Just installed and registered for an API key.

I hope this helps get rid of the spam I have recently been having.

segwayon 10-25-2008 06:15 PM

Quote:

Originally Posted by Wired1 (Post 1650801)
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)
Code:

// 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?

Wired1,

I've never added a plugin before. I undertand the product setting (vbStopForumSpam). But which hook location and execution order would I need to tag if any? Thanks!

pedigree 10-25-2008 07:06 PM

Quote:

Originally Posted by segwayon (Post 1652574)
Wired1,

I've never added a plugin before. I undertand the product setting (vbStopForumSpam). But which hook location and execution order would I need to tag if any? Thanks!

Just go to the Plugin Manager, add a new plugin and upload the XML file that Wired1 posted (theyre in my first post in the thread as well) - but just one of them. One is for just the admin account to use, the other is for all admin accounts to use. The // QUICK LINKS thing is if you want to manually edit files, which I doubt you would want to do.

segwayon 10-25-2008 09:07 PM

Quote:

Originally Posted by pedigree (Post 1652597)
Just go to the Plugin Manager, add a new plugin and upload the XML file that Wired1 posted (theyre in my first post in the thread as well) - but just one of them. One is for just the admin account to use, the other is for all admin accounts to use. The // QUICK LINKS thing is if you want to manually edit files, which I doubt you would want to do.

Aha! Got it! I didn't notice the 'upload' category earlier. Thanks again, pedigree. You've helped stop a thousand spammers in the past month on our small board, and your consistent support is admirable. Nominating for MOTM.

hvb 10-29-2008 09:02 AM

Hi Pedigree, just installed your addon, but I have a question.
If I don't have cURL installed, will your addon still work?

Delphiprogrammi 10-29-2008 09:30 AM

Quote:

Originally Posted by hvb (Post 1655168)
Hi Pedigree, just installed your addon, but I have a question.
If I don't have cURL installed, will your addon still work?


yes it will use file_get_contents() if cURL is not availible

hvb 10-29-2008 09:39 AM

Ok, thx, delphiprogrammi for your quick response

pedigree 10-29-2008 01:09 PM

Delphi is dead right. cUrl support is there for those that have it and want to use it. It provides a more robust connection system but doesnt require it. I just like using it myyself which is why its there :)

ArnyVee 11-01-2008 01:08 PM

I've been using that StopForumSpam for some time to track the spammers and such. But, I had never seen this mod. Thanks, tagged. :D

nicker 11-01-2008 09:51 PM

When ever I enable this, it stops spammers but it also causes new registrations to get this...

Quote:

You tried to access the address http://www.myforums.com/forum/register.php?do=addmember, which is currently unavailable. Please make sure that the Web address (URL) is correctly spelt and punctuated, then try reloading the page.
Make sure your Internet connection is active and check whether other applications that rely on the same connection are working.
anyone else getting this

pedigree 11-02-2008 09:16 AM

nicker looks like a problem with your forums I think as any error generated by the mod should cause a more serious (ie informative) error but without the correct url to the forum in question, I couldnt tell you. PM me with the forum address and I can have a look. Sometimes, if there is an error and the server has started sending a compressed page, that can cause strange errors that often have nothing to do with the problem but sometimes (in Firefox anyway as IE is a peice of s**t) you get the correct error.

nicker 11-02-2008 01:39 PM

Quote:

Originally Posted by pedigree (Post 1657741)
nicker looks like a problem with your forums I think as any error generated by the mod should cause a more serious (ie informative) error but without the correct url to the forum in question, I couldnt tell you. PM me with the forum address and I can have a look. Sometimes, if there is an error and the server has started sending a compressed page, that can cause strange errors that often have nothing to do with the problem but sometimes (in Firefox anyway as IE is a peice of s**t) you get the correct error.

I tried to register using Firefox on 2 different pc s, when I disabled the product the registering was fine.

PM on way.

thanks

pedigree 11-02-2008 07:48 PM

All fixed :)

nicker 11-02-2008 07:49 PM

Pedigree, thanks for all your help, it's reassuring to know that top class support is available here.

10/10 for you.

BadgerDog 11-03-2008 11:55 AM

I just added "wired1" plugins to be able to to add to the vBstopforum database without leaving the AdminCP function.

https://vborg.vbsupport.ru/showpost....&postcount=289

I wasn't sure what to do, so I added both his XML plugins.

Now I seem to have two boxes added to the user profile, which appear identical. I assume my mistake was that I should have imported onlt one XML plugin, but now I don't know how to get rid of one of them?

I only want usergroup #6 (Admins) to be able to use this function, so I assume I need to delete the XML for the plugin that isn't that one?

Where do I find it?

Thanks for any help... :)

Regards,
Badger

Wired1 11-03-2008 02:33 PM

Remove both from the plugin manager, then install the one you want.

BadgerDog 11-03-2008 03:04 PM

Quote:

Originally Posted by Wired1 (Post 1658587)
Remove both from the plugin manager, then install the one you want.


Thank you ... :)

I unchecked the plugin with "1" and only one box appeared after that in the user profile.

BYW, thanks for this plugin. :up:

It's far more convenient then having to open up the web site in a separate browser window and cut-n-paste ...

Regards,
Badger

JaredC01 11-03-2008 05:04 PM

I seem to be having a problem with the plugin... I'm getting this error:

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.

Though I have no issues checking manually from the website.

pedigree 11-03-2008 07:18 PM

Thats the message you get when youre on the blacklist and you try to register. If you look in the logs, youll see what field the denied registration was based on

JaredC01 11-03-2008 07:45 PM

It says it cannot connect to the DB to check in the error message, not that they're blacklisted... Also, that is the message I get when I try to register an alternate account. I KNOW for a fact I'm not blacklisted.

JaredC01 11-03-2008 07:56 PM

You know what, I think I found out the issue... It's with my host, not the mod.

pedigree 11-03-2008 10:50 PM

great. what was it? just so that i can look at code around it or incase others find the same problem

Skyrider 11-04-2008 12:18 PM

I wanted to order the logs by IP Adress, and got this error:

Quote:

Database error in vBulletin 3.7.3:

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 : Tuesday, November 4th 2008 @ 08:17:14 AM
Error Date : Tuesday, November 4th 2008 @ 08:17:14 AM
Script : xxxx/admincp/vbstopforumspam.php?do=view&pp=15&orderby=ip&page= 1

Wired1 11-04-2008 12:32 PM

Quote:

Originally Posted by FF|Skyrider (Post 1659302)
I wanted to order the logs by IP Adress, and got this error:

Reading is fundamental :)

Quote:

Originally Posted by pedigree (Post 1609780)
If you go to line 62 in admincp/vbstopforumspam.php and change

$order = 'ip ASC, date DESC';

to

$order = 'ipaddress ASC, date DESC';

then that will fix that error


pedigree 11-04-2008 05:04 PM

Sometimes I think Wired1 watches this thread like a hawk :)

pigpog 11-04-2008 05:26 PM

Thanks for this mod. I've installed it in conjunction with "Stop the Registration Bots" so if they get through that, they have your mod to contend with. Mwhahahaha! :D I'll be seeing how this goes - I looked at your site and it looks very comprehensive so I hope this will go a long way toward stopping the spammers from getting to my members! :cool:

Wired1 11-04-2008 08:58 PM

Quote:

Originally Posted by pedigree (Post 1659447)
Sometimes I think Wired1 watches this thread like a hawk :)

Maaaayyyybbbeee.....

J Random Hacker 11-08-2008 08:21 AM

Nice plugin, and saves me from writing my own. Gotta love it!

When might we see Project Honey Pot included? SFS and PHP pretty much overlap, but I've found a few comment spammers in one but not the other and the ones I worry most about are those who haven't been around long enough to be widely detected yet.

Thanks for the plugin!


All times are GMT. The time now is 09:28 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.02066 seconds
  • Memory Usage 1,837KB
  • 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
  • (13)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