Reformat SQL queries using spaces

[GitHub/WoltLab/com.woltlab.wcf.conversation.git] / files / lib / system / search / ConversationMessageSearch.class.php

diff --git a/files/lib/system/search/ConversationMessageSearch.class.php b/files/lib/system/search/ConversationMessageSearch.class.php
index 190e78a2ca9fa3ea31e3fa5167ad61b2afe49028..ace6d308a25352390fa01457c0a315ad4f41600b 100644 (file)
--- a/files/lib/system/search/ConversationMessageSearch.class.php
+++ b/files/lib/system/search/ConversationMessageSearch.class.php
@@ -76,8 +76,13 @@ class ConversationMessageSearch extends AbstractSearchableObjectType
      */
     public function getJoins()
     {
-        return "JOIN wcf" . WCF_N . "_conversation_to_user conversation_to_user ON (conversation_to_user.participantID = " . WCF::getUser()->userID . " AND conversation_to_user.conversationID = " . $this->getTableName() . ".conversationID)
-                       LEFT JOIN wcf" . WCF_N . "_conversation conversation ON (conversation.conversationID = " . $this->getTableName() . ".conversationID)";
+        return "    JOIN        wcf" . WCF_N . "_conversation_to_user conversation_to_user
+                    ON          (
+                                    conversation_to_user.participantID = " . WCF::getUser()->userID . "
+                                    AND conversation_to_user.conversationID = " . $this->getTableName() . ".conversationID
+                                )
+                    LEFT JOIN   wcf" . WCF_N . "_conversation conversation
+                    ON          (conversation.conversationID = " . $this->getTableName() . ".conversationID)";
     }
 
     /**