diff options
| -rw-r--r-- | motto/index.js | 4 |
1 files 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); |