diff options
| author | Ovahlord <dreadkiller@gmx.de> | 2023-12-24 06:30:33 +0100 |
|---|---|---|
| committer | Ovahlord <dreadkiller@gmx.de> | 2023-12-24 06:30:33 +0100 |
| commit | db9a46001575cfad402372517c9b0495f20a0063 (patch) | |
| tree | 24857daaddd04d099c204e44113695a087bfb6fc | |
| parent | 0db162790c5a8ffbfc38beca9c3bf8bf2baa1a06 (diff) | |
DB/RBAC: restored the RBAC permission entries for the .instance set/getbossstate commands
| -rw-r--r-- | sql/base/auth_database.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/master/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 e5358105e34..b1c72397cba 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -945,6 +945,8 @@ INSERT INTO `rbac_linked_permissions` VALUES (192,792), (192,793), (192,794), +(192,795), +(192,796), (192,835), (192,844), (192,845), @@ -2233,6 +2235,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'), @@ -2773,7 +2777,8 @@ INSERT INTO `updates` VALUES ('2023_12_12_00_auth.sql','EDC092787956178A08D15B9245EE4716ED0847B0','RELEASED','2023-12-12 05:47:47',0), ('2023_12_13_00_auth.sql','C3D6AA45BECD5A7F8A420FE0022AAF6A349C5E3F','RELEASED','2023-12-13 06:42:48',0), ('2023_12_19_00_auth.sql','6761E7111F613E57A7D684E18E38FCA3F5CD66A6','RELEASED','2023-12-19 08:54:36',0), -('2023_12_21_00_auth.sql','DB294EF35C00AA92C79786F7A0BFBCE739D4E193','RELEASED','2023-12-21 09:08:30',0); +('2023_12_21_00_auth.sql','DB294EF35C00AA92C79786F7A0BFBCE739D4E193','RELEASED','2023-12-21 09:08:30',0), +('2023_12_24_00_auth.sql','F59B3A895750FD83177324B89BFCEBD8A43DD577','RELEASED','2023-12-24 06:24:58',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/master/2023_12_24_00_auth.sql b/sql/updates/auth/master/2023_12_24_00_auth.sql new file mode 100644 index 00000000000..6242c21a362 --- /dev/null +++ b/sql/updates/auth/master/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); |