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

(cherry picked from commit 6f29aac93626ce37922c3c9a85d20b2e4d9d3bbc)

3 files changed, 27 insertions, 1 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 0f8d8876224..b77cf6c9b73 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1267,7 +1267,8 @@ INSERT INTO `rbac_linked_permissions` VALUES
 (197,857),
 (197,858),
 (197,859),
-(197,860)
+(197,860),
+(197,865),
 (198,218),
 (198,300),
 (198,312),
@@ -2099,6 +2100,7 @@ INSERT INTO `rbac_permissions` VALUES
 (858,'Command: gobject spawngroup'),
 (859,'Command: gobject despawngroup'),
 (860,'Command: list respawns'),
+(865,'Command: npc showloot'),
 (868,'Command: modify power'),
 (869,'Command: debug send playerchoice'),
 (872,'Command: server debug');
diff --git a/sql/updates/auth/master/2017_06_12_02_auth.sql b/sql/updates/auth/master/2017_06_12_02_auth.sql
new file mode 100644
index 00000000000..2b42dc39b12
--- /dev/null
+++ b/sql/updates/auth/master/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/master/2020_07_16_05_world_2017_06_12_02_world.sql b/sql/updates/world/master/2020_07_16_05_world_2017_06_12_02_world.sql
new file mode 100644
index 00000000000..77f854df9bd
--- /dev/null
+++ b/sql/updates/world/master/2020_07_16_05_world_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.");