From 293ba08d21c4e9634229bb5015445ecc0cc08fef Mon Sep 17 00:00:00 2001 From: Treeston Date: Tue, 16 Jul 2019 15:04:14 +0200 Subject: Scripts/Commands: Add .debug questreset to force daily/weekly/monthly quest reset. --- sql/updates/auth/3.3.5/2019_07_16_00_auth.sql | 6 ++++++ sql/updates/world/3.3.5/2019_07_16_00_world.sql | 7 +++++++ 2 files changed, 13 insertions(+) create mode 100644 sql/updates/auth/3.3.5/2019_07_16_00_auth.sql create mode 100644 sql/updates/world/3.3.5/2019_07_16_00_world.sql (limited to 'sql/updates') diff --git a/sql/updates/auth/3.3.5/2019_07_16_00_auth.sql b/sql/updates/auth/3.3.5/2019_07_16_00_auth.sql new file mode 100644 index 00000000000..bbec0eb65aa --- /dev/null +++ b/sql/updates/auth/3.3.5/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/3.3.5/2019_07_16_00_world.sql b/sql/updates/world/3.3.5/2019_07_16_00_world.sql new file mode 100644 index 00000000000..e61738a3eaa --- /dev/null +++ b/sql/updates/world/3.3.5/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 + +Performs quest reset procedure for the specified type (or all types). +Quest pools will be re-generated, and quest completion status will be reset.'); -- cgit v1.2.3