[SOLVED] Get usergroup for condition in Auto Actions

Hi,

I need to set a field value upon a members usergroups. I cannot find any substitution for that. Is is possible in any way?

Example:
A new user registeres to a site and chooses in a dropdown-list, if he is either "Manager" or "Taxidriver". He gets automatically assigned to usergroup "ManagersGroup" or "TaxidriversGroup". Now a separate field called "HasTaxiLicense" should be set to strings "no" for the manager or "yes" for the taxidriver by default upon registration, but the field should not be shown during registration or in usertabs at the frondent, because it is only for internal use.
The easiest way for me would be if i can check the assigned group with triggers "onAfterUserRegistration,onAfterUserUpdate,onAfterUpdateUser". This updates the field even if the user changes his employment from manager to taxidriver..

How can I solve this? Maybe theres a was for substituting a sql-select?

Thanx in advance for your help!

Stefan

Hi all,

I solved it on my own with the absolutely great cb-plugin "CB MySQL Field".

The query

SELECT title FROM jos_usergroups, jos_user_usergroup_map WHERE jos_user_usergroup_map.group_id = jos_usergroups.id AND jos_user_usergroup_map.user_id = '{USERID}'

with a delimiter ","

gets me all usergroups of the user which then can be used as condition "Does Contain" or "Does Not Contain" in CB Auto Actions.

Thanks for these great plugins!

Stefan

Just have 2 actions act on the field value. There's no need to check the actual usergroups if you've a CB field that represents them.

Please also note we've a CB Query Field plugin that provides query output as field values with substitution support and much much more.

Hi Kyle,

thank you for your reply. I just did it through the MySQL-Field and that works like it should. I don't have a separate field representing the usergroups, but the MySQL-Field just does that job..

Stefan