Thanks Kyle but I am not a developper, just trying to make something as you don't have proper integration with K2 and it is impossible to add a user to K2 group when using CB !
With CB integration enabled in K2 and CB Articles installed to CB and set to K2 you don't need K2s users table, it won't be used for display anywhere. The integration is "proper" and complete, we've communicated well with the K2 team to ensure it was.
K2 groups aren't needed to establish permissions to K2 tasks, see K2 > Parameters > Permissions and you can assign permissions to Joomla usergroups. K2 groups are basically there as before J2.5 such feature wasn't available.
Please could you help me on this one and correct my awrful try ??
Below should do the trick.
Code:
INSERT INTO `#__k2_users` ( `userID`, `userName`, `group` ) VALUES ( '[user_id]', '[USERNAME]', 3 )
ON DUPLICATE KEY UPDATE `userName` = '[USERNAME]', `group` = 3;
krileon
