Move members from one custom usergroup to another??

[XUG]

Hello

Could somebody help me with a command line for MYSQL that does the following:

I have 3 custom usersgroups which I want to combine all in one.

Usersgroup A is the biggest one and B and C are somewhat smaller.

To do it not all in one so I can check that one group went fine I would like to have a MYSQL command that places all members from usergroup B into usersgroup A, later I can do the same command to move all from C into A.

Please help.

[XUG]

Hello

Could somebody help me with a command line for MYSQL that does the following:

I have 3 custom usersgroups which I want to combine all in one.

Usersgroup A is the biggest one and B and C are somewhat smaller.

To do it not all in one so I can check that one group went fine I would like to have a MYSQL command that places all members from usergroup B into usersgroup A, later I can do the same command to move all from C into A.

Please help.


Please, I need some help here.

[Lats]

This will help...

UPDATE user SET usergroupid='C' WHERE userid='B'

[XUG]

This will help...

UPDATE user SET usergroupid='C' WHERE userid='B'

Thank you so much.

And shouldn't it be:

UPDATE user SET usergroupid='A' WHERE usergroupid='B'

and then for the second one:

UPDATE user SET usergroupid='A' WHERE usergroupid='C'

this because i want to bring users from usergroupid'B' to usergroupide'A'
and also want to bring usergroupid'C' to usergroup'A'

??????

[merk]

Thank you so much.

And shouldn't it be:

UPDATE user SET usergroupid='A' WHERE usergroupid='B'

and then for the second one:

UPDATE user SET usergroupid='A' WHERE usergroupid='C'

this because i want to bring users from usergroupid'B' to usergroupide'A'
and also want to bring usergroupid'C' to usergroup'A'

??????
Youd need to use some string manipulation if you were going to have users of many subgroups to other subgroups.

edit: And doing the above query will change the PRIMARY usergroup. Not the subgroups.

And im just too tired to look at the schema in pma to work it out :\ Sorry :(

[XUG]

Youd need to use some string manipulation if you were going to have users of many subgroups to other subgroups.

edit: And doing the above query will change the PRIMARY usergroup. Not the subgroups.

And im just too tired to look at the schema in pma to work it out :\ Sorry :(

Subgroup?

I'm talking about the usersgroups like 'Admin' 'Supermod' 'Member' etc.
Do they have subgroups? I don't think I use that on my forum!

[Lats]

Just give it a go XUG, on your test board first :)