diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2025_03_12_01_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2025_03_12_01_world.sql b/sql/updates/world/3.3.5/2025_03_12_01_world.sql new file mode 100644 index 00000000000..6d5baf75113 --- /dev/null +++ b/sql/updates/world/3.3.5/2025_03_12_01_world.sql @@ -0,0 +1,11 @@ +-- Add correct equipment to Darkspear Dragon Hunter +SET @NPC=26870; +DELETE FROM `creature_equip_template` WHERE `CreatureID`=@NPC; +INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `ItemID2`, `ItemID3`, `VerifiedBuild`) VALUES +(@NPC, 1, 36790, 0, 0, 59570), +(@NPC, 2, 36791, 0, 0, 59570), +(@NPC, 3, 36792, 0, 0, 59570); + +UPDATE `creature` SET `equipment_id`=-1 WHERE `id`=@NPC; +UPDATE `creature_addon` SET `emote`=425 WHERE `guid`=203379; +UPDATE `creature_addon` SET `PvpFlags`=0 WHERE `guid` BETWEEN 203380 AND 203385; |