Assigning a Membership Number

I've created a membership site for Jaguar Drivers using Joomla 2.5, CB 1.9 and CBsubs. I've also used Fabrik extensively for reporting and creating additional tables.

I need to assign a membership number automatically to each new subscriber, being the last used membership number plus 1. I'm sure there are a number of ways to do this but would appreciate some direction on what would be the most effective?

If it's in the database somewhere you should be able to use CBSubs SQL Actions to perform a database query to grab the highest value for that column and increment it by one. So for example it could be a read only integer field or something of the sort.

Thanks Kyle,

I'm having trouble finding that plugin. Are you referring to CB Query Field?

RodFarrell wrote: Thanks Kyle,

I'm having trouble finding that plugin. Are you referring to CB Query Field?

Nope, Kyle mentioned the CBSubs SQL Action - please study your CBSubs manual for this plugin and feature.

It will allow you to execute SQL queries in your database everytime a new subscription starts in your cbsubs plan.

You would need to formulate the proper query to check your membership table and find the largest (assuming membership number is an integer) membership number and the adding 1 to that value and save it for your just subscribed user.

Thanks Nick, I've found that but the manual says

"Warning: This plugin should not be used to alter #__user and/or #__comprofiler
tables, the CBFields integration plugin should be used to alter CB Field values
(stored in #__comprofiler table)." so its no good for this purpose.

OK, I've achieved what I needed by setting the user ID to the last member number and retrieving the new user id into the Member Number field with CBFields Integration.

I still have another task that requires running a mysql query to retrieve data from another (non cb) table and populating a CB field with it. Which plugin do we use for that?

I still have another task that requires running a mysql query to retrieve data from another (non cb) table and populating a CB field with it. Which plugin do we use for that?

Depends on when you want the query to happen. If it's meant to happen on subscription then you'd also use CBSubs SQL Actions. If you want it to happen on profile update and registration then CB Auto Actions and its Query action works best. An alternative is to not move data at all and just display the information you want on the users profile using CB Query Field, which displays database query results as a CB field.