X-Git-Url: http://git.harvie.cz/?a=blobdiff_plain;f=wwwroot%2Fbackend%2Fmysql%2Fbackend.inc;fp=wwwroot%2Fbackend%2Fmysql%2Fbackend.inc;h=0f66b8d55d6536372660be14ea59904788e63080;hb=d9b4dfbcb3d920445869db2c3abd706ee6916286;hp=f72a1025162d95aef1c54a3d78ad6a5c9c1fd812;hpb=a0e722be3ebca8f1f25ba76a7c93d8cae7155462;p=mirrors%2FKyberia-bloodline.git

diff --git a/wwwroot/backend/mysql/backend.inc b/wwwroot/backend/mysql/backend.inc
index f72a102..0f66b8d 100644
--- a/wwwroot/backend/mysql/backend.inc
+++ b/wwwroot/backend/mysql/backend.inc
@@ -574,5 +574,38 @@ public static function getNodesByType($vector,$user_id,$type,$orderby,$offset,$l
 	return $result;
 }
 
+// getLinkedNodes
+
+// 
+// returns XXX
+
+function getLinkedNodes($node_id,$orderby,$offset,$listing_amount) {
+	global $db;
+
+	if ((!is_numeric($node_id))
+		or (!is_numeric($offset))
+		or (!is_numeric($listing_amount)))
+		{ return -1; } // XXX check return value by caller?
+	$orderby=db_escape_string($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();
+		transport_process_node($array); // XXX
+		$array['node_status']="linked";
+		$array['node_created']=$array['synapse_created'];
+		$get_linked_nodes[]=$array;
+	}
+	return $get_linked_nodes;
+}
+
+
 }
 ?>