From 8adde791d835a1b18755bb9708c6d8ae2f762755 Mon Sep 17 00:00:00 2001 From: Odyssey Date: Thu, 28 Aug 2014 23:03:26 +0100 Subject: Scripts/Commands: Implement .guild info command Displays a information summary about the selected player guild or a given guildId or Name Closes #12949 Signed-off-by: DDuarte --- sql/updates/auth/2014_08_28_01_auth_rbac_permissions.sql | 8 ++++++++ sql/updates/world/2014_08_28_04_world_misc.sql | 15 +++++++++++++++ 2 files changed, 23 insertions(+) create mode 100644 sql/updates/auth/2014_08_28_01_auth_rbac_permissions.sql create mode 100644 sql/updates/world/2014_08_28_04_world_misc.sql (limited to 'sql/updates') 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'); -- cgit v1.2.3