diff options
11 files changed, 24 insertions, 18 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); diff --git a/sql/updates/world/2013_09_02_04_world_command.sql b/sql/updates/world/2013_09_02_04_world_command.sql index a4bc79b8a39..4fd1e0db8e2 100644 --- a/sql/updates/world/2013_09_02_04_world_command.sql +++ b/sql/updates/world/2013_09_02_04_world_command.sql @@ -21,4 +21,4 @@ UPDATE `command` SET `permission` = @id+14 WHERE `name` = 'disable remove mmap'; UPDATE `command` SET `permission` = @id+15 WHERE `name` = 'disable remove outdoorpvp'; UPDATE `command` SET `permission` = @id+16 WHERE `name` = 'disable remove quest'; UPDATE `command` SET `permission` = @id+17 WHERE `name` = 'disable remove spell'; -UPDATE `command` SET `permission` = @id+18 WHERE `name` = 'disable remove vmap'); +UPDATE `command` SET `permission` = @id+18 WHERE `name` = 'disable remove vmap'; diff --git a/sql/updates/world/2013_09_02_07_world_command.sql b/sql/updates/world/2013_09_02_07_world_command.sql index 58350a6c729..4f73ee4e439 100644 --- a/sql/updates/world/2013_09_02_07_world_command.sql +++ b/sql/updates/world/2013_09_02_07_world_command.sql @@ -12,4 +12,4 @@ UPDATE `command` SET `permission` = @id+5 WHERE `name` = 'go taxinode'; UPDATE `command` SET `permission` = @id+6 WHERE `name` = 'go ticket'; UPDATE `command` SET `permission` = @id+7 WHERE `name` = 'go trigger'; UPDATE `command` SET `permission` = @id+8 WHERE `name` = 'go xyz'; -UPDATE `command` SET `permission` = @id+9 WHERE `name` = 'go zonexy'); +UPDATE `command` SET `permission` = @id+9 WHERE `name` = 'go zonexy'; diff --git a/sql/updates/world/2013_09_02_08_world_command.sql b/sql/updates/world/2013_09_02_08_world_command.sql index d09a7030a5b..5190a8f8a61 100644 --- a/sql/updates/world/2013_09_02_08_world_command.sql +++ b/sql/updates/world/2013_09_02_08_world_command.sql @@ -15,4 +15,4 @@ UPDATE `command` SET `permission` = @id+8 WHERE `name` = 'gobject set'; UPDATE `command` SET `permission` = @id+9 WHERE `name` = 'gobject set phase'; UPDATE `command` SET `permission` = @id+10 WHERE `name` = 'gobject set state'; UPDATE `command` SET `permission` = @id+11 WHERE `name` = 'gobject target'; -UPDATE `command` SET `permission` = @id+12 WHERE `name` = 'gobject turn'); +UPDATE `command` SET `permission` = @id+12 WHERE `name` = 'gobject turn'; diff --git a/sql/updates/world/2013_09_02_09_world_command.sql b/sql/updates/world/2013_09_02_09_world_command.sql index 5d32d09a45a..1fca31eaf57 100644 --- a/sql/updates/world/2013_09_02_09_world_command.sql +++ b/sql/updates/world/2013_09_02_09_world_command.sql @@ -1,4 +1,4 @@ -/* cs_gobject.cpp */ +/* cs_guild.cpp */ SET @id = 401; diff --git a/sql/updates/world/2013_09_02_12_world_command.sql b/sql/updates/world/2013_09_02_12_world_command.sql index 67f544755e2..7320b87f823 100644 --- a/sql/updates/world/2013_09_02_12_world_command.sql +++ b/sql/updates/world/2013_09_02_12_world_command.sql @@ -15,4 +15,4 @@ UPDATE `command` SET `permission` = @id+8 WHERE `name` = 'learn all crafts'; UPDATE `command` SET `permission` = @id+9 WHERE `name` = 'learn all default'; UPDATE `command` SET `permission` = @id+10 WHERE `name` = 'learn all lang'; UPDATE `command` SET `permission` = @id+11 WHERE `name` = 'learn all recipes'; -UPDATE `command` SET `permission` = @id+12 WHERE `name` = 'unlearn'); +UPDATE `command` SET `permission` = @id+12 WHERE `name` = 'unlearn'; diff --git a/sql/updates/world/2013_09_02_13_world_command.sql b/sql/updates/world/2013_09_02_13_world_command.sql index 0d5c6fdc545..6ecc3b8374f 100644 --- a/sql/updates/world/2013_09_02_13_world_command.sql +++ b/sql/updates/world/2013_09_02_13_world_command.sql @@ -8,4 +8,4 @@ UPDATE `command` SET `permission` = @id+1 WHERE `name` = 'lfg player'; UPDATE `command` SET `permission` = @id+2 WHERE `name` = 'lfg group'; UPDATE `command` SET `permission` = @id+3 WHERE `name` = 'lfg queue'; UPDATE `command` SET `permission` = @id+4 WHERE `name` = 'lfg clean'; -UPDATE `command` SET `permission` = @id+5 WHERE `name` = 'lfg options'); +UPDATE `command` SET `permission` = @id+5 WHERE `name` = 'lfg options'; diff --git a/sql/updates/world/2013_09_02_14_world_command.sql b/sql/updates/world/2013_09_02_14_world_command.sql index 08b092c7f0a..4d0b5d35d6f 100644 --- a/sql/updates/world/2013_09_02_14_world_command.sql +++ b/sql/updates/world/2013_09_02_14_world_command.sql @@ -8,4 +8,4 @@ UPDATE `command` SET `permission` = @id+1 WHERE `name` = 'list creature'; UPDATE `command` SET `permission` = @id+2 WHERE `name` = 'list item'; UPDATE `command` SET `permission` = @id+3 WHERE `name` = 'list object'; UPDATE `command` SET `permission` = @id+4 WHERE `name` = 'list auras'; -UPDATE `command` SET `permission` = @id+5 WHERE `name` = 'list mail'); +UPDATE `command` SET `permission` = @id+5 WHERE `name` = 'list mail'; diff --git a/sql/updates/world/2013_09_02_15_world_command.sql b/sql/updates/world/2013_09_02_15_world_command.sql index 650413fb79d..0ec5002b61c 100644 --- a/sql/updates/world/2013_09_02_15_world_command.sql +++ b/sql/updates/world/2013_09_02_15_world_command.sql @@ -22,4 +22,4 @@ UPDATE `command` SET `permission` = @id+15 WHERE `name` = 'lookup spell id'; UPDATE `command` SET `permission` = @id+16 WHERE `name` = 'lookup taxinode'; UPDATE `command` SET `permission` = @id+17 WHERE `name` = 'lookup tele'; UPDATE `command` SET `permission` = @id+18 WHERE `name` = 'lookup title'; -UPDATE `command` SET `permission` = @id+19 WHERE `name` = 'lookup map'); +UPDATE `command` SET `permission` = @id+19 WHERE `name` = 'lookup map'; diff --git a/sql/updates/world/2013_09_02_16_world_command.sql b/sql/updates/world/2013_09_02_16_world_command.sql index c1c36417859..f9930afd213 100644 --- a/sql/updates/world/2013_09_02_16_world_command.sql +++ b/sql/updates/world/2013_09_02_16_world_command.sql @@ -12,4 +12,4 @@ UPDATE `command` SET `permission` = @id+5 WHERE `name` = 'gmnameannounce'; UPDATE `command` SET `permission` = @id+6 WHERE `name` = 'gmnotify'; UPDATE `command` SET `permission` = @id+7 WHERE `name` = 'nameannounce'; UPDATE `command` SET `permission` = @id+8 WHERE `name` = 'notify'; -UPDATE `command` SET `permission` = @id+9 WHERE `name` = 'whispers'); +UPDATE `command` SET `permission` = @id+9 WHERE `name` = 'whispers'; |