Complex data query (bookmark and nodes)

i guess there will be a lot of room for improvement, but this worked in a fast test i did. I quickly installed the module and made some references between some node types. You just stick that code in a new block with PHP Filter enabled.

I tested like this.

bookmarked node1 -----referenceTo-----> mainnode1
bookmarked node2 -----referenceTo-----> mainnode2

THIS ONLY WORKS IF YOUR REFERENCE FIELD IS ONLY USED IN ONE NODETYPE. If you reuse the field it doesnt get stored in the content_type_YOURTYPE table, but in its own.

ALSO NOTICE that you have to rename field_reference_nid TO field_YourFieldname_nid (you can look that up in the database if your not sure)

<?php
// gets the current user object because we need the uid ($user->uid)
global $user;

// query the views_bookmark_nodes table and get all the node id of bookmarked nodes
$nid_array = db_query(db_rewrite_sql("SELECT nid FROM {views_bookmark_nodes} WHERE uid = %d", $user->uid), $user->uid);

// prepare output in unordered list
print '<ul>';

// now we need to get the referred node for each bookmark
while ($nid = db_fetch_object($nid_array)) {

  // since we maybe have to query different node type, lets get the current node type first
  $node_type = db_result(db_query("SELECT type FROM {node} WHERE nid = $nid->nid"));

  // query the content_type_YOURTYPE table 
  $reference_nid = db_result(db_query("SELECT field_reference_nid FROM {content_type_$node_type} WHERE nid = $nid->nid"));

  // get the title of the node
  $reference_title = db_result(db_query("SELECT title FROM {node} WHERE nid = $reference_nid"));

  // print the link
  print '<li><a href="/node/'. $reference_nid .'">'. $reference_title.'</a></li>';
}

// close unordered list
print '</ul>';
?>

the problem is, its hard to make a gereric approach. There are many small details that may require a totally different approach. Hope this helps.