listing users with an specific rol

argie01

Hi, is there a way to list all the users that belong to an specific rol? Thank you!

Minisweeper

Try using the advanced search.

argie01

Thank you very much!

argie01

Anybody could give an sql query code to execute in my phpmyadmin and get a listing of members that belong to an specific rol? The problem with the advance search is that I have to do a copy/paste for each name of user to get a list of them... Thank you!

Minisweeper

SELECT 'Name' FROM 'LUM_USER' WHERE 'RoleID'=4; Should work I think... change the 4 for whichever ID you need. You can find them in the LUM_Role table.

sirlancelot

SELECT u.UserID, u.Name, r.Name, u.FirstName, u.LastName, u.Email FROM LUM_User AS u, LEFT JOIN LUM_Role AS r USING RoleID WHERE r.Name = 'Banned';
You can change the WHERE clause to r.RoleID = '1' and select by the RoleID if you know that, or leave it as-is and use the Role Name. The query will show the User Name, Real Full Name, Email Address, User ID, and Role Name.

What exactly are you trying to do? The advanced search in Vanilla is pretty powerful and will show all users in a single so you shouldn't have to use this query.

argie01

Thank you!! I know the advanced search is useful to do it. But I need a listing of user of a rol, and if I use the advanced search I should copy/paste for each user returned to an excel. Instead it, by using an sql query I do not need to copy/paste for each user, because I just need 1 copy/paste :)