From 8cf3e5536a22ee1ac6ab524ac678cb2c94a99565 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 28 Aug 2011 18:27:34 +0200 Subject: Scripts/Icecrown Citadel: Fixed eating ooze ability Closes #2707 --- sql/updates/world/2011_08_28_00_world_instance_misc.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 sql/updates/world/2011_08_28_00_world_instance_misc.sql (limited to 'sql') 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; -- cgit v1.2.3