diff options
| author | Keader <keader.android@gmail.com> | 2016-11-26 02:31:17 +0100 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2018-02-11 16:20:32 +0100 |
| commit | 83d0ba4b8950d0b1e01bc8c7722d9d9290cf58b4 (patch) | |
| tree | 61aa466de7dcdeca85a5b264532e264624bd481f /sql | |
| parent | aab6416e64b0d99ddd9bdb9dfffb4f0ebca8b880 (diff) | |
Core/Scripts: Gurtogg Bloodboil Rewrite (#18279)
(cherry picked from commit eb41194dbb98558c50a71a39414e5b4091c158d7)
Rename 9999_25_44_50_world.sql to 2016_11_26_02_world.sql
(cherry picked from commit 8975fb73f09cc8559ee2451dec3744d15f8ad970)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2018_02_11_07_world_2016_11_26_02_world.sql | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/sql/updates/world/master/2018_02_11_07_world_2016_11_26_02_world.sql b/sql/updates/world/master/2018_02_11_07_world_2016_11_26_02_world.sql new file mode 100644 index 00000000000..b9cdadf6bf7 --- /dev/null +++ b/sql/updates/world/master/2018_02_11_07_world_2016_11_26_02_world.sql @@ -0,0 +1,23 @@ +-- Added aura Acidic Wound on Gurtogg Bloodboil +DELETE FROM `creature_addon` where `guid`=52761; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(52761, 0, 0, 0, 0, 0, 40484); + +-- SpellScripts +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gurtogg_bloodboil_insignificance'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(40618, 'spell_gurtogg_bloodboil_insignificance'); + +-- Added creature script in Fel Geyser creature +UPDATE `creature_template` SET `ScriptName`='npc_fel_geyser' WHERE `entry`=23254; + +-- Conditions for spell Taunt Gurtogg +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=40603; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13,3,40603,0,0,31,0,3,22948,0,0,0,0,'','Effect_0 and Effect_1 - Hits Gurtogg Bloodboil'); + +-- Fix Texts +UPDATE `creature_text` SET `text`='I hunger.',`BroadcastTextId`=21744 WHERE `entry`=22948 AND `groupid`=2 AND `id`=1; +DELETE FROM `creature_text` WHERE `entry`=22948 AND `groupid`IN(3,4); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES +(22948,3,0,'I\'ll rip the meat from your bones!',14,0,100,0,0,11438,21745,0,'bloodboil SAY_ENRAGE'); |