SQL queries for changing user permission in all forums

Thanks in advance · Post by **Thanks in advance** » Thu Oct 20, 2011 5:52 pm

I have a lot of forums and would like to temporary change the permissions for all types of users and guests (except moderators and admins) so that they can just read topics, but not open a new thread or reply to one. I'd really really appreciate if someone more knowlegeable could tell me the right SQL queries. Thanks in advance!

Post by **Brf** » Thu Oct 20, 2011 5:59 pm

We do not recommend changinf such things through SQL statements.

How about editing the Forum permission Role you are using for standard users?
Edit Standard Access(or whichever one you are using), so it is read only.

Thanks in advance · Post by **Thanks in advance** » Thu Oct 20, 2011 6:19 pm

I checked the ACP for like 10 minutes and still couldn't figure out how to do that (achieve that guests, users, newly registered user... can just read forums without me making changes to all my forums).

Lumpy Burgertushie · Post by **Lumpy Burgertushie** » Thu Oct 20, 2011 6:35 pm

there probably isn't one because there are so many different places that have to be changed.

why not just disable the board for the few minutes it will take to restore the database backup?

roberrt

Thanks in advance · Post by **Thanks in advance** » Thu Oct 20, 2011 6:48 pm

Ok, that does the trick for me, locks all forums:

Code: Select all

UPDATE phpbb_forums SET forum_status=1

Post by **KevC** » Thu Oct 20, 2011 6:56 pm

What Brf is saying is that is you go to the admin panel permissions tab, about 3/4 of the way down are the permission roles. These are the 'default' permission setups.

Your users are probably set to standard access or standard access + polls for all your forums.

So, edit that permission role and set the 'can start new topics' and 'can reply' permissions to never.

That will allow them to read but not post for a while until you're done. Then change them back to yes.

Thanks in advance · Post by **Thanks in advance** » Thu Oct 20, 2011 7:23 pm

Ok, thanks everybody!

advertisements