From 971d617e9e01640a4f2b6d55aba4d98dfd352a76 Mon Sep 17 00:00:00 2001 From: "malcromdev@gmail.com>" Date: Mon, 5 Apr 2010 22:09:36 -0230 Subject: Add Spells to Coldarra Warmages to target Tansisus Shield Bunnys same as Violet Stand. Also required: http://trinitydatabase.org/index.php?/topic/15320-fix-for-transis-shield-bunnys-coldarra/ --HG-- branch : trunk --- sql/FULL/world_scripts_full.sql | 3 ++- sql/updates/7780_world_scriptname.sql | 1 + 2 files changed, 3 insertions(+), 1 deletion(-) create mode 100644 sql/updates/7780_world_scriptname.sql (limited to 'sql') diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql index b2cfd9dacf1..ad4ef6954a2 100644 --- a/sql/FULL/world_scripts_full.sql +++ b/sql/FULL/world_scripts_full.sql @@ -407,7 +407,8 @@ UPDATE `creature_template` SET `ScriptName`='npc_fezzix_geartwist' WHERE `entry` UPDATE `creature_template` SET `scriptname`='npc_trapped_mammoth_calf' WHERE `entry`=25850; UPDATE `item_template` SET `scriptname`='item_dehta_trap_smasher' WHERE `entry`=35228; UPDATE `creature_template` SET `ScriptName`='npc_magmoth_crusher' WHERE `entry`=25434; - +UPDATE `creature_template` SET `ScriptName`='npc_valiance_keep_cannoneer' WHERE `entry`=25306; +UPDATE `creature_template` SET `ScriptName`='npc_warmage_coldarra' WHERE `entry` IN (27173,27904,27906); /* BURNING STEPPES */ UPDATE `creature_template` SET `ScriptName`='npc_ragged_john' WHERE `entry`=9563; diff --git a/sql/updates/7780_world_scriptname.sql b/sql/updates/7780_world_scriptname.sql new file mode 100644 index 00000000000..25cdec2b229 --- /dev/null +++ b/sql/updates/7780_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`= 'npc_warmage_coldarra' WHERE `entry` IN (27173,27904,27906); -- cgit v1.2.3