I've got a Select Field with options and when one is selected I need to not only change a user group but delete one as well first.
These are the options in the CB select field:
Code:
{
Northern
Southern
Eastern
Western
}
I will need to run this query when the Profile is saved in order to delete the current User Group in question (only 4 options represented by 23,24,33,34)
Code:
DELETE IGNORE FROM `#__user_usergroup_map`
WHERE `#__user_usergroup_map`.`user_id` = [USER_ID]
AND `#__user_usergroup_map`.`group_id` IN (23,24,33,34)
and also run this query afterwards, but I need to set the CB field options = to actual user group values somehow like this:
Code:
data= {
northern: 003;
western: 004;
eastern: 005;
western: 006;
}
Code:
INSERT IGNORE INTO `jos_user_usergroup_map` (`user_id`, `group_id`) VALUES ('[USER_ID]', 'OPTION_SELECTED');
Would this be something the CB Query field can do or maybe CB Auto Actions?
Thank you
krileon
