aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates')
-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);