aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--sql/updates/world/2015_05_01_04_world.sql200
1 files changed, 200 insertions, 0 deletions
diff --git a/sql/updates/world/2015_05_01_04_world.sql b/sql/updates/world/2015_05_01_04_world.sql
new file mode 100644
index 00000000000..a84fde8bb5c
--- /dev/null
+++ b/sql/updates/world/2015_05_01_04_world.sql
@@ -0,0 +1,200 @@
+DELETE FROM `spell_area` WHERE `spell` IN (40624, 40627, 40628);
+INSERT INTO `spell_area` (`spell`, `area`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES
+(40624,3767,0,2,1,0,0), -- Apexis Vibrations
+(40624,3768,0,2,1,0,0),
+(40624,3769,0,2,1,0,0),
+(40624,3770,0,2,1,0,0),
+(40624,3771,0,2,1,0,0),
+(40624,3772,0,2,1,0,0),
+(40624,3773,0,2,1,0,0),
+(40624,3774,0,2,1,0,0),
+(40624,3775,0,2,1,0,0),
+(40624,3776,0,2,1,0,0),
+(40624,3777,0,2,1,0,0),
+(40624,3778,0,2,1,0,0),
+(40624,3779,0,2,1,0,0),
+(40624,3780,0,2,1,0,0),
+(40624,3781,0,2,1,0,0),
+(40624,3782,0,2,1,0,0),
+(40624,3783,0,2,1,0,0),
+(40624,3784,0,2,1,0,0),
+(40624,3785,0,2,1,0,0),
+(40624,3786,0,2,1,0,0),
+(40624,3787,0,2,1,0,0),
+(40624,3824,0,2,1,0,0),
+(40624,3825,0,2,1,0,0),
+(40624,3826,0,2,1,0,0),
+(40624,3827,0,2,1,0,0),
+(40624,3828,0,2,1,0,0),
+(40624,3829,0,2,1,0,0),
+(40624,3830,0,2,1,0,0),
+(40624,3831,0,2,1,0,0),
+(40624,3832,0,2,1,0,0),
+(40624,3833,0,2,1,0,0),
+(40624,3834,0,2,1,0,0),
+(40624,3844,0,2,1,0,0),
+(40624,3855,0,2,1,0,0),
+(40624,3862,0,2,1,0,0),
+(40624,3863,0,2,1,0,0),
+(40624,3864,0,2,1,0,0),
+(40624,3865,0,2,1,0,0),
+(40624,3866,0,2,1,0,0),
+(40624,3867,0,2,1,0,0),
+(40624,3903,0,2,1,0,0),
+(40624,3904,0,2,1,0,0),
+(40624,3918,0,2,1,0,0),
+(40624,3919,0,2,1,0,0),
+(40624,3922,0,2,1,0,0),
+(40624,3924,0,2,1,0,0),
+(40624,3925,0,2,1,0,0),
+(40624,3931,0,2,1,0,0),
+(40624,3942,0,2,1,0,0),
+(40624,3951,0,2,1,0,0),
+(40624,3952,0,2,1,0,0),
+(40624,3953,0,2,1,0,0),
+(40624,3954,0,2,1,0,0),
+(40624,3960,0,2,1,0,0),
+(40624,3962,0,2,1,0,0),
+(40624,3963,0,2,1,0,0),
+(40624,3964,0,2,1,0,0),
+(40624,3969,0,2,1,0,0),
+(40624,3970,0,2,1,0,0),
+(40624,3971,0,2,1,0,0),
+(40624,3972,0,2,1,0,0),
+(40624,4008,0,2,1,0,0),
+(40627,3767,0,2,1,0,0), -- Apexis Emanations
+(40627,3768,0,2,1,0,0),
+(40627,3769,0,2,1,0,0),
+(40627,3770,0,2,1,0,0),
+(40627,3771,0,2,1,0,0),
+(40627,3772,0,2,1,0,0),
+(40627,3773,0,2,1,0,0),
+(40627,3774,0,2,1,0,0),
+(40627,3775,0,2,1,0,0),
+(40627,3776,0,2,1,0,0),
+(40627,3777,0,2,1,0,0),
+(40627,3778,0,2,1,0,0),
+(40627,3779,0,2,1,0,0),
+(40627,3780,0,2,1,0,0),
+(40627,3781,0,2,1,0,0),
+(40627,3782,0,2,1,0,0),
+(40627,3783,0,2,1,0,0),
+(40627,3784,0,2,1,0,0),
+(40627,3785,0,2,1,0,0),
+(40627,3786,0,2,1,0,0),
+(40627,3787,0,2,1,0,0),
+(40627,3824,0,2,1,0,0),
+(40627,3825,0,2,1,0,0),
+(40627,3826,0,2,1,0,0),
+(40627,3827,0,2,1,0,0),
+(40627,3828,0,2,1,0,0),
+(40627,3829,0,2,1,0,0),
+(40627,3830,0,2,1,0,0),
+(40627,3831,0,2,1,0,0),
+(40627,3832,0,2,1,0,0),
+(40627,3833,0,2,1,0,0),
+(40627,3834,0,2,1,0,0),
+(40627,3844,0,2,1,0,0),
+(40627,3855,0,2,1,0,0),
+(40627,3862,0,2,1,0,0),
+(40627,3863,0,2,1,0,0),
+(40627,3864,0,2,1,0,0),
+(40627,3865,0,2,1,0,0),
+(40627,3866,0,2,1,0,0),
+(40627,3867,0,2,1,0,0),
+(40627,3903,0,2,1,0,0),
+(40627,3904,0,2,1,0,0),
+(40627,3918,0,2,1,0,0),
+(40627,3919,0,2,1,0,0),
+(40627,3922,0,2,1,0,0),
+(40627,3924,0,2,1,0,0),
+(40627,3925,0,2,1,0,0),
+(40627,3931,0,2,1,0,0),
+(40627,3942,0,2,1,0,0),
+(40627,3951,0,2,1,0,0),
+(40627,3952,0,2,1,0,0),
+(40627,3953,0,2,1,0,0),
+(40627,3954,0,2,1,0,0),
+(40627,3960,0,2,1,0,0),
+(40627,3962,0,2,1,0,0),
+(40627,3963,0,2,1,0,0),
+(40627,3964,0,2,1,0,0),
+(40627,3969,0,2,1,0,0),
+(40627,3970,0,2,1,0,0),
+(40627,3971,0,2,1,0,0),
+(40627,3972,0,2,1,0,0),
+(40627,4008,0,2,1,0,0),
+(40628,3767,0,2,1,0,0), -- Apexis Enlightment
+(40628,3768,0,2,1,0,0),
+(40628,3769,0,2,1,0,0),
+(40628,3770,0,2,1,0,0),
+(40628,3771,0,2,1,0,0),
+(40628,3772,0,2,1,0,0),
+(40628,3773,0,2,1,0,0),
+(40628,3774,0,2,1,0,0),
+(40628,3775,0,2,1,0,0),
+(40628,3776,0,2,1,0,0),
+(40628,3777,0,2,1,0,0),
+(40628,3778,0,2,1,0,0),
+(40628,3779,0,2,1,0,0),
+(40628,3780,0,2,1,0,0),
+(40628,3781,0,2,1,0,0),
+(40628,3782,0,2,1,0,0),
+(40628,3783,0,2,1,0,0),
+(40628,3784,0,2,1,0,0),
+(40628,3785,0,2,1,0,0),
+(40628,3786,0,2,1,0,0),
+(40628,3787,0,2,1,0,0),
+(40628,3824,0,2,1,0,0),
+(40628,3825,0,2,1,0,0),
+(40628,3826,0,2,1,0,0),
+(40628,3827,0,2,1,0,0),
+(40628,3828,0,2,1,0,0),
+(40628,3829,0,2,1,0,0),
+(40628,3830,0,2,1,0,0),
+(40628,3831,0,2,1,0,0),
+(40628,3832,0,2,1,0,0),
+(40628,3833,0,2,1,0,0),
+(40628,3834,0,2,1,0,0),
+(40628,3844,0,2,1,0,0),
+(40628,3855,0,2,1,0,0),
+(40628,3862,0,2,1,0,0),
+(40628,3863,0,2,1,0,0),
+(40628,3864,0,2,1,0,0),
+(40628,3865,0,2,1,0,0),
+(40628,3866,0,2,1,0,0),
+(40628,3867,0,2,1,0,0),
+(40628,3903,0,2,1,0,0),
+(40628,3904,0,2,1,0,0),
+(40628,3918,0,2,1,0,0),
+(40628,3919,0,2,1,0,0),
+(40628,3922,0,2,1,0,0),
+(40628,3924,0,2,1,0,0),
+(40628,3925,0,2,1,0,0),
+(40628,3931,0,2,1,0,0),
+(40628,3942,0,2,1,0,0),
+(40628,3951,0,2,1,0,0),
+(40628,3952,0,2,1,0,0),
+(40628,3953,0,2,1,0,0),
+(40628,3954,0,2,1,0,0),
+(40628,3960,0,2,1,0,0),
+(40628,3962,0,2,1,0,0),
+(40628,3963,0,2,1,0,0),
+(40628,3964,0,2,1,0,0),
+(40628,3969,0,2,1,0,0),
+(40628,3970,0,2,1,0,0),
+(40628,3971,0,2,1,0,0),
+(40628,3972,0,2,1,0,0),
+(40628,4008,0,2,1,0,0);
+
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (-40623,-40625,-40626) AND `spell_effect` IN (-40624,-40627,-40628);
+INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES
+(-40623, -40624, 0, 'Remove Swiftness if Apexis Vibrations is removed'),
+(-40625, -40627, 0, 'Remove Swiftness if Apexis Emanations is removed'),
+(-40626, -40628, 0, 'Remove Swiftness if Apexis Enlightment is removed');
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry` IN (40624, 40627, 40628);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ScriptName`, `Comment`) VALUES
+(17,0,40624,0,0,1,0,40623, '', 'Swiftness - Only cast if Apexis Vibrations is active'),
+(17,0,40627,0,0,1,0,40625, '', 'Swiftness - Only cast if Apexis Emanations is active'),
+(17,0,40628,0,0,1,0,40626, '', 'Swiftness - Only cast if Apexis Enlightment is active');