Please Log in to join the conversation.
Please Log in to join the conversation.
SELECT`usertype` FROM `#__users` WHERE `uid`=[username];
Please Log in to join the conversation.
Ah, I see. That's no problem at all. You don't even need the query field either. What you'll need to do is use a condition for the gids field, which contains all their usergroups, but you'll need to use "Contains" operator. Example as follows.What I need, is to automaticaly have my users from groupA , from joomla, to join a private group, from groupjive, called groupA as well.
Please Log in to join the conversation.
SELECT `title`
FROM `#__usergroups` AS g, `#__user_usergroup_map` AS m, `#__users` AS u
WHERE m.user_id = u.id
AND m.group_id = g.id
AND `email` = '[email]';
Please Log in to join the conversation.
Please Log in to join the conversation.