From 7ea5168e7bd00a54987a7da73a1b1836bd25035a Mon Sep 17 00:00:00 2001
From: Rasmus Fuhse <fuhse@data-quest.de>
Date: Tue, 8 Jul 2025 13:03:54 +0000
Subject: =?UTF-8?q?Resolve=20"Forum=203=20-=20Ungelesene=20Beitr=C3=A4ge?=
 =?UTF-8?q?=20werden=20nicht=20vom=20alten=20Forum=20=C3=BCbernommen"?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Closes #5661

Merge request studip/studip!4323
---
 db/migrations/6.1.10_forum3_mark_as_read.php | 41 ++++++++++++++++++++++++++++
 1 file changed, 41 insertions(+)
 create mode 100644 db/migrations/6.1.10_forum3_mark_as_read.php

diff --git a/db/migrations/6.1.10_forum3_mark_as_read.php b/db/migrations/6.1.10_forum3_mark_as_read.php
new file mode 100644
index 0000000..f0c3d86
--- /dev/null
+++ b/db/migrations/6.1.10_forum3_mark_as_read.php
@@ -0,0 +1,41 @@
+<?php
+final class Forum3MarkAsRead extends Migration
+{
+    public function description()
+    {
+        return 'Marks discussions as read when they are older than the last visit in the forum';
+    }
+
+    public function up()
+    {
+        $statement = DBManager::get()->prepare("
+            SELECT `pluginid`
+            FROM `plugins`
+            WHERE `pluginclassname` = 'CoreForum'
+        ");
+        $statement->execute();
+        $pluginid = $statement->fetch(PDO::FETCH_COLUMN);
+
+        if ($pluginid) {
+            $statement = DBManager::get()->prepare("
+                INSERT IGNORE INTO `forum_posting_reads` (`discussion_id`, `user_id`, `read_index`, `chdate`)
+                SELECT `forum_discussions`.`discussion_id`,
+                       `object_user_visits`.`user_id`,
+                       `object_user_visits`.`visitdate`,
+                       UNIX_TIMESTAMP()
+                FROM `object_user_visits`
+                JOIN `forum_topics` ON (`forum_topics`.`range_id` = `object_user_visits`.`object_id`)
+                JOIN `forum_discussions` ON (`forum_discussions`.`topic_id` = `forum_topics`.`topic_id`)
+                WHERE `object_user_visits`.`plugin_id` = :pluginid
+            ");
+            $statement->execute(['pluginid' => $pluginid]);
+        }
+    }
+
+    public function down()
+    {
+        DBManager::get()->exec("
+            DELETE FROM `forum_posting_reads`
+        ");
+    }
+}
-- 
cgit v1.0