Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
1 registered (1 invisible), 20 Guests and 22 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 02/13/08
Posts: 1
Top Posters (30 Days)
Ruben Rocha 103
Rick 81
Mark S 72
Thelockman 56
Gizmo 50
driv 35
Sirdude 30
ntdoc 30
packlite 24
AllenAyres 22
Latest Photos
bear test
Beach Barbie-Q
Sunset
Accept the challenge!
Trees
Topic Options
Rate This Topic
#216399 - 08/11/08 05:16 PM Bulk Update Forum Permissions: Is It Possible?
mmem700 Offline
stranger

Registered: 06/26/08
Posts: 22
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".

Herb Allure:
Alternative Health, Mercury Poisoning (dental fillings), Chemtrails, Conspiracies

Top
#216400 - 08/11/08 05:19 PM Re: Bulk Update Forum Permissions: Is It Possible? [Re: mmem700]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7993
Loc: Aberdeen, WA
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.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#216401 - 08/11/08 05:33 PM Re: Bulk Update Forum Permissions: Is It Possible? [Re: Rick]
mmem700 Offline
stranger

Registered: 06/26/08
Posts: 22
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;


Edited by mmem700 (08/11/08 05:33 PM)
_________________________
Today they call you "crazy".
Tomorrow they call you "ahead of your time".

Herb Allure:
Alternative Health, Mercury Poisoning (dental fillings), Chemtrails, Conspiracies

Top
#216402 - 08/11/08 05:35 PM Re: Bulk Update Forum Permissions: Is It Possible? [Re: mmem700]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7993
Loc: Aberdeen, WA
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.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#216403 - 08/11/08 05:40 PM Rebuilding Permission Set for Logged In Users [Re: Rick]
mmem700 Offline
stranger

Registered: 06/26/08
Posts: 22
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".

Herb Allure:
Alternative Health, Mercury Poisoning (dental fillings), Chemtrails, Conspiracies

Top
#216404 - 08/11/08 06:07 PM Re: Rebuilding Permission Set for Logged In Users [Re: mmem700]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7993
Loc: Aberdeen, WA
You'd need to purge the CACHED_PERMISSIONS table.

delete from ubbt_CACHED_PERMISSIONS
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#216411 - 08/11/08 07:54 PM Re: Rebuilding Permission Set for Logged In Users [Re: Rick]
Sirdude Offline

*****

Registered: 04/19/07
Posts: 2127
Loc: SoCal, USA
i believe clear cache purges the user Perms for all peeps smile

Php Code:
$userob->clear_cached_perms(); 
_________________________


Top
#216415 - 08/11/08 11:12 PM Re: Rebuilding Permission Set for Logged In Users [Re: Sirdude]
mmem700 Offline
stranger

Registered: 06/26/08
Posts: 22
Awesome. Thanks!
_________________________
Today they call you "crazy".
Tomorrow they call you "ahead of your time".

Herb Allure:
Alternative Health, Mercury Poisoning (dental fillings), Chemtrails, Conspiracies

Top


Shout Box

Today's Birthdays
theregit
Recent Topics
New members don't get access and are not displayed in the config panel
by Yomar
Yesterday at 03:32 AM
How to Change Link Color / Underline in styles?
by ECNet
01/07/09 10:00 PM
Chaging the "max online" number and date
by wanted
01/07/09 02:22 PM
7.4.1. In Threaded Mode - "Mark All Read" Doesn't Work
by packlite
01/07/09 10:26 AM
Custom island with sql connection
by Robje01
01/07/09 09:13 AM
Forum Stats
4296 Members
33 Forums
30687 Topics
156017 Posts

Max Online: 978 @ 06/24/07 08:19 PM