diff options
| author | Scott Ostler <scottbot9000@gmail.com> | 2010-06-18 21:17:47 -0400 |
|---|---|---|
| committer | Scott Ostler <scottbot9000@gmail.com> | 2010-06-18 21:17:47 -0400 |
| commit | 92f46acde02afacd7ea8de29442dd68ebe71a37b (patch) | |
| tree | 7a3d53f30241a7411f6e715a10a43d080262c152 | |
| parent | 91a7cdece73fe045484e019df636434c3c672577 (diff) | |
removed users_dumps_faved_cnt
| -rw-r--r-- | src/site.clj | 9 | ||||
| -rw-r--r-- | template/profile.st | 1 |
2 files changed, 0 insertions, 10 deletions
diff --git a/src/site.clj b/src/site.clj index 77ea36b..a5b87d3 100644 --- a/src/site.clj +++ b/src/site.clj @@ -400,13 +400,6 @@ FROM users u and t.message_id = m.message_id and m.is_image = true" (.toLowerCase nick)])))) -(defn count-users-dumps-faved [nick] - (:count - (first - (do-select ["select count(distinct(m.message_id)) from users u, tags t, messages m - where t.message_id = m.message_id and t.tag = 'favorite' - and m.user_id = u.user_id and lower(u.nick) = ?" - (.toLowerCase nick)])))) (defn profile ([session profile-nick offset] (profile session profile-nick offset "profile")) ([session profile-nick offset template] @@ -420,7 +413,6 @@ FROM users u offset (maybe-parse-int offset 0) dump-cnt (count-dumps-posted profile-nick) fav-from-cnt (count-dumps-user-faved profile-nick) - fav-to-cnt (count-users-dumps-faved profile-nick) score (lookup-score profile-nick) dump-offset (* offset *dumps-per-page*) raw-dumps (logger tags/fetch-dumps-by-nick @@ -444,7 +436,6 @@ FROM users u (.setAttribute st "score_ent" (score-to-entity score)) (.setAttribute st "dump_cnt" dump-cnt) (.setAttribute st "dumps_user_faved_cnt" fav-from-cnt) - (.setAttribute st "users_dumps_faved_cnt" fav-to-cnt) (if (not= offset 0) (.setAttribute st "prev" (max (dec offset) 0))) (.setAttribute st "debug_log_items" (logger)) diff --git a/template/profile.st b/template/profile.st index defe414..547772e 100644 --- a/template/profile.st +++ b/template/profile.st @@ -40,7 +40,6 @@ <div>dumps posted: $dump_cnt$</div> <div>dumps $nick$ faved: $dumps_user_faved_cnt$</div> - <div>$nick$'s dumps faved: $users_dumps_faved_cnt$</div> $if(is_home)$ <div id="avatar-editing" style="display: none"> |