Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
5 registered (SteveS, driv, A-GATE, Iann128, GregK), 42 Guests and 17 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 709
Top Posters (30 Days)
Ruben 51
Gizmo 24
DennyP 24
Dunny 15
SteveS 13
AllenAyres 12
SD 10
dbremer 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#216399 - 08/11/08 08:16 PM Bulk Update Forum Permissions: Is It Possible?
mmem700 Offline
newbie
Registered: 06/27/08
Posts: 35
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".

OrbisVitae.com
GlobalSkywatch.com
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#216400 - 08/11/08 08:19 PM Re: Bulk Update Forum Permissions: Is It Possible? [Re: mmem700]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
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.
Top
#216401 - 08/11/08 08:33 PM Re: Bulk Update Forum Permissions: Is It Possible? [Re: Rick]
mmem700 Offline
newbie
Registered: 06/27/08
Posts: 35
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 08:33 PM)
_________________________
Today they call you "crazy".
Tomorrow they call you "ahead of your time".

OrbisVitae.com
GlobalSkywatch.com
Top
#216402 - 08/11/08 08:35 PM Re: Bulk Update Forum Permissions: Is It Possible? [Re: mmem700]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
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.
Top
#216403 - 08/11/08 08:40 PM Rebuilding Permission Set for Logged In Users [Re: Rick]
mmem700 Offline
newbie
Registered: 06/27/08
Posts: 35
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".

OrbisVitae.com
GlobalSkywatch.com
Top
#216404 - 08/11/08 09:07 PM Re: Rebuilding Permission Set for Logged In Users [Re: mmem700]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
You'd need to purge the CACHED_PERMISSIONS table.

delete from ubbt_CACHED_PERMISSIONS
Top
#216411 - 08/11/08 10:54 PM Re: Rebuilding Permission Set for Logged In Users [Re: Rick]
SD Offline
Registered: 04/19/07
Posts: 4056
Loc: SoCal, USA
i believe clear cache purges the user Perms for all peeps smile

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

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#216415 - 08/12/08 02:12 AM Re: Rebuilding Permission Set for Logged In Users [Re: SD]
mmem700 Offline
newbie
Registered: 06/27/08
Posts: 35
Awesome. Thanks!
_________________________
Today they call you "crazy".
Tomorrow they call you "ahead of your time".

OrbisVitae.com
GlobalSkywatch.com
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image