get_linked_nodes moved to backend

[mirrors/Kyberia-bloodline.git] / wwwroot / inc / smarty / node_methodz / function.get_nodes_by_parent.php

diff --git a/wwwroot/inc/smarty/node_methodz/function.get_nodes_by_parent.php b/wwwroot/inc/smarty/node_methodz/function.get_nodes_by_parent.php
index 35c1aa37a56ca7f55d43bdbdb4a9125a894eed0c..9fb36599c53b0720cab628d2dc42ecebcb6e6d81 100644 (file)
--- a/wwwroot/inc/smarty/node_methodz/function.get_nodes_by_parent.php
+++ b/wwwroot/inc/smarty/node_methodz/function.get_nodes_by_parent.php
@@ -3,6 +3,8 @@
 function smarty_function_get_nodes_by_parent($params,&$smarty) {
        global $node;
 
+       $sql_time="";
+       $sql_type="";
        $parent=$params['parent'];
        $permissions=permissions::checkPerms($parent);
        if (!$permissions['r']) {
@@ -26,6 +28,7 @@ function smarty_function_get_nodes_by_parent($params,&$smarty) {
        if (isset($params['time'])) {
                $sql_time=" nodes.node_created > '".db_escape_string($params['time'])."' and ";
        }
+
        $q="select 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 users on users.user_id=nodes.node_creator where ";
        $q.=" $sql_time nodes.node_parent='$parent' and nodes.node_system_access!='private'";
 
@@ -43,7 +46,7 @@ function smarty_function_get_nodes_by_parent($params,&$smarty) {
                        $q.=$sql_type;
         }
 
-       if ($orderby) $q.=" order by $orderby ";
+       if (isset($orderby)) $q.=" order by $orderby ";
        else $q.=" order by nodes.node_id desc ";
        $q.= " LIMIT $offset,$listing_amount ";
        $set=$db->query($q);