summaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authordumpfmprod <dumpfmprod@ubuntu.(none)>2010-03-17 16:15:02 -0400
committerdumpfmprod <dumpfmprod@ubuntu.(none)>2010-03-17 16:15:02 -0400
commit8eb3322069330b33823eebd81292ce00a632e5e7 (patch)
treed73fa3371b822282f180e4bb2c5b03998054770f /src
parent59ee84bae113dcf4ec4e3e89c9da668de4b67273 (diff)
parente30b950396b7fb7f0b7e97dd083370fa4263300a (diff)
Merge branch 'master' of /pichat/repo
Diffstat (limited to 'src')
-rwxr-xr-xsrc/site.clj4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/site.clj b/src/site.clj
index e0a03e4..43e17a8 100755
--- a/src/site.clj
+++ b/src/site.clj
@@ -211,7 +211,7 @@
(defn fetch-messages-by-nick
([nick image-only] (fetch-messages-by-nick nick image-only 0))
([nick image-only offset]
- (let [query (str "SELECT m.content, m.created_on, u.nick, u.avatar
+ (let [query (str "SELECT m.content, m.created_on, m.message_id, u.nick, u.avatar
FROM messages m, users u, rooms r
WHERE m.user_id = u.user_id AND u.nick = ?
AND r.room_id = m.room_id AND r.admin_only = false "
@@ -412,7 +412,7 @@
(min (count directory)
(* (inc offset) *per-directory-page*)))
user-ids (apply str (interpose ", " (map #(%1 :user_id) users)))
- qry (str "SELECT u.user_id, u.nick, u.avatar, m.content
+ qry (str "SELECT u.user_id, u.nick, u.avatar, m.content, m.message_id
FROM users u, messages m
WHERE u.user_id in (" user-ids ")
AND m.user_id = u.user_id