Khaos :: KhACL

[eluser]depthcharge[/eluser]
Hi Neophyte,

Ah, i new something was wrong, I wasn't paying attention to the left and right numbers in my table. and me adding 2 roots. thanks adamp1.

Having looked at the code i think the aros tree query should be something like the following, to make it select the aros and all aros parents, so it gets the right interested array. Same thing with the acos i guess.

Code:

/*
* Retrieve the data needed to determine the AROs access
* and extensions to the specified ACO.
*/

$ci->db->select('branch.id, branch.name, branch.link');
$ci->db->from($tables['aros'].' AS tree');
$ci->db->join($tables['aros'].' AS branch', 'branch.lft <= tree.lft AND branch.rgt >= tree.rgt', 'inner');
$ci->db->where('tree.name', $aro);
$ci->db->order_by('branch.lft', 'ASC');
$rs = $ci->db->get();

and the same with the acos i guess, I will take a look also as soon as i can.

I am sure this could be done with the 1 sql query, which would make looping in your code minimum, and make mysql do the work which it is good at.

UPDATE

The following sql gives you the Y or N result of a users access to an aco

It needs testing and clean up, maybe joins are not final.

Code:

SELECT allow
FROM `khacl_aros` as tree JOIN `khacl_aros` AS branch ON (branch.lft <= tree.lft AND branch.rgt >= tree.rgt)
LEFT JOIN khacl_access AS access ON (access.aro_id = branch.id)
LEFT JOIN khacl_acos AS acostree ON (acostree.name = $aco)
RIGHT JOIN khacl_acos AS acosbranch ON (acosbranch.lft <= acostree.lft AND acosbranch.rgt >= acostree.rgt)
WHERE tree.name = $aro AND access.aco_id = acosbranch.id
ORDER BY branch.rgt, acosbranch.rgt
limit 0,1

I have not played with axo's at all yet, but I am sure it can be included in the query. And with mysql caching maybe speed can be improved.

Woah 3am, i gotta sleep

Thanks

Lee