Checks and updates the 'has_children' status for the parent of a link.
function _menu_update_parental_status($item, $exclude = FALSE) {
// If plid == 0, there is nothing to update.
if ($item['plid']) {
// Check if at least one visible child exists in the table.
$query = db_select('menu_links');
$query
->addField('menu_links', 'mlid');
$query
->condition('menu_name', $item['menu_name']);
$query
->condition('hidden', 0);
$query
->condition('plid', $item['plid']);
$query
->range(0, 1);
if ($exclude) {
$query
->condition('mlid', $item['mlid'], '<>');
}
$parent_has_children = (bool) $query
->execute()
->fetchField() ? 1 : 0;
db_update('menu_links')
->fields(array(
'has_children' => $parent_has_children,
))
->condition('mlid', $item['plid'])
->execute();
}
}