[Documentation] Users have been Orphaned how do i auto add them all to a role?

H00j

I have about 25 pages of users and several random ones have been orphaned is there away i can add them all to a group with out doing everypage manually

UnderDog

I have no solution, but a couple of MySQL selects to figure out more information:
All users which do not have a Role in the UserRole table:

select u.UserID
from GDN_User u
left join GDN_UserRole ur
on u.UserID = ur.UserID
where ur.UserID is null;

All users with multiple Roles:

select u.UserID
from GDN_User u
join GDN_UserRole ur
on u.UserID = ur.UserID
GROUP BY ur.RoleID
ORDER BY ur.RoleID DESC;

edit
Also figure out exactly what you want to do with which type of users.

For example : For every user that has role 33 I want him to give only role 8
Every user that has role 27 will only get role 33
etcetera etcetera

peregrine

Do you want to switch them all to one user.

or do you want to change the role for a select number of users?

what do you mean 25 pages?

if you have access to phpmyadmin

you could just place a check box next to each userid you want to change the role on on update to the new roleid you want. or you could use mysql.

if you really are changing roles - look in UserRole table.

Todd

You'll need to run a bit of SQL. Check out this discussion.

UnderDog

H00j said:
I have about 25 pages of users and several random ones have been orphaned is there away i can add them all to a group with out doing everypage manually

I agree with what my neighbours above me said and I have something to add. Figure out why you have 25 pages of users without a Role attached. Did you delete a Role? In that case let us know here please :-)

This fixing of the Users' role could be something interesting to enhance a plugin or core functionality :-)

H00j

UnderDog said:

H00j said:
I have about 25 pages of users and several random ones have been orphaned is there away i can add them all to a group with out doing everypage manually

I agree with what my neighbours above me said and I have something to add. Figure out why you have 25 pages of users without a Role attached. Did you delete a Role? In that case let us know here please :-)

This fixing of the Users' role could be something interesting to enhance a plugin or core functionality :-)

Sorry i made it unclear, i have 25pages of users, most have a role, however about 15 of the 25 do not. The delete role and migrate to another role button wouldn't work for me so i had to delete without.

H00j

Okay from SQL it looks like they are not orphaned they just have multiple role ids, how do i fix this so they only have one?

--------+--------+
| UserID | RoleID |
+--------+--------+
|    785 |      8 |
|    785 |     27 |
|    785 |     33 | 

UnderDog

I have no solution, but a couple of MySQL selects to figure out more information:
All users which do not have a Role in the UserRole table:

select u.UserID
from GDN_User u
left join GDN_UserRole ur
on u.UserID = ur.UserID
where ur.UserID is null;

All users with multiple Roles:

select u.UserID
from GDN_User u
join GDN_UserRole ur
on u.UserID = ur.UserID
GROUP BY ur.RoleID
ORDER BY ur.RoleID DESC;

edit
Also figure out exactly what you want to do with which type of users.

For example : For every user that has role 33 I want him to give only role 8
Every user that has role 27 will only get role 33
etcetera etcetera