Merge branch 'master' of ssh://dump.fm/pichat/repo

6 files changed, 184 insertions, 157 deletions

diff --git a/src/datalayer.clj b/src/datalayer.clj
index 6b2a466..8590a7d 100644
--- a/src/datalayer.clj
+++ b/src/datalayer.clj
@@ -1,4 +1,5 @@
 (ns datalayer
+  (:import java.util.Date)
   (:require redis
             tags)
   (:use clojure.contrib.sql
@@ -10,8 +11,6 @@
         user
         utils))
 
-
-
 ;;;; Message lookup
 
 (defn recent-posts-query [user-id]
@@ -81,41 +80,46 @@ WHERE  u.nick = ANY(?)"
 
 ;;;; Popular Posts
 
-(def popular-dumps-qry "
-select u.nick, u.avatar, r.key, m.message_id, m.content, m.created_on, count(*) as count,
-               array_agg(u2.nick) as user_nicks
-from users u, messages m, rooms r, tags t, users u2
-where lower(u.nick) = lower(?)
-and u.user_id = m.user_id and m.message_id = t.message_id
-and m.room_id = r.room_id and m.is_image = true and r.admin_only = false
-and t.tag = 'favorite'
-and t.user_id = u2.user_id
-group by u.nick, u.avatar, r.key, m.message_id, m.content, m.created_on
-order by count desc limit ? offset ?")
-
-(defn fetch-popular-dumps [nick viewer-nick]
-  (for [d (do-select [popular-dumps-qry nick 40 0])]
-    (let [favers (.getArray (:user_nicks d))]
-      (assoc d
-        :favers    favers
-        :favorited (some #(= % viewer-nick) favers)))))
+(defn redis-popular-key [nick]
+  (str "popular:" nick))
 
 (defn fetch-popular-dumps-redis [nick viewer-nick]
-  (let [rkey      (str "popular:" nick)
-        msg-ids   (redis/with-server redis-server
-                    (redis/zrevrange rkey 0 (dec num-popular-dumps)))
+  (let [msg-ids   (redis/with-server redis-server
+                    (redis/zrevrange (redis-popular-key nick)
+                                     0
+                                     (dec num-popular-dumps)))
         msg-ids   (map maybe-parse-int msg-ids)]
     (if-not (empty? msg-ids)
-      (tags/fetch-dumps-by-ids msg-ids viewer-nick))))
+      (sort-by
+       #(* -1 (:count %))
+       (tags/fetch-dumps-by-ids msg-ids viewer-nick)))))
 
 
 ;;;; Redis Favscores
 
+(def score-piece-map
+     (zipmap
+      [:pawn :knight :bishop :rook :queen :king :skull]
+      ["♟" "♞" "♝" "♜" "♛" "♚" "☠"]))
+
+(defn score-to-piece [score]
+  (cond (= score -1)   :skull 
+        (= score 0)    :pawn
+        (< score 50)   :knight
+        (< score 150)  :bishop
+        (< score 300)  :rook
+        (< score 1000) :queen
+        :else :king))
+
+(def score-to-entity (comp score-piece-map score-to-piece))
+
+(def redis-favscores-key "favscores")
+
 (defn fetch-redis-directory [page num]
   (vec
    (for [t (with-jedis
              #(.zrevrangeWithScores %
-                                    "favscores"
+                                    redis-favscores-key
                                     (* page num)
                                     (dec (* (inc page) num))))]
      {:nick  (.getElement t)
@@ -142,19 +146,27 @@ order by count desc limit ? offset ?")
 
 ;;;; Redis Hall of Fame
 
+(def redis-hall-key "hall")
+
 (defn fetch-redis-hall [viewer-nick]
   (let [ids (map maybe-parse-int
                  (redis/with-server redis-server
-                   (redis/zrevrange "hall" 0 (dec num-hall-dumps))))]
+                   (redis/zrevrange redis-hall-key 0 (dec num-hall-dumps))))]
     (if-not (empty? ids)
-      (tags/fetch-dumps-by-ids ids viewer-nick))))
+      (sort-by
+       #(* -1 (:count %))
+       (tags/fetch-dumps-by-ids ids viewer-nick)))))
 
 ;;;; Message insertion
 
+(defn direct-message-key [u-id]
+  (str "directmessage:" u-id))
+
 (def msg-insert-query
   "INSERT INTO messages (user_id, room_id, content, is_image, is_text)
    VALUES (?, ?, ?, ?, ?) RETURNING message_id, created_on")
 
+;; Note: direct-message recipients are inserted into postgres, but topics aren't.
 (defn insert-message-into-postgres! [author-id room-id content is-image is-text recips]
   (with-connection *db*
     (transaction
@@ -169,43 +181,83 @@ order by count desc limit ? offset ?")
           [msg-id author-id (:user_id r)]))
        [msg-id ts]))))
 
-(defn insert-recips-into-redis! [recips author-id ts content]
-  (let [dm-json (json-str {"author_id" author-id
-                           "recips" (map :nick recips)
-                           "content" content})]
+(defn insert-recips-into-redis! [recips author-id dt content room-key]
+  (let [msg-json (json-str {"author_id" author-id
+                            "recips" (map :nick recips)
+                            "key"    room-key
+                            "content" content})
+        ts       (.getTime dt)]
     (redis/with-server redis-server
       (redis/atomically
        (doseq [r recips]
-         (redis/zadd (str "directmessage:" (:user_id r))
-                     (.getTime ts)
-                     dm-json))))))
+         (redis/zadd (direct-message-key (:user_id r))
+                     ts
+                     msg-json))))))
+
+(defn topic-key [topic]
+  (str "topic:" topic))
 
