DB/Creature: Add some equipments

(cherry picked from commit a08e5e38e9d15e9cbd028ff86d1fbc1bf5288f3e)

1 files changed, 34 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_12_20_12_world_2020_01_12_04_world.sql b/sql/updates/world/master/2021_12_20_12_world_2020_01_12_04_world.sql
new file mode 100644
index 00000000000..7548d3a850b
--- /dev/null
+++ b/sql/updates/world/master/2021_12_20_12_world_2020_01_12_04_world.sql
@@ -0,0 +1,34 @@
+-- 
+UPDATE `creature` SET `equipment_id`=-1 WHERE `id` IN (1976, 14901, 23745, 24015, 24062, 24212, 28579, 32710, 32711, 34838); 
+DELETE FROM `creature_equip_template` WHERE `CreatureID` IN (/*1976,*/ 14901, 23745, 24015, 24062, 24212, 28579, 32710, 32711, 34838);
+INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `ItemID2`, `ItemID3`, `VerifiedBuild`) VALUES
+-- (1976, 1, 1899, 143, 0, 0),
+-- (1976, 2, 2715, 143, 0, 0),
+(14901, 1, 12629, 0, 0, 18019),
+(14901, 2, 1910, 13605, 0, 0),
+(23745, 1, 6228, 0, 0, 0),
+(23745, 2, 2023, 0, 0, 18019),
+(24015, 1, 34818, 0, 0, 0),
+(24015, 2, 34817, 0, 0, 0),
+(24015, 3, 34819, 0, 0, 0),
+(24015, 4, 34819, 33212, 0, 0),
+(24015, 5, 34820, 0, 0, 0),
+(24015, 6, 34816, 0, 0, 0),
+(24015, 7, 34821, 0, 0, 0),
+(24015, 8, 33276, 0, 0, 18019),
+(24062, 1, 1910, 0, 0, 18019),
+(24062, 2, 2704, 0, 0, 0),
+(24212, 1, 1983, 0, 0, 18019),
+(24212, 2, 1910, 0, 0, 0),
+(28579, 1, 39359, 0, 0, 0),
+(28579, 2, 33594, 33594, 0, 18019),
+(32710, 1, 0, 0, 44635, 0),
+(32710, 2, 0, 0, 44643, 0),
+(32711, 1, 0, 0, 44643, 0),
+(32711, 2, 0, 0, 44635, 0),
+(34838, 1, 34817, 0, 0, 0),
+(34838, 2, 40894, 13407, 0, 0),
+(34838, 3, 34816, 34819, 0, 0),
+(34838, 4, 34821, 34816, 0, 0),
+(34838, 5, 34819, 33212, 0, 0),
+(34838, 6, 34818, 0, 0, 0);