diff options
| author | Scott Ostler <scottbot9000@gmail.com> | 2010-08-22 19:46:15 -0400 |
|---|---|---|
| committer | Scott Ostler <scottbot9000@gmail.com> | 2010-08-22 19:46:15 -0400 |
| commit | 40683eda906135fb1880ead890a0fcba7c256347 (patch) | |
| tree | edf7214958a34c86a4c21da86a6deba534a63e2f /src | |
| parent | 4aad093c8434742c4548b24854b920f1a08b9de7 (diff) | |
dumb change to fetch-dumps-by-nick
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 |
