Scripts/Ulduar: Added script for Auriaya's encounter

7 files changed, 34 insertions, 0 deletions

diff --git a/sql/scripts/world_script_texts.sql b/sql/scripts/world_script_texts.sql
index 0c66169cbfb..c7cae645b83 100644
--- a/sql/scripts/world_script_texts.sql
+++ b/sql/scripts/world_script_texts.sql
@@ -2423,6 +2423,8 @@ INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`
    (33515,-1603052,'There is no escape!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15475,1,0,0,'Auriaya SAY_SLAY_2'),
    (33515,-1603053,'Auriaya screams in agony.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,6,0,15476,'Auriaya SAY_DEATH'),
    (33515,-1603054,'You waste my time!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15477,1,0,0,'Auriaya SAY_BERSERK'),
+   (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'),
 
 -- Flame Leviathan
    (33113,-1603060,'Hostile entities detected. Threat assessment protocol active. Primary target engaged. Time minus thirty seconds to re-evaluation.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15506,1,0,0,'Flame Leviathan SAY_AGGRO'),
diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql
index 6d8ca17379e..54b2a269ee8 100644
--- a/sql/scripts/world_scripts_full.sql
+++ b/sql/scripts/world_scripts_full.sql
@@ -1614,6 +1614,9 @@ UPDATE `creature_template` SET `ScriptName`='npc_eonars_gift' WHERE `entry`=3322
 UPDATE `creature_template` SET `ScriptName`='npc_healthy_spore' WHERE `entry`=33215;
 UPDATE `creature_template` SET `ScriptName`='npc_unstable_sun_beam' WHERE `entry`=33050;
 UPDATE `creature_template` SET `ScriptName`='npc_iron_roots' WHERE `entry` IN (33088,33168);
+UPDATE `creature_template` SET `ScriptName`='npc_feral_defender' WHERE `entry`=34035;
+UPDATE `creature_template` SET `ScriptName`='npc_sanctum_sentry' WHERE `entry`=34014;
+UPDATE `creature_template` SET `ScriptName`='npc_auriaya_seeping_trigger' WHERE `entry` =34098;
 
 
 /* UN'GORO CRATER */
@@ -2218,6 +2221,7 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 ( 62775, 'spell_xt002_tympanic_tantrum'),
 ( 37751, 'spell_xt002_submerged'),
 ( 37752, 'spell_xt002_stand'),
+( 64381, 'spell_auriaya_strenght_of_the_pack'),
 -- Eye Of Eternity
 ( 56105, 'spell_malygos_vortex_dummy'),
 ( 55873, 'spell_malygos_vortex_visual'),
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');