Scripts/Ulduar: Added script for Auriaya's encounter

5 files changed, 28 insertions, 0 deletions

diff --git a/sql/updates/world/2011_06_17_01_world_script_texts.sql b/sql/updates/world/2011_06_17_01_world_script_texts.sql
new file mode 100644
index 00000000000..e974671b054
--- /dev/null
+++ b/sql/updates/world/2011_06_17_01_world_script_texts.sql
@@ -0,0 +1,5 @@
+DELETE FROM `script_texts` WHERE `entry` IN (-1603055,-1603056);
+INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`)
+VALUES
+(33515,-1603055,'Auriaya begins to cast Terrifying Screech.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3,0,0,'Auriaya - EMOTE_FEAR'),
+(33515,-1603056,'Auriaya begins to activate the Feral Defender!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3,0,0,'Auriaya - EMOTE_DEFENDER');
diff --git a/sql/updates/world/2011_06_17_02_world_spelldifficulty_dbc.sql b/sql/updates/world/2011_06_17_02_world_spelldifficulty_dbc.sql
new file mode 100644
index 00000000000..e4ea3f26eeb
--- /dev/null
+++ b/sql/updates/world/2011_06_17_02_world_spelldifficulty_dbc.sql
@@ -0,0 +1,10 @@
+DELETE FROM `spelldifficulty_dbc` WHERE `id` BETWEEN 3200 AND 3206;
+INSERT INTO `spelldifficulty_dbc` (`id`,`spellid0`,`spellid1`,`spellid2`,`spellid3`)
+VALUES
+(3200,64389,64678,0,0), -- Auriaya - Sentinel Blast
+(3201,64422,64688,0,0), -- Auriaya - Sonic Screech
+(3202,64496,64674,0,0), -- Auriaya/Feral Defender - Feral Rush
+(3203,64478,64669,0,0), -- Auriaya/Feral Defender - Feral Pounce
+(3204,64458,64676,0,0), -- Auriaya/Feral Defender - Seeping Essence
+(3205,64666,64374,0,0), -- Auriaya/Sanctum Sentry - Savage Pounce
+(3206,64375,64667,0,0); -- Auriaya/Sanctum Sentry - Rip Flesh
diff --git a/sql/updates/world/2011_06_17_03_world_creature_template.sql b/sql/updates/world/2011_06_17_03_world_creature_template.sql
new file mode 100644
index 00000000000..b8e6b4c6639
--- /dev/null
+++ b/sql/updates/world/2011_06_17_03_world_creature_template.sql
@@ -0,0 +1,5 @@
+UPDATE `creature_template` SET `equipment_id`=2500 WHERE `entry`=33515; -- Freya
+UPDATE `creature_template` SET `ScriptName`='npc_feral_defender' WHERE `entry`=34035; -- Feral Defender
+UPDATE `creature_template` SET `ScriptName`='npc_sanctum_sentry' WHERE `entry`=34014; -- Sanctum Sentry
+UPDATE `creature_template` SET `ScriptName`='npc_auriaya_seeping_trigger',`unit_flags`=33554692,`flags_extra`=130 WHERE `entry` =34098; -- Seeping Trigger
+UPDATE `creature_template` SET `ScriptName`='',`unit_flags`=33554692,`flags_extra`=128 WHERE `entry` =34096; -- Feral Defender Trigger
diff --git a/sql/updates/world/2011_06_17_04_world_spell_script_names.sql b/sql/updates/world/2011_06_17_04_world_spell_script_names.sql
new file mode 100644
index 00000000000..6f26bbc0875
--- /dev/null
+++ b/sql/updates/world/2011_06_17_04_world_spell_script_names.sql
@@ -0,0 +1,4 @@
+DELETE FROM `spell_script_names` WHERE `spell_id`=64381;
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`)
+VALUES
+(64381,'spell_auriaya_strenght_of_the_pack');
diff --git a/sql/updates/world/2011_06_17_05_world_conditions.sql b/sql/updates/world/2011_06_17_05_world_conditions.sql
new file mode 100644
index 00000000000..f79a0c6f8f8
--- /dev/null
+++ b/sql/updates/world/2011_06_17_05_world_conditions.sql
@@ -0,0 +1,4 @@
+DELETE FROM `conditions` WHERE `SourceEntry`=64449; 
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`)
+VALUES 
+(13,0,64449,0,18,1,34096,0,0,'','Auriaya Feral Defender Stalker spell script target');