diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 3 | ||||
| -rw-r--r-- | sql/updates/auth/master/2019_07_16_00_auth.sql | 6 | ||||
| -rw-r--r-- | sql/updates/world/master/2021_12_16_03_world_2019_07_16_00_world.sql | 7 |
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.'); |