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

(cherry picked from commit 293ba08d21c4e9634229bb5015445ecc0cc08fef)

3 files changed, 16 insertions, 0 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 996dc059c59..bb643b79876 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1250,6 +1250,7 @@ INSERT INTO `rbac_linked_permissions` VALUES
 (196,875),
 (196,876),
 (196,877),
+(196,878),
 (196,881),
 (196,882),
 (197,232),
@@ -2165,6 +2166,7 @@ INSERT INTO `rbac_permissions` VALUES
 (875,'Command: lookup map id'),
 (876,'Command: lookup item id'),
 (877,'Command: lookup quest id'),
+(878,'Command: debug questreset'),
 (881,'Command: reload vehicle_template'),
 (882,'Command: reload spell_script_names');
 /*!40000 ALTER TABLE `rbac_permissions` ENABLE KEYS */;
@@ -2407,6 +2409,7 @@ INSERT INTO `updates` VALUES
 ('2019_06_21_00_auth.sql','C519239830204B68E710F698BC0C9E89B6D5FD24','ARCHIVED','2019-06-20 19:43:50',0),
 ('2019_07_14_00_auth.sql','94C2B877BD906538E1E008350BEA8D8B58E0A158','ARCHIVED','2019-07-14 19:22:08',0),
 ('2019_07_15_00_auth.sql','3649248104CFEC70553016273069A9AE744798E3','ARCHIVED','2019-07-15 19:22:08',0),
+('2019_07_16_00_auth.sql','36CB53A9EBD64BFDCF7030083E36E534F1753773','ARCHIVED','2019-07-16 00:00:00',0),
 ('2019_07_26_00_auth.sql','DC9D0651602AE78B1243B40555A1A7B8447D01B2','ARCHIVED','2019-07-26 18:21:34',0),
 ('2019_08_11_00_auth.sql','04DCC2ABDA15BC7C015E8BFEA383C62A362B166F','ARCHIVED','2019-08-11 10:56:39',0),
 ('2019_08_18_00_auth.sql','0479A04B669A67D2E5A498CFB91507E742EFB34F','ARCHIVED','2019-08-17 11:51:02',0),
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.');