diff options
Diffstat (limited to 'lib/classes')
| -rw-r--r-- | lib/classes/MvvPerm.php | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/lib/classes/MvvPerm.php b/lib/classes/MvvPerm.php index 693b7b7..d75a35d 100644 --- a/lib/classes/MvvPerm.php +++ b/lib/classes/MvvPerm.php @@ -638,9 +638,12 @@ class MvvPerm { } if (count($institutes)) { - $stmt = DBManager::get()->prepare('SELECT DISTINCT(Institut_id) ' - . 'FROM Institute WHERE Institut_id IN (:inst_ids) ' - . 'OR fakultaets_id IN (:inst_ids)'); + $stmt = DBManager::get()->prepare(' + SELECT DISTINCT(`Institut_id`) + FROM `Institute` + WHERE `Institut_id` IN (:inst_ids) + OR `fakultaets_id` IN (:inst_ids) + '); $stmt->execute(['inst_ids' => $institutes]); self::$user_role_institutes[$user_id] = $stmt->fetchAll(PDO::FETCH_COLUMN); } else { |