diff options
| author | megamage <none@none> | 2009-08-15 23:04:21 -0500 |
|---|---|---|
| committer | megamage <none@none> | 2009-08-15 23:04:21 -0500 |
| commit | 90ed27059df7aa3a220cf0aa305a7dab58de92e3 (patch) | |
| tree | fc310de254bbab33c616115ee78896da9301870c /sql | |
| parent | 95a79b2815da4f374d8ffcd1fb5cf9ce41f6c50f (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')
| -rw-r--r-- | sql/FULL/world_scripts_full.sql | 3 | ||||
| -rw-r--r-- | sql/FULL/world_spell_full.sql | 8 | ||||
| -rw-r--r-- | sql/updates/5083_world_scripts_dk.sql | 11 |
3 files changed, 20 insertions, 2 deletions
diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql index 24abf192482..81350d1cd44 100644 --- a/sql/FULL/world_scripts_full.sql +++ b/sql/FULL/world_scripts_full.sql @@ -110,6 +110,9 @@ UPDATE `creature_template` SET `ScriptName`='npc_mirror_image' WHERE `entry`=312 UPDATE `creature_template` SET `ScriptName`='npc_training_dummy' WHERE `entry` IN (17578,24792,32543,32546,32542,32545,30527,31143,31144,31146,32541,32666,32667); UPDATE `creature_template` SET `ScriptName`='npc_lightwell' WHERE `entry` IN (31883,31893,31894,31895,31896,31897); UPDATE `creature_template` SET `ScriptName`='npc_ebon_gargoyle' WHERE `entry`=27829; +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'); /* */ /* ZONE */ diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql index c6a6db63037..7c760a8df2f 100644 --- a/sql/FULL/world_spell_full.sql +++ b/sql/FULL/world_spell_full.sql @@ -2006,8 +2006,12 @@ INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `qu (28606, 52263, 12680, 1, 12680, 1), (28607, 52263, 12680, 1, 12680, 1), (28782, 52280, 12687, 1, 12687, 1), -- Unbound Charger -(28833, 52447, 12701, 1, 12701, 1), -- Scarlet Cannon Master -(28887, 52447, 12701, 1, 12701, 1); +(28833, 52447, 12701, 1, 12701, 1); -- Scarlet Cannon Master +# (28887, 52447, 12701, 1, 12701, 1); -- dead cannon + +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'); -- mine car + -- -------- -- NAXXARAMAS 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'); + |