diff options
author | Shauren <shauren.trinity@gmail.com> | 2011-02-26 14:09:32 +0100 |
---|---|---|
committer | Shauren <shauren.trinity@gmail.com> | 2011-02-26 14:09:32 +0100 |
commit | 8497fb27e9ff104e99818fbe2c85eccf25e7931d (patch) | |
tree | c69b02947c43c5faedf9de1c219f7334688ff55e | |
parent | cbbfc21934cddcb9ce890e8b1f98feb89b2d0bc1 (diff) |
DB/Spells: Added flower summoning visual of Lifeblood
-rw-r--r-- | sql/base/world_database.sql | 7 | ||||
-rw-r--r-- | sql/updates/world/2011_02_26_4_world_spell_linked_spell.sql | 8 |
2 files changed, 15 insertions, 0 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 3e3098e8f42..58e9459c54c 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -18065,6 +18065,13 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment ( 20066,-61840, 0, 'Repentance'), ( 66235, 66233, 0, 'Ardent Defender Visuals'), ( 58875, 58876, 1, 'Spirit Walk'), +-- Misc +( 55428, 55475, 0, 'Lifeblood (Rank 1)'), +( 55480, 55475, 0, 'Lifeblood (Rank 2)'), +( 55500, 55475, 0, 'Lifeblood (Rank 3)'), +( 55501, 55475, 0, 'Lifeblood (Rank 4)'), +( 55502, 55475, 0, 'Lifeblood (Rank 5)'), +( 55503, 55475, 0, 'Lifeblood (Rank 6)'), -- Quest ( 26286, 44430, 0, 'Small Red Rocket - questcredit'), ( 26292, 44430, 0, 'Small Green Rocket - questcredit'), diff --git a/sql/updates/world/2011_02_26_4_world_spell_linked_spell.sql b/sql/updates/world/2011_02_26_4_world_spell_linked_spell.sql new file mode 100644 index 00000000000..fe15af01a64 --- /dev/null +++ b/sql/updates/world/2011_02_26_4_world_spell_linked_spell.sql @@ -0,0 +1,8 @@ +DELETE FROM `spell_linked_spell` WHERE `spell_effect`=55475; +INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES +(55428,55475,0, 'Lifeblood (Rank 1)'), +(55480,55475,0, 'Lifeblood (Rank 2)'), +(55500,55475,0, 'Lifeblood (Rank 3)'), +(55501,55475,0, 'Lifeblood (Rank 4)'), +(55502,55475,0, 'Lifeblood (Rank 5)'), +(55503,55475,0, 'Lifeblood (Rank 6)'); |