From 40683eda906135fb1880ead890a0fcba7c256347 Mon Sep 17 00:00:00 2001
From: Scott Ostler <scottbot9000@gmail.com>
Date: Sun, 22 Aug 2010 19:46:15 -0400
Subject: dumb change to fetch-dumps-by-nick

---
 src/tags.clj | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src')

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
-- 
cgit v1.2.3-70-g09d2