From be5ae0f99e685177d51ff82304eb525e6790ea7d Mon Sep 17 00:00:00 2001 From: sostler Date: Thu, 20 May 2010 13:22:43 -0400 Subject: Enable room disabling --- src/rooms.clj | 4 ++-- src/site.clj | 9 +++++---- 2 files changed, 7 insertions(+), 6 deletions(-) (limited to 'src') 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 -- cgit v1.2.3-70-g09d2