diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/auth/2014_08_28_01_auth_rbac_permissions.sql | 8 | ||||
| -rw-r--r-- | sql/updates/world/2014_08_28_04_world_misc.sql | 15 |
2 files changed, 23 insertions, 0 deletions
diff --git a/sql/updates/auth/2014_08_28_01_auth_rbac_permissions.sql b/sql/updates/auth/2014_08_28_01_auth_rbac_permissions.sql new file mode 100644 index 00000000000..4c885bfd92e --- /dev/null +++ b/sql/updates/auth/2014_08_28_01_auth_rbac_permissions.sql @@ -0,0 +1,8 @@ +-- Permissions for .guild info command +DELETE FROM `rbac_permissions` WHERE `id`=794; +INSERT INTO `rbac_permissions` (`id`, `name`) VALUES +(794, 'Command: .guild info'); + +DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=794; +INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES +(192, 794); diff --git a/sql/updates/world/2014_08_28_04_world_misc.sql b/sql/updates/world/2014_08_28_04_world_misc.sql new file mode 100644 index 00000000000..3921b40998d --- /dev/null +++ b/sql/updates/world/2014_08_28_04_world_misc.sql @@ -0,0 +1,15 @@ +-- .guild info command +DELETE FROM `command` WHERE `name`='guild info'; +INSERT INTO `command` (`name`, `permission`, `help`) VALUES +('guild info', 794, 'Shows information about target''''s guild or a given guild Id or Name.'); + +-- .guild info command strings +DELETE FROM `trinity_string` WHERE `entry` IN (1177,1178,1179,1180,1181,1182,1183); +INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES +(1177, 'Displaying Guild Details for %s (Id: %u)'), +(1178, '| Guild Master: %s (GUID: %u)'), +(1179, '| Guild Creation Date: %s'), +(1180, '| Guild Members: %u'), +(1181, '| Guild Bank: %u gold'), +(1182, '| Guild MOTD: %s'), +(1183, '| Guild Information: %s'); |