summaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authordumpfmprod <dumpfmprod@ubuntu.(none)>2010-08-22 19:49:11 -0400
committerdumpfmprod <dumpfmprod@ubuntu.(none)>2010-08-22 19:49:11 -0400
commit07c94d40b8051849f362cc8475e6fec12eddd4f0 (patch)
tree52f3c55963891c1d4de002eb45acb5240fbc6a5f /src
parent0791d4f2c2152c4e88ba6c4527fe354667cacf45 (diff)
parent40683eda906135fb1880ead890a0fcba7c256347 (diff)
Merge branch 'master' of /pichat/repo
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