DB/Loot: Reference template 24077 corrections

Closes #21181

1 files changed, 17 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2018_01_06_00_world_335.sql b/sql/updates/world/3.3.5/2018_01_06_00_world_335.sql
new file mode 100644
index 00000000000..bac44d70cb9
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_01_06_00_world_335.sql
@@ -0,0 +1,17 @@
+-- Remove unique items from reference table 24077
+DELETE FROM `reference_loot_template` WHERE `Entry`=24077 AND `Item` IN (827, 1214, 1219, 1405, 1925, 1928, 1958, 1959, 4676);
+-- Add former items from reference table 24077 to their proper NPCs
+DELETE FROM `creature_loot_template` WHERE `Item` IN (827, 1214, 1219, 1405, 1925, 1928, 1958, 1959, 4676);
+INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Chance`, `LootMode`, `MinCount`, `MaxCount`, `GroupId`, `Comment`) VALUES
+(122, 827, 0.1, 1, 1, 1, 0, 'Defias Highwayman - Wicked Blackjack'),
+(449, 827, 0.1, 1, 1, 1, 0, 'Defias Knuckleduster - Wicked Blackjack'),
+(426, 1214, 0.1, 1, 1, 1, 0, 'Redridge Brute - Gnoll Punisher'),
+(424, 1219, 0.1, 1, 1, 1, 0, 'Redridge Poacher - Redridge Machete'),
+(517, 1405, 0.1, 1, 1, 1, 0, 'Murloc Oracle - Foamspittle Staff'),
+(1725, 1925, 0.1, 1, 1, 1, 0, 'Defias Watchman - Defias Rapier'),
+(1726, 1928, 0.1, 1, 1, 1, 0, 'Defias Magician - Defias Mage Staff'),
+(623, 1958, 0.1, 1, 1, 1, 2, 'Skeletal Miner - Petrified Shinbone'),
+(623, 1959, 0.1, 1, 1, 1, 2, 'Skeletal Miner - Cold Iron Pick'),
+(624, 1958, 0.1, 1, 1, 1, 2, 'Undead Excavator - Petrified Shinbone'),
+(624, 4676, 0.1, 1, 1, 1, 2, 'Undead Excavator - Skeletal Gauntlets'),
+(625, 1958, 0.1, 1, 1, 1, 0, 'Undead Dynamiter - Petrified Shinbone');