diff options
| author | wotlk-enthusiast <61640421+wotlk-enthusiast@users.noreply.github.com> | 2021-01-08 14:56:55 -0700 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-05 22:39:32 +0100 |
| commit | 850d60c4b33eb96150ee15edd3107fe6036fefbd (patch) | |
| tree | 17f53a36c27800168e563d594edd54ea2894b448 /sql/updates | |
| parent | c7bff97d1a6511dbfea99e13ea05c557a67add14 (diff) | |
Scripts/Utgarde Pinnacle: Svala Sorrowgrave Intro and Ritual of the Sword (#24503)
* Scripts/Svala SorrowGrave - Fix broken intro event and Ritual of the Sword
* Added missing header for non-PCH build.
* Added error checking for Svala's targeting, and tightened up the timing on the intro event.
* Update WorldDB\Creature_Template_Movement for Svala
* Fix movement during intro and ritual event
* Rename SQL file for merge
Co-authored-by: Carbenium <carbenium@outlook.com>
(cherry picked from commit a225717b99b6d1befcfe40f3001bfb1efcf8a9d8)
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/master/2022_03_05_63_world_2021_01_08_08_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_05_63_world_2021_01_08_08_world.sql b/sql/updates/world/master/2022_03_05_63_world_2021_01_08_08_world.sql new file mode 100644 index 00000000000..f5e40526d8c --- /dev/null +++ b/sql/updates/world/master/2022_03_05_63_world_2021_01_08_08_world.sql @@ -0,0 +1,8 @@ +UPDATE `creature_template` SET `flags_extra` = `flags_extra`| 0x200 WHERE `entry` IN (29281, 30809, 26668, 30810); + +DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (29281, 30809, 26668, 30810); +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) VALUES +(29281, 1, 0, 1, 0, 0, 0), +(30809, 1, 0, 1, 0, 0, 0), +(26668, 2, 0, 1, 0, 0, 0), +(30810, 2, 0, 1, 0, 0, 0); |