From 5fa36d9ea426f6f3dffc31cce8a55821e9ead5bf Mon Sep 17 00:00:00 2001
From: alex <alex@alexloehr.net>
Date: Mon, 17 Nov 2025 17:39:17 +0000
Subject: [PATCH] GS-2373
---
lib/db.js | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/lib/db.js b/lib/db.js
index f990051..5a27371 100644
--- a/lib/db.js
+++ b/lib/db.js
@@ -87,7 +87,7 @@
}
async function getUsers(offset = 0, limit = 10, search = null) {
- log.info("++++++++++ get users", offset, limit, search)
+ // log.info("++++++++++ get users", offset, limit, search)
limit = Number(limit) || 10
offset = Number(offset) || 0
// TODO check args for SQL Injection
@@ -505,6 +505,7 @@
ulc.item_id,
ulc.lpmode,
t.obj_id as item_obj_id,
+ od.type,
ulm.status,
ulm.status_changed,
ulm.percentage,
@@ -513,10 +514,11 @@
INNER JOIN ${database}.object_reference t ON t.ref_id = ulc.item_id
INNER JOIN ${database}.ut_lp_marks ulm ON ulm.obj_id = t.obj_id
INNER JOIN ${database}.usr_data ud ON ud.usr_id = ulm.usr_id
+ INNER JOIN ${database}.object_data od ON od.obj_id = t.obj_id
WHERE ulc.obj_id = ${obj_id} # obj_id Kurs
AND ulc.active = 1
AND ulc.lpmode = 5 # nur mode 5
- ORDER BY ud.usr_id
+ ORDER BY ud.usr_id, ulc.item_id
`
const [results] = await pool.query(q)
return results
--
Gitblit v1.8.0