Migration to PDO database abstraction layer

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

diff --git a/wwwroot/inc/smarty/node_methodz/function.get_k_neurons.php b/wwwroot/inc/smarty/node_methodz/function.get_k_neurons.php
index 394167d4b0be22f0fa00daca5de1895e080ed639..c188c6ea7f8d70fe81109d8ae670e8f8b9480452 100644 (file)
--- a/wwwroot/inc/smarty/node_methodz/function.get_k_neurons.php
+++ b/wwwroot/inc/smarty/node_methodz/function.get_k_neurons.php
@@ -2,36 +2,25 @@
 
 function smarty_function_get_k_neurons($params,&$smarty) {
 
-       global $db,$node;
-       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=DEFAULT_LISTING_AMOUNT;
-       if (!is_numeric($_POST['interval'])) $interval=1;
-       else $interval = $_POST['interval'];
-       if ($params['vector']) {
+       global $db;
+       if (isset($params['offset']) && (is_numeric($params['offset']))) {
+               $offset=$params['offset'];
+       } else {$offset=20;} 
+       if (isset($params['listing_amount']) && (is_numeric($params['listing_amount']))) {
+               $listing_amount=$params['listing_amount'];
+       } else {$listing_amount=DEFAULT_LISTING_AMOUNT;}
+       if (isset($_POST['interval']) && (is_numeric($_POST['interval']))) {
+               $interval= $_POST['interval'];
+       } else {$interval = 1;}
+       if (isset($params['vector']) && ($params['vector'])) {
                $vector=$params['vector'];
                $interval=365;
-       }
-       else $vector="00";
+       } else {$vector="00";}
 
-// XXX move to backend
-
-/*$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 and nodes.node_system_access!='private' order by nodes.k desc limit $offset,$listing_amount";
-*/
                
-       $q="select COUNT(I.node_id) as count,length(concat(nodes.node_vector)) as vector_depth,nodes.*,nodes.node_creator as node_owner_id,creator.node_name as owner, node_parent.node_name as node_parent_name from I left join nodes on nodes.node_id=I.node_id left join nodes as creator on creator.node_id=nodes.node_creator left join nodes as node_parent on nodes.node_parent=node_parent.node_id where cas>NOW()-INTERVAL 1 HOUR and nodes.node_system_access='public' and nodes.node_vector like '00%' GROUP BY I.node_id ORDER BY count desc";
-//      $q="select nodes.*,'foter' as parent_name,'niekt0' as creator from nodes where node_id=4738126";
-
-       $set=$db->query($q);
-       while ($set->next()) {
-               $k_array[]=$set->getRecord();
-       }
+       // XXX other parameters
+       $k_array=nodes::getKNeurons($_SESSION['user_id'],$offset);
 
-// XXX backend end
 
        $smarty->assign('get_k_neurons',$k_array);
 }