aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorwotlk-enthusiast <61640421+wotlk-enthusiast@users.noreply.github.com>2021-01-08 14:56:55 -0700
committerGitHub <noreply@github.com>2021-01-08 22:56:55 +0100
commita225717b99b6d1befcfe40f3001bfb1efcf8a9d8 (patch)
tree2c1aa70dfa38bdc28dc190ec480eb02b9d85646a /sql
parent94a74126e9b82c1f31ac4218ff5fbaf773cd50ef (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>
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2021_01_08_08_world.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_01_08_08_world.sql b/sql/updates/world/3.3.5/2021_01_08_08_world.sql
new file mode 100644
index 00000000000..f5e40526d8c
--- /dev/null
+++ b/sql/updates/world/3.3.5/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);