Add new command 'npc showloot'. Does exactly what it says on the tin.

2 files changed, 24 insertions, 0 deletions

diff --git a/sql/updates/auth/3.3.5/2017_06_12_02_auth.sql b/sql/updates/auth/3.3.5/2017_06_12_02_auth.sql
new file mode 100644
index 00000000000..2b42dc39b12
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2017_06_12_02_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `rbac_permissions` WHERE `id`=865;
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(865, 'Command: npc showloot');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=865;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
+(197,865);
diff --git a/sql/updates/world/3.3.5/2017_06_12_02_world.sql b/sql/updates/world/3.3.5/2017_06_12_02_world.sql
new file mode 100644
index 00000000000..77f854df9bd
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_06_12_02_world.sql
@@ -0,0 +1,17 @@
+--
+DELETE FROM `trinity_string` WHERE `entry` BETWEEN 288 AND 295;
+INSERT INTO `trinity_string` (`entry`,`content_default`) VALUES
+  (288, '%s either isn\'t dead or has no loot available.'),
+  (289, 'LOOT INFO: %s (%d)'),
+  (290, '├ %s (%d items):'),
+  (291, '├─ %dx |c%08x|Hitem:%d:0:0:0:0:0:0:0:0|h[%s]|h|r (#%05d)'),
+  (292, '├ Money: %01d|TInterface\\MoneyFrame\\UI-GoldIcon:0:0:2:0|t %02d|TInterface\\MoneyFrame\\UI-SilverIcon:0:0:2:0|t %02d|TInterface\\MoneyFrame\\UI-CopperIcon:0:0:2:0|t'),
+  (293, '├ %s:'),
+  (294, '├─ %s (%d items):'),
+  (295, '├── %dx |c%08x|Hitem:%d:0:0:0:0:0:0:0:0|h[%s]|h|r (#%05d)');
+
+DELETE FROM `command` WHERE `name`='npc showloot';
+INSERT INTO `command` (`name`,`permission`,`help`) VALUES
+('npc showloot', 865, "Syntax: .npc showloot [all]
+
+Shows the loot contained in targeted dead creature.");