aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
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/updates
parent395667a7f36c4e2db0f7d2f558532b6b13f80a2c (diff)
Add script for quest 12687
--HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/3724_world.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/3724_world.sql b/sql/updates/3724_world.sql
new file mode 100644
index 00000000000..1269925e0ee
--- /dev/null
+++ b/sql/updates/3724_world.sql
@@ -0,0 +1,10 @@
+-- Vehicle and summon spell(summon npc 28788) for Acherus Deathcharger
+UPDATE creature_template SET `spell1`=52362, `VehicleId`=200 WHERE `entry`=28782;
+
+-- ScriptName for dark rider
+UPDATE creature_template SET `ScriptName`='npc_ros_dark_rider' WHERE `entry`=28768;
+
+-- 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);