Scripts/Icecrown Citadel: Added support for weekly quest Residue Rendezvous

6 files changed, 50 insertions, 2 deletions

diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql
index 2b5dce0e3de..606688c44de 100644
--- a/sql/scripts/world_scripts_full.sql
+++ b/sql/scripts/world_scripts_full.sql
@@ -850,6 +850,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_high_overlord_saurfang_icc' WHE
 UPDATE `creature_template` SET `ScriptName`='npc_muradin_bronzebeard_icc' WHERE `entry`=37200;
 UPDATE `creature_template` SET `ScriptName`='npc_saurfang_event' WHERE `entry` IN (37920,37830);
 UPDATE `creature_template` SET `ScriptName`='npc_frost_freeze_trap' WHERE `entry`=37744;
+UPDATE `creature_template` SET `ScriptName`='npc_alchemist_adrianna' WHERE `entry`=38501;
 UPDATE `creature_template` SET `ScriptName`='boss_festergut' WHERE `entry`=36626;
 UPDATE `creature_template` SET `ScriptName`='npc_stinky_icc' WHERE `entry`=37025;
 UPDATE `creature_template` SET `ScriptName`='boss_rotface' WHERE `entry`=36627;
@@ -1915,6 +1916,8 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 ( 72444, 'spell_deathbringer_mark_of_the_fallen_champion'),
 ( 72445, 'spell_deathbringer_mark_of_the_fallen_champion'),
 ( 72446, 'spell_deathbringer_mark_of_the_fallen_champion'),
+( 72155, 'spell_icc_harvest_blight_specimen'),
+( 72162, 'spell_icc_harvest_blight_specimen'),
 ( 71123, 'spell_stinky_precious_decimate'),
 ( 73032, 'spell_festergut_pungent_blight'),
 ( 73031, 'spell_festergut_pungent_blight'),
@@ -1928,6 +1931,18 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 ( 71222, 'spell_festergut_blighted_spores'),
 ( 73033, 'spell_festergut_blighted_spores'),
 ( 73034, 'spell_festergut_blighted_spores'),
+( 69159, 'spell_festergut_gaseous_blight'),
+( 70135, 'spell_festergut_gaseous_blight'),
+( 70136, 'spell_festergut_gaseous_blight'),
+( 70137, 'spell_festergut_gaseous_blight'),
+( 69161, 'spell_festergut_gaseous_blight'),
+( 70138, 'spell_festergut_gaseous_blight'),
+( 70139, 'spell_festergut_gaseous_blight'),
+( 70140, 'spell_festergut_gaseous_blight'),
+( 69163, 'spell_festergut_gaseous_blight'),
+( 70468, 'spell_festergut_gaseous_blight'),
+( 70469, 'spell_festergut_gaseous_blight'),
+( 70470, 'spell_festergut_gaseous_blight'),
 ( 69782, 'spell_rotface_ooze_flood'),
 ( 69796, 'spell_rotface_ooze_flood'),
 ( 69798, 'spell_rotface_ooze_flood'),
@@ -1938,6 +1953,10 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 ( 69839, 'spell_rotface_unstable_ooze_explosion_init'),
 ( 69832, 'spell_rotface_unstable_ooze_explosion'),
 ( 71441, 'spell_rotface_unstable_ooze_explosion_suicide'),
+( 69507, 'spell_rotface_slime_spray'),
+( 71213, 'spell_rotface_slime_spray'),
+( 73189, 'spell_rotface_slime_spray'),
+( 73190, 'spell_rotface_slime_spray'),
 ( 70701, 'spell_putricide_expunged_gas'),
 ( 70343, 'spell_putricide_slime_puddle'),
 ( 70351, 'spell_putricide_unstable_experiment'),
diff --git a/sql/updates/world/2011_02_18_0_world_pool_quest.sql b/sql/updates/world/2011_02_18_0_world_pool_quest.sql
index 0ea5d42026e..6c386e8b77b 100644
--- a/sql/updates/world/2011_02_18_0_world_pool_quest.sql
+++ b/sql/updates/world/2011_02_18_0_world_pool_quest.sql
@@ -1,6 +1,6 @@
 -- ICC Quest pools (also deletes old pool data)
 SET @pool := 5662;
