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