inc/smarty/node_methodz/function.get_linked_nodes.php

   1 <?php
   2
   3         function smarty_function_get_linked_nodes($params,&$smarty) {
   4                 global $db, $error, $node, $time_1, $time_2;
   5                 $time_1=$time_1;
   6                 $time_2=$time_2;
   7                 $orderby=$params['orderby'];
   8                 if ($orderby!='desc' && $orderby!='asc') $orderby='desc';
   9
  10                 if (!empty($time_1) || !empty($time_2)) {
  11                         if ($orderby=='desc') {
  12                                 $from=$time_2;
  13                                 $to=$time_1;
  14                         }
  15                         else {
  16                                 $from=$time_1;
  17                                 $to=$time_2;
  18                         }
  19                         $time=" and synapse_created>'$from' and synapse_created<='$to'";
  20                 }
  21                 else {
  22                         $time="";
  23                 }
  24
  25                 $node_id=$node['node_id'];
  26                 $q="select neurons.synapse_created,node_content,author.login,linker.login as linker,nodes.* from neurons left join nodes on neurons.src=nodes.node_id left join users as linker on neurons.synapse_creator=linker.user_id left join users as author on nodes.node_creator=author.user_id left join node_content on node_content.node_id=nodes.node_id where dst='$node_id' and link='hard' $time order by synapse_created $orderby";
  27                 $result=$db->query($q);
  28                 while ($result->next()) {
  29                         $array=$result->getRecord();
  30                         $array['node_status']="linked";
  31                         $array['node_vector']=$node['node_vector'].";".$node['node_id'];
  32                         $array['node_created']=$array['synapse_created'];
  33                         $get_linked_nodes[]=$array;
  34                 }
  35                 $smarty->assign('get_linked_nodes',$get_linked_nodes);
  36
  37                 $q="select neurons.synapse_created,node_content,users.login,nodes.* from neurons left join nodes on neurons.src=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 dst='$node_id' and link='bookmark' $time order by synapse_created $orderby";
  38                 $result=$db->query($q);
  39                 while ($result->next()) {
  40                         $array=$result->getRecord();
  41                         $array['node_status']="linked";
  42                         $array['node_vector']=$node['node_vector'].";".$node['node_id'];
  43                         $array['node_created']=$array['synapse_created'];
  44                         $get_linked_bookmarks[]=$array;
  45                 }
  46                 $smarty->assign('get_linked_bookmarks',$get_linked_bookmarks);
  47                 }
  48 ?>