From 438ac59d939246afe647cbffc018bcd8f13e0417 Mon Sep 17 00:00:00 2001 From: Alexander Ebert Date: Tue, 2 Jul 2013 02:38:49 +0200 Subject: [PATCH] Fixed calculation of number of assigned moderation queues --- .../system/moderation/queue/ModerationQueueManager.class.php | 2 ++ 1 file changed, 2 insertions(+) diff --git a/wcfsetup/install/files/lib/system/moderation/queue/ModerationQueueManager.class.php b/wcfsetup/install/files/lib/system/moderation/queue/ModerationQueueManager.class.php index 6fb743120d..7748bca455 100644 --- a/wcfsetup/install/files/lib/system/moderation/queue/ModerationQueueManager.class.php +++ b/wcfsetup/install/files/lib/system/moderation/queue/ModerationQueueManager.class.php @@ -248,10 +248,12 @@ class ModerationQueueManager extends SingletonFactory { LEFT JOIN wcf".WCF_N."_moderation_queue moderation_queue ON (moderation_queue.queueID = moderation_queue_to_user.queueID) WHERE moderation_queue_to_user.userID = ? + AND moderation_queue_to_user.isAffected = ? AND moderation_queue.status <> ?"; $statement = WCF::getDB()->prepareStatement($sql); $statement->execute(array( WCF::getUser()->userID, + 1, ModerationQueue::STATUS_DONE )); $row = $statement->fetchArray(); -- 2.20.1