From 292411e2151bed0289aa6fc86643a5d3896b08d8 Mon Sep 17 00:00:00 2001 From: Killyana Date: Tue, 2 Oct 2018 21:02:54 +0200 Subject: DB/Quest: Rescuing Evanor Reset the spell cast on quest_template_addon and remove it from the SAI Ref #22444 (cherry picked from commit 7694ff2ed3f8d86966555660f77141e59f311e2e) --- sql/updates/world/master/2021_11_11_23_world_2018_10_02_04_world.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/master/2021_11_11_23_world_2018_10_02_04_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2021_11_11_23_world_2018_10_02_04_world.sql b/sql/updates/world/master/2021_11_11_23_world_2018_10_02_04_world.sql new file mode 100644 index 00000000000..85c18fc1a26 --- /dev/null +++ b/sql/updates/world/master/2021_11_11_23_world_2018_10_02_04_world.sql @@ -0,0 +1,4 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid`=25356 AND `source_type`=0 AND `id`=0 AND `action_type`=85; +UPDATE `smart_scripts` SET `id`=0, `event_type`=19 WHERE `entryorguid`=25356 AND `source_type`=0 AND `id`=1 AND `action_type`=80; +UPDATE `quest_template_addon` SET `SourceSpellID`=45883 WHERE `ID`=11681; -- cgit v1.2.3