[eluser]Stylec[/eluser]
Hi, I seem to be having a problem gettings this working.
I've set up the database and tables and can use the example code to create the objects in them, but when i run the code
Code:
<?php
class Welcome extends Controller {
function Welcome()
{
parent::Controller();
}
function index()
{
$this->load->helper('Khacl');
echo $allowed = kh_acl_check('neophyte', 'news', 'comment');
}
}
I get this error
Code:
A Database Error Occurred
Error Number: 1054
Unknown column 'aro_node.lft' in 'on clause'
SELECT access.allow FROM khacl_aros AS aro_node, khacl_acos AS aco_node LEFT JOIN khacl_aros AS aro_branch ON (aro_node.lft >= aro_branch.lft AND aro_node.lft <= aro_branch.rgt) LEFT JOIN khacl_acos AS aco_branch ON (aco_node.lft >= aco_branch.lft AND aco_node.lft <= aco_branch.rgt) INNER JOIN khacl_access AS access ON (aro_branch.id = access.aro_id AND aco_branch.id = access.aco_id) WHERE aro_node.name = 'neophyte' AND aco_node.name = 'news' ORDER BY aro_branch.rgt ASC, aco_branch.rgt ASC LIMIT 1
Any ideas what I could be doing wrong?
Thanks