Automated creation of usergroup and subforum with permissions

[petteyg359]

I have several scripts running on my site that verify forum users against the EVE Online API. Currently, when a new group joins, I have to manually create their usergroup, subforum, and set the permission of that forum. Would it be possible to write a query or two to automatically create the usergroup, create a subforum with the title being the same as the usergroup, and set permissions for the subforum so usergroupids ex. 14 to 32 have "deny all" permissions, the usergroup I've just created gets "allow all" permissions, and previously created subforums (ex. ids 15-20) have "deny all" permission for the new usergroup?

If that's too complicated, is there a readable explanation somewhere of the numbers in the permissions columns of the vB tables?

Say I have groupa, groupb, groupc. Say I have a forum called "Groups". Then I have a subforum of Groups for each usergroup, subforum titled the same as the usergroups, so

Forum
-Groups
--groupa
--groupb
--groupc

Permissions:
groupa inherits default for admins/mods/coppa/banned etc. and then groupa has all yes, and groupb and groupc have all no.
groupb inherits default for admins/mods/coppa/banned etc. and then groupb has all yes, and groupa and groupc have all no.
groupc inherits default for admins/mods/coppa/banned etc. and then groupa has all yes, and groupa and groupb have all no.

So my script finds a new user who should be in groupd. It would check to see if groupd exists. If not, it would then execute whatever query (Q1) to create groupd. It would then check for forum groupd. If it doesn't find it, it would execute a query (Q2) to create the subforum. Then another query (Q3) would set forum groupd to inherited admins/mods/coppa/banned etc., groupa/b/c all no, groupd all yes. It would then change the forums groupa, groupb, and groupc, and add permissions for groupd all no to each.