Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jun 2008
Posts: 92
Likes: 1
M
Journeyman
Journeyman
M Offline
Joined: Jun 2008
Posts: 92
Likes: 1
I was wondering if there is a way to bulk-update permissions of all forums at once.

This would save a lot of clicking (and time) for a large forum.

Thanks!


Today they call you "crazy".
Tomorrow they call you "ahead of your time".
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Currently, there is only one real way that might save time. If you have many forums that need to have their permissions changed to the same permission set, then what you could do is:

Modify the "New Forum Template" in the permission editor. At that point, you could bring up each forum, and then just choose the copy option to copy the New Forum Template permissions, and then update it.

Definitely need to spend more time in this area to make it easier to edit permissions on a larger scale.

Joined: Jun 2008
Posts: 92
Likes: 1
M
Journeyman
Journeyman
M Offline
Joined: Jun 2008
Posts: 92
Likes: 1
OK, thanks. That's how I've done it in the past.

I admin my own machine so I can work with the database directly. Is there a list of field usage somewhere that I could use as a guide?

Thanks!

I need to add file-attach capability to all forums. Could I just:

SQL Query
UPDATE my_FORUM_PERMISSIONS SET FILE_TOTAL = 3;

Last edited by mmem700; 08/11/2008 8:33 PM.

Today they call you "crazy".
Tomorrow they call you "ahead of your time".
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
There's no list, but you can just use

SHOW FIELDS from ubbt_FORUM_PERMISSIONS to get the list and most are fairly obvious as to what they do.

And yes, that query would work, but since it won't rebuild the permission set for logged in users you'll need to log out and then back in, in order to see the change on the forum itself.

Joined: Jun 2008
Posts: 92
Likes: 1
M
Journeyman
Journeyman
M Offline
Joined: Jun 2008
Posts: 92
Likes: 1
Excellent. Thanks.

Is there a way to force a rebuild of the permission set for logged in users?


Today they call you "crazy".
Tomorrow they call you "ahead of your time".
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
You'd need to purge the CACHED_PERMISSIONS table.

delete from ubbt_CACHED_PERMISSIONS

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
i believe clear cache purges the user Perms for all peeps smile

PHP Code
$userob->clear_cached_perms(); 

Joined: Jun 2008
Posts: 92
Likes: 1
M
Journeyman
Journeyman
M Offline
Joined: Jun 2008
Posts: 92
Likes: 1
Awesome. Thanks!


Today they call you "crazy".
Tomorrow they call you "ahead of your time".

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Havenofsobriety), 522 guests, and 99 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)