From e0dae8feb6607b5190d14b56ecfc10bbfa667c95 Mon Sep 17 00:00:00 2001 From: "Trond B. Krokli" <38162891+illfated@users.noreply.github.com> Date: Wed, 29 Jul 2020 13:26:39 +0200 Subject: Scripts/Quest: Force of Neltharaku quest credit (#24807) * Scripts/Quest: Force of Neltharaku quest credit **Description:** Suggested solution to resolve the kill credit double cast issue in the quest "The Force of Neltharaku" (10854). by Rushor **Changes proposed:** - Remove duplicate spell casts in the zone quest script - Remove commented-out script section - Set a couple of unit flags (anim/stand/hover) - Move return new creature script override to end of script - Move PlayerGUID, FlyTimer, and Tapped to Private - Add DB flight movement control to Enslaved Netherwing Drake - Add SpellMgr MaxAffectedTargets = 1 for spell 38762 - Add movement enum POINT_MOVE_UP - Add missing enum for quest ID **Target branch(es):** 3.3.5/master - [X] 3.3.5 - [X] master **Issues addressed:** Closes #24796 **Tests performed:** (Does it build, tested in-game, etc.) Pending for now. **Known issues and TODO list:** (add/remove lines as needed) - [X] Open PR in draft mode until testing is cleared - [ ] Compile and create local server - [ ] Test changes on local server * Rename 9999_99_99_99_world.sql to 2020_07_29_00_world.sql Co-authored-by: Rushor Co-authored-by: Giacomo Pozzoni --- sql/updates/world/3.3.5/2020_07_29_00_world.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_07_29_00_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2020_07_29_00_world.sql b/sql/updates/world/3.3.5/2020_07_29_00_world.sql new file mode 100644 index 00000000000..4e3b7bb4769 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_07_29_00_world.sql @@ -0,0 +1,4 @@ +-- +-- The Force of Neltharaku: Enslaved Netherwing Drake (21722) +UPDATE `creature_template_movement` SET `Flight`= 1 WHERE `CreatureId`= 21722; +UPDATE `creature_addon` SET `bytes1`= 0 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id`= 21722); -- cgit v1.2.3