X-Git-Url: https://git.infodrom.org/?p=misc%2Fkostenrechnung;a=blobdiff_plain;f=lib%2Fmenu.php;h=a6fd04b937443b6e0b6f3c1c711d281d88753383;hp=c7190c3daa96d661bf7b6bd80cda7743b255ef96;hb=b0136cd9327c8bb946770617085134f67eb81911;hpb=0dd7b92453a41d3df157079310a88c039422cdd5;ds=sidebyside

diff --git a/lib/menu.php b/lib/menu.php
index c7190c3..a6fd04b 100644
--- a/lib/menu.php
+++ b/lib/menu.php
@@ -4,15 +4,20 @@ function menu()
 {
   if (empty($_SESSION['sys']['login'])) return '';
 
-  $ret = '<div id="menu">
-  <ul id="nav">
-   <li><a href="./">Start</a></li>
-   <li><a href="./?mask=personal">Personal</a></li>
-   <li><a href="./?mask=overview_gewaesser">Gewässer</a></li>
-   <li><a href="#">Abfragen</a></li>
-  </ul>
-</div>
-';
+  $ret = '<div id="menu">';
+  $ret .= '<ul id="nav">';
+  $ret .= '<li><a href="./">Start</a></li>';
+
+  $sql = "SELECT id,name FROM sys_menu ORDER BY priority";
+  $sth = pg_query($sql);
+
+  if ($sth)
+    while ($row = pg_fetch_assoc($sth))
+      $ret .= sprintf('<li><a href="./?menu=%d">%s</a></li>', $row['id'], $row['name']);
+
+  $ret .= '</ul>';
+  $ret .= '</div>';
+
   return $ret;
 }