Scripts/Icecrown Citadel: Added support for weekly quest "Deprogramming"

7 files changed, 46 insertions, 0 deletions

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 21f4032ecab..16cb1292292 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -18151,6 +18151,7 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment
 ( 67623,-67620, 1, 'Remove Paralytic Toxin when hit by Burning Bite'),
 (-66683, 68667, 0, 'Icehowl - Surge of Adrenaline'),
 (-67661, 68667, 0, 'Icehowl - Surge of Adrenaline'),
+( 65940, 65941, 0, 'Trial of the Crusader: Shattering Throw'),
 -- Forge of Souls
 (-68839, 68846, 0, 'Bronjahm: Corrupt Soul Summon'),
 -- Icecrown Citadel
diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql
index 70e87e635ce..2b5dce0e3de 100644
--- a/sql/scripts/world_scripts_full.sql
+++ b/sql/scripts/world_scripts_full.sql
@@ -843,6 +843,7 @@ UPDATE `creature_template` SET `ScriptName`='boss_lady_deathwhisper' WHERE `entr
 UPDATE `creature_template` SET `ScriptName`='npc_cult_fanatic' WHERE `entry` IN (37890,38009,38135);
 UPDATE `creature_template` SET `ScriptName`='npc_cult_adherent' WHERE `entry` IN(37949,38010,38136);
 UPDATE `creature_template` SET `ScriptName`='npc_vengeful_shade' WHERE `entry`=38222;
+UPDATE `creature_template` SET `ScriptName`='npc_darnavan' WHERE `entry` IN (38472,38485);
 UPDATE `creature_template` SET `ScriptName`='npc_rotting_frost_giant' WHERE `entry` IN (38490,38494);
 UPDATE `creature_template` SET `ScriptName`='boss_deathbringer_saurfang' WHERE `entry`=37813;
 UPDATE `creature_template` SET `ScriptName`='npc_high_overlord_saurfang_icc' WHERE `entry`=37187;
diff --git a/sql/updates/world/2011_02_18_0_world_creature.sql b/sql/updates/world/2011_02_18_0_world_creature.sql
new file mode 100644
index 00000000000..4f07781a267
--- /dev/null
+++ b/sql/updates/world/2011_02_18_0_world_creature.sql
@@ -0,0 +1,6 @@
+SET @GUID := 137743;
+DELETE FROM `creature` WHERE `id` IN (38471,38501,38551);
+INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES
+(@GUID+0,38471,631,15,1,0,0,-504.949,2184.24,62.3048,0.450047,86400,0,0,0,0,0,0,0,0,0),
+(@GUID+1,38501,631,15,1,0,0,4247.040,2753.25,348.996,0.227759,86400,0,0,0,0,0,0,0,0,0),
+(@GUID+2,38551,631,15,1,0,0,4466.260,2787.99,348.954,3.349720,86400,0,0,0,0,0,0,0,0,0);
diff --git a/sql/updates/world/2011_02_18_0_world_creature_text.sql b/sql/updates/world/2011_02_18_0_world_creature_text.sql
new file mode 100644
index 00000000000..39d46f15fef
--- /dev/null
+++ b/sql/updates/world/2011_02_18_0_world_creature_text.sql
@@ -0,0 +1,6 @@
+DELETE FROM `creature_text` WHERE `entry` IN (38472,38485);
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(38472,0,0, 'Die, intruders! None shall interfere with the Cult''s plans!',1,0,0,0,0,0, 'Darnavan - SAY_DARNAVAN_AGGRO'),
+(38472,1,0, 'Wh- where am I...? What a nightmare I have had... But this is no time to reflect, I have much information to report!',0,0,0,0,0,0, 'Darnavan - SAY_DARNAVAN_RESCUED'),
+(38485,0,0, 'Die, intruders! None shall interfere with the Cult''s plans!',1,0,0,0,0,0, 'Darnavan - SAY_DARNAVAN_AGGRO'),
+(38485,1,0, 'Wh- where am I...? What a nightmare I have had... But this is no time to reflect, I have much information to report!',0,0,0,0,0,0, 'Darnavan - SAY_DARNAVAN_RESCUED');
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
new file mode 100644
index 00000000000..0ea5d42026e
--- /dev/null
+++ b/sql/updates/world/2011_02_18_0_world_pool_quest.sql
@@ -0,0 +1,28 @@
+-- ICC Quest pools (also deletes old pool data)
+SET @pool := 5662;
+DELETE FROM `pool_quest` WHERE `pool_entry` BETWEEN @pool+18 AND @pool+22;
+INSERT INTO `pool_quest` (`entry`,`pool_entry`,`description`) VALUES
+(24874,@pool+17, 'Blood Quickening (10)'),
+(24869,@pool+17, 'Deprogramming (10)'),
+(24873,@pool+17, 'Residue Rendezvous (10)'),
+(24872,@pool+17, 'Respite for a Tormented Soul (10)'),
+(24870,@pool+19, 'Securing the Ramparts HORDE (10)'),
+(24871,@pool+19, 'Securing the Ramparts ALLY (10)'),
+(24879,@pool+18, 'Blood Quickening (25)'),
+(24875,@pool+18, 'Deprogramming (25)'),
+(24878,@pool+18, 'Residue Rendezvous (25)'),
+(24880,@pool+18, 'Respite for a Tormented Soul (25)'),
+(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;
+INSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES
+(@pool+17,1, 'ICC weeklies (10)'),
+(@pool+18,1, 'ICC weeklies (25)'),
+(@pool+19,2, 'Securing the Ramparts (10)'),
+(@pool+20,2, 'Securing the Ramparts (25)');
+
+DELETE FROM `pool_pool` WHERE `mother_pool` IN (@pool+17,@pool+18);
+INSERT INTO `pool_pool` (`pool_id`,`mother_pool`,`chance`,`description`) VALUES
+(@pool+19,@pool+17,0, 'Securing the Ramparts (10)'),
+(@pool+20,@pool+18,0, 'Securing the Ramparts (25)');
diff --git a/sql/updates/world/2011_02_18_0_world_scriptname.sql b/sql/updates/world/2011_02_18_0_world_scriptname.sql
new file mode 100644
index 00000000000..3588fe7ae3b
--- /dev/null
+++ b/sql/updates/world/2011_02_18_0_world_scriptname.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `ScriptName`='npc_darnavan' WHERE `entry` IN (38472,38485);
diff --git a/sql/updates/world/2011_02_18_0_world_spell_linked_spell.sql b/sql/updates/world/2011_02_18_0_world_spell_linked_spell.sql
new file mode 100644
index 00000000000..66ceb1b593c
--- /dev/null
+++ b/sql/updates/world/2011_02_18_0_world_spell_linked_spell.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=65940;
+INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES
+(65940,65941,0, 'Trial of the Crusader: Shattering Throw');