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