From f3941ff68305b118bec706bd128de2471d16773f Mon Sep 17 00:00:00 2001 From: Aokromes Date: Wed, 12 Mar 2025 18:51:51 +0100 Subject: DB/Creature: Fix Darkspear Dragon Hunter equipment closes #30744 by CraftedRO --- sql/updates/world/3.3.5/2025_03_12_01_world.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/world/3.3.5/2025_03_12_01_world.sql (limited to 'sql/updates') 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; -- cgit v1.2.3