From ffd899be626c2f3e1476bc69199033c99b97328e Mon Sep 17 00:00:00 2001 From: offl <11556157+offl@users.noreply.github.com> Date: Fri, 31 Jul 2020 22:47:38 +0300 Subject: DB/SAI: Use serverside spells to activate taxi in some scripts Closes #24986 (cherry picked from commit 7762a53b43a0c35f305c1e14a854936e0464cf5d) --- .../world/master/2022_01_24_02_world_2020_07_31_03_world.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/master/2022_01_24_02_world_2020_07_31_03_world.sql diff --git a/sql/updates/world/master/2022_01_24_02_world_2020_07_31_03_world.sql b/sql/updates/world/master/2022_01_24_02_world_2020_07_31_03_world.sql new file mode 100644 index 00000000000..3586eadbcdb --- /dev/null +++ b/sql/updates/world/master/2022_01_24_02_world_2020_07_31_03_world.sql @@ -0,0 +1,9 @@ +-- +UPDATE `smart_scripts` SET `event_flags` = 0, `action_type` = 11, `action_param1` = 32892, `comment` = "Brazen - On Gossip Option 0 Selected - Cast 'Brazen Taxi'" WHERE `entryorguid` = 18725 AND `source_type` = 0 AND `id` = 0; +UPDATE `smart_scripts` SET `event_flags` = 0, `action_type` = 85, `action_param1` = 38970, `comment` = "Karynaku - On Quest 'Ally of the Netherwing' Taken - Invoker Cast 'Karynaku's Flight Home'" WHERE `entryorguid` = 22112 AND `source_type` = 0 AND `id` = 1; +UPDATE `smart_scripts` SET `event_flags` = 0, `action_type` = 11, `action_param1` = 29931, `comment` = "William Kielar - On Gossip Option 0 Selected - Cast 'Flight Path'" WHERE `entryorguid` = 17209 AND `source_type` = 0 AND `id` = 0; +UPDATE `smart_scripts` SET `event_flags` = 0, `action_type` = 11, `action_param1` = 29934, `comment` = "William Kielar - On Gossip Option 1 Selected - Cast 'Flight Path'" WHERE `entryorguid` = 17209 AND `source_type` = 0 AND `id` = 1; +UPDATE `smart_scripts` SET `event_flags` = 0, `action_type` = 11, `action_param1` = 29994, `comment` = "William Kielar - On Gossip Option 2 Selected - Cast 'Flight Path'" WHERE `entryorguid` = 17209 AND `source_type` = 0 AND `id` = 2; +-- Was 627. There's no spell with 627 and 627 is bugged and completely +-- different from the one that is used in retail. Probably test version +UPDATE `smart_scripts` SET `event_flags` = 0, `action_type` = 11, `action_param1` = 35731, `comment` = "Protectorate Nether Drake - On Gossip Option 0 Selected - Cast 'Protectorate Drake'" WHERE `entryorguid` = 20903 AND `source_type` = 0 AND `id` = 0; -- cgit v1.2.3