diff options
| author | offl <11556157+offl@users.noreply.github.com> | 2020-07-31 22:47:38 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-07-31 22:47:38 +0300 |
| commit | 7762a53b43a0c35f305c1e14a854936e0464cf5d (patch) | |
| tree | 9b0385878eef98aca12f878c5a3211786268e9b6 | |
| parent | 7786c51d0eef8003ed196bba43175e1a1778ea9a (diff) | |
DB/SAI: Use serverside spells to activate taxi in some scripts
Closes #24986
| -rw-r--r-- | sql/updates/world/3.3.5/2020_07_31_03_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_07_31_03_world.sql b/sql/updates/world/3.3.5/2020_07_31_03_world.sql new file mode 100644 index 00000000000..3586eadbcdb --- /dev/null +++ b/sql/updates/world/3.3.5/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; |