From 8450b33041267d821bddcd8eea928c643123cc5f Mon Sep 17 00:00:00 2001 From: megamage Date: Sun, 24 May 2009 11:07:09 -0500 Subject: *Add vehicle id for three-seat mammoth. *Fix spell impale of archavon. --HG-- branch : trunk --- sql/updates/3498_world_scripts.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/3498_world_scripts.sql (limited to 'sql/updates') diff --git a/sql/updates/3498_world_scripts.sql b/sql/updates/3498_world_scripts.sql new file mode 100644 index 00000000000..de9d9903bb0 --- /dev/null +++ b/sql/updates/3498_world_scripts.sql @@ -0,0 +1,12 @@ +UPDATE creature_template SET VehicleId = 312 WHERE entry IN (31857,31858,31861,31862,32212,32213,32633,32640); +UPDATE creature_template SET VehicleId = 174 WHERE entry IN (31125,31722); + +DELETE FROM `spell_linked_spell` WHERE spell_trigger IN (58666,60882); +INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES +( 58666, 58672, 1, 'Impale (Archavon)'), +( 60882, 58672, 1, 'Impale (Archavon)'); + +DELETE FROM `spell_script_target` WHERE entry IN +(58672); +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +(58672, 1, 31125); \ No newline at end of file -- cgit v1.2.3