-(defn insert-message! [author-id author-nick room-id content]
+(defn insert-topics-into-redis! [topics recips author-nick author-avatar dt msg-id content room-key]
+  (let [ts         (.getTime dt)
+        msg-json   (json-str {"nick"          author-nick
+                              "avatar"        author-avatar
+                              "recips"        (map :nick recips)
+                              "content"       content
+                              "key"           room-key
+                              "message_id"    msg-id
+                              "ts"            ts})]
+    (redis/with-server redis-server
+      (redis/atomically
+       (doseq [t topics]
+         (redis/lpush (topic-key t)
+                      msg-json))))))
+
+(defn insert-message! [author-id author-nick author-avatar room content]
   (let [msg-type    (classify-msg content)
         is-image    (boolean (#{:image :mixed} msg-type))
         is-text     (boolean (#{:mixed :text} msg-type))
         recips      (get-recips content)
-        [msg-id ts] (insert-message-into-postgres! author-id
-                                                   room-id
+        topics      (get-topics content)
+        [msg-id dt] (insert-message-into-postgres! author-id
+                                                   (:room_id room)
                                                    content
                                                    is-image
                                                    is-text
                                                    recips)]
-    (if-not (empty? recips)
-      (insert-recips-into-redis! recips author-id ts content))
+    (when-not (:admin_only room)
+      (if-not (empty? recips)
+        (insert-recips-into-redis! recips author-id dt content (:key room)))
+      (if-not (empty? topics)
+        (insert-topics-into-redis! topics recips author-nick author-avatar dt msg-id content (:key room))))
     {:author  author-nick
      :msg-id  msg-id
-     :room    room-id
-     :db-ts   ts
+     :room    (:room_id room)
+     :db-ts   dt
      :content content
-     :recips  (map (comp lower-case :nick) recips)}))
+     :recips  (map :nick recips)
+     }))
 
-(defn fetch-private-messages [user-id]
+(defn fetch-direct-messages [user-id]
   (for [dm (redis/with-server redis-server
-             (redis/zrevrange (str "directmessage:" user-id) 0 40))]
+             (redis/zrevrange (direct-message-key user-id) 0 40))]
     (let [dm    (read-json dm)
           info  (fetch-user-id (get dm "author_id"))]
       {"nick"    (:nick info)
        "content" (get dm "content")
        "recips"  (get dm "recips" [])
        "avatar" (:avatar info)})))
+
+(def topic-fetch-num 40)
+
+(defn fetch-topic [viewer-id topic]
+  (let [redis-msgs (redis/with-server redis-server
+                     (redis/lrange (topic-key topic) 0 topic-fetch-num))
+        raw-msgs (for [m redis-msgs]
+                   (let [m (keywordify (read-json m))]
+                     (assoc m
+                       :created_on (Date. (:ts m)))))]
+    (if viewer-id
+      (tags/add-user-favs-to-msgs
+       raw-msgs
+       viewer-id)
+      raw-msgs)))
diff --git a/src/message.clj b/src/message.clj
index a8e0e9b..5b3b66f 100644
--- a/src/message.clj
+++ b/src/message.clj
@@ -1,5 +1,6 @@
 (ns message
-  (:use user))
+  (:use user
+        utils))
 
 ;; Message parsing
 
@@ -26,7 +27,7 @@
 (defn get-recips [content]
   (filter
    boolean
-   (for [at-nick (re-seq recip-regex content)]
+   (for [at-nick (set (re-seq recip-regex content))]
      (fetch-nick (.substring (.trim at-nick) 1)))))
 
 (defn get-recips-from-msgs [msgs]
@@ -37,3 +38,10 @@
      boolean
      (for [r recips]
        (fetch-nick (.substring (.trim r) 1))))))
