Looking for a mass forum permissions mod

New Member Joined: Sep 01, 2004 Posts: 10

I seriously need a mod that does mass forum permissions so I don't have to go in and set each forum, does anyone have a hack for this?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Just write an sql query in phpMyAdmin.

Posted: Thu Feb 09, 2006 12:42 pm

I'm very newb, I don't know how.

Posted: Thu Feb 09, 2006 1:51 pm

Alright, coming back and looking at this I have to ask, if a forum was, in phpBB the first forum in the second catagory named "forum" how would I change its permissions?

Worker Joined: Dec 08, 2005 Posts: 107

Does your provider let you use phpMyAdmin or something similar? That gives you a nice GUI to examine (and change) the database. The nuke_bbforums table contains the forum names and permissions (among other things). The columns that define the permissions are that last one, which all start with auth_*.

Set the first forum to the permissions you want using the PHPNuke admin , then you can see in phpMyAdmin what the permissions are. Then you can run a query something like this:

update nuke_bbforums
set auth_view = 0,
auth_read = 0,
auth_post = 0,
auth_reply = 0,
auth_edit = 0,
auth_delete = 0,
auth_sticky = 0,
auth_announce = 0,
auth_vote = 0,
auth_pollcreate = 0,
auth_attachments = 0
where forum_id in (32,45,34,22,40,19,12)

If you want to set **all** of the columns to the exact same values, then leave off the where line. Obviously, you can/should change the values you set according to the values set for your first forum.

The way I did it, was to first set them to very restrictive values, so that only the admin could do anything. I then did the update again setting things like auth_read, auth_post to more relaxed values. Once I got to this point, I then went back into the PHPNuke admin to fine tune the values. However, at that point, there were only a few things that I needed to change.