From f620befc37fd8a4aed917e1ebba6f268c44a0a99 Mon Sep 17 00:00:00 2001
From: Carbenium <carbenium@outlook.com>
Date: Sat, 26 Jun 2021 22:47:26 +0200
Subject: Scripts/Commands: Convert rbac commands to new system

Note: To enable rbac commands for administrators permissions 202-206 have to be linked to permission 196.

Sample SQL for auth DB:
INSERT INTO `rbac_linked_permissions` VALUES (196, 202), (196, 203), (196, 204), (196, 205), (196, 206);
---
 sql/base/auth_database.sql                      | 7 +++++--
 sql/updates/world/3.3.5/2021_08_14_00_world.sql | 5 +++++
 2 files changed, 10 insertions(+), 2 deletions(-)
 create mode 100644 sql/updates/world/3.3.5/2021_08_14_00_world.sql

(limited to 'sql')

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index e2b97df7aaf..eb77012c356 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -521,8 +521,11 @@ INSERT INTO `rbac_linked_permissions` VALUES
 (195,49),
 (195,199),
 (196,7),
-(196,200),
-(196,201),
+(196,202),
+(196,203),
+(196,204),
+(196,205),
+(196,206),
 (196,226),
 (196,227),
 (196,230),
diff --git a/sql/updates/world/3.3.5/2021_08_14_00_world.sql b/sql/updates/world/3.3.5/2021_08_14_00_world.sql
new file mode 100644
index 00000000000..10b53a58095
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_08_14_00_world.sql
@@ -0,0 +1,5 @@
+UPDATE `command` SET help='Syntax: rbac account revoke [$account] #id [#realmId]
+
+Remove a permission from an account
+
+Note: Removes the permission from granted or denied permissions' WHERE name='rbac account revoke';
-- 
cgit v1.2.3