aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorccrs <ccrs@users.noreply.github.com>2019-06-30 19:48:50 +0200
committerccrs <ccrs@users.noreply.github.com>2019-06-30 19:48:50 +0200
commit3dbf3fed7c10b5808d2c20bdd3a8a3598ddd7cf6 (patch)
treea8e3c8df9ed6d83e253e512919f200eb729055f2 /sql
parente1787b883e1dc4cd67d6b30c8a1ca6db4abb2660 (diff)
Scripts/ICC: base support for Ymirjar Vrykuls AI
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2019_06_30_02_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_06_30_02_world.sql b/sql/updates/world/3.3.5/2019_06_30_02_world.sql
new file mode 100644
index 00000000000..8f90f79220e
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_06_30_02_world.sql
@@ -0,0 +1,5 @@
+UPDATE `creature_template` SET `AIName`='', `ScriptName`='npc_frostwing_ymirjar_vrykul' WHERE `entry` IN (37132,38125,37127,37134,37133);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (37132,38125,37127,37134,37133) AND `source_type`=0;
+
+-- Dual wield for 'Ymirjar Battle-Maiden'
+UPDATE `creature_template` SET `flags_extra`=2048 WHERE `entry` IN (37132,38132);