diff options
author | Udo Walter | 2017-04-07 15:49:54 +0200 |
---|---|---|
committer | Udo Walter | 2017-04-07 15:49:54 +0200 |
commit | d033483d3ed9e05f1109a3713ec6a3df883a1dae (patch) | |
tree | 13df2276d6c137901d87ea5daf23464e5c7bb869 /modules-available/permissionmanager/inc/dbupdate.inc.php | |
parent | [permission-manager] added possibility to select all permissions (diff) | |
download | slx-admin-d033483d3ed9e05f1109a3713ec6a3df883a1dae.tar.gz slx-admin-d033483d3ed9e05f1109a3713ec6a3df883a1dae.tar.xz slx-admin-d033483d3ed9e05f1109a3713ec6a3df883a1dae.zip |
[permission-manager] renamed some files, moved html generation to templates,
using bind variables in mysql code, changed order of modules in role editor
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')"); - } - } - -} |