From 0fefef7be46b83e5abbb865643f70308480b984c Mon Sep 17 00:00:00 2001 From: Matthias Schmidt Date: Sun, 8 Sep 2019 16:49:36 +0200 Subject: [PATCH] Fix export of CMS contents See #32 --- files/lib/system/exporter/WBB4xExporter.class.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/files/lib/system/exporter/WBB4xExporter.class.php b/files/lib/system/exporter/WBB4xExporter.class.php index df8c994..561f42a 100644 --- a/files/lib/system/exporter/WBB4xExporter.class.php +++ b/files/lib/system/exporter/WBB4xExporter.class.php @@ -2668,7 +2668,7 @@ class WBB4xExporter extends AbstractExporter { $conditionBuilder = new PreparedStatementConditionBuilder(); $conditionBuilder->add('page_content.pageID IN (?)', [$pageIDs]); $sql = "SELECT page_content.*, - (SELECT languageCode FROM wcf".WCF_N."_language WHERE languageID = page_content.languageID) AS languageCode + (SELECT languageCode FROM wcf".$this->dbNo."_language WHERE languageID = page_content.languageID) AS languageCode FROM wcf".$this->dbNo."_page_content page_content ".$conditionBuilder; $statement = $this->database->prepareStatement($sql); @@ -2747,7 +2747,7 @@ class WBB4xExporter extends AbstractExporter { $conditionBuilder = new PreparedStatementConditionBuilder(); $conditionBuilder->add('media_content.mediaID IN (?)', [$mediaIDs]); $sql = "SELECT media_content.*, - (SELECT languageCode FROM wcf".WCF_N."_language WHERE languageID = media_content.languageID) AS languageCode + (SELECT languageCode FROM wcf".$this->dbNo."_language WHERE languageID = media_content.languageID) AS languageCode FROM wcf".$this->dbNo."_media_content media_content ".$conditionBuilder; $statement = $this->database->prepareStatement($sql); @@ -2764,7 +2764,7 @@ class WBB4xExporter extends AbstractExporter { $conditionBuilder = new PreparedStatementConditionBuilder(); $conditionBuilder->add('media.mediaID IN (?)', [$mediaIDs]); $sql = "SELECT media.*, - (SELECT languageCode FROM wcf".WCF_N."_language WHERE languageID = media.languageID) AS languageCode + (SELECT languageCode FROM wcf".$this->dbNo."_language WHERE languageID = media.languageID) AS languageCode FROM wcf".$this->dbNo."_media media ".$conditionBuilder." ORDER BY media.mediaID"; @@ -2847,7 +2847,7 @@ class WBB4xExporter extends AbstractExporter { $conditionBuilder = new PreparedStatementConditionBuilder(); $conditionBuilder->add('article_content.articleID IN (?)', [$articleIDs]); $sql = "SELECT article_content.*, - (SELECT languageCode FROM wcf".WCF_N."_language WHERE languageID = article_content.languageID) AS languageCode + (SELECT languageCode FROM wcf".$this->dbNo."_language WHERE languageID = article_content.languageID) AS languageCode FROM wcf".$this->dbNo."_article_content article_content ".$conditionBuilder; $statement = $this->database->prepareStatement($sql); -- 2.20.1