Previous Thread
Next Thread
Print Thread
Hop To
Joined: Nov 2004
Posts: 198
L
Member
Member
L Offline
Joined: Nov 2004
Posts: 198
I would like to leave my boards available for read-only access. IS there an easy to do this globally for all forums?


Member since November 2004
Gold Member since Feb 2008
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
The easiest and quickest way is just to do a SQL call if you want them read only for everyone (which it looks like you do). The following SQL command will get rid of the ability to create topics and replies for all groups, including the admin group, so be sure that's what you want wink You can always re-enable the admin group if you want afterward.

SQL Query
update ubbt_FORUM_PERMISSIONS
set CREATE_TOPICS = 0,
CREATE_REPLIES = 0

You'll then need to purge the cached permissions

SQL Query
delete from ubbt_CACHED_PERMISSIONS

Joined: Nov 2004
Posts: 198
L
Member
Member
L Offline
Joined: Nov 2004
Posts: 198
thanks Rick smile


Member since November 2004
Gold Member since Feb 2008
Joined: Nov 2004
Posts: 198
L
Member
Member
L Offline
Joined: Nov 2004
Posts: 198
Turns out there is a "Mass Permission copy" for the forums that does what I want.

I just selected one of my existing 'read-only' forums and used it as the template permissions to mass-copy to all the rest of the forums. Worked great, was easy and fast and didn't require any SQL black-magic.


Member since November 2004
Gold Member since Feb 2008
Joined: Dec 2003
Posts: 6,562
Likes: 78
Joined: Dec 2003
Posts: 6,562
Likes: 78
Well that works too.
But Ricks suggestion would have been quicker.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
spam issues
by ECNet - 03/19/2024 11:45 PM
Who's Online Now
1 members (Nightcrawler), 963 guests, and 210 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)