From 144cfbf5988d883da477975324c9ddb17610e6cc Mon Sep 17 00:00:00 2001 From: Killyana Date: Fri, 17 Mar 2017 09:40:17 +0100 Subject: DB/Quest: On Spirit's Wings Use the DBC spell to summon the npc --- sql/updates/world/3.3.5/2017_03_17_00_world_355.sql | 3 +++ sql/updates/world/3.3.5/2017_03_17_01_world.sql | 5 +++++ sql/updates/world/3.3.5/2017_03_17_02_world_355.sql | 3 --- 3 files changed, 8 insertions(+), 3 deletions(-) create mode 100644 sql/updates/world/3.3.5/2017_03_17_00_world_355.sql create mode 100644 sql/updates/world/3.3.5/2017_03_17_01_world.sql delete mode 100644 sql/updates/world/3.3.5/2017_03_17_02_world_355.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2017_03_17_00_world_355.sql b/sql/updates/world/3.3.5/2017_03_17_00_world_355.sql new file mode 100644 index 00000000000..ef79a2cb3f7 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_03_17_00_world_355.sql @@ -0,0 +1,3 @@ +-- +UPDATE `spell_dbc` SET `Effect2` = 28, `EffectMiscValueB2` = 64 WHERE `Id`IN (23201, 27939, 30774, 33614, 33616, 39074); +UPDATE `spell_dbc` SET `Effect3` = 28, `EffectMiscValueB3` = 64 WHERE `Id`IN (19224); diff --git a/sql/updates/world/3.3.5/2017_03_17_01_world.sql b/sql/updates/world/3.3.5/2017_03_17_01_world.sql new file mode 100644 index 00000000000..52e520c419f --- /dev/null +++ b/sql/updates/world/3.3.5/2017_03_17_01_world.sql @@ -0,0 +1,5 @@ +-- +DELETE FROM `spell_scripts` WHERE `id`=38173; +INSERT INTO `spell_scripts` (`id`, `effIndex`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES +(38173, 0, 0, 15, 39074, 1, 0, 0, 0, 0, 0); +UPDATE `smart_scripts` SET `action_type`=41, `action_param1`=0, `target_type`=1, `comment`='Spirit - action list - Despawn' WHERE `entryorguid`=2202300 AND `source_type`=9 AND `id`=2; diff --git a/sql/updates/world/3.3.5/2017_03_17_02_world_355.sql b/sql/updates/world/3.3.5/2017_03_17_02_world_355.sql deleted file mode 100644 index ef79a2cb3f7..00000000000 --- a/sql/updates/world/3.3.5/2017_03_17_02_world_355.sql +++ /dev/null @@ -1,3 +0,0 @@ --- -UPDATE `spell_dbc` SET `Effect2` = 28, `EffectMiscValueB2` = 64 WHERE `Id`IN (23201, 27939, 30774, 33614, 33616, 39074); -UPDATE `spell_dbc` SET `Effect3` = 28, `EffectMiscValueB3` = 64 WHERE `Id`IN (19224); -- cgit v1.2.3