X-Git-Url: http://git.harvie.cz/?a=blobdiff_plain;f=wwwroot%2Finc%2Fsmarty%2Fnode_methodz%2Ffunction.get_nodes_by_parent.php;h=9fb36599c53b0720cab628d2dc42ecebcb6e6d81;hb=d9b4dfbcb3d920445869db2c3abd706ee6916286;hp=35c1aa37a56ca7f55d43bdbdb4a9125a894eed0c;hpb=8f52a0530e35e87e5624e1bb84283aa58ea78e2b;p=mirrors%2FKyberia-bloodline.git 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 35c1aa3..9fb3659 100644 --- 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);