aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/2702_world_spell_proc_event.sql5
-rw-r--r--sql/updates/2706_world_SD2_scripts.sql4
2 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/2702_world_spell_proc_event.sql b/sql/updates/2702_world_spell_proc_event.sql
new file mode 100644
index 00000000000..a887d590c54
--- /dev/null
+++ b/sql/updates/2702_world_spell_proc_event.sql
@@ -0,0 +1,5 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN (56337, 56336, 56333);
+INSERT INTO `spell_proc_event` VALUES
+(56337, 0x00, 9, 0x00000004, 0x00000000, 0x00000200, 0x00011100, 0x0000000, 0.000000, 0.000000, 0),
+(56336, 0x00, 9, 0x00000004, 0x00000000, 0x00000200, 0x00011100, 0x0000000, 0.000000, 0.000000, 0),
+(56333, 0x00, 9, 0x00000004, 0x00000000, 0x00000200, 0x00011100, 0x0000000, 0.000000, 0.000000, 0);
diff --git a/sql/updates/2706_world_SD2_scripts.sql b/sql/updates/2706_world_SD2_scripts.sql
new file mode 100644
index 00000000000..71f97997461
--- /dev/null
+++ b/sql/updates/2706_world_SD2_scripts.sql
@@ -0,0 +1,4 @@
+UPDATE creature_template SET ScriptName='npc_kingdom_of_dalaran_quests' WHERE entry IN (29169,23729,26673,27158,29158,29161,26471,29155,29159,29160,29162);
+DELETE FROM spell_target_position WHERE id=53360;
+INSERT INTO spell_target_position VALUES
+(53360, 571, 5807.829, 587.960, 660.939, 1.663); \ No newline at end of file