diff options
| author | Keader <keader.android@gmail.com> | 2016-04-17 20:10:13 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-01-12 00:02:29 +0100 |
| commit | 7f2b5f3859ca65d0fe96485d13cfd47dc69e7355 (patch) | |
| tree | 42f2b056df363816105e0db314d015148dd88b45 /sql | |
| parent | fbb9fc02286fecc13a7a81c46a6d3da25b25a203 (diff) | |
Core/Scripts Improve Jormungars fight
(cherry picked from commit 0912df258d722f867c8ebe8fc77310f4fd1ce38c)
Rename spell_snakes_spray for spell_jormungars_snakes_spray and cleanup
(cherry picked from commit 2c9c8afc0f23dada7599ecede4bf3d598ab42006)
Fixing the issue
(cherry picked from commit 81083a8593b846e5a64f59771c4446f9f29c34c3)
Changing remove aura method
(cherry picked from commit b88d49be2498ce484124c1adc2bc1ab5ac2aa176)
changing creature_text (tk feedback)
(cherry picked from commit 9b444877dd8955ee0cfcf9bf56304220c4c276fb)
Override and tkrokli again :D
(cherry picked from commit 7205b4dd65bd569e4b254586f6802199de447194)
Fix SQL name
(cherry picked from commit cae19692ab2b627b292cdeed59069d5f6fa3be30)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2017_01_11_24_world_2016_06_02_00_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_01_11_24_world_2016_06_02_00_world.sql b/sql/updates/world/master/2017_01_11_24_world_2016_06_02_00_world.sql new file mode 100644 index 00000000000..c1167d60305 --- /dev/null +++ b/sql/updates/world/master/2017_01_11_24_world_2016_06_02_00_world.sql @@ -0,0 +1,11 @@ +DELETE FROM `spell_script_names` where `ScriptName` IN ('spell_jormungars_burning_spray','spell_jormungars_paralytic_spray','spell_jormungars_paralytic_toxin','spell_jormungars_paralysis'); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(66902,'spell_jormungars_burning_spray'), -- Burning Spray +(66901,'spell_jormungars_paralytic_spray'), -- Paralytic Spray +(66823,'spell_jormungars_paralytic_toxin'), -- Paralytic Toxin +(66830,'spell_jormungars_paralysis'); -- Paralysis + +-- Acidmaw missing text +DELETE FROM `creature_text` where entry = 35144 AND groupid = 1; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES +(35144,1,0,'You have been infected with a Paralytic Toxin!',42,0,100,0,0,0,36323,0,'Acidmaw - Special Attack'); |