From 48c87bc1052bf84b63280ac44ec20081f14e5a89 Mon Sep 17 00:00:00 2001 From: Alexander Ebert Date: Mon, 8 Jul 2013 13:34:02 +0200 Subject: [PATCH] Fixed SQL query --- files/lib/data/conversation/ConversationEditor.class.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/files/lib/data/conversation/ConversationEditor.class.php b/files/lib/data/conversation/ConversationEditor.class.php index 49eaa95..2e3a88d 100644 --- a/files/lib/data/conversation/ConversationEditor.class.php +++ b/files/lib/data/conversation/ConversationEditor.class.php @@ -143,8 +143,8 @@ class ConversationEditor extends DatabaseObjectEditor { $sql = "SELECT participantID AS userID, hideConversation, username FROM wcf".WCF_N."_conversation_to_user WHERE conversationID = ? - participantID <> ? - isInvisible = 0 + AND participantID <> ? + AND isInvisible = 0 ORDER BY username"; $statement = WCF::getDB()->prepareStatement($sql, 5); $statement->execute(array($this->conversationID, $this->userID)); -- 2.20.1