Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In with Facebook Sign In with Google Sign In with OpenID Sign In with Twitter
Support for Vanilla Forums Cloud product

In this Discussion

Follow Us


[Documentation] repair permissions feature request

edited April 2012 in Questions

I would like to request a "repair permissions" button. When setting up my forums from phpbb I did not have my default roles set so I had a lot of users created without a role. There doesn't seem to be any way to locate all users with a blank role or edit multiple users at once.

My idea is that you could click this button and then assign a role to any user that has no role defined or even change all users of one role to another.

Comments

  • ToddTodd Chief Product Officer Vanilla Staff

    Good idea. In the meantime try the following SQL:

    insert ignore GDN_UserRole (UserID, RoleID)
    select u.UserID, XXX
    from GDN_User u
    left join GDN_UserRole ur
      on u.UserID = ur.UserID
    where ur.UserID is null;
    

    Replace XXX with the RoleID of the role you want to use.

  • I tried this code but it doesn't work for me.

    Todd said: Good idea. In the meantime try the following SQL:

    insert ignore GDN_UserRole (UserID, RoleID)
    select u.UserID, XXX
    from GDN_User u
    left join GDN_UserRole ur
      on u.UserID = ur.UserID
    where ur.UserID is null;
    

    Replace XXX with the RoleID of the role you want to use.

  • peregrineperegrine MVP
    edited May 2012

    "Doesn't work" doesn't help somebody solve your problem - you need to give a wee bit more of an explanation.

    remove the ignore? and probably 8 is the roleid you want for members

    Do you see any nulls in your UserRole table?

    if yes, after you run the code

    do you still see nulls?

    Monetary Donations will be appreciated if you use my plugins. Thanks in Advance.
    As a waiter gets a tip for a good meal, tips for successful solutions appreciated as well. Peregrine

    UnderDog
Sign In or Register to comment.