diff options
Diffstat (limited to 'questions/index.js')
| -rw-r--r-- | questions/index.js | 17 |
1 files changed, 3 insertions, 14 deletions
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) { |