From df46e7171c2dd42b3084dffb19e705a54d1731ba Mon Sep 17 00:00:00 2001
From: alex <alex@alexloehr.net>
Date: Fri, 24 Oct 2025 09:32:15 +0000
Subject: [PATCH] GS-2375
---
lib/db.js | 4 +++-
1 files changed, 3 insertions(+), 1 deletions(-)
diff --git a/lib/db.js b/lib/db.js
index f990051..a9a41a7 100644
--- a/lib/db.js
+++ b/lib/db.js
@@ -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