How can I update primary and secondary group for a selection of users?

[Chris81]

Hi,

I have imported a phphBB 3 forum into IPS 4.1 and after that conversion I discovered that some users have a primary group other than Members.
Is it possible to - script wise / sql wise / plugin wise - change the primary group for these members to Members and have their current primary group set as secondary group?

For instance:
User A - primary group Barber -> User A - primary group Members - secondary group Barber

I haven't found a way to do member management from group perspective.
I have to go to the member and change the group, I can't go to groups and select / deselect members.

Maybe there is a plugin for it? (Which I haven't found so far).

Thank you in advance!

Chris

[Cookie Monster]

I would suggest make a SQL query for this.

SELECT
core_members.member_group_id,
core_members.`name`,
core_members.member_id,
core_members.mgroup_others
FROM
core_members
WHERE
core_members.member_group_id = 3

Replace 3 with the group ID of members (normally 3 is Members)

When running this query it will show you a list of all members.

the mgroup_others is the secondary group.

So here you then could Change member_group_id to their new id and add 3 as their mgroup_others (to give them secondary)

[Chris81]

Ok, I can work with that. Thanks!
I can't see where the group names are registered in the databse...I see core_groups, but not with a group name. If I can correlate the group ID to the group name I should be set.

[Cookie Monster]

Hover over the edit button or click edit on a group, in the URL at the end it should say something like ID = X

where X is the number for that group

[Chris81]

Awesome! Thanks

[Cookie Monster]

Let me know if it works and solved your problem then @Chris81

[Chris81]

I have enough to work with. This can be marked as resolved.

[Cookie Monster]

The question(s) in this support topic have been answered and the topic author has resolved their issue. This topic is now closed. If you have other questions, please open a new topic.