From 40c7ffcd991bec9848eb476a7486cc02bcae3441 Mon Sep 17 00:00:00 2001 From: Killyana Date: Sun, 12 Jan 2020 19:11:19 +0100 Subject: DB/Creature: Add some equipments (cherry picked from commit a08e5e38e9d15e9cbd028ff86d1fbc1bf5288f3e) --- .../2021_12_20_12_world_2020_01_12_04_world.sql | 34 ++++++++++++++++++++++ 1 file changed, 34 insertions(+) create mode 100644 sql/updates/world/master/2021_12_20_12_world_2020_01_12_04_world.sql (limited to 'sql') 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); -- cgit v1.2.3