MyBB Community Forums

Full Version: SQl query to copy user group's permissions in ALL forums
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
1- When creating a new user group B, does "Copy Permissions From..." option allow to copy forum permissions from the source group A as well?
I mean: everything group A can/cant do in forum1, forum2, forum3..etc, Group B can/cant do as well,

2-Now what about default user groups? I want to copy Guest group's permission on ALL forum to Awaiting Activation group, I mean everything Guests cant do in a forum Awaiting activation cant do also
Going through all forum one by one, checking and un-checking is quite tedious , so is there any SQL query to mass set permissions?
It's in cache too...so it's more complicated than a single query.
Thanks
does it mean there is no hope !? Sad
2) Set Global permissions to "Awaiting ativation" in AdminCP=>usegroups, then in PHPmyAdmin delete entries with custom permissions in mybb_forumpermissions table. 'Awaiting activation' has a "gid" (Group ID) you can check that in AdminCP.

Thank you aglioeolio
Can you explain more in details?
Will other group's permissions be affected by deleting mybb_forumpermissions table?