How to calculate the result of crc32 function inside a field ?

hello

I need to get the calculated value using crc32 function of UserId+Email+Username for each user and I wondering how to do that. CB do no have any "Code" field which can help for this task and CB Query field is not adapted for this.

Any clue ?

I make some investigation and it seem is maybe possible to use CB Query field. So I tried to use this:

SELECT CRC32(CONCAT(user_id, email, username)) FROM `jos_comprofiler` WHERE `user_id` = [user_id]

..and to create a delimiter field for output the result but this don't work. What wrong in my query ?

Furthermore I read this on W3schools:

To ensure that you get the correct string representation from the crc32() function, you'll need to use the %u formatter of the printf() or sprintf() function. If the %u formatter is not used, the result may display in incorrect and negative numbers.

But I don't know if this is necessary and if yes, how to add this in the query. Could you help me also with that please?

thank

To do it via MYSQL you'd use the below query. This assumes your database supports crc32.


CB doesn't have a code field so to do it via PHP you'd need to update a field value after profile update and after registration using a Code action in CB Auto Actions. Set the method to PHP and use whatever PHP you need to update the users user object. The alternative is to create a new fieldtype plugin that works like the query field except it can run PHP and return the result as a field value.

you rock your query seem to work well :woohoo: :silly: . I forget always user data are not stored in CB but in Joomla.

The alternative is to create a new fieldtype plugin that works like the query field except it can run PHP and return the result as a field value.

You don't have a future plan such this one on Joomlapolis ??

Happy New Year to you

You don't have a future plan such this one on Joomlapolis ??

I do, it's just low on my TODO list. Time wise it's probably just an hour of work as it's a very simple and basic fieldtype plugin. Just busy focusing on CB 2.0. I have to get all active incubator projects upgraded, which is a pretty time consuming task (so far CB Invites and CB Auto Actions is upgraded).