$hierarchy=explode(';',$node_vector);
foreach ($hierarchy as $hierarch) {
$hierarch=ltrim($hierarch,0);
$hierarchy=explode(';',$node_vector);
foreach ($hierarchy as $hierarch) {
$hierarch=ltrim($hierarch,0);
- $q="select nodes.node_creator,node_access.node_permission from nodes left join node_access on nodes.node_id=node_access.node_id and node_access.user_id='".$_SESSION['user_id']."' where nodes.node_id='$hierarch'";
+ $q="select nodes.node_creator,node_access.node_permission from nodes left join node_access on nodes.node_id=node_access.node_id and node_access.user_id='".$user_id."' where nodes.node_id='$hierarch'";
$hierarchy=array_reverse(explode(';',$node_vector));
foreach ($hierarchy as $hierarch) {
$hierarch=ltrim($hierarch,0);
$hierarchy=array_reverse(explode(';',$node_vector));
foreach ($hierarchy as $hierarch) {
$hierarch=ltrim($hierarch,0);
- $q="select nodes.node_creator,nodes.node_system_access,node_access.node_permission from nodes left join node_access on nodes.node_id=node_access.node_id and node_access.user_id='".$_SESSION['user_id']."' where nodes.node_id='$hierarch'";
+ $q="select nodes.node_creator,nodes.node_system_access,node_access.node_permission from nodes left join node_access on nodes.node_id=node_access.node_id and node_access.user_id='".$user_id."' where nodes.node_id='$hierarch'";
elseif ($result->getString('node_permission')!='') {
array_pop($hierarchy_bounce);
$node['node_permission']=$result->getString('node_permission');
elseif ($result->getString('node_permission')!='') {
array_pop($hierarchy_bounce);
$node['node_permission']=$result->getString('node_permission');
$updated=$db->update($q);
if (!$updated && IsSet($_SESSION['user_id'])) {
$q="insert into node_access set node_permission='".$result->getString('node_permission')."', node_id='".$node['node_id']."',user_id='".$_SESSION['user_id']."'";
$updated=$db->update($q);
if (!$updated && IsSet($_SESSION['user_id'])) {
$q="insert into node_access set node_permission='".$result->getString('node_permission')."', node_id='".$node['node_id']."',user_id='".$_SESSION['user_id']."'";