diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2020_05_06_04_world.sql | 17 |
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); |