From e2eb694c57885e49f37c328b899d802e1ff4ea90 Mon Sep 17 00:00:00 2001
From: megamage <none@none>
Date: Fri, 31 Oct 2008 21:42:00 -0500
Subject: [svn] Improve TargetedMovement (TODO: let mob find "near angle"
 rather than "random angle"). Delete a repeated check in instance canenter().
 Fix some spell targets. Add some sunwell spell sql. Fix Magtheridons
 earthquake. (TODO: need to find out why soul transfer has no effect when
 casted by mobs) Let Brutallus dual wield. Enable burn (still no script
 effect). Quick fix for shadowmoon valley illidan quest crash (wait for
 author's fix).

--HG--
branch : trunk
---
 sql/updates/147_world.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 sql/updates/147_world.sql

(limited to 'sql/updates/147_world.sql')

diff --git a/sql/updates/147_world.sql b/sql/updates/147_world.sql
new file mode 100644
index 00000000000..088a06567a7
--- /dev/null
+++ b/sql/updates/147_world.sql
@@ -0,0 +1,14 @@
+DELETE FROM spell_linked_spell WHERE `spell_trigger` IN (46648, 46019, 46021, -46021, 46020);
+INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (46648, 44866, 1, 'Spectral Blast');
+INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (46019, 46021, 1, 'Teleport: Spectral Realm');
+INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (46021, 44852, 1, 'Spectral Realm Aura');
+INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-46021, 46020, 0, 'Teleport: Normal Realm');
+INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (46020, 44867, 1, 'Spectral Exhaustion');
+
+DELETE FROM spell_target_position WHERE `id` IN (46019, 46020);
+INSERT INTO spell_target_position () VALUES (46019, 580, 1704.34, 928.17, -74.558, 0);
+INSERT INTO spell_target_position () VALUES (46020, 580, 1704.34, 928.17, 53.079, 0);
+
+--Magtheridon Earthquake
+DELETE FROM spell_script_target WHERE `entry` IN (30657);
+INSERT INTO spell_script_target VALUES ('30657', '1', '24136');
\ No newline at end of file
-- 
cgit v1.2.3

