aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2016-06-26 00:27:19 +0200
committerjoschiwald <joschiwald.trinity@gmail.com>2017-02-04 17:58:01 +0100
commit5c3651379bd2236e266eb796b5cc5c449d899570 (patch)
tree44437c9f0421ff1cbcfa4ecfc34e6862fbadf288 /sql
parente336272ec29dc5a4cc271205e2238d4087150b9c (diff)
Scripts/Midsummer: Burning hot pole dance (#17445)
* Scripts/Midsummer: Burning hot pole dance By zwerg, closes #6876 (cherry picked from commit b0e5f6de47e85e1ca7cd3cc54dcf31fddac71a9f) Rename 2016_99_99_99_world_.sql to 2016_06_26_01_world_.sql (cherry picked from commit 184e64fa3318caa32cd7b283c79a77b4033d88ed) Rename 2016_06_26_01_world_.sql to 2016_06_26_01_world.sql (cherry picked from commit 4cc88b5f091ba7909bda2bb664b7904907b29197)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2017_02_04_05_world_2016_06_26_01_world.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_04_05_world_2016_06_26_01_world.sql b/sql/updates/world/master/2017_02_04_05_world_2016_06_26_01_world.sql
new file mode 100644
index 00000000000..b9ab8f12a54
--- /dev/null
+++ b/sql/updates/world/master/2017_02_04_05_world_2016_06_26_01_world.sql
@@ -0,0 +1,10 @@
+-- Link Dancer Check Aura and Visual to Ribbon Pole Channel
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (29531,45390);
+INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES
+(29531,45390,0, 'Ribbon Pole - Dancer Check Aura'),
+(45390,45406,2, 'Ribbon Pole - Periodic Visual');
+
+-- Spell Script
+DELETE FROM `spell_script_names` WHERE `spell_id`=45390;
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(45390, 'spell_gen_ribbon_pole_dancer_check');