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)

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.


All times are GMT. The time now is 08:08 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.02026 seconds
  • Memory Usage 1,745KB
  • 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
  • (4)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