diff options
| author | offl <offl@users.noreply.github.com> | 2020-05-06 22:56:52 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-02 16:31:43 +0100 |
| commit | d6488f985b2e6aed67d1240f0410a977a710aaf2 (patch) | |
| tree | c875b971d00e49732aa43f73baae3ecddb4e064d /sql | |
| parent | 16735c0ec21fe88ad053da9a9a6b3f33d5840da5 (diff) | |
DB/Loot: Add more items for Crimson Hand Battle Mage
Closes #24576
(cherry picked from commit 63b1c740941e3b6af537b27024b12982064eddfa)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_01_02_10_world_2020_05_06_04_world.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_02_10_world_2020_05_06_04_world.sql b/sql/updates/world/master/2022_01_02_10_world_2020_05_06_04_world.sql new file mode 100644 index 00000000000..2179da99357 --- /dev/null +++ b/sql/updates/world/master/2022_01_02_10_world_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); |