diff options
| author | dumpfmprod <dumpfmprod@ubuntu.(none)> | 2010-08-22 19:49:11 -0400 |
|---|---|---|
| committer | dumpfmprod <dumpfmprod@ubuntu.(none)> | 2010-08-22 19:49:11 -0400 |
| commit | 07c94d40b8051849f362cc8475e6fec12eddd4f0 (patch) | |
| tree | 52f3c55963891c1d4de002eb45acb5240fbc6a5f /src | |
| parent | 0791d4f2c2152c4e88ba6c4527fe354667cacf45 (diff) | |
| parent | 40683eda906135fb1880ead890a0fcba7c256347 (diff) | |
Merge branch 'master' of /pichat/repo
Diffstat (limited to 'src')
| -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 |
