diff options
Diffstat (limited to 'modules-available/permissionmanager/inc/dbupdate.inc.php')
-rw-r--r-- | modules-available/permissionmanager/inc/dbupdate.inc.php | 54 |
1 files changed, 0 insertions, 54 deletions
diff --git a/modules-available/permissionmanager/inc/dbupdate.inc.php b/modules-available/permissionmanager/inc/dbupdate.inc.php deleted file mode 100644 index 1101e4f7..00000000 --- a/modules-available/permissionmanager/inc/dbupdate.inc.php +++ /dev/null @@ -1,54 +0,0 @@ -<?php - -class DbUpdate { - - // insert new userXrole to database. "ignore" to ignore duplicate entry try - public static function addRoleToUser($users, $roles) { - foreach($users AS $user) { - foreach ($roles AS $role) { - $query = "INSERT IGNORE INTO userXrole (userid, roleid) VALUES ($user, $role)"; - Database::exec($query); - } - } - } - - // remove userXrole entry from database - public static function removeRoleFromUser($users, $roles) { - foreach($users AS $user) { - foreach ($roles AS $role) { - $query = "DELETE FROM userXrole WHERE userid = $user AND roleid = $role"; - Database::exec($query); - } - } - } - - // delete role, delete userXrole relationships, delete roleXlocation relationships, delete roleXpermission relationships - public static function deleteRole($id) { - $query = "DELETE FROM role WHERE id = $id"; - Database::exec($query); - $query = "DELETE FROM userXrole WHERE roleid = $id"; - Database::exec($query); - $query = "DELETE FROM roleXlocation WHERE roleid = $id"; - Database::exec($query); - $query = "DELETE FROM roleXpermission WHERE roleid = $id"; - Database::exec($query); - } - - public static function saveRole($roleName, $locations, $permissions, $role = NULL) { - if ($role) { - Database::exec("UPDATE role SET name = '$roleName' WHERE id = $role"); - Database::exec("DELETE FROM roleXlocation WHERE roleid = $role"); - Database::exec("DELETE FROM roleXpermission WHERE roleid = $role"); - } else { - Database::exec("INSERT INTO role (name) VALUES ('$roleName')"); - $role = Database::lastInsertId(); - } - foreach ($locations as $locID) { - Database::exec("INSERT INTO roleXlocation (roleid, locid) VALUES ($role, $locID)"); - } - foreach ($permissions as $permission) { - Database::exec("INSERT INTO roleXpermission (roleid, permissionid) VALUES ($role, '$permission')"); - } - } - -} |