-DELETE FROM `pool_quest` WHERE `pool_entry` BETWEEN @pool+18 AND @pool+22;
+DELETE FROM `pool_quest` WHERE `pool_entry` BETWEEN @pool+17 AND @pool+22;
 INSERT INTO `pool_quest` (`entry`,`pool_entry`,`description`) VALUES
 (24874,@pool+17, 'Blood Quickening (10)'),
 (24869,@pool+17, 'Deprogramming (10)'),
@@ -15,7 +15,7 @@ INSERT INTO `pool_quest` (`entry`,`pool_entry`,`description`) VALUES
 (24876,@pool+20, 'Securing the Ramparts ALLY (25)'),
 (24877,@pool+20, 'Securing the Ramparts HORDE (25)');
 
-DELETE FROM `pool_template` WHERE `entry` BETWEEN @pool+18 AND @pool+22;
+DELETE FROM `pool_template` WHERE `entry` BETWEEN @pool+17 AND @pool+22;
 INSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES
 (@pool+17,1, 'ICC weeklies (10)'),
 (@pool+18,1, 'ICC weeklies (25)'),
diff --git a/sql/updates/world/2011_02_19_0_world_conditions.sql b/sql/updates/world/2011_02_19_0_world_conditions.sql
new file mode 100644
index 00000000000..23ca7bb5766
--- /dev/null
+++ b/sql/updates/world/2011_02_19_0_world_conditions.sql
@@ -0,0 +1,4 @@
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (72155,72162);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(13,0,72155,0,18,1,0,0,0, '', 'Harvest Blight Specimen - player target'),
+(13,0,72162,0,18,1,0,0,0, '', 'Harvest Blight Specimen - player target');
diff --git a/sql/updates/world/2011_02_19_0_world_creature_template.sql b/sql/updates/world/2011_02_19_0_world_creature_template.sql
new file mode 100644
index 00000000000..edfa570115a
--- /dev/null
+++ b/sql/updates/world/2011_02_19_0_world_creature_template.sql
@@ -0,0 +1,2 @@
+UPDATE `creature_template` SET `difficulty_entry_1`=38717 WHERE `entry`=38501;
+UPDATE `creature_template` SET `minlevel`=80,`maxlevel`=80,`exp`=2,`unit_class`=1,`faction_A`=2070,`faction_H`=2070,`npcflag`=2,`dynamicflags`=8,`unit_flags`=33280,`unit_class`=8 WHERE `entry`=38717; -- Alchemist Adrianna (1)
diff --git a/sql/updates/world/2011_02_19_0_world_scriptname.sql b/sql/updates/world/2011_02_19_0_world_scriptname.sql
new file mode 100644
index 00000000000..4901cb763ae
--- /dev/null
+++ b/sql/updates/world/2011_02_19_0_world_scriptname.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `ScriptName`='npc_alchemist_adrianna' WHERE `entry`=38501;
diff --git a/sql/updates/world/2011_02_19_0_world_spell_script_names.sql b/sql/updates/world/2011_02_19_0_world_spell_script_names.sql
new file mode 100644
index 00000000000..709344ae76d
--- /dev/null
+++ b/sql/updates/world/2011_02_19_0_world_spell_script_names.sql
@@ -0,0 +1,22 @@
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_icc_harvest_blight_specimen';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_festergut_gaseous_blight';
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_rotface_slime_spray';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(72155,'spell_icc_harvest_blight_specimen'),
+(72162,'spell_icc_harvest_blight_specimen'),
+(69159,'spell_festergut_gaseous_blight'),
+(70135,'spell_festergut_gaseous_blight'),
+(70136,'spell_festergut_gaseous_blight'),
+(70137,'spell_festergut_gaseous_blight'),
+(69161,'spell_festergut_gaseous_blight'),
+(70138,'spell_festergut_gaseous_blight'),
+(70139,'spell_festergut_gaseous_blight'),
+(70140,'spell_festergut_gaseous_blight'),
+(69163,'spell_festergut_gaseous_blight'),
+(70468,'spell_festergut_gaseous_blight'),
+(70469,'spell_festergut_gaseous_blight'),
+(70470,'spell_festergut_gaseous_blight'),
+(69507,'spell_rotface_slime_spray'),
+(71213,'spell_rotface_slime_spray'),
+(73189,'spell_rotface_slime_spray'),
+(73190,'spell_rotface_slime_spray');