diff options
Diffstat (limited to 'public/app/models/Access_model.php')
| -rw-r--r-- | public/app/models/Access_model.php | 28 |
1 files changed, 1 insertions, 27 deletions
diff --git a/public/app/models/Access_model.php b/public/app/models/Access_model.php index d5ae19e..8d446dc 100644 --- a/public/app/models/Access_model.php +++ b/public/app/models/Access_model.php @@ -56,33 +56,7 @@ class Access_model FROM user_role WHERE user_role.user_id = :id ) - ) AS Roles_json, - ( -- construct array of (root-)privileges granted to user - SELECT CONCAT( - '[', - GROUP_CONCAT(privilege.id), - ']' - ) - FROM privilege - WHERE privilege.id IN ( - SELECT user_privilege.privilege_id - FROM user_privilege - WHERE user_privilege.user_id = :id - ) - ) AS RootPrivileges_json, - ( -- construct array of (root-)privileges granted to user - SELECT CONCAT( - '[', - GROUP_CONCAT(privilege.includes), - ']' - ) - FROM privilege - WHERE privilege.id IN ( - SELECT user_privilege.privilege_id - FROM user_privilege - WHERE user_privilege.user_id = :id - ) - ) AS SubPrivileges_json + ) AS Roles_json FROM user WHERE id = :id", [ ':id' => $id ] |