aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorTrond B. Krokli <38162891+illfated@users.noreply.github.com>2020-07-29 13:26:39 +0200
committerGitHub <noreply@github.com>2020-07-29 13:26:39 +0200
commite0dae8feb6607b5190d14b56ecfc10bbfa667c95 (patch)
tree8165713ded87b3d500b340e29bb8330744c6a320 /sql/updates
parent7f7fa8b23d71297f75ff4ca3c1d6e38333a5cc76 (diff)
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 <Rushor@users.noreply.github.com> Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com>
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/3.3.5/2020_07_29_00_world.sql4
1 files changed, 4 insertions, 0 deletions
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);