aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorSpp <spp@jorge.gr>2013-09-02 15:11:28 +0200
committerSpp <spp@jorge.gr>2013-09-02 15:11:28 +0200
commit0004d2e9cfb2dae4a7176762a3dad9e5a48633c9 (patch)
tree7f000fa396d7f2eb6365aa58fcd1f9f82d4827d1 /sql/updates/auth
parent28f9317698aec3eb8480e6682af3c4c65a98707c (diff)
Fix SQL typos after RBAC commits
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/2013_09_02_04_auth_misc.sql2
-rw-r--r--sql/updates/auth/2013_09_02_08_auth_misc.sql22
2 files changed, 15 insertions, 9 deletions
diff --git a/sql/updates/auth/2013_09_02_04_auth_misc.sql b/sql/updates/auth/2013_09_02_04_auth_misc.sql
index 6c14080dad2..4734aa6bbd4 100644
--- a/sql/updates/auth/2013_09_02_04_auth_misc.sql
+++ b/sql/updates/auth/2013_09_02_04_auth_misc.sql
@@ -1,4 +1,4 @@
-/* cs_disable.cpp */
+/* cs_event.cpp */
SET @id = 367;
diff --git a/sql/updates/auth/2013_09_02_08_auth_misc.sql b/sql/updates/auth/2013_09_02_08_auth_misc.sql
index 6efc9765ab6..b6bf442aeb5 100644
--- a/sql/updates/auth/2013_09_02_08_auth_misc.sql
+++ b/sql/updates/auth/2013_09_02_08_auth_misc.sql
@@ -1,19 +1,25 @@
-/* cs_honor.cpp */
+/* cs_guild.cpp */
SET @id = 401;
-- Add new permissions
-DELETE FROM `rbac_permissions` WHERE `id` BETWEEN @id AND @id+3;
+DELETE FROM `rbac_permissions` WHERE `id` BETWEEN @id AND @id+6;
INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
-(@id+0, 'honor'),
-(@id+1, 'honor add'),
-(@id+2, 'honor add kill'),
-(@id+3, 'honor update');
+(@id+0, 'guild'),
+(@id+1, 'guild create'),
+(@id+2, 'guild delete'),
+(@id+3, 'guild invite'),
+(@id+4, 'guild uninvite'),
+(@id+5, 'guild rank'),
+(@id+6, 'guild rename');
-- Add permissions to "corresponding Commands Role"
-DELETE FROM `rbac_role_permissions` WHERE `permissionId` BETWEEN @id AND @id+3;
+DELETE FROM `rbac_role_permissions` WHERE `permissionId` BETWEEN @id AND @id+6;
INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES
(4, @id+0),
(4, @id+1),
(4, @id+2),
-(4, @id+3);
+(4, @id+3),
+(4, @id+4),
+(4, @id+5),
+(4, @id+6);