Administrative and Maintenance Tools - Stop the Registration Bots

Stop the Registration Bots for vBulletin 4.2.0 PL3 and up.

This mod will check the the time it takes for a vBulletin registration form to be submitted. If the form is submitted faster then humanly possible, the registration will be denied and the admin contact can be emailed about the event.

First we will add a custom hidden field with a hash. Second we will insert a randomly named hidden field with a random value. This should make it a bit difficult to program a bot since the field names on all sites will be different as well as the values.

Time stamps to check the time spent on registration submission are stored in a DB table and private.

Installation is very easy.
Template edits.
Files to upload.
Product xml file to import.

Backup your database before any install or upgrade.

To upgrade from 2.x to 4.0.2, remove the existing Stop the Registration Bots product in the ACP and then follow the installation file instructions.


History

4.0.2
Added 10 minute delete interval
Fixed bug in part 3
updated table query
removed old hook code from product.

4.0.1
modify phrase vars
modified install instructions for 4.2.0 pl3 templates.

4.0.0
modified to work with vB 4.x.

2.0.2
Edited file includes/stb_reg_process.php
Added IP and Proxy IP to email notification.

2.0.1
Added tabindex="1" to input box template edit.
Fixed onsubmit code in input box template edit.

2.0.0
Conversion from vB 3.x version to vB 4.x
Reduced template edits to one.
Edited all arrays to include single quotes.
Removed ACP Setting StopBotReg_rulespage_hash
Removed Rules page instructions. All one page now.
Removed file includes/stb_reg_signup.php
Removed hook register_signup
Edited includes/cron/strb_cron_job.php Removed Rules page query.
Removed `rf_name` and `rf_value` fields from DB table.
Moved register_form_start hook code to register_form_complete hook
New Phrases
stop_reg_bot_please_wait
stop_reg_bot_seconds_more
stop_reg_bot_seconds_remaining
Removed phrase stop_reg_bot_enter_prereg_name
Removed phrase setting_StopBotReg_rulespage_hash_title
Removed phrase setting_StopBotReg_rulespage_hash_desc

[pbforum]

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]

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]

can u tell me how ?

[Videx]

Originally Posted by pbforum

can u tell me how ?

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

[pbforum]

i did but same problem

[Videx]

Originally Posted by pbforum

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]

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

[Toorak Times]

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

[hyperspin]

I'm getting the attached error upon importing this mod.

[Max Taxable]

Better job of this:

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