1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mass query to allow guest to see everything

Discussion in 'Installation, Upgrade, and Import Support' started by Brandon Sheley, Apr 16, 2013.

  1. Brandon Sheley

    Brandon Sheley Well-Known Member

    I imported a database with tons of forums in it that were set to private before for guest.
    I've been going through one at a time and it's taking forever.
    Is there a query that I could run to allow all forums to be seen by guest.

    I need this group

    Unregistered / Unconfirmed (ID1)

    I need to allow these these 3 options for all forums.

    View threads by others:
    View thread content:
    View attachments to posts:

    I hope someone can help me with this quickly (y)
  2. Brandon Sheley

    Brandon Sheley Well-Known Member

    Can anyone help on this?
    It would really save me a few hours of clicking if so. :)
  3. Brogan

    Brogan XenForo Moderator Staff Member

    You can't really edit the permissions using queries.
    Your only option is to configure them all via the ACP.
    Brandon Sheley likes this.
  4. Brandon Sheley

    Brandon Sheley Well-Known Member

    bummer, I was afraid of that

    Thanks for the reply :)
  5. 0ptima

    0ptima Well-Known Member

    Why cant a SQL be run to set permissions?
  6. James

    James Well-Known Member

    It may be possible to do by inserting into xf_permission_entry, but I imagine there are way too many dependencies to make this feasible.

    There are methods to insert permissions into the db via XenForo_Model_Permission, but again quite complex.

    You may as well just use the quick select and select yes for the unregistered permissions.

Share This Page