From e2eb694c57885e49f37c328b899d802e1ff4ea90 Mon Sep 17 00:00:00 2001 From: megamage 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') 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