+
+(def topic-regex #"(?:^|\s)#\w+")
+
+(defn get-topics [content]
+  (set
+   (for [r (re-seq topic-regex content)]
+     (lower-case (.substring (.trim r) 1)))))
diff --git a/src/redisload.clj b/src/redisload.clj
index 31a25f0..8796d9e 100644
--- a/src/redisload.clj
+++ b/src/redisload.clj
@@ -9,6 +9,8 @@
 (defn redis-days [n]
   (* 24 60 60))
 
+;;;; Tag counters
+
 (def tag-query "
 SELECT
     u.nick as author,
@@ -65,7 +67,7 @@ WHERE
 (defn transmit-popular []
   (doseq [[nick msgs] @popular-map]
     (let [sorted-msgs (sort #(>= (second %1) (second %2)) msgs)
-          userkey     (str "popular:" nick)]
+          userkey     (redis-popular-key nick)]
       (redis/atomically
        (redis/del key)
        (doseq [[msg-id score] (take (* num-popular-dumps 2)
@@ -75,19 +77,19 @@ WHERE
 
 (defn transmit-favscores []
   (redis/atomically
-   (redis/del "favscores")
+   (redis/del redis-favscores-key)
    (doseq [[nick score] @score-map]
-     (redis/zadd "favscores" score (lower-case nick))))
+     (redis/zadd redis-favscores-key score (lower-case nick))))
   (println "cached favscores for " (count @score-map) "users"))
 
 (defn transmit-hall []
   (let [scores (take (* 2 num-hall-dumps)
                      (sort #(>= (second %1) (second %2)) @hall-map))]
     (redis/atomically
-     (redis/del "hall")
+     (redis/del redis-hall-key)
      (doseq [[msg-id score] scores]
-       (redis/zadd "hall" score msg-id)))))
-     
+       (redis/zadd redis-hall-key score msg-id)))
+    (println "cached hall-of-fame")))
 
 (println "streaming tags")
 (stream-tags [update-popular])
diff --git a/src/site.clj b/src/site.clj
index 3ec07a5..5b20361 100644
--- a/src/site.clj
+++ b/src/site.clj
@@ -71,9 +71,9 @@
   (assoc d :created_on (.getTime (d :created_on))))
 
 (defn message-room-link [m]
-  (if (= (:key m) "dumpfm")
-    "http://dump.fm/chat"
-    (format "http://%s.dump.fm" (:key m))))
+  (if (default-room? (:key m *default-room*))
+    "http://dump.fm/"
+    (format "http://%s.dump.fm/" (:key m))))
 
 (defn process-message-for-output [d]
   (escape-html-deep 
@@ -306,65 +306,6 @@ WHERE  user_id IN
 		                [(session-assoc-from-db db-user)
 		                 (resp-success "OK")])))))
 
-;; Fav scores
-
-(def *score-query* "
-SELECT u.user_id,
-       u.nick,
-       COUNT(*) AS cnt
-FROM   tags t,
-       messages m,
-       users u
-WHERE  t.message_id = m.message_id
-       AND m.user_id != t.user_id
-       AND m.user_id = u.user_id
-GROUP  BY u.user_id, u.nick
-ORDER BY cnt DESC
-")
-
-(defn build-score-list []
-  (let [res (vec (do-select [*score-query*]))]
-    {:list res
-     :map  (zipmap (map :nick res) (map :cnt res))}))
-
-;; sostler: stop score refresh until redis cache can be added
-(def *scores-refresh-period-sec* (* 29 60 9999999))
-
-(def *user-scores*
-     (scheduled-agent build-score-list
-                      *scores-refresh-period-sec*
-                      []))
-
-(def *piece-map*
-     (zipmap
-      [:pawn :knight :bishop :rook :queen :king :skull]
-      ["&#9823;" "&#9822;" "&#9821;" "&#9820;" "&#9819;" "&#9818;" "&#9760;"]))
-
-(defn score-to-piece [score]
-  (cond (= score -1)   :skull 
-        (= score 0)    :pawn
-        (< score 50)   :knight
-        (< score 150)  :bishop
-        (< score 300)  :rook
-        (< score 1000) :queen
-        :else :king))
-
-(def score-to-entity (comp *piece-map* score-to-piece))
-
-(defn lookup-score [nick]
-  (if (= (lower-case nick) "scottbot")
-    -1
-    (let [scores (:map (poll *user-scores*))]
-      (get scores nick 0))))
-
-(defn get-user-ranking [offset num]
-  (if-let [ranking  (:list (poll *user-scores*))]
-    (let [cnt       (count ranking)]
-      (subvec ranking
-              (min cnt (* offset num))
-              (min cnt (* (inc offset) num))))))
-
-
 ;; Profile
 
 (defn pull-random-dump-images [dumps num]
@@ -375,7 +316,8 @@ ORDER BY cnt DESC
                       (comp take-images :content)
                       dumps))))))
 
