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

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

diff --git a/inc/smarty/node_methodz/function.get_k.php b/inc/smarty/node_methodz/function.get_k.php
index 5f58b112d58aba4bddf4a7cba45cc3a71bbc9271..91ce3e4aac0b8bdd7cdaa52e2836f8a5a9494d70 100644 (file)
--- a/inc/smarty/node_methodz/function.get_k.php
+++ b/inc/smarty/node_methodz/function.get_k.php
@@ -5,7 +5,7 @@
                if (is_numeric($params['offset'])) $offset=$params['offset'];
                else $offset=0;
                if (is_numeric($params['listing_amount'])) $listing_amount=$params['listing_amount'];
-               else $listing_amount=23;
+               else $listing_amount=DEFAULT_LISTING_AMOUNT;
                if (!is_numeric($_POST['interval'])) $interval=1;
                else $interval = $_POST['interval'];
                if ($params['vector']) {
@@ -14,10 +14,10 @@
                }
                else $vector="00";
 
-$q="select node_content.node_content,nodes.*,parent.node_name as parent_name,users.login as creator
- from nodes left join node_content on node_content.node_id=nodes.node_id left join nodes as parent on nodes.node_parent=parent.node_id
+$q="select nodes.*,parent.node_name as parent_name,users.login as creator
+ from nodes left join nodes as parent on nodes.node_parent=parent.node_id
  left join users on users.user_id=nodes.node_creator where nodes.node_created>now()-interval $interval day
-  and nodes.node_vector like '$vector%' and nodes.k>0 order by nodes.k desc limit $offset,$listing_amount";
+  and nodes.node_vector like '$vector%' and nodes.k>0 and nodes.node_system_access!='private' order by nodes.k desc limit $offset,$listing_amount";
 
                $set=$db->query($q);
                while ($set->next()) {