vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Administrative and Maintenance Tools - Stop the Registration Bots (https://vborg.vbsupport.ru/showthread.php?t=244746)

hugh_ 12-20-2012 07:04 PM

I get this error when I try to install this:

Database error in vBulletin 4.2.0:

Invalid SQL:

CREATE TABLE IF NOT EXISTS stopbotsregistry (
`hash` varchar(100) NOT NULL default '',
`regtime` int(10) unsigned NOT NULL default '0',
`rf_name` varchar(10) NOT NULL default '',
`rf_value` varchar(10) NOT NULL default '',
`uf_name` varchar(10) NOT NULL default '',
`uf_value` varchar(10) NOT NULL default '',
PRIMARY KEY (`hash`),
KEY `regtime` (`regtime`)
) TYPE=MyISAM;

DAMINK 12-22-2012 01:36 AM

I would love for this mod to be able to write the results of failed registrations to thread instead of or as well as email.
Me personally i like to name and shame and this mod could do well for that.
If anyone could give advice on how to do this, that would be great.

Videx 12-22-2012 02:15 AM

Quote:

Originally Posted by DAMINK (Post 2392158)
Me personally i like to name and shame and this mod could do well for that.

You want to "name and shame" bots? Do you think that would make them feel so bad they will stop annoying us?

DAMINK 12-22-2012 02:26 AM

No not really Videx.
Way i figure it........
Better in a thread than 500 emails a day.
To have them available to visually see i think could be a good thing if only for reference and perhaps a constant ip address that is not dynamic and therefor easy to ban.
Dunno just think it would be better in a thread than an email.
( I get too many emails NOW)
But im guessing your comment was infact a smartarse one rather than a constructive one so i will not reply further to that.

Videx 12-22-2012 02:47 AM

No, I was not being a smartass. I really think you're doing something terribly wrong if you're getting 500 emails a day from rejected bots. Have you just tried a simple Q&A? That eliminates about 100% of our bots, and no email notification is necessary.

That leaves real humans as our only remaining source of spam. And when you ban these guys, they won't be able to read your 'shame' forum anyway so why bother?

And the few bots that may register but never post - and thus don't get banned - aren't a problem anyway. They just swell our ranks which isn't a Bad Thing.

DAMINK 12-22-2012 02:58 AM

Yep i run a Q&A mate.
I do email verification.
I put all new users into a special group.
I force all new uses to post in one area only that is moderated. (non visible to members or bots)
They have no access to spam my site. None actually.
Once someone registers they loose access to my forum unless they are allowed.
It works just fine. I dont care if its difficult. I only want members who are real anyway.

I dont have visible spam on my forum. I just dont. I have in place the measures to stop that.
I simply want this mod to post in thread as other mods do like duplicate ips and what not.

Quote:

Do you think that would make them feel so bad they will stop annoying us?
That is my point about sarcasm or being a smartarse.
Did i think it would stop annoying us?
Well first of all. I dont concider me and you US.
But as for me. No i dont. I simply want to post a thread about it.
Public or private. My choice. But is that too much to ask without comments like above?

ps....
i dont show my member list.
I dont promote spammers as members.
I have anyone who has not posted after X deleted as a user.
I have people that are inactive moved to different user groups.
My forum was never about ego and stats. Others are and i get that.
Mine is not.

stickskills 12-23-2012 01:10 AM

Quote:

Originally Posted by hugh_ (Post 2391905)
I get this error when I try to install this:

Database error in vBulletin 4.2.0:

Invalid SQL:

CREATE TABLE IF NOT EXISTS stopbotsregistry (
`hash` varchar(100) NOT NULL default '',
`regtime` int(10) unsigned NOT NULL default '0',
`rf_name` varchar(10) NOT NULL default '',
`rf_value` varchar(10) NOT NULL default '',
`uf_name` varchar(10) NOT NULL default '',
`uf_value` varchar(10) NOT NULL default '',
PRIMARY KEY (`hash`),
KEY `regtime` (`regtime`)
) TYPE=MyISAM;

Yeah, I'm receiving the exact same issue.

togotutor 12-26-2012 01:05 AM

Downloaded and Installed..

DAMINK 12-27-2012 04:26 AM

Any chance of adding and option to push the user who registered too quickly to a specific URL or our choice?
That would be GOLD for me.

mrsbuzzy 01-14-2013 06:08 PM

Before I upgraded my forums and then this hack to the most recent vB (not the version 5) this hack worked beautifully. But, since the upgrade to the vB and to this hack I am getting TONS of new bot registrations. Literally 30+ a day are making it through this hack. I have checked and double checked the settings. I have the time for registration set to 65 seconds.

Anyone else having this problem?:confused:


All times are GMT. The time now is 10:05 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.01153 seconds
  • Memory Usage 1,741KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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