From 0654c753a6964aee6963eba48fdfe27ad09160fd Mon Sep 17 00:00:00 2001
From: alex <alex@alexloehr.net>
Date: Thu, 05 Jun 2025 09:18:44 +0000
Subject: [PATCH] fixed user by login
---
lib/db.js | 7 +++----
app.js | 4 ++--
2 files changed, 5 insertions(+), 6 deletions(-)
diff --git a/app.js b/app.js
index cc1bd5b..f74787a 100644
--- a/app.js
+++ b/app.js
@@ -45,8 +45,8 @@
.get("/api/user/login/:login", async function (req, res) {
const {login} = req.params
const user = await db.getUserByLogin(login)
- if (user.length) {
- return res.send(user[0])
+ if (user) {
+ return res.send(user)
}
else {
return res.code(404).send({status: "error", msg: "not found"})
diff --git a/lib/db.js b/lib/db.js
index af7a8e6..bc2ac32 100644
--- a/lib/db.js
+++ b/lib/db.js
@@ -85,9 +85,9 @@
const [results, fields] = await pool.query(
`SELECT ${sel}
FROM ${database}.usr_data AS ud
- WHERE login = '${login}'
- AND login REGEXP '^[0-9]+$'`
+ WHERE login = '${login}'`
)
+ console.log(results)
return joinUDF(results[0])
}
@@ -100,8 +100,7 @@
const [results, fields] = await pool.query(
`SELECT ${sel}
FROM ${database}.usr_data AS ud
- WHERE usr_id = '${userId}'
- AND login REGEXP '^[0-9]+$'`
+ WHERE usr_id = '${userId}'`
)
return joinUDF(results[0])
}
--
Gitblit v1.8.0