From c143319b052daa2ba79afd36e438fd6de09fd459 Mon Sep 17 00:00:00 2001 From: kaelima Date: Mon, 30 May 2011 14:36:19 +0200 Subject: Ruby Sanctum: - Scripted Saviana Ragefire - Moved Baltharus the Warborn's clone from smartai to cpp (this because they share healthpool with Baltharus the Warborn, witch cant be done with SAI) --- sql/updates/world/2011_05_30_01_world_conditions.sql | 3 +++ sql/updates/world/2011_05_30_01_world_creature.sql | 13 +++++++++++++ .../world/2011_05_30_01_world_spell_script_names.sql | 5 +++++ 3 files changed, 21 insertions(+) create mode 100644 sql/updates/world/2011_05_30_01_world_conditions.sql create mode 100644 sql/updates/world/2011_05_30_01_world_creature.sql create mode 100644 sql/updates/world/2011_05_30_01_world_spell_script_names.sql (limited to 'sql') diff --git a/sql/updates/world/2011_05_30_01_world_conditions.sql b/sql/updates/world/2011_05_30_01_world_conditions.sql new file mode 100644 index 00000000000..14fc7d999d0 --- /dev/null +++ b/sql/updates/world/2011_05_30_01_world_conditions.sql @@ -0,0 +1,3 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=74455; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,0,74455,0,18,1,39747,0,0,'', 'Spell 74455 targets only Saviana Ragefire'); diff --git a/sql/updates/world/2011_05_30_01_world_creature.sql b/sql/updates/world/2011_05_30_01_world_creature.sql new file mode 100644 index 00000000000..b3a485d188e --- /dev/null +++ b/sql/updates/world/2011_05_30_01_world_creature.sql @@ -0,0 +1,13 @@ +-- Saviana Ragefire +UPDATE `creature_template` SET `InhabitType`=3,`mechanic_immune_mask`=`mechanic_immune_mask`|8388624,`ScriptName`= 'boss_saviana_ragefire' WHERE `entry`=39747; +DELETE FROM `creature_text` WHERE `entry`=39747; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(39747,0,0, 'You will sssuffer for this intrusion!',14,0,100,0,0,17528, 'Saviana Ragefire'), +(39747,1,0, 'Burn in the master''s flame!',14,0,100,0,0,17532, 'Saviana Ragefire'), +(39747,2,0, '%s becomes enraged!',16,0,100,0,0,0, 'Saviana Ragefire'), +(39747,3,0, 'Halion will be pleased.',14,0,100,0,0,17530, 'Saviana Ragefire'), +(39747,3,1, 'As it should be....',14,0,100,0,0,17529, 'Saviana Ragefire'); + +-- Baltharus the Warborn Clone +UPDATE `creature_template` SET `AIName`= '',`ScriptName`= 'npc_baltarhus_the_warborn_clone' WHERE `entry`=39899; +DELETE FROM `smart_scripts` WHERE `entryorguid`=39899; \ No newline at end of file diff --git a/sql/updates/world/2011_05_30_01_world_spell_script_names.sql b/sql/updates/world/2011_05_30_01_world_spell_script_names.sql new file mode 100644 index 00000000000..4c6af78eb02 --- /dev/null +++ b/sql/updates/world/2011_05_30_01_world_spell_script_names.sql @@ -0,0 +1,5 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`= 'spell_saviana_conflagration_init'; +DELETE FROM `spell_script_names` WHERE `ScriptName`= 'spell_saviana_conflagration_throwback'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(74452, 'spell_saviana_conflagration_init'), +(74455, 'spell_saviana_conflagration_throwback'); -- cgit v1.2.3