diff options
| author | offl <offl@users.noreply.github.com> | 2020-11-15 04:09:04 +0200 |
|---|---|---|
| committer | offl <offl@users.noreply.github.com> | 2020-11-15 04:09:04 +0200 |
| commit | 21777e2f79b6ce1ec19bd2e1f9bd354b9cf93ce6 (patch) | |
| tree | 7ef125164be3280c8216a58ca70abc07bcd23a9c | |
| parent | ac9ced520148a722d821f824d10633e156d7be86 (diff) | |
DB/Creature: Update equipment of Darkmoon Carnie & Sayge
| -rw-r--r-- | sql/updates/world/3.3.5/2020_11_15_03_world_335.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_11_15_03_world_335.sql b/sql/updates/world/3.3.5/2020_11_15_03_world_335.sql new file mode 100644 index 00000000000..81ad4aa2f27 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_11_15_03_world_335.sql @@ -0,0 +1,9 @@ +-- Linked to building events spawns with 1, linked to actual events spawns with 2 or 3, maybe they're set randomly on linked +-- to guid, I have no idea. Let's use only 2 now +DELETE FROM `creature_equip_template` WHERE (`CreatureID`=14849 AND `ID`=2) OR (`CreatureID`=14849 AND `ID`=3); +INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `ItemID2`, `ItemID3`, `VerifiedBuild`) VALUES +(14849, 2, 3362, 13604, 0, 12340), -- Darkmoon Carnie +(14849, 3, 3362, 13605, 0, 12340); -- Darkmoon Carnie + +UPDATE `creature` SET `equipment_id` = 2 WHERE `id` = 14849 AND `guid` IN (SELECT `guid` FROM `game_event_creature` WHERE `eventEntry` IN (3,4,5)); +UPDATE `creature_equip_template` SET `ItemID2`=12865, `VerifiedBuild`=12340 WHERE (`CreatureID`=14822 AND `ID`=1); -- Sayge |