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)

bongwater 10-13-2011 04:18 AM

does anybody know if this works on 4.1.6, or the latest 4.1.7?

Videx 10-14-2011 06:54 PM

Quote:

Originally Posted by bongwater (Post 2256648)
does anybody know if this works on 4.1.6, or the latest 4.1.7?

Maybe, but I doubt it will help anything as all the spammers we get nowadays are actual humans. Good Q&A will stop the bots.

caper12 12-16-2011 08:47 PM

I have looked everywhere. What file am I looking for in the registration template? Is it a php file? I did find a register.php but that didn't have the lines that the instructions say need to be modified

I have 4.0.8 Vbulletin
Thanks

DAMINK 01-14-2012 10:47 PM

Does not appear to be working anymore for me with 4.1.10
I tried reinstalling and still no luck.
I have it set at 20 seconds but can hit the "Complete Registration" instantly.
Is this a problem my end or a problem with 4.1.10?

tnagaming 01-26-2012 02:43 PM

Quote:

Originally Posted by DAMINK (Post 2287901)
Does not appear to be working anymore for me with 4.1.10
I tried reinstalling and still no luck.
I have it set at 20 seconds but can hit the "Complete Registration" instantly.
Is this a problem my end or a problem with 4.1.10?

I'm running 4.1.10 vbulletin with this mod installed. Havn't encountered any problems as of yet.

Getting 5 to 10 emails a day about blocked registrations. My human members don't have a problem registering either.

Only thing I would like to do is find a way to make it post up in my Admin forums each time it blocks someone.

DAMINK 01-28-2012 07:29 AM

Your lucky tnagaming.
Dont work for me and no advice from creator so sort of in the dark.
Sucks really it was a good mod i liked to have.
Uninstalled until i can fix the problem.

Toorak Times 01-29-2012 02:14 AM

Hi mate,

Tried to mark as installed but am not authorised or something...I own a 4.19 version atm. Thanks, hope this works for me as the bots drive me nuts.

Cheers

Mick

DAMINK 04-08-2012 01:40 AM

Hey guys. I really want to get this mod to work but cant currently.
I found out why. I cant seem to edit my registration template. It just hangs on the loading screen forever so i was wondering....
Is there any way i can do this template edit manually? Not from within ACP i mean.
I really would like to get this mod going again.

datoneer 04-13-2012 07:39 PM

Works with 4.1.10. Thanks, great mod

AshenTemper 06-25-2012 06:01 PM

Using this with 4.1.12 and it is a fantastic mod! I have a couple of barriers of entry for would-be spambots but thismod is catching a good 90+% of them before they even get to the others. Definitely thumbs up on it!

pbforum 08-08-2012 09:50 AM

i have aa problem to install

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',
`uf_name` varchar(10) NOT NULL default '',
`uf_value` varchar(10) NOT NULL default '',
PRIMARY KEY (`hash`),
KEY `regtime` (`regtime`)
) 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 8
Error Number : 1064
Request Date : Wednesday, August 8th 2012 @ 06:51:46 AM
Error Date : Wednesday, August 8th 2012 @ 06:51:46 AM
Script : http://punjabiforum.in/forum/admincp...=productimport
Referrer : https://punjabiforum.in/forum/adminc...?do=productadd
IP Address : 94.59.232.82
Username : pendu
Classname : vB_Database
MySQL Version : 5.5.24-cll

Videx 08-08-2012 12:07 PM

The 'Type =' part of the query is obsolete and no longer supported by newer MySQL installations.

Either delete that part of the query to use the default storage engine or replace it with 'Engine ='

