UserBackend-Interface erweitert und im Mysql-Backend implementiert

1 files changed, 5 insertions, 5 deletions

diff --git a/src/mad-server.conf b/src/mad-server.conf
index 188833b..09614c4 100644
--- a/src/mad-server.conf
+++ b/src/mad-server.conf
@@ -18,12 +18,12 @@ UserBackendMysql {
   Queries {
     ListUsers "SELECT id, gid, username, fullname FROM users"
     ListGroups "SELECT id, name FROM groups"
-    #ListUserGroups
-    #ListGroupUsers
-    UserById "SELECT id, gid, username, fullname FROM users WHERE id = {ID}"
+    ListUserGroups "SELECT gid FROM usergroups WHERE uid = {UID}"
+    ListGroupUsers "SELECT uid FROM usergroups WHERE gid = {GID}"
+    UserById "SELECT id, gid, username, fullname FROM users WHERE id = {UID}"
     UserByName "SELECT id, gid, username, fullname FROM users WHERE username = {USER}"
-    #GroupById
-    #GroupByName
+    GroupById "SELECT id, name FROM groups WHERE id = {GID}"
+    GroupByName "SELECT id, name FROM groups WHERE name = {GROUP}"
   }
 }