aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authormegamage <none@none>2009-04-15 17:20:54 -0500
committermegamage <none@none>2009-04-15 17:20:54 -0500
commit02003cc338bb9ea5a8428ee068d618af5940b145 (patch)
treed6c3425180e032405d5ac591c21c4109d5dd739c /sql
parentb76e8cfa5cf4791a9227b266569e9478d8a8298a (diff)
parente3bd7fed4e06827ed1337dd80f85e83304ba28fe (diff)
*Merge.
--HG-- branch : trunk
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