From 075e5675d7bd8a90d8db48c7039fc1bd6fe1b970 Mon Sep 17 00:00:00 2001
From: "Ole B. Rosentreter" <ole@laktatnebel.de>
Date: Fri, 14 Feb 2025 20:28:23 +0100
Subject: [PATCH] Fixed Bug: returnID von INSERT value

---
 .../webui/lib/db/database_functions_pgsql.php | 60 +++++++++++++------
 ticket-web/src/webui/newissue.php             |  6 +-
 2 files changed, 46 insertions(+), 20 deletions(-)

diff --git a/ticket-web/src/webui/lib/db/database_functions_pgsql.php b/ticket-web/src/webui/lib/db/database_functions_pgsql.php
index 9d584c7..a7bfc6c 100644
--- a/ticket-web/src/webui/lib/db/database_functions_pgsql.php
+++ b/ticket-web/src/webui/lib/db/database_functions_pgsql.php
@@ -51,25 +51,51 @@ function getBooleanData ($dbms_connection, $db_query) {
 // Parameter: Tablle, Feld(er), Wert(e)
 // Rückgabewert: Array
 function getData ($dbms_connection, $db_query) {
-	$return_arr_data = array();		 // Rückgabewert als Array
-	//echo "\n<p> SQL:<br>".$ref_str_db_query."</p>";
+    $return_arr_data = array();		 // Rückgabewert als Array
+    //echo "\n<p> SQL:<br>".$ref_str_db_query."</p>";
+    
+    // DB Abfage starten
+    //echo $db_query;
+    $res_sql_result = pg_query ($dbms_connection, $db_query);
+    // Gültigkeit der DB Abfage testen
+    if ($res_sql_result) {
+        //echo "<p>".$res_sql_result."</p>";
+        while ($arr_sql_data = pg_fetch_row($res_sql_result)) {
+            //echo debugPrint($arr_sql_data);
+            array_push ($return_arr_data, $arr_sql_data);
+        }
+        //var_dump( $return_arr_data);
+    } else {
+        return "Datenbankabfrage fehlgeschlagen!";
+    }
+    
+    return $return_arr_data;
+}
 
-	// DB Abfage starten
-	//echo $db_query;
-	$res_sql_result = pg_query ($dbms_connection, $db_query);
-	// Gültigkeit der DB Abfage testen
-	if ($res_sql_result) {
-		//echo "<p>".$res_sql_result."</p>";
-		while ($arr_sql_data = pg_fetch_row($res_sql_result)) {
-			//echo debugPrint($arr_sql_data);
-			array_push ($return_arr_data, $arr_sql_data);
-		}
-		//var_dump( $return_arr_data);
-	} else {
-		return "Datenbankabfrage fehlgeschlagen!";
-	}
 
-	return $return_arr_data;
+// SQL an DB absetzen
+// Parameter: Tablle, Feld(er), Wert(e)
+// Rückgabewert: Array
+function getDataReturnID ($dbms_connection, $db_query) {
+    $return_arr_data = array();		 // Rückgabewert als Array
+    //echo "\n<p> SQL:<br>".$ref_str_db_query."</p>";
+    
+    // DB Abfage starten
+    //echo $db_query;
+    $res_sql_result = pg_query ($dbms_connection, $db_query);
+    // Gültigkeit der DB Abfage testen
+    if ($res_sql_result) {
+        //echo "<p>".$res_sql_result."</p>";
+        while ($arr_sql_data = pg_fetch_row($res_sql_result)) {
+            //echo debugPrint($arr_sql_data);
+            array_push ($return_arr_data, $arr_sql_data);
+        }
+        //var_dump( $return_arr_data);
+    } else {
+        return "Datenbankabfrage fehlgeschlagen!";
+    }
+    
+    return $return_arr_data[0][0];
 }
 
 
diff --git a/ticket-web/src/webui/newissue.php b/ticket-web/src/webui/newissue.php
index d7ae27a..4c780f6 100644
--- a/ticket-web/src/webui/newissue.php
+++ b/ticket-web/src/webui/newissue.php
@@ -94,9 +94,9 @@ if (isset($_POST)) {
             $sqllog = generateInsertSchema("ticket", "dt_sqllog", array("DEFAULT", "now()", "'".addslashes(str_replace("'", "\"", $sqlinsert))."'", $current_user, "'".uniqid()."'", "'".$page."'"));
             $sqllog_result = getBooleanData($connect_dbms_handle, $sqllog);
             //echo $sqllog_result;
-            } else {
-                echo "unzulässige Eingaben!";
-            }
+        } else {
+            echo "unzulässige Eingaben!";
+        }
     }
 }
 ?>
-- 
2.39.5