-(def use-redis-favscore true)
+(defn pull-recips [dumps]
+  (set (apply concat (map #(get % "recips" []) dumps))))
 
 (defn profile
   ([session profile-nick] (profile session profile-nick "profile"))
@@ -386,15 +328,13 @@ ORDER BY cnt DESC
              nick          (:nick session)
              logger        (make-time-logger)
              is-home       (and nick (= nick profile-nick))
-             score         (if use-redis-favscore
-                             (fetch-redis-favscore profile-nick)
-                             (lookup-score profile-nick))
+             score         (fetch-redis-favscore profile-nick)
 	     dumps         (logger tags/fetch-dumps
                                    :user-tag-id (:user_id session)
 				   :nick profile-nick
 				   :limit 10)
-             dms           (fetch-private-messages (:user_id user-info))
-             recips        (set (apply concat (map #(get % "recips") dms)))
+             dms           (fetch-direct-messages (:user_id user-info))
+             recips        (pull-recips dms)
              imgs          (pull-random-dump-images dumps 5)]
          (do
            (.setAttribute st "is_home" is-home)
@@ -406,7 +346,7 @@ ORDER BY cnt DESC
 	   (.setAttribute st "score_ent" (score-to-entity score))
            (when-not (empty? dms)
              (.setAttribute st "dms" dms)
-             (.setAttribute st "recips" (json-str (map lower-case recips))))
+             (.setAttribute st "recips" (json-str recips)))
            (if (not (empty? imgs))
 	     (.setAttribute st "imgs" imgs))
 	   (.setAttribute st "debug_log_items" (logger))
@@ -457,9 +397,7 @@ ORDER BY cnt DESC
 (defn build-mini-profile [user-info]
   (let [st    (fetch-template-fragment "mini_profile")
         nick  (user-info :nick)
-        score (if use-redis-favscore
-                (fetch-redis-favscore nick)
-                (lookup-score nick))]
+        score (fetch-redis-favscore nick)]
     (doseq [a [:nick :avatar :contact :bio]]
       (let [v (user-info a)]
         (.setAttribute st (name a)
@@ -486,6 +424,7 @@ ORDER BY cnt DESC
                        :msg-id msg-id
                        :date (if msg-id nil date)
                        :limit (inc *dumps-per-page*))
+        recips        (map :nick (get-recips-from-msgs raw-dumps))
         back-dumps    (if (or date msg-id)
                         (tags/fetch-dumps
                          :nick (:nick user-info)
@@ -497,8 +436,9 @@ ORDER BY cnt DESC
     (.setAttribute st "nick" (:nick user-info))
     (.setAttribute st "is_home" (= (:nick user-info) (:nick session)))
     (.setAttribute st "mini_profile" (build-mini-profile user-info))
-    (if (> (count dumps) 0)
+    (when (> (count dumps) 0)
       (.setAttribute st "dumps" dumps))
+    (.setAttribute st "recips" (json-str recips))
     (.setAttribute st "prev"
                    (if back-dumps
                      (cond
@@ -518,20 +458,18 @@ ORDER BY cnt DESC
 
 ;; Who faved me
 
-(def use-popular-redis true)
-
 (defn popular [session profile-nick]
   (if-let [user-info (fetch-nick profile-nick)]
     (let [st            (fetch-template "popular" session)
 	  profile-nick  (:nick user-info)
-	  raw-dumps     (if use-popular-redis
-                          (fetch-popular-dumps-redis profile-nick (:nick session))
-                          (fetch-popular-dumps       profile-nick (:nick session)))
+	  raw-dumps     (fetch-popular-dumps-redis profile-nick (:nick session))
           raw-dumps     (filter #(> (:count %) 0) raw-dumps)
+          recips        (map :nick (get-recips-from-msgs raw-dumps))
 	  dumps         (map process-message-for-output raw-dumps)]
       (.setAttribute st "nick" profile-nick)
       (.setAttribute st "mini_profile" (build-mini-profile user-info))
       (.setAttribute st "dumps" dumps)
+      (.setAttribute st "recips" (json-str recips))
       (.toString st))
     (resp-error "NO_USER")))
 
@@ -603,6 +541,7 @@ ORDER BY cnt DESC
     (if (= nick-from-url (:nick message))
       (let [st (fetch-template "single_message" session)]
         (.setAttribute st "dump" (process-message-for-output message))
+        (.setAttribute st "recips" (json-str (map :nick (get-recips (:content message)))))
         (.toString st))
       (resp-error "NO_MESSAGE"))
     (resp-error "NO_MESSAGE")))
@@ -638,7 +577,7 @@ ORDER BY cnt DESC
       (doto st
 	(.setAttribute "users" (prepare-user-list room true))
 	(.setAttribute "messages" message-list)
-        (.setAttribute "recips" (json-str (map lower-case recips)))
+        (.setAttribute "recips" (json-str recips))
 	(.setAttribute "roomkey" (room :key))
 	(.setAttribute "isadminroom" (room :admin_only))
 	(.setAttribute "json_room_key" (json-str (room :key)))
@@ -670,7 +609,7 @@ ORDER BY cnt DESC
 						     :avatar    (session :avatar)}))
 	 (commute users assoc nick (user-struct-from-session session))))
      (resp-success (assoc (updates nick room old-ts)
-		          :timestamp now)))))
+                     :timestamp now)))))
 
 (defn validated-refresh [session params]
   (let [room-key (params :room)
@@ -703,16 +642,16 @@ ORDER BY cnt DESC
            mute                (resp-error (format-mute mute))
            :else
 	   (let [content    (validated-content content session)
-	         msg-info   (insert-message! user-id nick (:room_id room) content)
+	         msg-info   (insert-message! user-id nick (:avatar session) room content)
                  msg-id     (:msg-id msg-info)]
 	     (dosync
-              (if (not (contains? (ensure (room :users)) nick))
-                (login-user (user-struct-from-session session) room))
-              (add-message (build-msg nick content msg-id (:recips msg-info)) room))
+              (let [msg-struct (build-msg nick content msg-id (:recips msg-info))]
+                (if (not (contains? (ensure (room :users)) nick))
+                  (login-user (user-struct-from-session session) room))
+                (add-message msg-struct room)))
              (resp-success {:msgid msg-id
                             :recips (:recips msg-info)})))))
 
-
 (defn validated-msg [session params request]
   (cond
    (not (validate-room-access (params :room) session)) (resp-error "UNKNOWN_ROOM")
@@ -720,7 +659,6 @@ ORDER BY cnt DESC
 
 ;; Browser
 
-;; TODO: make work for all rooms
 (defn browser [session]
   (let [room  (lookup-room *default-room*)
         now   (System/currentTimeMillis)
@@ -740,6 +678,21 @@ ORDER BY cnt DESC
     (.toString st)))
 
 
+;; Topics
+
+(defn topic [session topic]
+  (let [topic  (lower-case topic)
+        msgs   (map
+                process-message-for-output
+                (fetch-topic (:user_id session) topic))
+        recips (pull-recips msgs)
+        st     (fetch-template "topic" session)]
+    (.setAttribute st "recips" (json-str recips))
+    (.setAttribute st "topic" topic)
+    (if-not (empty? msgs)
+      (.setAttribute st "dumps" msgs))
+    (.toString st)))
+
 ;; Chat Log
 
 (defn log [session room offset params]
@@ -755,7 +708,9 @@ ORDER BY cnt DESC
                             :image-only image-only
                             :amount (+ 1 *dumps-per-page*)
                             :offset dump-offset)
-        dumps       (map tags/add-favorited-flag (take *dumps-per-page* raw-dumps) (repeat session))
+        dumps       (map tags/add-favorited-flag
+                         (take *dumps-per-page* raw-dumps)
+                         (repeat session))
         ;;   json-tags (for [dump dumps :when (not (empty? (dump :tags)))] 
         ;;               (json-str {"id" (dump :message_id) "tags" (dump :tags) }))
         dumps       (map tags/remove-tags-for-output dumps)
@@ -799,8 +754,6 @@ ORDER BY cnt DESC
     (.setAttribute st "dumps" dumps)
     (.toString st)))
         
-
-
 ;; Altars
 
 ;; if :nick is in params, will fetch only altars by that nick
@@ -952,6 +905,7 @@ ORDER BY cnt DESC
                        :hide-vip (not (:is_admin session))
                        :date (if msg-id nil date)
                        :limit (inc *dumps-per-page*))
+        recips        (map :nick (get-recips-from-msgs raw-dumps))
         back-dumps    (if (or date msg-id)
                         (tags/fetch-tagged-dumps
                          :nick (:nick user-info)
@@ -971,6 +925,7 @@ ORDER BY cnt DESC
     (if (> (count raw-dumps) *dumps-per-page*)
       (.setAttribute st "next" (favorites-next-page-link (:nick user-info) (last raw-dumps))))
     (.setAttribute st "dumps" dumps)
+    (.setAttribute st "recips" (json-str recips))
     (.setAttribute st "infobar" (build-mini-profile user-info))
     (.setAttribute st "page_title" (format "%s'S FAVS" (:nick user-info)))
     (.setAttribute st "debug_log_items" (logger))
@@ -1134,11 +1089,17 @@ ORDER BY cnt DESC
           date       (today)
           dest       (open-file [*image-directory* date] filename)
           url        (image-url-from-file "images" date dest)
-          msg-info   (insert-message! (:user_id session) (:nick session)
-                                      (:room_id room) url)]
+          msg-info   (insert-message! (:user_id session)
+                                      (:nick session)
+                                      (:avatar session)
+                                      room
+                                      url)]
       (copy (:tempfile image) dest)
       (dosync
-       (let [msg (build-msg (:nick session) url (:msg-id msg-info) (:recips msg-info))]
+       (let [msg (build-msg (:nick session)
+                            url
+                            (:msg-id msg-info)
+                            (:recips msg-info))]
          (add-message msg room)))
       [200 "OK"])))
 
