aboutsummaryrefslogtreecommitdiff
path: root/sql/world_spell_full.sql
diff options
context:
space:
mode:
authorKudlaty <none@none>2009-06-02 23:41:50 +0200
committerKudlaty <none@none>2009-06-02 23:41:50 +0200
commit66c4a695ba7a705384122b5fefdc5c246093e74d (patch)
treeb1f04c7d6a8b4d9f019eb1b782d93e6bf3d9467e /sql/world_spell_full.sql
parent395667a7f36c4e2db0f7d2f558532b6b13f80a2c (diff)
Add script for quest 12687
--HG-- branch : trunk
Diffstat (limited to 'sql/world_spell_full.sql')
-rw-r--r--sql/world_spell_full.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/world_spell_full.sql b/sql/world_spell_full.sql
index 284072608ba..a9fecbb4e07 100644
--- a/sql/world_spell_full.sql
+++ b/sql/world_spell_full.sql
@@ -178,6 +178,11 @@ INSERT INTO npc_spellclick_spells (`npc_entry`, `spell_id`, `quest_id`, `quest_s
(28606, 52263, 12680, 3, 1),
(28607, 52263, 12680, 3, 1);
+-- Spellclick spell to mount deathcharger
+DELETE FROM npc_spellclick_spells WHERE `npc_entry`=28782;
+INSERT INTO npc_spellclick_spells (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES
+(28782, 52280, 12687, 3, 1);
+
-- --------
-- TARGET
-- --------
@@ -1562,6 +1567,9 @@ UPDATE creature_template SET VehicleId = 312 WHERE entry IN (31857,31858,31861,3
-- Horses for quest 12680 / not sure if its offilike
UPDATE creature_template SET `VehicleId`=200 WHERE `entry` IN (28605,28606,28607);
+-- Vehicle and summon spell(summon npc 28788) for Acherus Deathcharger
+UPDATE creature_template SET `spell1`=52362, `VehicleId`=200 WHERE `entry`=28782;
+
-- --------
-- Death Knight
-- --------