diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2025-03-12 18:51:51 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-03-12 18:51:51 +0100 |
| commit | f3941ff68305b118bec706bd128de2471d16773f (patch) | |
| tree | 564bb1106748d08fe266086fc7e63fe48d690dc1 | |
| parent | 608c579836c2234b75571f1a38fd0b8985d406af (diff) | |
DB/Creature: Fix Darkspear Dragon Hunter equipment
closes #30744
by CraftedRO
| -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; |