Scripts/Commands: Add .debug questreset to force daily/weekly/monthly quest reset.

(cherry picked from commit 293ba08d21c4e9634229bb5015445ecc0cc08fef)

2 files changed, 13 insertions, 0 deletions

diff --git a/sql/updates/auth/master/2019_07_16_00_auth.sql b/sql/updates/auth/master/2019_07_16_00_auth.sql
new file mode 100644
index 00000000000..bbec0eb65aa
--- /dev/null
+++ b/sql/updates/auth/master/2019_07_16_00_auth.sql
@@ -0,0 +1,6 @@
+-- 
+DELETE FROM `rbac_permissions` WHERE `id`=878;
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES (878, 'Command: debug questreset');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=878;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES (196,878);
diff --git a/sql/updates/world/master/2021_12_16_03_world_2019_07_16_00_world.sql b/sql/updates/world/master/2021_12_16_03_world_2019_07_16_00_world.sql
new file mode 100644
index 00000000000..e61738a3eaa
--- /dev/null
+++ b/sql/updates/world/master/2021_12_16_03_world_2019_07_16_00_world.sql
@@ -0,0 +1,7 @@
+-- 
+DELETE FROM `command` WHERE `name`='debug questreset';
+INSERT INTO `command` (`name`,`permission`,`help`) VALUES
+('debug questreset',878,'Syntax: .debug questreset <daily/weekly/monthly/all>
+
+Performs quest reset procedure for the specified type (or all types).
+Quest pools will be re-generated, and quest completion status will be reset.');