1 files changed, 17 insertions, 0 deletions
diff --git a/modules-available/permissionmanager/inc/dbupdate.inc.php b/modules-available/permissionmanager/inc/dbupdate.inc.php
index 20ff746a..417fd812 100644
--- a/modules-available/permissionmanager/inc/dbupdate.inc.php
+++ b/modules-available/permissionmanager/inc/dbupdate.inc.php
@@ -34,4 +34,21 @@ class DbUpdate {
 		Database::exec($query);
 	}
 
+	public static function saveRole($roleName, $locType, $locations, $permissions, $role = NULL) {
+		if ($role) {
+			Database::exec("UPDATE role SET name = '$roleName', locType = '$locType' 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, locType) VALUES ('$roleName', '$locType')");
+			$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')");
+		}
+	}
+
 }