(from https://vborg.vbsupport.ru/showpost....67&postcount=2)

pbforum 08-08-2012 03:57 PM

can u tell me how ?

Videx 08-08-2012 04:34 PM

Quote:

Originally Posted by pbforum (Post 2355571)
can u tell me how ?

Until the author fixes it, just edit the .xml file with any text editor prior to installing.

pbforum 08-08-2012 05:07 PM

i did but same problem

Videx 08-08-2012 11:51 PM

Quote:

Originally Posted by pbforum (Post 2355597)
i did but same problem

Then I can't help you. If you've changed line 8 I can't imagine why it would still say you have " 'TYPE=MyISAM' at line 8" if you really don't.

Maybe you tried to upload the original file? Maybe you forgot to save it after editing it?

nyenius 08-19-2012 02:11 PM

:(

Really this kind of mod... (im using 4.2)

Toorak Times 10-21-2012 06:03 PM

This has been working fine on my 4.2pl2 till last week now the shifty ones have found away around:eek:

hyperspin 10-22-2012 03:01 AM

1 Attachment(s)
I'm getting the attached error upon importing this mod.

Max Taxable 10-25-2012 09:31 PM

Better job of this:

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

noppid 12-08-2012 11:08 AM

Gonna try this on vB 4.2.0 PL3 today and will post any needed updates.

Stefan118 12-08-2012 02:03 PM

No need to update.....
I have installed this on vB 4.0.8 and it is ever since running.
Updated vB every time and running now without any problems on vB 4.2.0 PL3 since several months.

MacGuyInNC 12-08-2012 02:13 PM

In the second step, I think I see a typo in the instructions.

Under b) Find:
<input type="submit" class="button" value="{vb:rawphrase complete_registration}" tabindex="1" accesskey="s" />

You have:
Change to:
<input type="submit" class="button" name="timeremaining" value="{vb:rawphrase complete_registration} in {vb:raw vboption.StopBotRegMinTime}" tabindex="1" accesskey="s" onsubmit"submit_form()") />

The "onsubmit" is missing the =

noppid 12-08-2012 02:31 PM

Quote:

Originally Posted by Stefan118 (Post 2389303)
No need to update.....
I have installed this on vB 4.0.8 and it is ever since running.
Updated vB every time and running now without any problems on vB 4.2.0 PL3 since several months.

The instructions needed an update for 4.2 templates. The product name needed attention and the version check needed attention. You may want to just double check things. Thanks.

Quote:

Originally Posted by MacGuyInNC (Post 2389304)
In the second step, I think I see a typo in the instructions.

Under b) Find:
<input type="submit" class="button" value="{vb:rawphrase complete_registration}" tabindex="1" accesskey="s" />

You have:
Change to:
<input type="submit" class="button" name="timeremaining" value="{vb:rawphrase complete_registration} in {vb:raw vboption.StopBotRegMinTime}" tabindex="1" accesskey="s" onsubmit"submit_form()") />

The "onsubmit" is missing the =

I just updated the zip with that fixed. Thanks for the heads up.

MacGuyInNC 12-10-2012 04:24 AM

Also, since I upgraded, I'm getting an error on the REPLACE statement:

Code:

REPLACE INTO stopbotsregistry (hash,rf_name,rf_value)
        values(
        '[Redacted]',
        '[Redacted]',
        '[Redacted'
        );

The MySQL error I'm getting is:
Code:

Unknown column 'rf_name' in 'field list'
The only columns in that table are:
Code:

hash, regtime, uf_name, uf_value
In the updated files, I'm seeing "rf_name" in 3 different files for a total of 8 instances. Also, "rf_value" appears in some of those files as well. Was there a database change that just didn't take? If I change the query to match the columns in the table, will that fargle anything up?

noppid 12-10-2012 03:00 PM

Somewhere along the line I think the upgrade procedure was to remove the product to remove the DB table and then re-install the product to create the new DB table.

The fix should be uninstall the product and re-install the product. Let us know it that works. There is no data in the table that won't be recreated.

MacGuyInNC 12-10-2012 04:48 PM

Quote:

Originally Posted by noppid (Post 2389770)
Somewhere along the line I think the upgrade procedure was to remove the product to remove the DB table and then re-install the product to create the new DB table.

The fix should be uninstall the product and re-install the product. Let us know it that works. There is no data in the table that won't be recreated.

Yeah, in looking at my setup a little more closely, I noticed 2.0.2 was still installed.

Uninstalled, reinstalled, am waiting now to see if there are any problems.

Thanks for pointing out my PEBKAC moment. :)

nicklfire 12-12-2012 02:27 PM

Does this mod take into consideration the Facebook login feature as well?

Toorak Times 12-12-2012 02:45 PM

I have had this mod for a while, it has saved me so many hours work getting rid of spammers, when I have had it off after a crash et al I'd get flooded...JUST upgraded to 4.2pl3 and will be installing the upgrade tomorrow I hope.

I have had a few sneaking thru so it will be interesting to see how it responds, I will report back

noppid 12-12-2012 07:09 PM

Quote:

Originally Posted by nicklfire (Post 2390225)
Does this mod take into consideration the Facebook login feature as well?

You should force the vB registration form on your forum to use this mod with FB or else you are relying on FB to give you real members.

This is designed to stop remotely submitted forms by installing random data fields in the registration form. It's one tool in the process of stopping spam.

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 05:08 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.01267 seconds
  • Memory Usage 1,831KB
  • 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_code_printable
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (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