diff options
author | Vitaly Takmazov | 2018-07-04 17:53:09 +0300 |
---|---|---|
committer | Vitaly Takmazov | 2018-07-04 17:53:09 +0300 |
commit | ea412bd40ab3576ac752c30705a13c0a7dfac27b (patch) | |
tree | 2d0fc44c3d0b1c6268707f1666fabf67f797e88f /juick-server/src/main/java/com/juick/service/MessagesServiceImpl.java | |
parent | 2e563514d4d3bd5f6ae325376d6c47671e9a474b (diff) |
do not show notifications from banned threads
Diffstat (limited to 'juick-server/src/main/java/com/juick/service/MessagesServiceImpl.java')
-rw-r--r-- | juick-server/src/main/java/com/juick/service/MessagesServiceImpl.java | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/juick-server/src/main/java/com/juick/service/MessagesServiceImpl.java b/juick-server/src/main/java/com/juick/service/MessagesServiceImpl.java index 6c13190f..d64ecc04 100644 --- a/juick-server/src/main/java/com/juick/service/MessagesServiceImpl.java +++ b/juick-server/src/main/java/com/juick/service/MessagesServiceImpl.java @@ -862,6 +862,7 @@ public class MessagesServiceImpl extends BaseJdbcService implements MessagesServ "LEFT JOIN users mu ON m.user_id=mu.id " + "WHERE replies.message_id = :mid " + "AND NOT EXISTS (SELECT 1 FROM banned WHERE banned.reply_id = replies.reply_id) " + + "AND NOT EXISTS (SELECT 1 FROM bl_users b WHERE b.user_id = :uid AND b.bl_user_id = m.user_id) " + "ORDER BY replies.reply_id ASC", new MapSqlParameterSource("mid", mid).addValue("uid", user.getUid()), new MessageMapper()); |