diff options
| author | Wyreth <Wyreth@users.noreply.github.com> | 2017-10-24 19:01:37 +0200 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2021-01-13 22:04:52 +0100 |
| commit | c33cd9771e23bf75c18f397aee80e14aa7a3d681 (patch) | |
| tree | a1f67c180256a3a66ebefc7ea226fa25a2cbbd73 | |
| parent | 1c64a7fbf4c45d01e3bdf33f2664c214aeb24293 (diff) | |
DB/SAI: Outro event for the quest Avast Ye, Admiral!
Closes #20708
(cherry picked from commit 7e1b5a842d56c6811f927f1d6cb42b8b28af76d7)
| -rw-r--r-- | sql/updates/world/master/2021_01_09_14_world_2017_10_24_02_world.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_01_09_14_world_2017_10_24_02_world.sql b/sql/updates/world/master/2021_01_09_14_world_2017_10_24_02_world.sql new file mode 100644 index 00000000000..8c2cc6bb692 --- /dev/null +++ b/sql/updates/world/master/2021_01_09_14_world_2017_10_24_02_world.sql @@ -0,0 +1,14 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid`=2546 AND `source_type`=0 AND `id`=1; +DELETE FROM `smart_scripts` WHERE `entryorguid`=254600 AND `source_type`=9; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(2546, 0, 1, 0, 20, 0, 100, 0, 4621, 0, 0, 0, 80, 254600, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fleet Master Firallon - On Quest 'Avast Ye, Admiral!' Rewarded - Run Script"), +(254600, 9, 0, 0, 0, 0, 100, 0, 400, 400, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Fleet Master Firallon - On Script - Say Line 0"), +(254600, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Fleet Master Firallon - On Script - Say Line 1"), +(254600, 9, 2, 0, 0, 0, 100, 0, 1500, 1500, 0, 0, 1, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Fleet Master Firallon - On Script - Say Line 1"), +(254600, 9, 3, 0, 0, 0, 100, 0, 1500, 1500, 0, 0, 1, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Fleet Master Firallon - On Script - Say Line 1"); + +DELETE FROM `creature_text` WHERE `CreatureID`=2546; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(2546, 0, 0, "Three cheers for $n -- Admiral o' the Bloodsail Bucaneer Navy!", 14, 0, 100, 0, 0, 0, 5522, 0, "Fleet Master Firallon"), +(2546, 1, 0, "Hip hip... arrrrr...", 14, 0, 100, 0, 0, 0, 5523, 0, "Fleet Master Firallon"); |