<?php 
  function fnGetSitemap($iGUI, $iChangeble, $oDBCon) {
    $sSitemap  = "<div id=\"tekst_venster\">\r\n";
    $sSitemap .= "&nbsp;<br />\r\n";
    $sSitemap .= "<div class=\"header_tekst tekst_rood\">Sitemap</div>\r\n";
    
    $sSelectSQL  = " SELECT ";
    $sSelectSQL .= "   pa_bestandsnaam, ";
    $sSelectSQL .= "   pa_naam, ";
    $sSelectSQL .= "   pa_type_id ";
    $sSelectSQL .= " FROM tbl_paginas ";
    $sSelectSQL .= " WHERE pa_beveiligd  = 0 ";
    $sSelectSQL .= "   AND pa_type_id >= 1 ";
    if($iChangeble == 0) {
      $sSelectSQL .= "   AND pa_sorteer_id >= 1 ";
    }
    $sSelectSQL .= " ORDER BY pa_sorteer_id;";
    $rsPaginas = $oDBCon->query($sSelectSQL);
    $iPaginasTeller = 0;
    $iSubTeller = 0;
    $sLastMainMenu = "";
    while ($rsPaginas && $arPagina = $rsPaginas->fetch_array()) {
      $iPaginasTeller++;
      $iSubTeller++;
      $iRow = $iPaginasTeller % 2 + 1;
      $sMapping = $arPagina['pa_bestandsnaam'];
      $iShowLevel = $arPagina['pa_type_id'];
      $arMapping = split("/", $sMapping);
      $iMaps = sizeof($arMapping);
      $iMaps--;
      if($iMaps == 2 && $arMapping[1] != $sLastMainMenu) {
        $sSitemap .= strtoupper($arMapping[1]) . "<br />\r\n";
        $sLastMainMenu = $arMapping[1];
        $iSubTeller = 1;
      }
      $iTeller = 1;
      $iColspan = (5 - $iMaps);
      if($iMaps > 1) {
        if($iChangeble) {
          $iColspan++;
        } else {
          $sSitemap .= "&nbsp;&nbsp;\r\n";
        }
      } else {
        $iColspan += 3;
      }
      while($iTeller < $iMaps) {
        $iTeller++;
        $sSitemap .= "&nbsp;&nbsp;\r\n";
      }
      if($iChangeble) {
        $sSitemap .= "<a href=\"/mangsys/pages/change.php?sPagina=" . $sMapping . "\">\r\n";
        $sSitemap .= "  <img src=\"/images/icons/change.png\" border=\"0\">\r\n";
        $sSitemap .= "</a>\r\n";
      }
      $sSitemap .= "<a href=\"" . $sMapping . "\">\r\n";
      $sSitemap .= $arPagina['pa_naam'] . "\r\n";
      $sSitemap .= "</a><br />\r\n";
    }
    $sSitemap .= "</div>\r\n";
    return $sSitemap;
  }
?>