aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authormegamage <none@none>2009-05-24 11:07:09 -0500
committermegamage <none@none>2009-05-24 11:07:09 -0500
commit8450b33041267d821bddcd8eea928c643123cc5f (patch)
treeb5ec8f4efc8a06117bc65a44a69b5ac789ecf080 /sql/updates
parent1b2579a2abd8dea7d728333706b57cd8b23e0936 (diff)
*Add vehicle id for three-seat mammoth.
*Fix spell impale of archavon. --HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/3498_world_scripts.sql12
1 files changed, 12 insertions, 0 deletions
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