Geeklog Forums

I am just posting this so I can find it later if I need it or someone needs help with it.

If your link is not working to your plug in the menus.
And want to check the SQL.
This don't have all the Fields for a plug. Just if your having a link problem with a plug.

There is 4 Tables you have to work with.
First "gl_groups"
It has 4 Fields.
grp_id =The number ID for the group.used in links/id
grp_name = Name of the Group
grp_descr = Description of that group
grp_gl_core = Is it a core GL Group 1=yes 0=no

Now go to "gl_group_assignments"
There is 3 Fields here.
ug_main_grp_id = The Group ID Must match grp_id in gl_groups
ug_uid = The ID of who has access. Null = default
ug_grp_id = The ID of the Group that has access.

Say you only want a Admin to get a link to it.
The Group ID is 20
20|Null|1 The 1 is the Group ID for Root.
Or say you want John smith to have access. his id is 1432

20|1432|Null

Now go to "gl_features"
There is 4 fields here.
So you can better understand the fields.
They are there to define deferent access to 1 plug.
Each access has it's own number.

ft_id = The ID that tells your site the access. Not a Group or user ID
ft_name = Name of the Access
ft_descr = description of the access
ft_gl_core = Is it Core gl. 1=yes 0=no

Say a plug a mod (limited access) and a Admin (full access) power.

it well look like this.
23|mod power|mods only|0
24|Admin power|Admins only|0

Now lets put it all together with "gl_access"
Only 2 fields here.

acc_ft_id = The "ft_id" From gl_features
acc_grp_id = The "grp_id" From gl_groups

So say were still working with the plug in with the plug in ID 20.
And we want to let the 2 groups submitted in gl_features access.

23|20
24|20

Thats it.

Hope it helps somone.