From 648762d7a32b27fb43f6931aa93fc4022358ad1b Mon Sep 17 00:00:00 2001
From: Marvin Borner
Date: Mon, 25 Jan 2021 18:59:16 +0100
Subject: idk

---
 questions/index.js | 17 +++--------------
 1 file changed, 3 insertions(+), 14 deletions(-)

(limited to 'questions/index.js')

diff --git a/questions/index.js b/questions/index.js
index daf419d..1f0f4ce 100644
--- a/questions/index.js
+++ b/questions/index.js
@@ -7,18 +7,12 @@ app.use("/", checkUser, express.static(__dirname + "/public"));
 
 app.get("/api/question/:id", checkUser, async (req, res) => {
     try {
-        const questions = await db.query(
-            `SELECT id, question
-             FROM question_questions`
-        );
+        const questions = await db.query("SELECT id, question FROM question_questions");
         const id = +req.params.id;
         if (id >= 0 && id < questions.length) {
             const question = questions[id];
             const answers = await db.query(
-                `SELECT answer
-                 FROM question_answers
-                 WHERE question_id = ?
-                   AND user_id = ?`,
+                "SELECT answer FROM question_answers WHERE question_id = ?  AND user_id = ?",
                 [question.id, req.session.uid],
             );
             question.answer = answers.length > 0 ? answers[0].answer : undefined;
@@ -36,12 +30,7 @@ app.get("/api/questions", checkUser, async (req, res) => {
     const fail = { success: false };
     try {
         const questions = await db.query("SELECT id FROM question_questions");
-        const answers = await db.query(
-            `SELECT question_id
-             FROM question_answers
-             WHERE user_id = ?`,
-            [req.session.uid],
-        );
+        const answers = await db.query("SELECT question_id FROM question_answers WHERE user_id = ?", [req.session.uid]);
         const resp = [];
         let i = 0;
         for (const question of questions) {
-- 
cgit v1.2.3