diff options
| -rw-r--r-- | src/tags.clj | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/tags.clj b/src/tags.clj index b6642d3..b95f824 100644 --- a/src/tags.clj +++ b/src/tags.clj @@ -146,7 +146,7 @@ WHERE EXISTS FROM tags, users WHERE message_id = m.message_id AND tags.user_id = users.user_id), ' ') as tags FROM messages m, users u, rooms r - WHERE m.user_id = u.user_id AND u.nick = ? + WHERE m.user_id = u.user_id AND u.user_id = (select user_id from users where lower(nick) = lower(?)) AND r.room_id = m.room_id AND r.admin_only = false " (if image-only "AND m.is_image = true " "") " ORDER BY created_on DESC |