From 11f6aa651884e5d024319fc4bb0ee38ddd4e4aac Mon Sep 17 00:00:00 2001 From: Killyana Date: Wed, 27 Mar 2019 16:46:21 +0100 Subject: DB/Quest: Valduran the Stormborn Remove the npc flag before the wp start, otherwise they will be restored at the end of the path --- sql/updates/world/3.3.5/2019_03_27_01_world.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/3.3.5/2019_03_27_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2019_03_27_01_world.sql b/sql/updates/world/3.3.5/2019_03_27_01_world.sql new file mode 100644 index 00000000000..39df25378e3 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_03_27_01_world.sql @@ -0,0 +1,9 @@ +-- +UPDATE `smart_scripts` SET `id`=30, `link`=2, `event_type`=54 WHERE `entryorguid` IN (29801) AND `source_type`=0 AND `action_type`=83; +UPDATE `smart_scripts` SET `id`=31, `link`=0, `event_type`=61 WHERE `entryorguid` IN (29801) AND `source_type`=0 AND `action_type`=53; +UPDATE `smart_scripts` SET `id`=1, `link`=2, `event_type`=54 WHERE `entryorguid` IN (29801) AND `source_type`=0 AND `action_type`=83; +UPDATE `smart_scripts` SET `id`=2, `link`=0, `event_type`=61 WHERE `entryorguid` IN (29801) AND `source_type`=0 AND `action_type`=53; +UPDATE `smart_scripts` SET `id`=30, `link`=1, `event_type`=54 WHERE `entryorguid` IN (30152) AND `source_type`=0 AND `action_type`=83; +UPDATE `smart_scripts` SET `id`=31, `link`=0, `event_type`=61 WHERE `entryorguid` IN (30152) AND `source_type`=0 AND `action_type`=53; +UPDATE `smart_scripts` SET `id`=0, `link`=1, `event_type`=54 WHERE `entryorguid` IN (30152) AND `source_type`=0 AND `action_type`=83; +UPDATE `smart_scripts` SET `id`=1, `link`=0, `event_type`=61 WHERE `entryorguid` IN (30152) AND `source_type`=0 AND `action_type`=53; -- cgit v1.2.3