diff options
| -rw-r--r-- | sql/updates/auth/2013_03_08_00_auth_misc.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/auth/2013_03_08_00_auth_misc.sql b/sql/updates/auth/2013_03_08_00_auth_misc.sql new file mode 100644 index 00000000000..85d61beff3d --- /dev/null +++ b/sql/updates/auth/2013_03_08_00_auth_misc.sql @@ -0,0 +1,9 @@ +-- Delete 'Two side mail interaction', 'Allow say chat between factions' and 'Allow channel chat between factions' from Player group +DELETE FROM `rbac_group_roles` WHERE `groupId` = 1 AND `roleId` IN (19, 28, 30); + +-- Delete 'Join channels withou announce' from Moderators group +DELETE FROM `rbac_group_roles` WHERE `groupId` = 2 AND `roleId` IN (31); + +-- Add 'Allow two side charater accounts' +DELETE FROM `rbac_group_roles` WHERE `roleId` = 34; +INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES (1, 34); |