$site_root = midcom_core_context::get()->get_key(MIDCOM_CONTEXT_ROOTTOPIC); $host_prefix = midcom::get()->get_host_prefix(); $nap = new midcom_helper_nav(); $qb = midcom_db_topic::new_query_builder(); $qb->add_constraint('up', 'INTREE', $site_root->id); $qb->begin_group('OR'); $qb->add_constraint('metadata.hidden', '=', 1); $qb->add_constraint('metadata.navnoentry', '=', 1); $qb->end_group(); $qb->add_order('name'); $topics = $qb->execute(); unset($qb); echo "<h2>Topics</h2>\n"; foreach ($topics as $topic) { $node =& $nap->get_node($topic->id); $crumbs =& $nap->get_breadcrumb_data($node[MIDCOM_NAV_ID]); $n_crumbs = count($crumbs); $i = 0; render_breadcrumb($crumbs); echo " (<a href='{$host_prefix}__mfa/asgard/object/view/{$topic->guid}'>in Asgard</a>)<br/>\n"; } echo "<h2>Articles</h2>\n"; $qb = midcom_db_article::new_query_builder(); $qb->add_constraint('topic', 'INTREE', $site_root->id); $qb->begin_group('OR'); $qb->add_constraint('metadata.hidden', '=', 1); $qb->add_constraint('metadata.navnoentry', '=', 1); $qb->end_group(); $qb->add_order('name'); $articles = $qb->execute(); unset($qb);