@@ -1245,6 +1206,9 @@ ORDER BY cnt DESC
   (GET "/r/:room/log/:offset"              (validated-log session (params :room) (params :offset) params))
 
   (GET "/favicon.ico" (serve-static "static" "favicon.ico"))
+
+  (GET "/t/:topic" (topic session (params :topic)))
+  
   (GET "/u/:nick"  (redirect-to (str "/" (params :nick))))
   (GET "/u/:nick/" (redirect-to (str "/" (params :nick))))
   (GET "/u/:nick/tag/:tag" (tagged-dumps-by-nick session params (request-url request)))
@@ -1441,7 +1405,7 @@ ORDER BY cnt DESC
 (start-user-flusher!)
 (start-session-pruner!)
 
-(if (not= *server-url* "http://dump.fm")
-  (start! random-poster))
+;(if (not= *server-url* "http://dump.fm")
+;  (start! random-poster))
   
 
diff --git a/src/user.clj b/src/user.clj
index 7641bd8..8380bce 100644
--- a/src/user.clj
+++ b/src/user.clj
@@ -18,7 +18,7 @@
 
 ;;; User info cache
 
-(def user-cache-size 500)
+(def user-cache-size 99999)
 (def user-nick-cache (ref {}))
 (def user-id-cache (ref {}))
 
