aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2012-04-27 15:38:09 +0200
committerShauren <shauren.trinity@gmail.com>2012-04-27 15:38:09 +0200
commit51656d7e609a4a079e636c74e5f1cd34d9141742 (patch)
tree0e8c9ec26fc779faf013142b2b5c84fa21cc948a /sql
parent778afa11ac80837c877d043c6146e18c1aab89aa (diff)
Scripts/Icecrown Citadel: Fixed Scent of Blood on heroic mode of Deathbringer Saurfang encounter
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2012_04_27_00_world_instance_icc.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2012_04_27_00_world_instance_icc.sql b/sql/updates/world/2012_04_27_00_world_instance_icc.sql
new file mode 100644
index 00000000000..6738e4904ab
--- /dev/null
+++ b/sql/updates/world/2012_04_27_00_world_instance_icc.sql
@@ -0,0 +1,5 @@
+DELETE FROM `creature_text` WHERE `entry`=37813 AND `groupid`=14;
+INSERT INTO `creature_text` (`entry`,`groupid`,`text`,`type`,`comment`) VALUES (37813,14,'%s''s Blood Beasts gain the scent of blood!',41,'Deathbringer Saurfang - EMOTE_SCENT_OF_BLOOD');
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=72771;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`Comment`) VALUES
+(13,3,72771,31,3,38508,'Deathbringer Saurfang - Scent of Blood on Blood Beast');