diff options
| author | Spp <spp@jorge.gr> | 2013-09-02 15:11:28 +0200 |
|---|---|---|
| committer | Spp <spp@jorge.gr> | 2013-09-02 15:11:28 +0200 |
| commit | 0004d2e9cfb2dae4a7176762a3dad9e5a48633c9 (patch) | |
| tree | 7f000fa396d7f2eb6365aa58fcd1f9f82d4827d1 /sql/updates/auth | |
| parent | 28f9317698aec3eb8480e6682af3c4c65a98707c (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.sql | 2 | ||||
| -rw-r--r-- | sql/updates/auth/2013_09_02_08_auth_misc.sql | 22 |
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); |
