function _nodehierarchy_get_children_menu_links in Node Hierarchy 7.2

Same name and namespace in other branches

1. 6.3 nodehierarchy.module \_nodehierarchy_get_children_menu_links()
2. 6.2 nodehierarchy.module \_nodehierarchy_get_children_menu_links()

Get the children of the given node.

3 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().

File

./nodehierarchy.module, line 1105

A module to make nodes hierarchical.

Code

function _nodehierarchy_get_children_menu_links($pnid, $limit = 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 = :pnid)\n     ORDER BY nh_menu_links.weight ASC";
  if ($limit) {
    $query .= " LIMIT {$limit}";
  }
  $result = db_query($query, array(
    ':pnid' => $pnid,
  ), array(
    'fetch' => PDO::FETCH_ASSOC,
  ));
  foreach ($result as $item) {
    $item['pnid'] = $pnid;
    $children[] = _nodehierarchy_prepare_menu_link($item);
  }
  return $children;
}