summaryrefslogtreecommitdiffstats
path: root/modules-available/permissionmanager/inc/dbupdate.inc.php
diff options
context:
space:
mode:
Diffstat (limited to 'modules-available/permissionmanager/inc/dbupdate.inc.php')
-rw-r--r--modules-available/permissionmanager/inc/dbupdate.inc.php54
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')");
- }
- }
-
-}