Bug Report Manager

1. Your server must be running on TrinityCore.
2. You must have access to an account with permission to use stored procedures on the characters database.
3. Your players must be given a small patch file containing the Blizzard Feedback addon. You can download it here.

USE `characters`;

DELIMITER //


DROP PROCEDURE IF EXISTS getAllRawBugReports;

CREATE PROCEDURE getAllRawBugReports()
BEGIN
    SELECT * FROM `bugreport`;
END//


DROP PROCEDURE IF EXISTS setButReportStatus;

CREATE PROCEDURE setButReportStatus(`varBugReportId` INT, `varBugReportStatus` INT)
BEGIN
    UPDATE `bugreport` SET `status` = `varBugReportStatus` WHERE `id` = `varBugReportId`;
END//


DROP PROCEDURE IF EXISTS deleteBugReport;

CREATE PROCEDURE deleteBugReport(`varBugReportId` INT)
BEGIN
    DELETE FROM `bugreport` WHERE id = `varBugReportId`;
END//

DELIMITER ;

USE `characters`;

ALTER TABLE `bugreport` ADD COLUMN `status` TINYINT NOT NULL DEFAULT 0 AFTER `id`;