[SOLVED] "Secured" registration

Hello all,

I'm using CB 1.9 and have installed an auto action


During registration, select users would place a "token" (unique string of numbers) into a field, [cb_verificationnumber]
When the number matches the number used in this auto action, the user is automatically authorized on the site. If they don't have a token they are registered but must await admin approval.

Here's my problem

I can only use a single token in auto actions in the ______ is equal to ___
and I kind of need to be able to use at least 70 different tokens for vendors.

this is the code I'm using in the auto action

Query
onAfterUserConfirm
___________ Equal To __"Token"__
Automatic
everybody

UPDATE `#__comprofiler` SET `approved`= '1' WHERE `user_id` = '[user_id]';
UPDATE `#__users` SET `block` = '0' WHERE `id` = '[user_id].

Again, This works, and it works well. I just need to find a way to do something like this but with more token values.

Any help would be greatly appreciated.

Use a text field with CB Query Field installed then add Query Validation to your text field. This will allow you to compare the value they supplied against a database of values. You then would simply validate it on successful rows returned. Next in your CB Auto Actions you just need to check that the field isn't empty as it'll only validate the field if their code supplied matches a list of codes in your custom database table.

Kyle,

Thanks for your reply. I understand what needs to be done, just not how to do it. Do you have any tutorials on it?
The largest confusion I have is where do I place the valid token keys? Do I have to create a new database or can it be placed "inline" in the query.
I can struggle through this if I'm pointed in the right direction.
Damn.... I should have stayed in school.

Looking further at what you said, and letting it sink in a little....

Field, [cb_verificationcode] would be on the registration form. That field would have query enabled and would check the data entered in that field against a database.
The query would only allow the field to populate if the entered data matched that database information, (ie, Select "tokens" from, validate.)
if the user enters a string that isn't in the database the form would not accept the entry and deny access. If however the string was acceptable it would populate the field and my new auto action would see that the field IsNotEmpty and allow the registration to progress. Right?

I guess it all makes sense except where do I enter the valid token information. Do I have to create a field in a DB somewhere?
Please bear with the ignorance, I'm the furthest thing there is away from being a script writer or programmer.

Thanks again for all you do.

Do you have any tutorials on it?

No, not currently. It makes a little more sense when looking at the parameters though. There is also a few usages for CB Query Field query validation posted around the forums.

The largest confusion I have is where do I place the valid token keys? Do I have to create a new database or can it be placed "inline" in the query.

You need to create a new database table in your Joomla database that'll store all your token keys. 1 key per row. This will allow you to query for them and make sure the value the user supplied matches one.

That field would have query enabled and would check the data entered in that field against a database.

Correct.

The query would only allow the field to populate if the entered data matched that database information, (ie, Select "tokens" from, validate.)

It will only allow registration to save if the value they supplied is valid. So if the field has no value or a valid value they can register, which would cover your 2 needed usages.

if the user enters a string that isn't in the database the form would not accept the entry and deny access.

They would get a registration validation error, which you can supply to inform them why they can't register.

If however the string was acceptable it would populate the field and my new auto action would see that the field IsNotEmpty and allow the registration to progress. Right?

Yup.

I guess it all makes sense except where do I enter the valid token information. Do I have to create a field in a DB somewhere?

Yes, you need to create a new database table to store your tokens so you have something to query against.

Okay, I almost have it working. The only problems I'm running into now is how to point to that fields values in the db.

fieldvalueid fieldid Fieldtitle

79 78 XKSI66406462J 1 0
80 78 LSDKJO4684056 2 0
81 78 LKJSIJAIEGHSK 3 0

I dont know what to call the values.
Select ? from? where?

Thanks again for your help Kyle. I know this wasn't part of the purchase plan.