aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2011-08-28 18:27:34 +0200
committerShauren <shauren.trinity@gmail.com>2011-08-28 18:27:34 +0200
commit8cf3e5536a22ee1ac6ab524ac678cb2c94a99565 (patch)
treefd6c63d5a03ce85814de5de0665fa55c67435689 /sql
parent8ca3912eeda9ff44c3e752f53571b250fdd5f8ed (diff)
Scripts/Icecrown Citadel: Fixed eating ooze ability
Closes #2707
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2011_08_28_00_world_instance_misc.sql16
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/2011_08_28_00_world_instance_misc.sql b/sql/updates/world/2011_08_28_00_world_instance_misc.sql
new file mode 100644
index 00000000000..751321d1187
--- /dev/null
+++ b/sql/updates/world/2011_08_28_00_world_instance_misc.sql
@@ -0,0 +1,16 @@
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (70346,72456,72868,72869);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(13,0,70346,0,18,1,37672,0,0, '', 'Slime Puddle - target Mutated Abomination'),
+(13,0,72456,0,18,1,38285,0,0, '', 'Slime Puddle - target Mutated Abomination'),
+(13,0,72868,0,18,1,37672,0,0, '', 'Slime Puddle - target Mutated Abomination'),
+(13,0,72869,0,18,1,38285,0,0, '', 'Slime Puddle - target Mutated Abomination');
+
+UPDATE `creature_template` SET `exp`=2,`spell1`=70360,`spell2`=70539 WHERE `entry`=37672;
+UPDATE `creature_template` SET `exp`=2,`spell1`=72527,`spell2`=72457 WHERE `entry`=38605;
+UPDATE `creature_template` SET `exp`=2,`spell1`=70360,`spell2`=72875 WHERE `entry`=38786;
+UPDATE `creature_template` SET `exp`=2,`spell1`=72527,`spell2`=72876 WHERE `entry`=38787;
+
+UPDATE `creature_template` SET `exp`=2,`spell1`=70360,`spell2`=70539 WHERE `entry`=38285;
+UPDATE `creature_template` SET `exp`=2,`spell1`=72527,`spell2`=72457 WHERE `entry`=38788;
+UPDATE `creature_template` SET `exp`=2,`spell1`=70360,`spell2`=72875 WHERE `entry`=38789;
+UPDATE `creature_template` SET `exp`=2,`spell1`=72527,`spell2`=72876 WHERE `entry`=38790;