diff options
| -rw-r--r-- | sql/base/auth_database.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/wotlk_classic/2024_01_09_00_auth_2023_12_24_00_auth.sql | 9 |
2 files changed, 15 insertions, 1 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index f1a26a18d73..aff25c3d7a3 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -939,6 +939,8 @@ INSERT INTO `rbac_linked_permissions` VALUES (192,792), (192,793), (192,794), +(192,795), +(192,796), (192,835), (192,844), (192,845), @@ -2227,6 +2229,8 @@ INSERT INTO `rbac_permissions` VALUES (792,'Command: ahbot reload'), (793,'Command: ahbot status'), (794,'Command: .guild info'), +(795,'Command: instance setbossstate'), +(796,'Command: instance getbossstate'), (797,'Command: pvpstats'), (798,'Command: .mod xp'), (802,'Command: .ticket bug'), @@ -2761,7 +2765,8 @@ INSERT INTO `updates` VALUES ('2023_11_21_00_auth.sql','146E5E6EF94C5DB78343372A8FDB32B062B80040','ARCHIVED','2023-11-21 11:24:11',0), ('2023_11_23_00_auth.sql','EC3D1289A07E387BF4D2AC94EEBE3A29483EAD3A','ARCHIVED','2023-11-23 02:39:18',0), ('2023_11_24_00_auth.sql','AC1B5136CC97264A21933BD1074D02E88D819488','ARCHIVED','2023-11-24 19:37:38',0), -('2023_12_20_00_auth.sql','D4AB92FEB9FECC1EE35BB9A734B2E95A44C43CD4','ARCHIVED','2023-12-20 21:51:28',0); +('2023_12_20_00_auth.sql','D4AB92FEB9FECC1EE35BB9A734B2E95A44C43CD4','ARCHIVED','2023-12-20 21:51:28',0), +('2024_01_09_00_auth_2023_12_24_00_auth.sql', 'F59B3A895750FD83177324B89BFCEBD8A43DD577', 'RELEASED', '2024-01-09 12:02:27', 0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; 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); |