From 3e1d8636a96ccd5ba1a7b7a5f8b4cffed22b9ea8 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Thu, 26 May 2016 04:50:52 +0200 Subject: DB/Quest: Thirst Unending By CrisPj, closes #17098 --- sql/updates/world/6.x/2016_05_26_04_world.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/6.x/2016_05_26_04_world.sql (limited to 'sql') diff --git a/sql/updates/world/6.x/2016_05_26_04_world.sql b/sql/updates/world/6.x/2016_05_26_04_world.sql new file mode 100644 index 00000000000..268b44c9616 --- /dev/null +++ b/sql/updates/world/6.x/2016_05_26_04_world.sql @@ -0,0 +1,13 @@ +-- Thirst Unending 6.x +-- Arcane Torrent Monk 129597 +-- Arcane Torrent Paladin 155145 +-- Arcane Torrent Warrior 69179 +-- Arcane Torrent Hunter 80483 + +SET @WYRM := 15274; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@WYRM AND `source_type`=0 and `id` in (4,5,6,7); +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@WYRM,0,4,0,8,0,100,1,69179,0,0,0,11,61314,0,0,0,0,0,7,0,0,0,0,0,0,0,"Mana Wyrm - On Spellhit 'Arcane Torrent' - Cast 'Quest Credit 8346' (No Repeat)"), +(@WYRM,0,5,0,8,0,100,1,80483,0,0,0,11,61314,0,0,0,0,0,7,0,0,0,0,0,0,0,"Mana Wyrm - On Spellhit 'Arcane Torrent' - Cast 'Quest Credit 8346' (No Repeat)"), +(@WYRM,0,6,0,8,0,100,1,129597,0,0,0,11,61314,0,0,0,0,0,7,0,0,0,0,0,0,0,"Mana Wyrm - On Spellhit 'Arcane Torrent' - Cast 'Quest Credit 8346' (No Repeat)"), +(@WYRM,0,7,0,8,0,100,1,155145,0,0,0,11,61314,0,0,0,0,0,7,0,0,0,0,0,0,0,"Mana Wyrm - On Spellhit 'Arcane Torrent' - Cast 'Quest Credit 8346' (No Repeat)"); -- cgit v1.2.3