From 4f6fe9fc1033e388c5cdf1dab6afa799547b30ef Mon Sep 17 00:00:00 2001
From: Marvin Borner
Date: Mon, 28 Sep 2020 20:10:10 +0200
Subject: Added hidden attribute

---
 motto/index.js | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/motto/index.js b/motto/index.js
index 423a19a..ec14a33 100644
--- a/motto/index.js
+++ b/motto/index.js
@@ -23,7 +23,7 @@ function create_db() {
     });
 
     db.run(
-        "CREATE TABLE IF NOT EXISTS theme(id INTEGER PRIMARY KEY AUTOINCREMENT, main TEXT NOT NULL, description TEXT NOT NULL, votes INTEGER DEFAULT 0, UNIQUE(main, description))",
+        "CREATE TABLE IF NOT EXISTS theme(id INTEGER PRIMARY KEY AUTOINCREMENT, main TEXT NOT NULL, description TEXT NOT NULL, votes INTEGER DEFAULT 0, hidden BOOL DEFAULT 0 UNIQUE(main, description))",
         (err) => {
             if (err) console.error(err.message);
         }
@@ -60,7 +60,7 @@ app.use("/", express.static(__dirname + "/public"));
 app.use("/api/", apiLimiter);
 
 app.get("/api/list", (req, res) => {
-    db.all("SELECT * FROM theme ORDER BY votes DESC", (err, all) => {
+    db.all("SELECT * FROM theme WHERE hidden = 0 ORDER BY votes DESC", (err, all) => {
         if (err) {
             res.send("error");
             console.error(err.message);
-- 
cgit v1.2.3