diff options
| author | sostler <sbostler@gmail.com> | 2010-05-20 13:22:43 -0400 |
|---|---|---|
| committer | sostler <sbostler@gmail.com> | 2010-05-20 13:22:43 -0400 |
| commit | be5ae0f99e685177d51ff82304eb525e6790ea7d (patch) | |
| tree | 73e6200538c8128fd1ec8bb1c9f503643f3f1305 /src | |
| parent | c500b9133d80d1e9757fa62237f772404e5fa298 (diff) | |
Enable room disabling
Diffstat (limited to 'src')
| -rw-r--r-- | src/rooms.clj | 4 | ||||
| -rw-r--r-- | src/site.clj | 9 |
2 files changed, 7 insertions, 6 deletions
diff --git a/src/rooms.clj b/src/rooms.clj index 5e1feb1..32239d2 100644 --- a/src/rooms.clj +++ b/src/rooms.clj @@ -35,10 +35,10 @@ (@rooms (lower-case key))) (defn fetch-room [key] - (first (do-select ["SELECT * FROM rooms WHERE key = LOWER(?)" key]))) + (first (do-select ["SELECT * FROM rooms WHERE key = LOWER(?) AND active" key]))) (defn fetch-rooms [] - (do-select ["SELECT * FROM ROOMS"])) + (do-select ["SELECT * FROM ROOMS WHERE active"])) (defn count-messages-by-room [room-id image-only] (let [query (str "SELECT COUNT(*) diff --git a/src/site.clj b/src/site.clj index a221fb4..a472dfe 100644 --- a/src/site.clj +++ b/src/site.clj @@ -329,11 +329,12 @@ ORDER BY cnt DESC; (def *piece-map* (zipmap - [:pawn :knight :bishop :rook :queen :king] - ["♟" "♞" "♝" "♜" "♛" "♚"])) + [:pawn :knight :bishop :rook :queen :king :skull] + ["♟" "♞" "♝" "♜" "♛" "♚" "☠"])) (defn score-to-piece [score] - (cond (= score 0) :pawn + (cond (= score -1) :skull + (= score 0) :pawn (< score 50) :knight (< score 150) :bishop (< score 300) :rook @@ -388,7 +389,7 @@ ORDER BY created_on DESC; has-avatar (non-empty-string? (user-info :avatar)) offset (maybe-parse-int offset 0) score (if (= (lower-case profile-nick) "scottbot") - 9999 + -1 (or ((poll *user-scores*) profile-nick) 0)) dump-offset (* offset *dumps-per-page*) raw-dumps (logger tags/fetch-dumps-by-nick |