You are here

function _nodehierarchy_get_children_menu_links in Node Hierarchy 6.3

Same name and namespace in other branches
  1. 6.2 nodehierarchy.module \_nodehierarchy_get_children_menu_links()
  2. 7.2 nodehierarchy.module \_nodehierarchy_get_children_menu_links()

Get the children of the given node.

4 calls to _nodehierarchy_get_children_menu_links()
nodehierarchy_children_form in ./nodehierarchy.module
Built the children tab form.
nodehierarchy_delete_descendants in ./nodehierarchy.module
Delete all of the descendants of the given node.
nodehierarchy_form_alter in ./nodehierarchy.module
Implementation of hooks_form_alter().
_nodehierarchyaccess_set_descendant_grants in nodehierarchyaccess/nodehierarchyaccess.module
Set the given grants for the children nodes

File

./nodehierarchy.module, line 1193
A module to make nodes hierarchical.

Code

function _nodehierarchy_get_children_menu_links($pnid, $pager = FALSE) {
  $children = array();
  $query = "\n       SELECT nh_menu_links.* \n         FROM {node} node\n    LEFT JOIN {nodehierarchy_menu_links} nodehierarchy_menu_links ON node.nid = nodehierarchy_menu_links.nid \n    LEFT JOIN {menu_links} nh_menu_links ON nodehierarchy_menu_links.mlid = nh_menu_links.mlid \n    LEFT JOIN {nodehierarchy_menu_links} nh_parent ON nh_menu_links.plid = nh_parent.mlid \n        WHERE (nh_parent.nid = %d) \n     ORDER BY nh_menu_links.weight ASC";
  if ($pager) {
    $result = pager_query($query, $pager, 0, NULL, $pnid);
  }
  else {
    $result = db_query($query, $pnid);
  }
  while ($item = db_fetch_array($result)) {
    $item['pnid'] = $pnid;
    $children[] = _nodehierarchy_prepare_menu_link($item);
  }
  return $children;
}