Don't add field values to _comprofiler_field_values. That's for select type fields created in CB > Field Management. You need to create your own database table to store them. Example structure as follows.
Create Database Table:
Code:
CREATE TABLE IF NOT EXISTS `jos_approval_tokens` (
`id` int(11) NOT NULL auto_increment,
`token` varchar(255) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16;
Now add all your tokens to the new database table. Next you can query against it with the below.
Query Validation: Enabled
Query:
Code:
SELECT * FROM `jos_approval_tokens` WHERE `token` = '[value]'
Mode: Internal
Validate On: Successful Results
Validate Error: Invalid token provided!
Ajax Validation: Enabled
Please understand we do not provide custom coding and this is the only example I can provide for you. If you need further query/database help you may want to consider hiring out this implementation.
krileon
