Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
5 registered (24hourcampfire, Bill B, ChevyGuy, FordDoctor, Gardener), 14 Guests and 19 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 01/10/04
Posts: 1703
Top Posters (30 Days)
Ruben Rocha 179
Gizmo 112
Rick 109
Thelockman 80
driv 43
AllenAyres 35
ntdoc 28
Ian 24
Sirdude 23
ScriptKeeper 20
Latest Photos
My Home System
test photo gallery
Bernese Mountain Dogs
My Daimler
Dorado and shark
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: 7898
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: 7898
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: 7898
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: 2077
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
brushie, cass, Monte G., twebman, White Gold Wielder
Recent Topics
Shrinking graemlins
by Djuma
Today at 05:48 PM
2 problems I'm seeing now.
by DougMM
Today at 04:39 PM
Which CSS Style Controls the bottom lines
by David DelMonte
Today at 01:51 PM
UBBThreads vs. vBulletin -- Defections & Why So Tough to Compare?
by WebMagic
Today at 12:28 PM
Font and column shifts occuring
by Bill B
Yesterday at 06:21 PM
Forum Stats
4261 Members
33 Forums
30532 Topics
154962 Posts

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