From 86d87b985ce10c51cf044c68bcb3382a20a1f6bc Mon Sep 17 00:00:00 2001
From: Aqua-sama <aqua@iserlohn-fortress.net>
Date: Fri, 30 Apr 2021 10:03:14 +0300
Subject: Reports can be bound to bugs

---
 report/update.php | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'report/update.php')

diff --git a/report/update.php b/report/update.php
index 0fadb53..c8ef12b 100644
--- a/report/update.php
+++ b/report/update.php
@@ -7,8 +7,8 @@ require_once(LIBRARY_PATH . "/functions.php");
 if(session_set()) {
     $conn = new PDO($config['db']['dsn'], $config['db']['username'], $config['db']['password']);
     $query = $_POST['id'] == "" ?
-        $conn->prepare("INSERT INTO reports (author, title, description) VALUES (:user_id, :title, :description)")
-      : $conn->prepare("UPDATE reports SET title=:title, description=:description WHERE id=:report_id");
+        $conn->prepare("INSERT INTO reports (author, title, description, bug) VALUES (:user_id, :title, :description, :bug_id)")
+      : $conn->prepare("UPDATE reports SET title=:title, description=:description, bug=:bug_id WHERE id=:report_id");
     if($_POST['id'] == "") {
         $query->bindParam(':user_id', $_SESSION['user_id']);
     } else {
@@ -16,6 +16,7 @@ if(session_set()) {
     }
     $query->bindParam(':title', $_POST['title']);
     $query->bindParam(':description', $_POST['description']);
+    $query->bindValue(':bug_id', $_POST['bug_id'] == "" ? null : $_POST['bug_id']);
     if($query->execute()) {
         echo "<h2>report submitted</h2>";
     } else {
-- 
cgit v1.2.1