From 6c4971ee79edb1ab58260ad92155015cc95a3c70 Mon Sep 17 00:00:00 2001 From: megamage Date: Tue, 1 Sep 2009 11:26:26 -0500 Subject: *Add script for iruk and "aces high". By manuel --HG-- branch : trunk --- sql/FULL/world_scripts_full.sql | 2 ++ sql/FULL/world_spell_full.sql | 14 +++++++++++++- sql/updates/5524_world_scripts.sql | 10 ++++++++++ 3 files changed, 25 insertions(+), 1 deletion(-) create mode 100644 sql/updates/5524_world_scripts.sql (limited to 'sql') diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql index 44a2e1142da..741f4273e0c 100644 --- a/sql/FULL/world_scripts_full.sql +++ b/sql/FULL/world_scripts_full.sql @@ -315,6 +315,8 @@ UPDATE `creature_template` SET `ScriptName`='npc_tiare' WHERE `entry`=30051; UPDATE `creature_template` SET `ScriptName`='npc_sinkhole_kill_credit' WHERE `entry` IN (26248,26249); UPDATE `creature_template` SET `ScriptName`='npc_khunok_the_behemoth' WHERE `entry`=25862; UPDATE `creature_template` SET `ScriptName`='npc_keristrasza' WHERE `entry`=26206; +update creature_template set ScriptName = 'npc_iruk' where entry = 26219; +UPDATE creature_template SET ScriptName = 'npc_corastrasza' WHERE entry = 32548; /* BURNING STEPPES */ UPDATE `creature_template` SET `ScriptName`='npc_ragged_john' WHERE `entry`=9563; diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql index 06481b9100d..a36ad7c0527 100644 --- a/sql/FULL/world_spell_full.sql +++ b/sql/FULL/world_spell_full.sql @@ -2275,4 +2275,16 @@ DELETE FROM `spell_script_target` WHERE `entry` = '51959' and `type` = '1'; INSERT INTO `spell_script_target` ( `entry`, `type`, `targetEntry`) VALUES ('51959', '1', '28161'); # the lurker below -update creature_template set inhabittype=3 where entry=21217; \ No newline at end of file +update creature_template set inhabittype=3 where entry=21217; + + +-- update creature_template set ScriptName = 'npc_iruk' where entry = 26219; +-- UPDATE creature_template SET ScriptName = 'npc_corastrasza' WHERE entry = 32548; + +DELETE FROM `spell_script_target` WHERE entry = 61245; +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +(61245, 1, 32535); + +UPDATE creature_template SET VehicleId = 165 , spell1 = 56091,spell2 = 56092,spell3 = 57090,spell4 = 57143 ,spell5 = 57108,spell6=57403, unit_class = 1, minhealth = 100000, maxhealth = 100000 WHERE entry = 32535; +UPDATE creature_template SET armor = 9729, mindmg = 422, maxdmg=586, minrangedmg=345, maxrangedmg=509, attackpower=642, rangedattackpower=103 WHERE entry = 32535; +update creature set DeathState = 0 where id = 26219; \ No newline at end of file diff --git a/sql/updates/5524_world_scripts.sql b/sql/updates/5524_world_scripts.sql new file mode 100644 index 00000000000..22f9e6763ab --- /dev/null +++ b/sql/updates/5524_world_scripts.sql @@ -0,0 +1,10 @@ +update creature_template set ScriptName = 'npc_iruk' where entry = 26219; +UPDATE creature_template SET ScriptName = 'npc_corastrasza' WHERE entry = 32548; + +DELETE FROM `spell_script_target` WHERE entry = 61245; +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +(61245, 1, 32535); + +UPDATE creature_template SET VehicleId = 165 , spell1 = 56091,spell2 = 56092,spell3 = 57090,spell4 = 57143 ,spell5 = 57108,spell6=57403, unit_class = 1, minhealth = 100000, maxhealth = 100000 WHERE entry = 32535; +UPDATE creature_template SET armor = 9729, mindmg = 422, maxdmg=586, minrangedmg=345, maxrangedmg=509, attackpower=642, rangedattackpower=103 WHERE entry = 32535; +update creature set DeathState = 0 where id = 26219; \ No newline at end of file -- cgit v1.2.3