aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authormegamage <none@none>2009-08-15 23:04:21 -0500
committermegamage <none@none>2009-08-15 23:04:21 -0500
commit90ed27059df7aa3a220cf0aa305a7dab58de92e3 (patch)
treefc310de254bbab33c616115ee78896da9301870c /sql/updates
parent95a79b2815da4f374d8ffcd1fb5cf9ce41f6c50f (diff)
*Script of quest Massacre at light's point. Original author nevan.
*primary bugs: *you may fall below the deck of ship after exiting mine car and have to try again. *mobs spawn too slow (part of it is db issue) *there is no cannon on ship (db issue, you can add some 28833 by yourself or ask your db dev to do it) --HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/5083_world_scripts_dk.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/5083_world_scripts_dk.sql b/sql/updates/5083_world_scripts_dk.sql
new file mode 100644
index 00000000000..185a6493f35
--- /dev/null
+++ b/sql/updates/5083_world_scripts_dk.sql
@@ -0,0 +1,11 @@
+DELETE FROM `npc_spellclick_spells` WHERE `spell_id` IN (52447);
+INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `quest_start_active`, `quest_end`, `cast_flags`) VALUES
+(28833, 52447, 12701, 1, 12701, 1); -- Scarlet Cannon Master
+
+UPDATE creature_template SET spell1=52435,spell2=52576,spell5=52588,VehicleId=79,speed=0 WHERE entry = 28833;
+UPDATE `creature_template` SET vehicleid=138 WHERE (`entry`='28817');
+
+UPDATE `gameobject_template` SET `ScriptName`='go_inconspicuous_mine_car' WHERE (`entry`='190767');
+UPDATE `creature_template` SET `ScriptName`='npc_scarlet_miner_cart' WHERE (`entry`='28817');
+UPDATE `creature_template` SET `ScriptName`='npc_scarlet_miner' WHERE (`entry`='28841');
+