From 42154f7baf7b61686eea00bf4d2807881093ef82 Mon Sep 17 00:00:00 2001
From: Marvin Borner
Date: Wed, 7 Oct 2020 10:06:28 +0200
Subject: Blabla

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

(limited to 'auth')

diff --git a/auth/index.js b/auth/index.js
index bfff5e1..a64d582 100644
--- a/auth/index.js
+++ b/auth/index.js
@@ -62,8 +62,8 @@ app.get("/api/list", checkUser, async (req, res) => {
         users = await db.query("SELECT id, name, middlename, surname FROM users ORDER BY name");
     } else {
         users = await db.query(
-            "SELECT id, name, middlename, surname FROM users WHERE class_id = (SELECT class_id FROM users WHERE id = ?) ORDER BY name",
-            [req.session.uid],
+            "SELECT id, name, middlename, surname FROM users WHERE class_id = (SELECT class_id FROM users WHERE id = ?) AND id != ? ORDER BY name",
+            [req.session.uid, req.session.uid],
         );
     }
 
-- 
cgit v1.2.3