Scripts/Ulduar:

* Added script for Freya encounter
* Cleaned up instance script
* Cleaned up teleporter script
* Fixed typo in Hodir script

Signed-off-by: Lopin <Lopin@TwinStar.cz>

5 files changed, 69 insertions, 0 deletions

diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql
index 139988a6fa0..c92fa331990 100644
--- a/sql/scripts/world_scripts_full.sql
+++ b/sql/scripts/world_scripts_full.sql
@@ -1600,6 +1600,21 @@ UPDATE `creature_template` SET `ScriptName`='npc_icicle' WHERE `entry` IN (33169
 UPDATE `creature_template` SET `ScriptName`='npc_snowpacked_icicle' WHERE `entry`=33174;
 UPDATE `creature_template` SET `ScriptName`='npc_ice_block' WHERE `entry`=32938;
 UPDATE `creature_template` SET `ScriptName`='boss_hodir' WHERE `entry`=32845;
+UPDATE `creature_template` SET `ScriptName`='boss_freya' WHERE `entry`=32906;
+UPDATE `creature_template` SET `ScriptName`='boss_elder_brightleaf' WHERE `entry`=32915;
+UPDATE `creature_template` SET `ScriptName`='boss_elder_ironbranch' WHERE `entry`=32913;
+UPDATE `creature_template` SET `ScriptName`='boss_elder_stonebark' WHERE `entry`=32914;
+UPDATE `creature_template` SET `ScriptName`='npc_ancient_conservator' WHERE `entry`=33203;
+UPDATE `creature_template` SET `ScriptName`='npc_snaplasher' WHERE `entry`=32916;
+UPDATE `creature_template` SET `ScriptName`='npc_storm_lasher' WHERE `entry`=32919;
+UPDATE `creature_template` SET `ScriptName`='npc_ancient_water_spirit' WHERE `entry`=33202;
+UPDATE `creature_template` SET `ScriptName`='npc_detonating_lasher' WHERE `entry`=32918;
+UPDATE `creature_template` SET `ScriptName`='npc_sun_beam' WHERE `entry`=33170;
+UPDATE `creature_template` SET `ScriptName`='npc_nature_bomb' WHERE `entry`=34129;
+UPDATE `creature_template` SET `ScriptName`='npc_eonars_gift' WHERE `entry`=33228;
+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);
 
 
 /* UN'GORO CRATER */
