aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authormegamage <none@none>2009-09-01 11:26:26 -0500
committermegamage <none@none>2009-09-01 11:26:26 -0500
commit6c4971ee79edb1ab58260ad92155015cc95a3c70 (patch)
tree59b874eb31335141a18318475c62f67c97d63ef9 /sql
parent55981782f0bdad5f80de8feeee793ae7f551e826 (diff)
*Add script for iruk and "aces high". By manuel
--HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/FULL/world_scripts_full.sql2
-rw-r--r--sql/FULL/world_spell_full.sql14
-rw-r--r--sql/updates/5524_world_scripts.sql10
3 files changed, 25 insertions, 1 deletions
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