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)

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 07:03 PM.

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.02021 seconds
  • Memory Usage 1,735KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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