Commit | Line | Data |
---|---|---|
e586807d H |
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 | ?> |