From 019770dddba453095b09545002000bc44a8d645a Mon Sep 17 00:00:00 2001
From: Spp <spp@jorge.gr>
Date: Mon, 25 Feb 2013 15:28:41 +0100
Subject: Core/RBAC: Create new permissions related to character creation -
 'Skips character creation team mask check' - 'Skips character creation class
 mask check' - 'Skips character creation race mask check' - 'Skips character
 creation reserved name check' - 'Skips character creation heroic min level
 check' - 'Creation of two side faction characters in same account' (Affected
 by global config option)

---
 sql/updates/auth/2013_02_25_12_auth_misc.sql |  8 +++----
 sql/updates/auth/2013_02_25_13_auth_misc.sql | 36 ++++++++++++++++++++++++++++
 2 files changed, 40 insertions(+), 4 deletions(-)
 create mode 100644 sql/updates/auth/2013_02_25_13_auth_misc.sql

(limited to 'sql')

diff --git a/sql/updates/auth/2013_02_25_12_auth_misc.sql b/sql/updates/auth/2013_02_25_12_auth_misc.sql
index 9d2f01a917d..2b394dc9bcb 100644
--- a/sql/updates/auth/2013_02_25_12_auth_misc.sql
+++ b/sql/updates/auth/2013_02_25_12_auth_misc.sql
@@ -1,8 +1,8 @@
 -- Add new permissions
-DELETE FROM `rbac_permissions` WHERE `id` IN (26, 46, 46);
+DELETE FROM `rbac_permissions` WHERE `id` IN (26, 45, 46);
 INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
 (26, 'Allow channel chat between factions'),
-(46, 'Join channels without announce'),
+(45, 'Join channels without announce'),
 (46, 'Change channel settings without being channel moderator');
 
 -- Add new role
@@ -16,8 +16,8 @@ INSERT INTO `rbac_roles` (`id`, `name`) VALUES
 DELETE FROM `rbac_role_permissions` WHERE `roleId` IN (30, 31, 32);
 INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES
 (30, 26),
-(31, 46),
-(32, 4645);
+(31, 45),
+(32, 46);
 
 -- Add it to all GM+ groups
 DELETE FROM `rbac_role_permissions` WHERE `roleId` IN (30, 31, 32);
diff --git a/sql/updates/auth/2013_02_25_13_auth_misc.sql b/sql/updates/auth/2013_02_25_13_auth_misc.sql
new file mode 100644
index 00000000000..82247ecd07d
--- /dev/null
+++ b/sql/updates/auth/2013_02_25_13_auth_misc.sql
@@ -0,0 +1,36 @@
+-- Add new permissions
+DELETE FROM `rbac_permissions` WHERE `id` IN (14, 15, 16, 17, 18, 24);
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(14, 'Skips character creation team mask check'),
+(15, 'Skips character creation class mask check'),
+(16, 'Skips character creation race mask check'),
+(17, 'Skips character creation reserved name check'),
+(18, 'Skips character creation heroic min level check'),
+(24, 'Creation of two side faction characters in same account');
+
+-- Add new role
+DELETE FROM `rbac_roles` WHERE `id` IN (33, 34);
+INSERT INTO `rbac_roles` (`id`, `name`) VALUES
+(33, 'Skips character creation checks'),
+(34, 'Creation of two side faction characters in same account');
+
+-- Add the permission to the role
+DELETE FROM `rbac_role_permissions` WHERE `roleId` IN (33, 34);
+INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES
+(33, 14),
+(33, 15),
+(33, 16),
+(33, 17),
+(33, 18),
+(34, 24);
+
+-- Add it to all groups
+DELETE FROM `rbac_role_permissions` WHERE `roleId` IN (33, 34);
+INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES
+(2, 33),
+(3, 33),
+(4, 33),
+(2, 34),
+(3, 34),
+(4, 34);
+
-- 
cgit v1.2.3