diff --git a/sql/updates/world/2011_05_21_01_world_conditions.sql b/sql/updates/world/2011_05_21_01_world_conditions.sql
new file mode 100644
index 00000000000..fc3e748a9de
--- /dev/null
+++ b/sql/updates/world/2011_05_21_01_world_conditions.sql
@@ -0,0 +1,9 @@
+DELETE FROM `conditions` WHERE `SourceEntry` IN (62385,62386,62387,62521,62525,62524);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`)
+VALUES
+(13,0,62385,0,18,1,32906,0,0,'','Brightleaf\'s Essence'),
+(13,0,62386,0,18,1,32906,0,0,'','Stonebarks\'s Essence'),
+(13,0,62387,0,18,1,32906,0,0,'','Ironbranch\'s Essence'),
+(13,0,62521,0,18,1,32906,0,0,'','Attuned to Nature 25 Dose Reduction'),
+(13,0,62524,0,18,1,32906,0,0,'','Attuned to Nature 2 Dose Reduction'),
+(13,0,62525,0,18,1,32906,0,0,'','Attuned to Nature 10 Dose Reduction');
\ No newline at end of file
diff --git a/sql/updates/world/2011_05_21_01_world_instance_misc.sql b/sql/updates/world/2011_05_21_01_world_instance_misc.sql
new file mode 100644
index 00000000000..2541bd9756b
--- /dev/null
+++ b/sql/updates/world/2011_05_21_01_world_instance_misc.sql
@@ -0,0 +1,24 @@
+-- Trigger flag
+UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128 WHERE `entry`=34129;
+
+-- Delete NPC which is not supposed to be here
+DELETE FROM `creature` WHERE `guid`=136607;
+
+-- Immunity
+UPDATE `creature_template` SET `mechanic_immune_mask`=650854239 WHERE `entry`=32906;
+
+-- Spell Difficulties
+DELETE FROM `spelldifficulty_dbc` WHERE `id` BETWEEN 3240 AND 3250;
+INSERT INTO `spelldifficulty_dbc` (`id`,`spellid0`,`spellid1`,`spellid2`,`spellid3`)
+VALUES
+(3240,63169,63549,0,0), -- Ulduar: Corrupted Servitor - Petrify Joints
+(3241,63082,63559,0,0), -- Ulduar: Misguided Nymph - Bind Life
+(3242,63111,63562,0,0), -- Ulduar: Misguided Nymph - Frost Spear
+(3243,63136,63564,0,0), -- Ulduar: Misguided Nymph - Winter's Embrace
+(3244,63047,63550,0,0), -- Ulduar: Guardian Lasher - Guardian's Lash
+(3245,63242,63556,0,0), -- Ulduar: Mangrove Ent - Nourish
+(3246,63241,63554,0,0), -- Ulduar: Mangrove Ent - Tranquility
+(3247,63240,63553,0,0), -- Ulduar: Ironroot Lasher - Ironroot Thorns
+(3248,63247,63568,0,0), -- Ulduar: Nature's Blade - Living Tsunami
+(3249,63226,63551,0,0), -- Ulduar: Guardian of Life - Poison Breath
+(3250,64587,34650,0,0); -- Ulduar: Nature Bomb - Nature Bomb
\ No newline at end of file
diff --git a/sql/updates/world/2011_05_21_01_world_scriptname.sql b/sql/updates/world/2011_05_21_01_world_scriptname.sql
new file mode 100644
index 00000000000..a6e054f6899
--- /dev/null
+++ b/sql/updates/world/2011_05_21_01_world_scriptname.sql
@@ -0,0 +1,15 @@
+UPDATE `creature_template` SET `ScriptName`='boss_freya' WHERE `entry`=32906;
+UPDATE `creature_template` SET `ScriptName`='boss_elder_brightleaf' WHERE `entry`=32915;
+UPDATE `creature_template` SET `ScriptName`='boss_elder_ironbranch' WHERE `entry`=32913;
+UPDATE `creature_template` SET `ScriptName`='boss_elder_stonebark' WHERE `entry`=32914;
+UPDATE `creature_template` SET `ScriptName`='npc_ancient_conservator' WHERE `entry`=33203;
+UPDATE `creature_template` SET `ScriptName`='npc_snaplasher' WHERE `entry`=32916;
+UPDATE `creature_template` SET `ScriptName`='npc_storm_lasher' WHERE `entry`=32919;
+UPDATE `creature_template` SET `ScriptName`='npc_ancient_water_spirit' WHERE `entry`=33202;
+UPDATE `creature_template` SET `ScriptName`='npc_detonating_lasher' WHERE `entry`=32918;
+UPDATE `creature_template` SET `ScriptName`='npc_sun_beam' WHERE `entry`=33170;
+UPDATE `creature_template` SET `ScriptName`='npc_nature_bomb' WHERE `entry`=34129;
+UPDATE `creature_template` SET `ScriptName`='npc_eonars_gift' WHERE `entry`=33228;
+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);
\ No newline at end of file
diff --git a/sql/updates/world/2011_05_21_01_world_spell_script_names.sql b/sql/updates/world/2011_05_21_01_world_spell_script_names.sql
new file mode 100644
index 00000000000..a10ad9fa53c
--- /dev/null
+++ b/sql/updates/world/2011_05_21_01_world_spell_script_names.sql
@@ -0,0 +1,6 @@
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (62519,65158,65160);
+INSERT INTO `spell_script_names`
+VALUES
+(62519, 'spell_freya_attuned_to_nature'),
+(65158, 'spell_freya_iron_roots'),
+(65160, 'spell_freya_iron_roots');
\ No newline at end of file