Hey all,

After a good period of development, we're proud to present Advanced Registration v2.0.0 Beta 1 for Pro-only customers.

This release focuses on adding to the Criteria system, with two new criterias you can use to direct people to separate instances of the registration page; Proxy and Code. The Proxy criteria lets you detect (within limitations) if someone is using a proxy to access your forum. The Code criteria will allow administrators to craft a special link that users can give to people, directing registrations to an entirely separate instance. Combined, these two features allow you to direct proxy users to an entirely separate registration page with additional human verification options, and bypass human verification for people with the special code.

Additionally, there's new Whitelisting features for the Pro-only Redirects feature, allowing you to exclude spiders and certain IP addresses you choose from the redirect.


If you like the product you can show your support by nominating it for mod of the month here: Advanced Registration v1 (vB4) - vBulletin.org Forum, and also please rate it to help cancel out the users who 1 star our mods.



Advanced Registration v2.0.0 Beta 1

New Criteria: Proxy

• Ability to create a criteria for whether the user is using a proxy
• Separate instances for proxy users and other users

New Criteria: Code

• Ability to create a criteria for whether users have clicked on an admin-crafted link.
• Separate instance for specially invited users.

(Pro) Redirects

• Whitelist certain IP addresses from the redirect
• Whitelist spiders from the redirect
• Whitelists are on a per-redirect instance basis

Thank you for your continued support

Read the original news thread here.

Database error in vBulletin 4.2.0:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `dbtech_registration_criteria` (
`criteriaid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`title` VARCHAR( 255 ) NOT NULL ,
`active` tinyint(1) NOT NULL DEFAULT '1',
`type` VARCHAR( 255 ) NOT NULL ,
`operator` VARCHAR( 255 ) NOT NULL ,
`value` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (`criteriaid`),
UNIQUE (`type`, `operator`, `value`)
);

MySQL Error : Specified key was too long; max key length is 1000 bytes
Error Number : 1071
Request Date : Monday, January 14th 2013 @ 09:35:49 PM
Error Date : Monday, January 14th 2013 @ 09:35:54 PM
Script : เข้าสู่ระบบ - บ้านฟ้าสาง - vBulletin ห้à¸*งควบคุม
Referrer : เข้าสู่ระบบ - บ้านฟ้าสาง - vBulletin ห้à¸*งควบคุม

Classname : vB_Database
MySQL Version : 5.1.63

That is a misconfiguration of your server, please contact your host

Originally Posted by Belazor

That is a misconfiguration of your server, please contact your host

My host want to know how to solve this issue?

The issue is actually that the table is using UTF-8 so the varchar(255) is triggering it.

I'll see if I can work around the issue in the next Beta version

Meanwhile, you can edit /dbtech/registration/install/200.php and remove the UNIQUE() line from the query you see in the error. That should at least enable you to install it.

I re-download and re-installed your new update, It have no error.