From 737d9431c187f05096680955d69e6f1cfb8f2e03 Mon Sep 17 00:00:00 2001
From: Cyperghost <olaf_schmitz_1@t-online.de>
Date: Tue, 19 Dec 2023 12:47:02 +0100
Subject: [PATCH] Export blog cover photos

---
 .../system/exporter/WBB4xExporter.class.php   | 40 +++++++++++++++++--
 1 file changed, 37 insertions(+), 3 deletions(-)

diff --git a/files/lib/system/exporter/WBB4xExporter.class.php b/files/lib/system/exporter/WBB4xExporter.class.php
index 3d6817d..e82b3f1 100644
--- a/files/lib/system/exporter/WBB4xExporter.class.php
+++ b/files/lib/system/exporter/WBB4xExporter.class.php
@@ -2005,12 +2005,42 @@ final class WBB4xExporter extends AbstractExporter
      */
     public function exportBlogs($offset, $limit)
     {
-        $sql = "SELECT      blog.*, language.languageCode
+        $sourceVersion52 = \version_compare(
+            $this->getPackageVersion('com.woltlab.blog'),
+            '5.2.0 Alpha 1',
+            '>='
+        );
+        $destVersion52 = \version_compare(
+            BLOGCore::getInstance()->getPackage()->packageVersion,
+            '5.2.0 Alpha 1',
+            '>='
+        );
+
+        $sql = "SELECT  packageDir
+                FROM    wcf" . $this->dbNo . "_package
+                WHERE   package = ?";
+        $statement = $this->database->prepareStatement($sql, 1);
+        $statement->execute(['com.woltlab.blog']);
+        $packageDir = $statement->fetchColumn();
+        $blogFilePath = FileUtil::getRealPath($this->fileSystemPath . '/' . $packageDir);
+
+        if ($sourceVersion52 && $destVersion52) {
+            $sql = "SELECT      blog.*, language.languageCode, coverPhoto.fileExtension, coverPhoto.fileHash
                 FROM        blog" . $this->dbNo . "_blog blog
                 LEFT JOIN   wcf" . $this->dbNo . "_language language
                 ON          language.languageID = blog.languageID
-                WHERE       blogID BETWEEN ? AND ?
-                ORDER BY    blogID";
+                LEFT JOIN   blog" . $this->dbNo . "_cover_photo coverPhoto
+                ON          coverPhoto.coverPhotoID = blog.coverPhotoID
+                WHERE       blog.blogID BETWEEN ? AND ?
+                ORDER BY    blog.blogID";
+        } else {
+            $sql = "SELECT      blog.*, language.languageCode
+                FROM        blog" . $this->dbNo . "_blog blog
+                LEFT JOIN   wcf" . $this->dbNo . "_language language
+                ON          language.languageID = blog.languageID
+                WHERE       blog.blogID BETWEEN ? AND ?
+                ORDER BY    blog.blogID";
+        }
         $statement = $this->database->prepareStatement($sql);
         $statement->execute([$offset + 1, $offset + $limit]);
         while ($row = $statement->fetchArray()) {
@@ -2027,6 +2057,10 @@ final class WBB4xExporter extends AbstractExporter
             if ($row['languageCode']) {
                 $additionalData['languageCode'] = $row['languageCode'];
             }
+            if ($sourceVersion52 && $destVersion52 && $row['coverPhotoID']) {
+                $directory = \substr($row["fileHash"], 0, 2);
+                $additionalData['coverPhoto'] = "{$blogFilePath}images/coverPhotos/{$directory}/{$row["coverPhotoID"]}-{$row["fileHash"]}.{$row["fileExtension"]}";
+            }
 
             ImportHandler::getInstance()
                 ->getImporter('com.woltlab.blog.blog')
-- 
2.20.1