summaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorScott Ostler <scottbot9000@gmail.com>2010-08-22 19:46:15 -0400
committerScott Ostler <scottbot9000@gmail.com>2010-08-22 19:46:15 -0400
commit40683eda906135fb1880ead890a0fcba7c256347 (patch)
treeedf7214958a34c86a4c21da86a6deba534a63e2f /src
parent4aad093c8434742c4548b24854b920f1a08b9de7 (diff)
dumb change to fetch-dumps-by-nick
Diffstat (limited to 'src')
-rw-r--r--src/tags.clj2
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