each user is automatically assigned a user_id value.

You can see this value in the CB User management backend (right column).

You can show this value in frontend by using a delimiter field with [user_id] in it.

Best approach is to develop a query to meet your needs then place it within your plan using CBSubs SQL Actions. The following is an example that might accomplish your needs (please make changes as necessary).

You will first need to create an integer field within CB Field Management. Remember its name as well as you'll need it for the query (for sake of example lets called it cb_integer).

[code:1]
UPDATE `#__comprofiler` SET `cb_integer` = ( ( SELECT `cb_integer` FROM `#__comprofiler` ORDER BY `cb_integer` DESC LIMIT 1 ) + 1 ) WHERE `id` = [user_id]
[/code:1]

This would at least allow more customized approach, but Nicks solution is by far the easiest (and likely most efficient) as each user is truly created with a unique number for user_id.

Post edited by: krileon, at: 2010/04/19 14:34