function smarty_function_get_nodes_by_parent($params, &$smarty) { global $node; $parent = $params['parent']; $permissions = permissions::checkPermissions($parent); if (!$permissions['r']) { $error = $error_messages['READ_PERMISSION_ERROR']; return false; } if ($params['listing_amount'] == 'all') { $listing_amount = '232323233'; } else { $listing_amount = $params['listing_amount']; } if (empty($params['offset'])) { $offset = 0; } else { $offset = $params['offset']; } if ($params['orderby']) { $orderby = addslashes($params['orderby']); } global $db, $node; $node_id = $node['node_id']; $user_id = $_SESSION['user_id']; $q = "select node_content.*,parent.node_name as parent_name,users.*,nodes.*,node_access.node_user_subchild_count from nodes left join nodes as parent on parent.node_id=nodes.node_parent left join node_access on node_access.node_id=nodes.node_id and node_access.user_id='{$user_id}' left join node_content on (node_content.node_id=nodes.node_id) left join users on users.user_id=nodes.node_creator where "; $q .= " nodes.node_parent='{$parent}' and nodes.node_system_access!='private'"; if ($_POST['template_event'] == 'filter_by') { if ($_POST['search_type'] == 'content') { $sql_type .= " and node_content like '%" . addslashes($_POST['node_content']) . "%' "; } else { $q2 = "select user_id from users where login='******'node_content'] . "'"; $userset = $db->query($q2); $userset->next(); $id = $userset->getString('user_id'); $sql_type = " and nodes.node_creator='{$id}'"; } $q .= $sql_type; } if ($orderby) { $q .= " order by {$orderby} "; } else { $q .= " order by nodes.node_id desc "; } $q .= " LIMIT {$offset},{$listing_amount} "; $set = $db->query($q); while ($set->next()) { $pole[] = $set->getRecord(); } $smarty->assign('get_nodes_by_parent', $pole); }
} elseif ($_SESSION['user_id']) { $smarty->assign('node_name', $_GET['node_name']); $content = $smarty->display("modules/addnode.tpl"); } } //modifying node glass pearl if (is_array($children_types[$node['node_type']])) { $smarty->assign('children_types', $children_types[$node['node_type']]); } $smarty->assign('types', $types); $node['node_type'] = $types[$node['node_type']]; $node['node_content'] = StripSlashes($node['node_content']); $node['node_name'] = StripSlashes($node['node_name']); //checking permissions require SYSTEM_ROOT . 'inc/permissions.inc'; $permissions = permissions::checkPermissions($node); $permissions['h'] = permissions::isHierarch($node); //entering the node //sventest if ($permissions['r'] || $event != 'register') { //performing node_events (based on update/insert/delete db queries) if ($event) { require SYSTEM_ROOT . 'inc/eventz.inc'; } elseif ($transaction) { require SYSTEM_ROOT . 'inc/transaction.inc'; } //end of performing node events //sventest } if ($permissions['r']) { log::log('enter', $node['node_id'], 'ok', $node['node_user_subchild_count']);