From ab12e77cf72bcd361a380c8d1ed37d12fe0e1bbb Mon Sep 17 00:00:00 2001 From: Shauren Date: Tue, 19 Jan 2021 22:48:46 +0100 Subject: Core/Commands: Restore instance management commands --- sql/updates/auth/master/2022_10_03_00_auth.sql | 3 +++ sql/updates/world/master/2022_10_03_01_world.sql | 6 ++++++ 2 files changed, 9 insertions(+) create mode 100644 sql/updates/auth/master/2022_10_03_00_auth.sql create mode 100644 sql/updates/world/master/2022_10_03_01_world.sql (limited to 'sql/updates') 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'; -- cgit v1.2.3