X-Git-Url: http://git.harvie.cz/?a=blobdiff_plain;f=wwwroot%2Finc%2Fsmarty%2Fnode_methodz%2Ffunction.get_k_neurons.php;h=394167d4b0be22f0fa00daca5de1895e080ed639;hb=b101f04f8e670b3eb060d32ef8771fd4494ef207;hp=b43bf952c7983079215d892f1e697be1ee7ccc8c;hpb=fba1bac4c86998039580413bc2dab4eeadfc15a7;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 b43bf95..394167d 100644
--- a/wwwroot/inc/smarty/node_methodz/function.get_k_neurons.php
+++ b/wwwroot/inc/smarty/node_methodz/function.get_k_neurons.php
@@ -1,34 +1,38 @@
 <?php
-	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']) {
-			$vector=$params['vector'];
-			$interval=365;
-		}
-		else $vector="00";
+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']) {
+		$vector=$params['vector'];
+		$interval=365;
+	}
+	else $vector="00";
 
-// XXX backend
+// XXX move to backend
 
-$q="select nodes.*,parent.node_name as parent_name,users.login as creator
+/*$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();
+	}
 
-		$set=$db->query($q);
-		while ($set->next()) {
-			$k_array[]=$set->getRecord();
-		}
-
-		$smarty->assign('get_k',$k_array);
-
-
+// XXX backend end
 
-	}
+	$smarty->assign('get_k_neurons',$k_array);
+}
 ?>