SQL queries for changing user permission in all forums

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
Thanks in advance
Registered User
Posts: 173
Joined: Mon Dec 28, 2009 8:17 am

SQL queries for changing user permission in all forums

Post by Thanks in advance »

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!
User avatar
Brf
Support Team Member
Support Team Member
Posts: 52298
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: SQL queries for changing user permission in all forums

Post by Brf »

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
Registered User
Posts: 173
Joined: Mon Dec 28, 2009 8:17 am

Re: SQL queries for changing user permission in all forums

Post by Thanks in advance »

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).
Last edited by Thanks in advance on Thu Oct 20, 2011 6:54 pm, edited 1 time in total.
User avatar
Lumpy Burgertushie
Registered User
Posts: 68550
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: SQL queries for changing user permission in all forums

Post by Lumpy Burgertushie »

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
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
Thanks in advance
Registered User
Posts: 173
Joined: Mon Dec 28, 2009 8:17 am

Re: SQL queries for changing user permission in all forums

Post by Thanks in advance »

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

Code: Select all

UPDATE phpbb_forums SET forum_status=1
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70432
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: SQL queries for changing user permission in all forums

Post by KevC »

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.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
Thanks in advance
Registered User
Posts: 173
Joined: Mon Dec 28, 2009 8:17 am

Re: SQL queries for changing user permission in all forums

Post by Thanks in advance »

Ok, thanks everybody!
Locked

Return to “[3.0.x] Support Forum”