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 <dnpd.dd@gmail.com>

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');