aboutsummaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorFinn Schneider <schneider@data-quest.de>2026-02-17 12:52:49 +0100
committerFinn Schneider <schneider@data-quest.de>2026-03-13 17:25:01 +0000
commitc8516b34feaa2f042bfdb6530012f506f7662dcc (patch)
treead32ee62e6c5e3354327556a6d5bf4e2f5fe60cf /db
parent6bc46d5a8659a0f5c3fb1a85dd8845d4382ad26c (diff)
no studygroups
Diffstat (limited to 'db')
-rw-r--r--db/migrations/6.3.1_central_evaluations.php6
1 files changed, 5 insertions, 1 deletions
diff --git a/db/migrations/6.3.1_central_evaluations.php b/db/migrations/6.3.1_central_evaluations.php
index a95937f..673585a 100644
--- a/db/migrations/6.3.1_central_evaluations.php
+++ b/db/migrations/6.3.1_central_evaluations.php
@@ -115,7 +115,11 @@ class CentralEvaluations extends Migration
(`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`)
VALUES(:range_id, :range_type, :plugin_id, :position, :metadata, :mkdate, :chdate)
";
- $update_courses = DBManager::get()->prepare("SELECT * FROM `seminare`"); //TODO where not study group
+ $update_courses = DBManager::get()->prepare("
+ SELECT * FROM `seminare`
+ INNER JOIN `sem_classes` ON `sem_classes`.`id` = `seminare`.`status`
+ WHERE `sem_classes`.`studygroup_mode` = 0
+ ");
$update_courses->execute();
while ($row = $update_courses->fetch(PDO::FETCH_ASSOC)) {
DBManager::get()->execute($sql, [