Secondary Usergroups Query?

[Reeve of shinra]

I have a list of user id's that I would like to add to a secondary usergroup (in addition to any that they may already have) .. does anyone know what the query for that would be?

[Andreas]

[sql]
update user set membergroupids=if(membergroupids != '', concat_ws(',', membergroupids, '10'), '10') where userid in (1,2,3,4)
[/sql]
This should give the users 1,2,3 and 4 the additional membergroup 10

[Davey]

How would you select all members from 1 specific group (not necessarily their primary group) and list them out?
(sorry if this is a bit off-topic, I'd sooner have not created another thread and clutter the place up)

[Andreas]

[sql]
SELECT * FROM user WHERE FIND_IN_SET('8', membergoupids) OR usergroupid=8;
[/sql]

This will select all members (additional and primary) in group 8.

[T3MEDIA]

Originally Posted by KirbyDE

[sql]
SELECT * FROM user WHERE FIND_IN_SET('8', membergoupids) OR usergroupid=8;
[/sql]

This will select all members (additional and primary) in group 8.

KirbyDE EVEN MORE offtopic... how do you do a conditional for secondary groups...

I tried <if condition="$bbuserinfo['usergroupid'] == '10' || $bbuserinfo['usergroupid'] == '11' || $bbuserinfo['usergroupid'] == '12' || $bbuserinfo['usergroupid'] == '13' || $bbuserinfo['usergroupid'] == '14' || $bbuserinfo['usergroupid'] == '15'"> stuff </if>

and it didnt work as well as it looks ugly. I tried arrays and got nothing as well. But I think it is becuase my code is looking for primary usergroups...

I want secondary. any help would be great.

[Andreas]

Use is member_of().
If you want to check for several groups i'd suggest do use this hack:
https://vborg.vbsupport.ru/showthread.php?t=61149