Kyberia v2.3 - 1st revision from SVN (Without patches of kyberia.sk team)

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

diff --git a/inc/smarty/node_methodz/function.get_nodes_by_parent.php b/inc/smarty/node_methodz/function.get_nodes_by_parent.php
index 0ab93be4163622d73723afa62d8f083879cbed6f..360f553c51e7320acedab78dc5ed74837836665d 100644 (file)
--- a/inc/smarty/node_methodz/function.get_nodes_by_parent.php
+++ b/inc/smarty/node_methodz/function.get_nodes_by_parent.php
@@ -9,8 +9,9 @@
                        $error=$error_messages['READ_PERMISSION_ERROR'];
                        return false;
                }
+               $parent_vectot=$parent['node_vector'];
 
-               if ($params['listing_amount']=='all') $listing_amount='232323233';
+               if ($params['listing_amount']=='all') $listing_amount='100';
                else $listing_amount=$params['listing_amount'];
                if (empty($params['offset'])) $offset=0;
                else $offset=$params['offset'];
@@ -22,8 +23,9 @@
                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 ($params['time']) $sql_time=" nodes.node_created > '".addslashes($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'";
 
 
                 if ($_POST['template_event']=='filter_by') {
@@ -47,4 +49,8 @@
                $smarty->assign('get_nodes_by_parent',$pole);
 
        }
-?>
\ No newline at end of file
+?>
+
+
+
+