inc/smarty/node_methodz/function.get_neurons.php

   1 <?php
   2
   3         function smarty_function_get_neurons($params,&$smarty) {
   4                 global $db, $error, $node, $time_1, $time_2;
   5                 $node_id=$node['node_id'];
   6                 $q="select neurons.*,node_content,users.login,nodes.* from neurons left join nodes on neurons.peripheral=nodes.node_id left join users on nodes.node_creator=users.user_id left join node_content on node_content.node_id=nodes.node_id where central='$node_id' order by synapse desc";
   7                 $result=$db->query($q);
   8                 while ($result->next()) {
   9                         $get_dendrites[]=$result->getRecord();
  10                 }
  11                 $smarty->assign('get_dendrites',$get_dendrites);
  12
  13                 $q="select neurons.*,node_content,users.login,nodes.* from neurons left join nodes on neurons.central=nodes.node_id left join users on nodes.node_creator=users.user_id left join node_content on node_content.node_id=nodes.node_id where peripheral='$node_id'  order by synapse desc";
  14                 $result=$db->query($q);
  15                 while ($result->next()) {
  16                         $get_axons[]=$result->getRecord();
  17                 }
  18                 $smarty->assign('get_axons',$get_axons);
  19
  20         }
  21 ?>