aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorOvahlord <dreadkiller@gmx.de>2023-12-24 06:30:33 +0100
committerfunjoker <funjoker109@gmail.com>2024-01-09 12:03:45 +0100
commitc431c77d8923d216901287a2d372494242bc7a51 (patch)
tree3057c5a445a8be12acbc68d2add3417bf5585103 /sql/updates
parent8426854ee803bfcbecf16edf65a2a11da90b5b3d (diff)
DB/RBAC: restored the RBAC permission entries for the .instance set/getbossstate commands
(cherry picked from commit db9a46001575cfad402372517c9b0495f20a0063)
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/auth/wotlk_classic/2024_01_09_00_auth_2023_12_24_00_auth.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/auth/wotlk_classic/2024_01_09_00_auth_2023_12_24_00_auth.sql b/sql/updates/auth/wotlk_classic/2024_01_09_00_auth_2023_12_24_00_auth.sql
new file mode 100644
index 00000000000..6242c21a362
--- /dev/null
+++ b/sql/updates/auth/wotlk_classic/2024_01_09_00_auth_2023_12_24_00_auth.sql
@@ -0,0 +1,9 @@
+DELETE FROM `rbac_permissions` WHERE `id` IN (795, 796);
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(795,'Command: instance setbossstate'),
+(796,'Command: instance getbossstate');
+
+DELETE FROM `rbac_linked_permissions` WHERE `id`= 192 AND `linkedId` IN (795, 796);
+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
+(192,795),
+(192,796);