UPDATE `ubbt_FORUM_PERMISSIONS` SET `SEE_FORUM` = '-1', `READ_TOPICS` = '-1', `CREATE_TOPICS` = '-1', `CREATE_REPLIES` = '-1' WHERE `ubbt_FORUM_PERMISSIONS`.`GROUP_ID` = 6 AND `ubbt_FORUM_PERMISSIONS`.`FORUM_ID` = '2'

This is to save time,
with having the best part of 100 forums and to update them using the control panel permissions screen, was taking for ever. So i created the above SQL to do them 1 at a time.

Would this have updated all in one go ?
6 = The Group


UPDATE `ubbt_FORUM_PERMISSIONS` SET `SEE_FORUM` = '-1', `READ_TOPICS` = '-1', `CREATE_TOPICS` = '-1', `CREATE_REPLIES` = '-1' WHERE `ubbt_FORUM_PERMISSIONS`.`GROUP_ID` = 6

Cheers
i also found that it does remove human error when doing it this way and not 1 at a time screen by scree via the control panel permissions screen.

Wish i was a swish as SD when it come to the SQL stuff.

Possible 7.5.6 Bug above.

Adding the SQL to Sql Tgs or Code Tags breaks the code try it and see it stops at _ Uderscore.

and



much more readable too

back ticks are the devil's spawn

Thank you SD

Apreciated that will save me Hrs of work and prevent Human error over so many forums.

Huge Thanks

mass permission copy does the same thing, so i don't know why you aren't using that ?

i guess i'm assuming the mass copy works for NEW forums wanting to copy a Set of Permissions from 1 Forum to many. So Duplicating that Template.

Ive not looked at the Mass Copy Permissions Function.

But in the case above,

I have say 100 Forums
and there very unique in there settings for various groups to see and not see etc. . . SO the above Group 6 is a Restricted access Where i can lock down a user to Group being a Restricted user to only see the ADMIN Holding forum.

So my understaning is that the Mass Permissions works creating new forums, but my request is a Retro Fit to use an existing Group but change who can see it and what.

Hope that makes sense.

Mark I have played with that permissions thing quite a bit since 7.X.X came out and it is pretty easy to use for mass permissions. It will do what I think you are looking for.... say 3 forums with this permissions set and 15 others with another type of permission set... it will do that... you just have to have one that is set up he way you want the permissions for the rest then use the Copy function to add it to all the others of the same permissions.


Dunny

yup... Dunny perty much sums it up...

use mass permission copy, instead of sql queries

For me regardless of all the other settings in each forum,
i only needed these ones updated.

SEE_FORUM = -1, (Forum is Visible)
READ_TOPICS = -1, (Can Read Topics)
CREATE_TOPICS = -1, (Create New Topic)
CREATE_REPLIES = -1 (Reply to a Topic)

This 1 Forum which i set up as a Holding Room.
So anyone i assign to Group 6 can not see / reply / or post a new topic or see anyother forums.

The Mass Copy for me would not work as i also have in the mix Hidden Private forums, so there are custom settings all over the place.

I Have previously used copy forum permissions for new forums but this one is chagning the permissions of an existing group.

What i see from the menus with the mass copy option is the copy all the settings from that forum to many which isnt what i had to do, i have to change a Groups settings to fit all the other settings.

Mark

I was thinking the same thing about the mass copy feature.
Make one forum the way you want and go to town selecting all the forums you want to change.
With the query method I am not so sure you would change the time involved or make any difference in the human error factor.