X-Git-Url: https://git.harvie.cz/?a=blobdiff_plain;ds=sidebyside;f=wwwroot%2Finc%2Fsmarty%2Fnode_methodz%2Ffunction.get_k_neurons.php;h=c188c6ea7f8d70fe81109d8ae670e8f8b9480452;hb=78f1a5f44941de2459b71c375e36cf88227c689c;hp=394167d4b0be22f0fa00daca5de1895e080ed639;hpb=b101f04f8e670b3eb060d32ef8771fd4494ef207;p=mirrors%2FKyberia-bloodline.git 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 394167d..c188c6e 100644 --- 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); }