diff options
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'); + |