From 758f3cf98f95fc906c2517c0d4537ce81cf7386d Mon Sep 17 00:00:00 2001 From: Matthias Schiffer Date: Fri, 7 Aug 2009 00:12:52 +0200 Subject: UserBackendMysql, client: Added group administration --- src/mad-server.conf | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'src/mad-server.conf') diff --git a/src/mad-server.conf b/src/mad-server.conf index c19fb0f..58a5116 100644 --- a/src/mad-server.conf +++ b/src/mad-server.conf @@ -31,14 +31,21 @@ UserManager { ListGroups "SELECT id, name FROM groups" 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 "SELECT id, name FROM groups WHERE id = {GID}" GroupByName "SELECT id, name FROM groups WHERE name = {GROUP}" UserGroupTable "SELECT uid, gid FROM usergroups" + AddUser "INSERT INTO users (id, gid, username, fullname) VALUES ({UID}, {GID}, {USER}, {FULL_NAME})" UpdateUser "UPDATE users SET id = {UID}, gid = {GID}, username = {USER}, fullname = {FULL_NAME} WHERE id = {ORIG_UID}" DeleteUser "DELETE FROM users WHERE id = {UID}" + + AddGroup "INSERT INTO groups (id, name) VALUES ({GID}, {GROUP})" + UpdateGroup "UPDATE groups SET id = {GID}, name = {GROUP} WHERE id = {ORIG_GID}" + DeleteGroup "DELETE FROM groups WHERE id = {GID}" + AddUserToGroup "INSERT INTO usergroups (uid, gid) VALUES ({UID}, {GID})" DeleteUserFromGroup "DELETE FROM usergroups WHERE uid = {UID} AND gid = {GID}" } -- cgit v1.2.3