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

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

diff --git a/inc/smarty/node_methodz/function.get_last.php b/inc/smarty/node_methodz/function.get_last.php
index 3ee441ecc6b43b21a31978619a97ad3839d675a0..85a016a8693e3636a2ab2c58c0c6f4d9bd63f032 100644 (file)
--- a/inc/smarty/node_methodz/function.get_last.php
+++ b/inc/smarty/node_methodz/function.get_last.php
@@ -2,17 +2,31 @@
 
        function smarty_function_get_last($params,&$smarty) {
 
-               $vector=addslashes($params['vector']);
-               if (empty($vector)) $vector='0';
                if ($params['listing_amount']=='all') $listing_amount='-1';
                else $listing_amount=addslashes($params['listing_amount']);
                if (empty($params['offset'])) $offset=0;
                else $offset=addslashes($params['offset']);
 
                global $db,$node;
+
+               if ($node['node_id']==23)  {
+                       $interval=" nodes.node_created>NOW()-INTERVAL 23 HOUR and";
+                       $params['vector']="00";
+               }
+
+               else {
+                       $vector=$node['node_vector'];
+                       $interval=" nodes.node_created>NOW()-INTERVAL 42 DAY and";
+               }
+
                $node_id=$node['node_id'];
                $user_id=$_SESSION['user_id'];
-               $q="select parent.node_name as parent_name,users.*,nodes.*,node_content.* from nodes left join nodes as parent on parent.node_id=nodes.node_parent left join node_content on (node_content.node_id=nodes.node_id) left  join users on users.user_id=nodes.node_creator where nodes.node_created>NOW()-INTERVAL 23 HOUR and nodes.node_vector like '%$vector%'  and nodes.node_system_access!='private' order by nodes.node_created desc LIMIT $offset,$listing_amount ";
+               $q="select parent.node_name as parent_name,users.*,nodes.* from nodes
+               left join nodes as parent on parent.node_id=nodes.node_parent
+               left  join users on users.user_id=nodes.node_creator where $interval
+               nodes.node_vector like '$vector%'  and
+               nodes.node_system_access!='private' order by nodes.node_id desc LIMIT $offset,$listing_amount ";
+
                $set=$db->query($q);
                while ($set->next()) $pole[]=$set->getRecord();
                $smarty->assign('get_last',$pole);