diff options
| author | Elmar Ludwig <elmar.ludwig@uni-osnabrueck.de> | 2022-09-15 12:51:43 +0000 |
|---|---|---|
| committer | David Siegfried <david.siegfried@uni-vechta.de> | 2022-09-15 12:51:43 +0000 |
| commit | ca10fde9cf94fb13045cbe1d009759834641b4a7 (patch) | |
| tree | ad54150d4aec0fa2f8b1ffcccbae8679ac2da76a /app/controllers/course/overview.php | |
| parent | 061434e70768674fe7c682e709160bec25191da3 (diff) | |
partly fix broken SQL queries, re #1579
Merge request studip/studip!1008
Diffstat (limited to 'app/controllers/course/overview.php')
| -rw-r--r-- | app/controllers/course/overview.php | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/app/controllers/course/overview.php b/app/controllers/course/overview.php index fa30b1c..966c0ca 100644 --- a/app/controllers/course/overview.php +++ b/app/controllers/course/overview.php @@ -96,9 +96,8 @@ class Course_OverviewController extends AuthenticatedController foreach ((array) $rule['attributes'] as $val) { if ($val == 1) { // Es gibt also Zusatzangaben. Nun noch überprüfen ob der Nutzer diese Angaben schon gemacht hat... - $count = DataField::countBySql("LEFT JOIN datafields_entries ON datafields_entries.datafield_id = datafields.datafield_id - WHERE datafield_id.object_type = 'usersemdata' AND datafields_entries.sec_range_id = ? AND datafields_entries.range_id = ?", - [$this->course_id, $GLOBALS['user']->id] + $count = DataField::countBySql("LEFT JOIN datafields_entries USING (datafield_id) WHERE object_type = ? AND sec_range_id = ? AND range_id = ?", + ['usersemdata', $this->course_id, $GLOBALS['user']->id] ); if (!$count) { $show = true; |