diff options
| -rw-r--r-- | sql/updates/5970_world_scripts.sql | 3 | ||||
| -rw-r--r-- | sql/updates/5971_world_scripts.sql | 3 | ||||
| -rw-r--r-- | sql/updates/5985_world_scripts.sql | 2 | ||||
| -rw-r--r-- | sql/updates/5990_world_scripts.sql | 2 | ||||
| -rw-r--r-- | sql/updates/5994_world_spells.sql | 3 | ||||
| -rw-r--r-- | sql/updates/5996_world_spells.sql | 3 | ||||
| -rw-r--r-- | sql/updates/5997_world_scripts.sql | 8 | ||||
| -rw-r--r-- | sql/updates/6008_world.sql | 11 |
8 files changed, 14 insertions, 21 deletions
diff --git a/sql/updates/5970_world_scripts.sql b/sql/updates/5970_world_scripts.sql index 04c2378278b..406ba84be0d 100644 --- a/sql/updates/5970_world_scripts.sql +++ b/sql/updates/5970_world_scripts.sql @@ -1,4 +1,3 @@ - UPDATE `creature_template` SET `ScriptName`='boss_amanitar' WHERE `entry`=30258; UPDATE `creature_template` SET `ScriptName`='mob_amanitar_mushrooms' WHERE `entry` IN (30435,30391); -UPDATE `creature_template` SET `ScriptName`='boss_hadronox' WHERE `entry`=28921; +UPDATE `creature_template` SET `ScriptName`='boss_hadronox' WHERE `entry`=28921;
\ No newline at end of file diff --git a/sql/updates/5971_world_scripts.sql b/sql/updates/5971_world_scripts.sql index 0a69409ae0c..a89b2ec37e7 100644 --- a/sql/updates/5971_world_scripts.sql +++ b/sql/updates/5971_world_scripts.sql @@ -1,2 +1 @@ - -UPDATE `creature_template` SET `ScriptName`='mob_nadox_eggs' WHERE `entry` IN (30172,30173); +UPDATE `creature_template` SET `ScriptName`='mob_nadox_eggs' WHERE `entry` IN (30172,30173);
\ No newline at end of file diff --git a/sql/updates/5985_world_scripts.sql b/sql/updates/5985_world_scripts.sql index 665187fd390..af45472758b 100644 --- a/sql/updates/5985_world_scripts.sql +++ b/sql/updates/5985_world_scripts.sql @@ -1,2 +1,2 @@ UPDATE `creature_template` SET `ScriptName`='mob_stalagg' WHERE `entry`=15929; -UPDATE `creature_template` SET `ScriptName`='mob_feugen' WHERE `entry`=15930; +UPDATE `creature_template` SET `ScriptName`='mob_feugen' WHERE `entry`=15930;
\ No newline at end of file diff --git a/sql/updates/5990_world_scripts.sql b/sql/updates/5990_world_scripts.sql index f19953090ed..e5d5b72b93e 100644 --- a/sql/updates/5990_world_scripts.sql +++ b/sql/updates/5990_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='boss_anub_arak' WHERE `entry`=29120; +UPDATE `creature_template` SET `ScriptName`='boss_anub_arak' WHERE `entry`=29120;
\ No newline at end of file diff --git a/sql/updates/5994_world_spells.sql b/sql/updates/5994_world_spells.sql index 306c0dd9ba9..80c7fad3720 100644 --- a/sql/updates/5994_world_spells.sql +++ b/sql/updates/5994_world_spells.sql @@ -1,5 +1,4 @@ - DELETE FROM `spell_bonus_data` WHERE `entry` IN (20187,54158); INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES (20187, 0, 0, 0, 0, 'Paladin - Judgement of Righteousness'), -(54158, 0, 0, 0, 0, 'Paladin - Judgement (Seal of Light, Seal of Wisdom, Seal of Justice)'); +(54158, 0, 0, 0, 0, 'Paladin - Judgement (Seal of Light, Seal of Wisdom, Seal of Justice)');
\ No newline at end of file diff --git a/sql/updates/5996_world_spells.sql b/sql/updates/5996_world_spells.sql index 2980451a2bb..5880c8035d3 100644 --- a/sql/updates/5996_world_spells.sql +++ b/sql/updates/5996_world_spells.sql @@ -1,4 +1,3 @@ - -- Fix spell_proc_event for spell Arcane Blast, remove on Arcane Barrage or Arcane Explosion DELETE FROM `spell_proc_event` WHERE `entry` = 36032; INSERT INTO `spell_proc_event` (entry, SchoolMask, SpellFamilyName, SpellFamilyMask0, SpellFamilyMask1, SpellFamilyMask2, procFlags, procEx, ppmRate, CustomChance, Cooldown) VALUES @@ -18,4 +17,4 @@ INSERT INTO `spell_linked_spell` (spell_trigger, spell_effect, type, comment) VA (-38699, -36032, 0, 'Arcane Missiles Rank 10'), (-38704, -36032, 0, 'Arcane Missiles Rank 11'), (-42843, -36032, 0, 'Arcane Missiles Rank 12'), -(-42846, -36032, 0, 'Arcane Missiles Rank 13'); +(-42846, -36032, 0, 'Arcane Missiles Rank 13');
\ No newline at end of file diff --git a/sql/updates/5997_world_scripts.sql b/sql/updates/5997_world_scripts.sql index 39078a5ba7a..7c30a6a22dc 100644 --- a/sql/updates/5997_world_scripts.sql +++ b/sql/updates/5997_world_scripts.sql @@ -1,5 +1,3 @@ - -UPDATE `creature_template` SET `ScriptName`='boss_jedoga_shadowseeker' WHERE `entry`='29310' LIMIT 1; -UPDATE `creature_template` SET `ScriptName`='mob_jedoga_initiand' WHERE `entry`='30114' LIMIT 1; -UPDATE `creature_template` SET `ScriptName`='npc_jedogas_aufseher_trigger' WHERE `entry`='30181' LIMIT 1; - +UPDATE `creature_template` SET `ScriptName`='boss_jedoga_shadowseeker' WHERE `entry`='29310'; +UPDATE `creature_template` SET `ScriptName`='mob_jedoga_initiand' WHERE `entry`='30114'; +UPDATE `creature_template` SET `ScriptName`='npc_jedogas_aufseher_trigger' WHERE `entry`='30181';
\ No newline at end of file diff --git a/sql/updates/6008_world.sql b/sql/updates/6008_world.sql index 77c04f4f81e..088821c056c 100644 --- a/sql/updates/6008_world.sql +++ b/sql/updates/6008_world.sql @@ -1,6 +1,5 @@ -UPDATE `creature_template` SET `modelid_A`='11686',`modelid_H`='11686' WHERE `entry`=23537; -UPDATE `creature_template` SET `modelid_A`='11686',`modelid_H`='11686' WHERE `entry`=23686; -UPDATE `creature_template` SET `modelid_A`='11686',`modelid_H`='11686' WHERE `entry`=23758; -UPDATE `creature_template` SET `modelid_A`='11686',`modelid_H`='11686' WHERE `entry`=24034; -UPDATE `creature_template` SET `modelid_A`='11686',`modelid_H`='11686' WHERE `entry`=23775; - +UPDATE `creature_template` SET `modelid1`='11686',`modelid3`='11686' WHERE `entry`=23537; +UPDATE `creature_template` SET `modelid1`='11686',`modelid3`='11686' WHERE `entry`=23686; +UPDATE `creature_template` SET `modelid1`='11686',`modelid3`='11686' WHERE `entry`=23758; +UPDATE `creature_template` SET `modelid1`='11686',`modelid3`='11686' WHERE `entry`=24034; +UPDATE `creature_template` SET `modelid1`='11686',`modelid3`='11686' WHERE `entry`=23775;
\ No newline at end of file |