Move background image into images directory

[misc/kostenrechnung] / lib / menu.php

diff --git a/lib/menu.php b/lib/menu.php
index 60701d8..e20b4d0 100644 (file)
--- a/lib/menu.php
+++ b/lib/menu.php
@@ -15,6 +15,8 @@ function menu()
 
   $sql = "SELECT fname,menutitle,name FROM sys_mask "
     . "JOIN sys_menu ON sys_mask.menu = sys_menu.id "
+    . "JOIN sys_group_mask ON sys_mask.id = sys_group_mask.mask "
+    . "WHERE sys_group_mask.gid = ".$_SESSION['sys']['group']." "
     . "ORDER BY sys_menu.priority,sys_menu.name,sys_mask.priority,sys_mask.menutitle";
   $sth = pg_query($sql);