3 function smarty_function_get_linked_nodes($params,&$smarty) {
4 global $db, $error, $node, $time_1, $time_2;
7 $orderby=$params['orderby'];
8 if ($orderby!='desc' && $orderby!='asc') $orderby='desc';
10 if (!empty($time_1) ||
!empty($time_2)) {
11 if ($orderby=='desc') {
19 $time=" and synapse_created>'$from' and synapse_created<='$to'";
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;
35 $smarty->assign('get_linked_nodes',$get_linked_nodes);
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;
46 $smarty->assign('get_linked_bookmarks',$get_linked_bookmarks);
This page took 0.29342 seconds and 4 git commands to generate.