diff options
Diffstat (limited to 'src/mad-server.conf')
| -rw-r--r-- | src/mad-server.conf | 10 |
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}" } } |