Previous Thread
Next Thread
Print Thread
Hop To
How do I make my boards read-only? #227662 07/14/2009 6:52 PM
Joined: Nov 2004
Posts: 173
luket Offline OP
enthusiast
OP Offline
enthusiast
Joined: Nov 2004
Posts: 173
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
Re: How do I make my boards read-only? [Re: luket] #227664 07/14/2009 8:52 PM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
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

Re: How do I make my boards read-only? [Re: Rick] #227667 07/15/2009 12:52 PM
Joined: Nov 2004
Posts: 173
luket Offline OP
enthusiast
OP Offline
enthusiast
Joined: Nov 2004
Posts: 173
thanks Rick smile


Member since November 2004
Gold Member since Feb 2008
Re: How do I make my boards read-only? [Re: luket] #227668 07/15/2009 1:52 PM
Joined: Nov 2004
Posts: 173
luket Offline OP
enthusiast
OP Offline
enthusiast
Joined: Nov 2004
Posts: 173
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
Re: How do I make my boards read-only? [Re: luket] #227669 07/15/2009 2:03 PM
Joined: Dec 2003
Posts: 6,017
Likes: 1
Ruben Online Yawn
Online Yawn
Joined: Dec 2003
Posts: 6,017
Likes: 1
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
Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Subscriptions Question
by Ruben - 01/14/2020 12:11 PM
Page won't load after 7.7.3 Update
by Jim0421 - 01/08/2020 11:11 AM
Ubb 7.7.3 winkey emoji shortcut issue
by Ruben - 01/07/2020 4:04 PM
testing winkey emoji shortcut
by Ruben - 01/06/2020 2:36 PM
Very strange problem
by Baldeagle - 01/05/2020 1:22 PM
Who's Online Now
1 members (Ruben), 72 guests, and 338 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20200106)