pagecategories
MIHDev |
|
---|---|
Hi Ez,
Ok, well as far as I know from the tables this query should do it, depends on the levels set as well (possibly). Replace the Auth_GroupID = 1 with the GroupID you wish to view rights for. Replace the Auth_Rights = 1 with >=1 for all rights from Read to Admin. SELECT * FROM Sed_Auth WHERE Auth_GroupID = 1 AND Auth_Code = 'Page' AND Auth_Rights = 1 Use the Auth_Option to filter by page category. SELECT DISTINCT Auth_Option FROM Sed_Auth WHERE Auth_GroupID = 1 AND Auth_Code = 'Page' To filter you could do the following: 1. Get the GroupID of the current user. 2. Use the GroupID of the current user in the SELECT statement above to filter down the Auth_Code and avoid the need for using another select on the Sed_Structure table. Hope this helps. Happy New Year MIHDev [b]Know the question and you will be far more likely to get an answer.[/b]
|