Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
3 registered members (Ruben, isaac, Gizmo), 49 guests, and 382 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Posts: 82
Joined: September 2008
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 16
M4TT 12
FREAK 11
Ruben 8
mmkk 5
isaac 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
Bulk Update Forum Permissions: Is It Possible? #216399
08/11/08 07:16 PM
08/11/08 07:16 PM
Joined: Jun 2008
Posts: 36
M
mmem700 Offline OP
newbie
mmem700  Offline OP
newbie
M
Joined: Jun 2008
Posts: 36
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
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."
Re: Bulk Update Forum Permissions: Is It Possible? [Re: mmem700] #216400
08/11/08 07:19 PM
08/11/08 07:19 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
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.

Re: Bulk Update Forum Permissions: Is It Possible? [Re: Rick] #216401
08/11/08 07:33 PM
08/11/08 07:33 PM
Joined: Jun 2008
Posts: 36
M
mmem700 Offline OP
newbie
mmem700  Offline OP
newbie
M
Joined: Jun 2008
Posts: 36
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/08 07:33 PM.

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

OrbisVitae.com
GlobalSkywatch.com
Re: Bulk Update Forum Permissions: Is It Possible? [Re: mmem700] #216402
08/11/08 07:35 PM
08/11/08 07:35 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
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.

Rebuilding Permission Set for Logged In Users [Re: Rick] #216403
08/11/08 07:40 PM
08/11/08 07:40 PM
Joined: Jun 2008
Posts: 36
M
mmem700 Offline OP
newbie
mmem700  Offline OP
newbie
M
Joined: Jun 2008
Posts: 36
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
Re: Rebuilding Permission Set for Logged In Users [Re: mmem700] #216404
08/11/08 08:07 PM
08/11/08 08:07 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
You'd need to purge the CACHED_PERMISSIONS table.

delete from ubbt_CACHED_PERMISSIONS

Re: Rebuilding Permission Set for Logged In Users [Re: Rick] #216411
08/11/08 09:54 PM
08/11/08 09:54 PM
Joined: Apr 2007
Posts: 4,313
SoCal, USA
SD Offline
Carpal Tunnel
SD  Offline
Carpal Tunnel
Joined: Apr 2007
Posts: 4,313
SoCal, USA
i believe clear cache purges the user Perms for all peeps smile

PHP Code
$userob->clear_cached_perms(); 

Re: Rebuilding Permission Set for Logged In Users [Re: SD] #216415
08/12/08 01:12 AM
08/12/08 01:12 AM
Joined: Jun 2008
Posts: 36
M
mmem700 Offline OP
newbie
mmem700  Offline OP
newbie
M
Joined: Jun 2008
Posts: 36
Awesome. Thanks!


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

OrbisVitae.com
GlobalSkywatch.com

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Users Unable to Upload Avatar [Not a Bug]
by M4TT. 12/13/17 08:51 AM
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
Forum Statistics
Forums36
Topics35,015
Posts190,540
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)