DB/Loot: Add more items for Crimson Hand Battle Mage

Closes #24576

1 files changed, 17 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_05_06_04_world.sql b/sql/updates/world/3.3.5/2020_05_06_04_world.sql
new file mode 100644
index 00000000000..2179da99357
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_05_06_04_world.sql
@@ -0,0 +1,17 @@
+-- Copied from Crimson Hand Centurion
+DELETE FROM `creature_loot_template` WHERE `Entry` = 20047 AND `Item` IN (21877,24001,24002,24011,24013,24014,24035,24093,27855,27860,30183,32897,32902,32905);
+INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`) VALUES
+(20047,21877,0,21.31,0,1,0,2,3),
+(20047,24001,24001,5,0,1,1,1,1),
+(20047,24002,24002,5,0,1,1,1,1),
+(20047,24011,24011,1,0,1,1,1,1),
+(20047,24013,24013,1,0,1,1,1,1),
+(20047,24014,24014,0.5,0,1,1,1,1),
+(20047,24035,24035,2,0,1,1,1,1),
+(20047,24093,24093,0.5,0,1,1,1,1),
+(20047,27855,0,5.13,0,1,0,1,1),
+(20047,27860,0,2.88,0,1,0,1,1),
+(20047,30183,0,4.14,0,1,0,1,1),
+(20047,32897,0,8.9,0,1,0,1,1),
+(20047,32902,0,10.68,0,1,0,1,3),
+(20047,32905,0,4.24,0,1,0,1,3);