mass query to allow guest to see everything

[Brandon Sheley]

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

 

[Brandon Sheley]

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

 

[Paul B]

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

 

[Brandon Sheley]

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

bummer, I was afraid of that

Thanks for the reply

 

[0ptima]

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

Why cant a SQL be run to set permissions?

 

[James]

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.