diff options
| author | Treeston <treeston.mmoc@gmail.com> | 2019-07-16 15:04:14 +0200 |
|---|---|---|
| committer | Treeston <treeston.mmoc@gmail.com> | 2019-07-16 15:04:14 +0200 |
| commit | 293ba08d21c4e9634229bb5015445ecc0cc08fef (patch) | |
| tree | 625d2a1581762a6b1171d0860a06c9208ee9e500 /sql/updates | |
| parent | 2c1b87ca298bce37405329b3af0b5e375f4e53ef (diff) | |
Scripts/Commands: Add .debug questreset to force daily/weekly/monthly quest reset.
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/auth/3.3.5/2019_07_16_00_auth.sql | 6 | ||||
| -rw-r--r-- | sql/updates/world/3.3.5/2019_07_16_00_world.sql | 7 |
2 files changed, 13 insertions, 0 deletions
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 <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.'); |