DB/Creature: Add some equipments

1 files changed, 33 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_01_12_04_world.sql b/sql/updates/world/3.3.5/2020_01_12_04_world.sql
new file mode 100644
index 00000000000..cf68e4def66
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_01_12_04_world.sql
@@ -0,0 +1,33 @@
+-- 
+UPDATE `creature` SET `equipment_id`=-1 WHERE `guid` 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`) VALUES
+(1976, 1, 1899, 143, 0),
+(1976, 2, 2715, 143, 0),
+(14901, 1, 12629, 0, 0),
+(14901, 2, 1910, 13605, 0),
+(23745, 1, 6228, 0, 0),
+(23745, 2, 2023, 0, 0),
+(24015, 1, 34818, 0, 0),
+(24015, 2, 34817, 0, 0),
+(24015, 3, 34819, 0, 0),
+(24015, 4, 34819, 33212, 0),
+(24015, 5, 34820, 0, 0),
+(24015, 6, 34816, 0, 0),
+(24015, 7, 34821, 0, 0),
+(24062, 1, 1910, 0, 0),
+(24062, 2, 2704, 0, 0),
+(24212, 1, 1983, 0, 0),
+(24212, 2, 1910, 0, 0),
+(28579, 1, 39359, 0, 0),
+(28579, 2, 33594, 33594, 0),
+(32710, 1, 0, 0, 44635),
+(32710, 2, 0, 0, 44643),
+(32711, 1, 0, 0, 44643),
+(32711, 2, 0, 0, 44635),
+(34838, 1, 34817, 0, 0),
+(34838, 2, 40894, 13407, 0),
+(34838, 3, 34816, 34819, 0),
+(34838, 4, 34821, 34816, 0),
+(34838, 5, 34819, 33212, 0),
+(34838, 6, 34818, 0, 0);