X-Git-Url: http://git.harvie.cz/?a=blobdiff_plain;f=inc%2Fsmarty%2Fnode_methodz%2Ffunction.get_linked_nodes.php;h=351679aceffaaf5b080979fb3430bc194c260203;hb=673e23209e2e3b9782c037e70156a1a20154a5b9;hp=3bdf36139ad8760e0662732063d795217c6420b5;hpb=e586807dafc64c3fe152ab518599e6cf3f0f84e1;p=mirrors%2FKyberia-bloodline.git diff --git a/inc/smarty/node_methodz/function.get_linked_nodes.php b/inc/smarty/node_methodz/function.get_linked_nodes.php index 3bdf361..351679a 100644 --- a/inc/smarty/node_methodz/function.get_linked_nodes.php +++ b/inc/smarty/node_methodz/function.get_linked_nodes.php @@ -1,48 +1,48 @@ '$from' and synapse_created<='$to'"; + global $db, $error, $node; + + if ($params['listing_amount']=='all') $listing_amount='23232323232323323'; + elseif (is_numeric($params['listing_amount'])) $listing_amount=$params['listing_amount']; + else $listing_amount=DEFAULT_LISTING_AMOUNT; + + if (is_numeric($params['offset'])) $offset=$params['offset']; + elseif (is_numeric($_POST['offset'])) $offset=$_POST['offset']; + else $offset=0; + + + + if ($params['node_id']) { + $node_id=$params['node_id']; } + + else { + $node_id=$node['node_id']; + } + + if ($params['orderby']='synapse') { + $orderby='synapse_created'; + } + else { - $time=""; + $orderby='node_id'; } - $node_id=$node['node_id']; - $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"; + + + $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 where dst='$node_id' and link in ('hard','bookmark') order by $orderby desc limit $offset , $listing_amount"; $result=$db->query($q); while ($result->next()) { $array=$result->getRecord(); $array['node_status']="linked"; - $array['node_vector']=$node['node_vector'].";".$node['node_id']; $array['node_created']=$array['synapse_created']; $get_linked_nodes[]=$array; } $smarty->assign('get_linked_nodes',$get_linked_nodes); - $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"; - $result=$db->query($q); - while ($result->next()) { - $array=$result->getRecord(); - $array['node_status']="linked"; - $array['node_vector']=$node['node_vector'].";".$node['node_id']; - $array['node_created']=$array['synapse_created']; - $get_linked_bookmarks[]=$array; - } - $smarty->assign('get_linked_bookmarks',$get_linked_bookmarks); - } -?> \ No newline at end of file +} + +?> +