diff options
| author | dumpfmprod <dumpfmprod@ubuntu.(none)> | 2010-03-17 16:15:02 -0400 |
|---|---|---|
| committer | dumpfmprod <dumpfmprod@ubuntu.(none)> | 2010-03-17 16:15:02 -0400 |
| commit | 8eb3322069330b33823eebd81292ce00a632e5e7 (patch) | |
| tree | d73fa3371b822282f180e4bb2c5b03998054770f /src | |
| parent | 59ee84bae113dcf4ec4e3e89c9da668de4b67273 (diff) | |
| parent | e30b950396b7fb7f0b7e97dd083370fa4263300a (diff) | |
Merge branch 'master' of /pichat/repo
Diffstat (limited to 'src')
| -rwxr-xr-x | src/site.clj | 4 |
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 |
