aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authortreeston <treeston.mmoc@gmail.com>2016-01-19 21:39:23 +0100
committerShauren <shauren.trinity@gmail.com>2016-04-10 14:32:51 +0200
commitc344feed96260b912929332e3799123617499ff9 (patch)
treef3cc4befad580dc200752508d50a9add4fd52e72 /sql
parent500d5db81e39e968f1e6b56cf29d3ee78bc24f5e (diff)
Merge branch '3.3.5-horsemen' into 3.3.5-base (PR #16194)
(cherry picked from commit e8a79737a530fe9b605fa6d62a84c1531d56965b)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2016_04_10_09_world_2016_01_19_07_world.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/2016_04_10_09_world_2016_01_19_07_world.sql b/sql/updates/world/2016_04_10_09_world_2016_01_19_07_world.sql
new file mode 100644
index 00000000000..3cb7abc618e
--- /dev/null
+++ b/sql/updates/world/2016_04_10_09_world_2016_01_19_07_world.sql
@@ -0,0 +1,13 @@
+-- four horsemen rewrite
+UPDATE `creature_template` SET `ScriptName`='boss_four_horsemen_baron' WHERE `entry`=30549;
+UPDATE `creature_template` SET `ScriptName`='boss_four_horsemen_thane' WHERE `entry`=16064;
+UPDATE `creature_template` SET `ScriptName`='boss_four_horsemen_lady' WHERE `entry`=16065;
+UPDATE `creature_template` SET `ScriptName`='boss_four_horsemen_sir' WHERE `entry`=16063;
+
+-- add ragecast texts
+DELETE FROM `creature_text` WHERE `entry` IN (16064,16065,16063,30549) AND `groupid`=7;
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`probability`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
+(16063,7,0,"%s casts Condemnation on everyone!",41,100,33088,3,"zeliek EMOTE_RAGECAST"),
+(16065,7,0,"%s casts Unyielding Pain on everyone!",41,100,33087,3,"blaumeux EMOTE_RAGECAST");
+-- slay text probability to DB
+UPDATE `creature_text` SET `probability`=30 WHERE `entry` IN (16064,16065,16063,30549) AND `groupid`=3;