diff --git a/src/utils.clj b/src/utils.clj
index 8aaffba..760ae63 100755
--- a/src/utils.clj
+++ b/src/utils.clj
@@ -27,7 +27,6 @@
       db-name "dumpfm"
       db-user "postgres"
       db-pass "root"]
-  ; TODO: use c3p0 for pooling?
   (def *db* {:datasource (doto (new PGPoolingDataSource)
                            (.setServerName   db-host)
                            (.setDatabaseName db-name)
@@ -48,9 +47,8 @@
       (throw (Exception. (str "Invalid url " u))))))
 
 (defn get-ip [request]
-  (let [ip (get (:headers request) "x-real-ip")  ; behind nginx
-        ip (if ip ip (:remote-addr request))] (str ip))  ; deployed locally
-)
+  (let [ip (get (:headers request) "x-real-ip")           ; behind nginx
+        ip (if ip ip (:remote-addr request))] (str ip)))  ; deployed locally
 
 (defn append [& seqs]
   (reduce into (map vector seqs)))
@@ -70,6 +68,9 @@
 (defn stringify-and-escape [m]
   (zipmap (map str* (keys m)) (map escape-html-deep (vals m))))
 
+(defn keywordify [m]
+  (zipmap (map keyword (keys m)) (vals m)))
+
 (defn nor [& args]
   (not-any? identity args))
 
@@ -371,16 +372,16 @@
 (.setRefreshInterval template-group 10)
 
 (defn initialize-template [st session]
+  (.setAttribute st "domain" config/*server-url*)
   (if (session :nick)
     (doto st
       (.setAttribute "user_email" (session :email))
       (.setAttribute "user_nick" (session :nick))
       (.setAttribute "user_avatar" (if (non-empty-string? (session :avatar))
-				     (session :avatar) nil))
-      (.setAttribute "isadmin" (session :is_admin))
-      (.setAttribute "domain" config/*server-url*))
-    (doto st
-      (.setAttribute "domain" config/*server-url*))))
+                                     (session :avatar)
+                                     nil))
+      (.setAttribute "isadmin" (session :is_admin))))
+  st)
 
 (defn fetch-template [template session]
   (try
@@ -446,7 +447,7 @@
             { :result result :time (System/currentTimeMillis)})
           result)))))
 
-;; Taken from Programming Clojure by Stuart Halloway
+;; From Programming Clojure by Stuart Halloway
 
 (defn index-filter [pred coll]
   (for [[idx elt] (indexed coll) :when (pred elt)] idx))