From 694dbdf6ff3eef3e33fcbe95ebd676eea3353dcc Mon Sep 17 00:00:00 2001
From: Jules Laplace <jules@okfoc.us>
Date: Mon, 7 Sep 2015 02:17:51 -0400
Subject: linking urls

---
 lib/bucky.js    | 2 +-
 lib/db/index.js | 9 +++++----
 2 files changed, 6 insertions(+), 5 deletions(-)

(limited to 'lib')

diff --git a/lib/bucky.js b/lib/bucky.js
index ad2018f..a429fb3 100644
--- a/lib/bucky.js
+++ b/lib/bucky.js
@@ -54,7 +54,7 @@ var bucky = module.exports = {
     })
   },
   ensureHootbox: function (req, res, next){
-    db.getCommentsForThread(1, 9).then(function(hootbox){
+    db.getCommentsForThread(1, 9, 0, "desc").then(function(hootbox){
       res.hootbox = hootbox
       next()
     })
diff --git a/lib/db/index.js b/lib/db/index.js
index 7452f3d..1ebae57 100644
--- a/lib/db/index.js
+++ b/lib/db/index.js
@@ -88,14 +88,15 @@ db.getFileSizes = function(ids){
 
 /* COMMENTS */
 
-db.getCommentsForThread = function (id, limit, offset){
+db.getCommentsForThread = function (id, limit, offset, order){
+  order = order || "asc"
   return Comment.query(function(qb){
-    qb.where("thread", "=", id).orderBy("id", "asc")
+    qb.where("thread", "=", id).orderBy("id", order)
     if (limit) {
-      qb = qb.limit(limit)
+      qb.limit(limit)
     }
     if (offset) {
-      qb = qb.offset(offset)
+      qb.offset(offset)
     }
   }).fetchAll().then(function(comments){
     comments.forEach(function(comment){
-- 
cgit v1.2.3-70-g09d2