From 0004d2e9cfb2dae4a7176762a3dad9e5a48633c9 Mon Sep 17 00:00:00 2001 From: Spp Date: Mon, 2 Sep 2013 15:11:28 +0200 Subject: Fix SQL typos after RBAC commits --- sql/updates/auth/2013_09_02_04_auth_misc.sql | 2 +- sql/updates/auth/2013_09_02_08_auth_misc.sql | 22 ++++++++++++++-------- 2 files changed, 15 insertions(+), 9 deletions(-) (limited to 'sql/updates/auth') 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); -- cgit v1.2.3