From 594de40ac39ac32d6d526c8c4875dc6665b2d8dc Mon Sep 17 00:00:00 2001
From: alex <alex@alexloehr.net>
Date: Thu, 23 Oct 2025 09:01:21 +0000
Subject: [PATCH] GS-2375
---
lib/db.js | 34 ++++++++++++++++++++++++++++++++--
1 files changed, 32 insertions(+), 2 deletions(-)
diff --git a/lib/db.js b/lib/db.js
index 6f9922c..d02f06c 100644
--- a/lib/db.js
+++ b/lib/db.js
@@ -43,6 +43,9 @@
getSingleKursTeilnehmer,
getKursTeilnehmerCount,
+ getKursLp,
+ getKursUnterobjektLp,
+
getKursOffline,
setKursOffline,
@@ -402,10 +405,37 @@
return results
}
+async function getKursLp(obj_id) {
+
+}
+
+async function getKursUnterobjektLp(obj_id) {
+ const pool = await poolP
+ const q = `SELECT ulc.obj_id,
+ ulc.item_id,
+ ulc.lpmode,
+ t.obj_id as item_obj_id,
+ ulm.usr_id,
+ ulm.status,
+ ulm.status_changed,
+ ulm.percentage,
+ ulm.completed
+ FROM ${database}.ut_lp_collections ulc
+ 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
+ WHERE ulc.obj_id = ${obj_id} # obj_id Kurs
+ AND ulc.active = 1
+ AND ulc.lpmode = 5 # nur mode 5
+ `
+ const [results] = await pool.query(q)
+ return results
+}
+
+
async function getKursOffline(obj_id) {
const pool = await poolP
- const q = `SELECT offline
- FROM ${database}.object_data
+ const q = `SELECT offline
+ FROM ${database}.object_data
WHERE obj_id = ${obj_id}
`
const [results] = await pool.query(q)
--
Gitblit v1.8.0