From 9f42af73101393f57ac653bbbdf2940b2de1f202 Mon Sep 17 00:00:00 2001 From: sijanec Date: Wed, 20 May 2020 14:29:27 +0200 Subject: DNM, not tested --- server/report/index.php | 14 ++++++++++++++ 1 file changed, 14 insertions(+) diff --git a/server/report/index.php b/server/report/index.php index c0ac172..6763a29 100644 --- a/server/report/index.php +++ b/server/report/index.php @@ -26,6 +26,20 @@ http_response_code(500); die("database connection failed. ".$warning); // . $conn->connect_error); } + + $query = "CREATE TABLE IF NOT EXISTS error_reports ( + msg VARCHAR(420) , + url VARCHAR(420) , + line INT , + column INT , + obj VARCHAR(420) , + ua VARCHAR(420) , + app_version VARCHAR(420) , + previous_commit VARCHAR(69) , + ip VARCHAR(69) , + )"; + $result = mysqli_query($dbConnection, $conn); + $stmt = $conn->prepare("INSERT INTO error_reports (msg, url, line, column, obj, ua, app_version, previous_commit, ip) VALUES". "(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"); $stmt->bind_param("ssiisssss", $_REQUEST["error"]["msg"], $_REQUEST["error"]["url"], $_REQUEST["error"]["line"], -- cgit v1.2.3