diff options
| -rw-r--r-- | sql/base/world_database.sql | 6 | ||||
| -rw-r--r-- | sql/updates/2011_01_29_0_world_spell_linked_spell.sql | 9 |
2 files changed, 15 insertions, 0 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 04fc64555bc..9a5dee34ff1 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -18073,6 +18073,12 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment ( 66235, 66233, 0, 'Ardent Defender Visuals'), ( 58875, 58876, 1, 'Spirit Walk'), -- Quest +( 26286, 44430, 0, 'Small Red Rocket - questcredit'), +( 26292, 44430, 0, 'Small Green Rocket - questcredit'), +( 26291, 44430, 0, 'Small Blue Rocket - questcredit'), +( 26327, 44429, 0, 'Red Firework Cluster - questcredit'), +( 26325, 44429, 0, 'Green Firework Cluster - questcredit'), +( 26304, 44429, 0, 'Blue Firework Cluster - questcredit'), ( 40214, 40216, 2, 'Dragonmaw Illusion'), ( 40214, 42016, 2, 'Dragonmaw Illusion'), ( 66744, 66747, 0, 'Totem of the earthen ring'), diff --git a/sql/updates/2011_01_29_0_world_spell_linked_spell.sql b/sql/updates/2011_01_29_0_world_spell_linked_spell.sql new file mode 100644 index 00000000000..d3b08cee952 --- /dev/null +++ b/sql/updates/2011_01_29_0_world_spell_linked_spell.sql @@ -0,0 +1,9 @@ +-- Lunar Fireworks +DELETE FROM `spell_linked_spell` WHERE `spell_effect` IN (44430,44429); +INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES +(26286,44430,0,'Small Red Rocket - questcredit'), +(26292,44430,0,'Small Green Rocket - questcredit'), +(26291,44430,0,'Small Blue Rocket - questcredit'), +(26327,44429,0,'Red Firework Cluster - questcredit'), +(26325,44429,0,'Green Firework Cluster - questcredit'), +(26304,44429,0,'Blue Firework Cluster - questcredit'); |