diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 5 | ||||
| -rw-r--r-- | sql/updates/auth/master/2022_10_03_00_auth.sql | 3 | ||||
| -rw-r--r-- | sql/updates/world/master/2022_10_03_01_world.sql | 6 |
3 files changed, 11 insertions, 3 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 1de9e3d0c9f..a9fd569837b 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -1426,7 +1426,6 @@ INSERT INTO `rbac_linked_permissions` VALUES (198,413), (198,414), (198,415), -(198,416), (198,430), (198,431), (198,432), @@ -1801,7 +1800,6 @@ INSERT INTO `rbac_permissions` VALUES (413,'Command: instance listbinds'), (414,'Command: instance unbind'), (415,'Command: instance stats'), -(416,'Command: instance savedata'), (417,'Command: learn'), (418,'Command: learn all'), (419,'Command: learn all my'), @@ -2622,7 +2620,8 @@ INSERT INTO `updates` VALUES ('2022_08_21_00_auth.sql','5DEC0CB848F99D575B90356D82276749F2473B72','ARCHIVED','2022-08-21 00:02:03',0), ('2022_09_02_00_auth.sql','E2ED8B4B90829CFD283C9679AE265A9C9B2CF762','RELEASED','2022-09-02 15:52:22',0), ('2022_09_08_00_auth.sql','20B4503E316E042432AC25F7CEE9DCD9EDC631C6','RELEASED','2022-09-08 15:38:35',0), -('2022_09_23_00_auth.sql','F7DB1B903982D99295BC0D7D2BC205C5A2145F03','RELEASED','2022-09-23 03:44:55',0); +('2022_09_23_00_auth.sql','F7DB1B903982D99295BC0D7D2BC205C5A2145F03','RELEASED','2022-09-23 03:44:55',0), +('2022_10_03_00_auth.sql','30220B5474AFA716B141B3879ADE287BAEC61016','RELEASED','2022-10-03 21:32:38',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/master/2022_10_03_00_auth.sql b/sql/updates/auth/master/2022_10_03_00_auth.sql new file mode 100644 index 00000000000..bfe9962d953 --- /dev/null +++ b/sql/updates/auth/master/2022_10_03_00_auth.sql @@ -0,0 +1,3 @@ +DELETE FROM `rbac_account_permissions` WHERE `permissionId`=416; +DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=416; +DELETE FROM `rbac_permissions` WHERE `id=416; diff --git a/sql/updates/world/master/2022_10_03_01_world.sql b/sql/updates/world/master/2022_10_03_01_world.sql new file mode 100644 index 00000000000..33768e20f45 --- /dev/null +++ b/sql/updates/world/master/2022_10_03_01_world.sql @@ -0,0 +1,6 @@ +UPDATE `trinity_string` SET `content_default`='Map: %u-%s | Difficulty: %u-%s | InstanceID: %u | Expired: %s | Extended: %s | Time remaining: %s',`content_loc1`=NULL,`content_loc2`=NULL,`content_loc3`=NULL,`content_loc4`=NULL,`content_loc5`=NULL,`content_loc6`=NULL,`content_loc7`=NULL,`content_loc8`=NULL WHERE `entry`=5045; -- LANG_COMMAND_LIST_BIND_INFO +UPDATE `trinity_string` SET `content_default`='Failed to unbind (lock in use by map) - Map: %u-%s | Difficulty: %u-%s | InstanceID: %u | Expired: %s | Extended: %s | Time remaining: %s',`content_loc1`=NULL,`content_loc2`=NULL,`content_loc3`=NULL,`content_loc4`=NULL,`content_loc5`=NULL,`content_loc6`=NULL,`content_loc7`=NULL,`content_loc8`=NULL WHERE `entry`=5047; -- LANG_COMMAND_INST_UNBIND_FAILED +UPDATE `trinity_string` SET `content_default`='Unbinding - Map: %u-%s | Difficulty: %u-%s | InstanceID: %u | Expired: %s | Extended: %s | Time remaining: %s',`content_loc1`=NULL,`content_loc2`=NULL,`content_loc3`=NULL,`content_loc4`=NULL,`content_loc5`=NULL,`content_loc6`=NULL,`content_loc7`=NULL,`content_loc8`=NULL WHERE `entry`=5048; -- LANG_COMMAND_INST_UNBIND_UNBINDING +DELETE FROM `trinity_string` WHERE `entry`=5054; -- LANG_COMMAND_INST_STAT_GROUPSBOUND + +DELETE FROM `command` WHERE `name`='instance savedata'; |