diff options
| author | runningnak3d <none@none> | 2008-12-24 09:03:40 +0000 |
|---|---|---|
| committer | runningnak3d <none@none> | 2008-12-24 09:03:40 +0000 |
| commit | 12a52d2fbb3aef60f7eff73d1a10e0dbe9de5edf (patch) | |
| tree | ab2bd2ae17d100b6a8f92368750269f6c59db3b8 | |
| parent | 08fa019253895c97515a6324a19b9183d5a39ce5 (diff) | |
* fixed typo for Electrical Storm spell
* removed Wyvern Sting rank 5 and rank 6 from spell_linked_spell since they
* are not available till wotlk :P
* Ok, who was on crack?
--HG--
branch : trunk
| -rw-r--r-- | sql/updates/389_world.sql | 6 | ||||
| -rw-r--r-- | sql/updates/455_world.sql | 4 | ||||
| -rw-r--r-- | sql/updates/615_world.sql | 7 |
3 files changed, 13 insertions, 4 deletions
diff --git a/sql/updates/389_world.sql b/sql/updates/389_world.sql index bbe7fb6fcc6..89094143f64 100644 --- a/sql/updates/389_world.sql +++ b/sql/updates/389_world.sql @@ -3,5 +3,7 @@ INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `commen INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-24132, 24134, 0, 'Wyvern Sting'); INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-24133, 24135, 0, 'Wyvern Sting'); INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-27068, 27069, 0, 'Wyvern Sting'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-49011, 49009, 0, 'Wyvern Sting'); -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-49012, 49010, 0, 'Wyvern Sting'); +-- Rank 5 (not available till wotlk) +-- INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-49011, 49009, 0, 'Wyvern Sting'); +-- Rank 6 (not available till wotlk) +-- INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-49012, 49010, 0, 'Wyvern Sting'); diff --git a/sql/updates/455_world.sql b/sql/updates/455_world.sql index a40de1b77f3..a5a23c5f5d6 100644 --- a/sql/updates/455_world.sql +++ b/sql/updates/455_world.sql @@ -5,8 +5,8 @@ UPDATE `creature_template` SET spell1 = 43218, flags_extra = 128, ScriptName = ' -- Broggok Poison Cloud UPDATE `creature_template` SET spell1 = 30914, flags_extra = 128, ScriptName = '' WHERE entry = 17662; - -INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (43468, 44007, 1, 'Storm Eye Safe Zone'); +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (43468, 43648, 43658, 43658, 43658, 43658, 43658); +INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (43648, 44007, 1, 'Storm Eye Safe Zone'); INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (43658, 43653, 0, 'Electrical Arc Visual'); INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (43658, 43654, 0, 'Electrical Arc Visual'); INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (43658, 43655, 0, 'Electrical Arc Visual'); diff --git a/sql/updates/615_world.sql b/sql/updates/615_world.sql new file mode 100644 index 00000000000..28512e8511e --- /dev/null +++ b/sql/updates/615_world.sql @@ -0,0 +1,7 @@ +-- Wyvern Sting rank 5 and 6 not avail. till wotlk +DELETE FROM spell_linked_spell WHERE `spell_trigger` IN (-49011, -49012); + +-- typo +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (43468, 43648); +INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (43648, 44007, 1, 'Storm Eye Safe Zone'); + |