From ff5d3cc2c30cac500921939e9c3da13a0e2671d0 Mon Sep 17 00:00:00 2001 From: Rothend Date: Fri, 3 Jul 2020 23:31:07 +0200 Subject: DB/Quest: script end event for quest Countdown to Doom Closes #24866 --- sql/updates/world/3.3.5/2020_07_01_08_world.sql | 84 ------------------------- sql/updates/world/3.3.5/2020_07_03_00_world.sql | 84 +++++++++++++++++++++++++ sql/updates/world/3.3.5/2020_07_03_01_world.sql | 25 ++++++++ 3 files changed, 109 insertions(+), 84 deletions(-) delete mode 100644 sql/updates/world/3.3.5/2020_07_01_08_world.sql create mode 100644 sql/updates/world/3.3.5/2020_07_03_00_world.sql create mode 100644 sql/updates/world/3.3.5/2020_07_03_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2020_07_01_08_world.sql b/sql/updates/world/3.3.5/2020_07_01_08_world.sql deleted file mode 100644 index 53dd79ba69d..00000000000 --- a/sql/updates/world/3.3.5/2020_07_01_08_world.sql +++ /dev/null @@ -1,84 +0,0 @@ -UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=23038; -UPDATE `creature` SET `orientation`=0.049211 WHERE `id`=23038; - -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (23038, 23042) AND `source_type`=0; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2303800, 2304200, 2304201, 2304202, 2304203) 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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES -(23042, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Spawn - Set Event Phase 1"), -(23042, 0, 1, 0, 19, 1, 100, 0, 11004, 0, 0, 0, 0, 80, 2304200, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Quest 'World of Shadows' Taken - Run Script (Event Phase 1)"), -(23042, 0, 2, 0, 20, 1, 100, 0, 11004, 0, 0, 0, 0, 80, 2304201, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Quest 'World of Shadows' Rewarded - Run Script (Event Phase 1)"), -(23042, 0, 3, 4, 38, 0, 100, 0, 1, 1, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Data 1 1 Set - Say Line 1"), -(23042, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 53, 1, 2304200, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Data 1 1 Set - Start WP"), -(23042, 0, 5, 0, 40, 0, 100, 0, 1, 2304200, 0, 0, 0, 80, 2304202, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On WP 1 Reached - Run Script"), -(23042, 0, 6, 0, 40, 0, 100, 0, 1, 2304201, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 4.555310, "Severin - On WP 1 Reached - Reset Orientation"), -(23042, 0, 7, 0, 38, 0, 100, 0, 2, 2, 0, 0, 0, 80, 2304203, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Data 2 2 Set - Run Script"), - -(23038, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Spawn - Set Event Phase 1"), -(23038, 0, 1, 2, 38, 0, 100, 0, 1, 1, 0, 0, 0, 91, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Data 1 1 Set - Remove StandState Sit"), -(23038, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Data 1 1 Set - Set StandState Kneel"), -(23038, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Data 1 1 Set - Say Line 1"), -(23038, 0, 4, 5, 38, 0, 100, 0, 2, 2, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 5.794490, "Sky Commander Adaris - On Data 2 2 Set - Set Orientation"), -(23038, 0, 5, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Data 2 2 Set - Say Line 2"), -(23038, 0, 6, 7, 38, 0, 100, 0, 3, 3, 0, 0, 0, 40, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Data 3 3 Set - Unsheathe Melee Weapon"), -(23038, 0, 7, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 53, 1, 2303800, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Data 3 3 Set - Start WP"), -(23038, 0, 8, 0, 40, 0, 100, 0, 1, 2303800, 0, 0, 0, 80, 2303800, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On WP 1 Reached - Run Script"), -(23038, 0, 9, 10, 40, 0, 100, 0, 1, 2303801, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0.049211, "Sky Commander Adaris - On WP 1 Reached - Reset Orientation"), -(23038, 0, 10, 11, 61, 0, 100, 0, 0, 0, 0, 0, 0, 40, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On WP 1 Reached - Sheathe Melee Weapon"), -(23038, 0, 11, 12, 61, 0, 100, 0, 0, 0, 0, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On WP 1 Reached - Set StandState Kneel"), -(23038, 0, 12, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 45, 2, 2, 0, 0, 0, 0, 19, 23042, 10, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On WP 1 Reached - Set Data 2 2 (Severin)"), - -(2303800, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 23042, 50, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Script - Set Data 1 1 (Severin)"), -(2303800, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 5.168708, "Sky Commander Adaris - On Script - Set Orientation"), -(2303800, 9, 2, 0, 0, 0, 100, 0, 400, 400, 0, 0, 0, 5, 54, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Script - Play Emote ONESHOT_ATTACK1H"), -(2303800, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 12, 23207, 3, 18000, 0, 0, 0, 8, 0, 0, 0, 0, -3399.783447, 3614.886719, 276.369293, 2.089945, "Sky Commander Adaris - On Script - Summon Creature 'Skettis Assassin'"), -(2303800, 9, 4, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 6.268262, "Sky Commander Adaris - On Script - Set Orientation"), -(2303800, 9, 5, 0, 0, 0, 100, 0, 400, 400, 0, 0, 0, 5, 54, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Script - Play Emote ONESHOT_ATTACK1H"), -(2303800, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 12, 23207, 3, 18000, 0, 0, 0, 8, 0, 0, 0, 0, -3397.512207, 3617.134766, 276.865234, 3.028496, "Sky Commander Adaris - On Script - Summon Creature 'Skettis Assassin'"), -(2303800, 9, 7, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Script - Say Line 3"), -(2303800, 9, 8, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 53, 0, 2303801, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Script - Start WP"), - -(2304200, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set Event Phase 0"), -(2304200, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Say Line 0 (Sky Commander Adaris)"), -(2304200, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set StandState Kneel"), -(2304200, 9, 3, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Say Line 0"), -(2304200, 9, 4, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 0, 91, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Remove StandState Kneel"), -(2304200, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set Event Phase 1"), - -(2304201, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set Event Phase 0"), -(2304201, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 83, 3, 0, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Remove Gossip+Questgiver Npcflag (Sky Commander Adaris)"), -(2304201, 9, 2, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set Data 1 1 (Sky Commander Adaris)"), -(2304201, 9, 3, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 91, 8, 0, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Remove StandState Kneel (Sky Commander Adaris)"), -(2304201, 9, 4, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 45, 2, 2, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set Data 2 2 (Sky Commander Adaris)"), -(2304201, 9, 5, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 0, 45, 3, 3, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set Data 3 3 (Sky Commander Adaris)"), - -(2304202, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 5.01555, "Severin - On Script - Set Orientation"), -(2304202, 9, 1, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 0, 53, 0, 2304201, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Start WP"), - -(2304203, 9, 0, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Say Line 4 (Sky Commander Adaris)"), -(2304203, 9, 1, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Say Line 2"), -(2304203, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set StandState Kneel"), -(2304203, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 91, 8, 0, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Remove StandState Kneel (Sky Commander Adaris)"), -(2304203, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 90, 1, 0, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set StandState Sit (Sky Commander Adaris)"), -(2304203, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 82, 3, 0, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set Gossip+Questgiver Npcflag (Sky Commander Adaris)"), -(2304203, 9, 6, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 0, 91, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Remove StandState Kneel"), -(2304203, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set Event Phase 1"); - -DELETE FROM `creature_text` WHERE `CreatureID` IN (23042, 23038) AND `GroupID`!=0; -INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES -(23038, 1, 0, "The elixir... give it to me, Severin!", 12, 0, 100, 0, 0, 0, 21083, 0, "Sky Commander Adaris"), -(23038, 2, 0, "I see them now... assassins from Skettis!", 12, 0, 100, 25, 0, 0, 21084, 0, "Sky Commander Adaris"), -(23038, 3, 0, "The arakkoa can send all the assassins they have... they will meet the same fate as these!", 12, 0, 100, 0, 0, 0, 21086, 0, "Sky Commander Adaris"), -(23038, 4, 0, "Is this... blood in my lungs? If I don't die to an assassin's blade, it'll be my old injuries that get me.", 12, 0, 100, 0, 0, 0, 21094, 0, "Sky Commander Adaris"), -(23042, 1, 0, "Adaris!", 14, 0, 100, 0, 0, 0, 21132, 0, "Severin"), -(23042, 2, 0, "Rest now, friend. You need your strength.", 12, 0, 100, 0, 0, 0, 21133, 0, "Severin"); - -DELETE FROM `waypoints` WHERE `entry` IN (2303800, 2303801, 2304200, 2304201); -INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES -(2303800, 1, -3401.270020, 3617.288330, 276.939697, "Sky Commander Adaris"), -(2303801, 1, -3408.260010, 3622.709961, 278.075012, "Sky Commander Adaris"), -(2304200, 1, -3402.066650, 3619.804688, 277.965363, "Severin"), -(2304201, 1, -3407.590088, 3624.570068, 278.075012, "Severin"); - -DELETE FROM `creature_template_addon` WHERE `entry`=23207; -INSERT INTO `creature_template_addon` (`entry`, `bytes1`, `auras`) VALUES -(23207, 0, "29266"); diff --git a/sql/updates/world/3.3.5/2020_07_03_00_world.sql b/sql/updates/world/3.3.5/2020_07_03_00_world.sql new file mode 100644 index 00000000000..53dd79ba69d --- /dev/null +++ b/sql/updates/world/3.3.5/2020_07_03_00_world.sql @@ -0,0 +1,84 @@ +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=23038; +UPDATE `creature` SET `orientation`=0.049211 WHERE `id`=23038; + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (23038, 23042) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2303800, 2304200, 2304201, 2304202, 2304203) 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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(23042, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Spawn - Set Event Phase 1"), +(23042, 0, 1, 0, 19, 1, 100, 0, 11004, 0, 0, 0, 0, 80, 2304200, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Quest 'World of Shadows' Taken - Run Script (Event Phase 1)"), +(23042, 0, 2, 0, 20, 1, 100, 0, 11004, 0, 0, 0, 0, 80, 2304201, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Quest 'World of Shadows' Rewarded - Run Script (Event Phase 1)"), +(23042, 0, 3, 4, 38, 0, 100, 0, 1, 1, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Data 1 1 Set - Say Line 1"), +(23042, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 53, 1, 2304200, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Data 1 1 Set - Start WP"), +(23042, 0, 5, 0, 40, 0, 100, 0, 1, 2304200, 0, 0, 0, 80, 2304202, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On WP 1 Reached - Run Script"), +(23042, 0, 6, 0, 40, 0, 100, 0, 1, 2304201, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 4.555310, "Severin - On WP 1 Reached - Reset Orientation"), +(23042, 0, 7, 0, 38, 0, 100, 0, 2, 2, 0, 0, 0, 80, 2304203, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Data 2 2 Set - Run Script"), + +(23038, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Spawn - Set Event Phase 1"), +(23038, 0, 1, 2, 38, 0, 100, 0, 1, 1, 0, 0, 0, 91, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Data 1 1 Set - Remove StandState Sit"), +(23038, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Data 1 1 Set - Set StandState Kneel"), +(23038, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Data 1 1 Set - Say Line 1"), +(23038, 0, 4, 5, 38, 0, 100, 0, 2, 2, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 5.794490, "Sky Commander Adaris - On Data 2 2 Set - Set Orientation"), +(23038, 0, 5, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Data 2 2 Set - Say Line 2"), +(23038, 0, 6, 7, 38, 0, 100, 0, 3, 3, 0, 0, 0, 40, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Data 3 3 Set - Unsheathe Melee Weapon"), +(23038, 0, 7, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 53, 1, 2303800, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Data 3 3 Set - Start WP"), +(23038, 0, 8, 0, 40, 0, 100, 0, 1, 2303800, 0, 0, 0, 80, 2303800, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On WP 1 Reached - Run Script"), +(23038, 0, 9, 10, 40, 0, 100, 0, 1, 2303801, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0.049211, "Sky Commander Adaris - On WP 1 Reached - Reset Orientation"), +(23038, 0, 10, 11, 61, 0, 100, 0, 0, 0, 0, 0, 0, 40, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On WP 1 Reached - Sheathe Melee Weapon"), +(23038, 0, 11, 12, 61, 0, 100, 0, 0, 0, 0, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On WP 1 Reached - Set StandState Kneel"), +(23038, 0, 12, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 45, 2, 2, 0, 0, 0, 0, 19, 23042, 10, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On WP 1 Reached - Set Data 2 2 (Severin)"), + +(2303800, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 23042, 50, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Script - Set Data 1 1 (Severin)"), +(2303800, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 5.168708, "Sky Commander Adaris - On Script - Set Orientation"), +(2303800, 9, 2, 0, 0, 0, 100, 0, 400, 400, 0, 0, 0, 5, 54, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Script - Play Emote ONESHOT_ATTACK1H"), +(2303800, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 12, 23207, 3, 18000, 0, 0, 0, 8, 0, 0, 0, 0, -3399.783447, 3614.886719, 276.369293, 2.089945, "Sky Commander Adaris - On Script - Summon Creature 'Skettis Assassin'"), +(2303800, 9, 4, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 6.268262, "Sky Commander Adaris - On Script - Set Orientation"), +(2303800, 9, 5, 0, 0, 0, 100, 0, 400, 400, 0, 0, 0, 5, 54, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Script - Play Emote ONESHOT_ATTACK1H"), +(2303800, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 12, 23207, 3, 18000, 0, 0, 0, 8, 0, 0, 0, 0, -3397.512207, 3617.134766, 276.865234, 3.028496, "Sky Commander Adaris - On Script - Summon Creature 'Skettis Assassin'"), +(2303800, 9, 7, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Script - Say Line 3"), +(2303800, 9, 8, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 53, 0, 2303801, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Script - Start WP"), + +(2304200, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set Event Phase 0"), +(2304200, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Say Line 0 (Sky Commander Adaris)"), +(2304200, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set StandState Kneel"), +(2304200, 9, 3, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Say Line 0"), +(2304200, 9, 4, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 0, 91, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Remove StandState Kneel"), +(2304200, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set Event Phase 1"), + +(2304201, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set Event Phase 0"), +(2304201, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 83, 3, 0, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Remove Gossip+Questgiver Npcflag (Sky Commander Adaris)"), +(2304201, 9, 2, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set Data 1 1 (Sky Commander Adaris)"), +(2304201, 9, 3, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 91, 8, 0, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Remove StandState Kneel (Sky Commander Adaris)"), +(2304201, 9, 4, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 45, 2, 2, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set Data 2 2 (Sky Commander Adaris)"), +(2304201, 9, 5, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 0, 45, 3, 3, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set Data 3 3 (Sky Commander Adaris)"), + +(2304202, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 5.01555, "Severin - On Script - Set Orientation"), +(2304202, 9, 1, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 0, 53, 0, 2304201, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Start WP"), + +(2304203, 9, 0, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Say Line 4 (Sky Commander Adaris)"), +(2304203, 9, 1, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Say Line 2"), +(2304203, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 90, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set StandState Kneel"), +(2304203, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 91, 8, 0, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Remove StandState Kneel (Sky Commander Adaris)"), +(2304203, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 90, 1, 0, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set StandState Sit (Sky Commander Adaris)"), +(2304203, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 82, 3, 0, 0, 0, 0, 0, 19, 23038, 10, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set Gossip+Questgiver Npcflag (Sky Commander Adaris)"), +(2304203, 9, 6, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 0, 91, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Remove StandState Kneel"), +(2304203, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Script - Set Event Phase 1"); + +DELETE FROM `creature_text` WHERE `CreatureID` IN (23042, 23038) AND `GroupID`!=0; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(23038, 1, 0, "The elixir... give it to me, Severin!", 12, 0, 100, 0, 0, 0, 21083, 0, "Sky Commander Adaris"), +(23038, 2, 0, "I see them now... assassins from Skettis!", 12, 0, 100, 25, 0, 0, 21084, 0, "Sky Commander Adaris"), +(23038, 3, 0, "The arakkoa can send all the assassins they have... they will meet the same fate as these!", 12, 0, 100, 0, 0, 0, 21086, 0, "Sky Commander Adaris"), +(23038, 4, 0, "Is this... blood in my lungs? If I don't die to an assassin's blade, it'll be my old injuries that get me.", 12, 0, 100, 0, 0, 0, 21094, 0, "Sky Commander Adaris"), +(23042, 1, 0, "Adaris!", 14, 0, 100, 0, 0, 0, 21132, 0, "Severin"), +(23042, 2, 0, "Rest now, friend. You need your strength.", 12, 0, 100, 0, 0, 0, 21133, 0, "Severin"); + +DELETE FROM `waypoints` WHERE `entry` IN (2303800, 2303801, 2304200, 2304201); +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES +(2303800, 1, -3401.270020, 3617.288330, 276.939697, "Sky Commander Adaris"), +(2303801, 1, -3408.260010, 3622.709961, 278.075012, "Sky Commander Adaris"), +(2304200, 1, -3402.066650, 3619.804688, 277.965363, "Severin"), +(2304201, 1, -3407.590088, 3624.570068, 278.075012, "Severin"); + +DELETE FROM `creature_template_addon` WHERE `entry`=23207; +INSERT INTO `creature_template_addon` (`entry`, `bytes1`, `auras`) VALUES +(23207, 0, "29266"); diff --git a/sql/updates/world/3.3.5/2020_07_03_01_world.sql b/sql/updates/world/3.3.5/2020_07_03_01_world.sql new file mode 100644 index 00000000000..8132fc57f8f --- /dev/null +++ b/sql/updates/world/3.3.5/2020_07_03_01_world.sql @@ -0,0 +1,25 @@ +-- +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=23306; +DELETE FROM `smart_scripts` WHERE `entryorguid`=23306 AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=23038 AND `source_type`=0 AND `id`=13; +DELETE FROM `smart_scripts` WHERE `entryorguid`=23042 AND `source_type`=0 AND `id` IN (8, 9); +DELETE FROM `smart_scripts` WHERE `entryorguid`=2303801 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`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(23306, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 0, "Hazzik - On Data 1 1 Set - Say Line 0 (Stored Target)"), +(23038, 0, 13, 0, 20, 1, 100, 0, 11028, 0, 0, 0, 0, 80, 2303801, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Quest 'Countdown to Doom' Rewarded - Run Script (Phase 1)"), +(23042, 0, 8, 0, 38, 0, 100, 0, 3, 3, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Data 3 3 Set - Set Event Phase 0"), +(23042, 0, 9, 0, 38, 0, 100, 0, 4, 4, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Severin - On Data 4 4 Set - Set Event Phase 1"), +(2303801, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Script - Set Event Phase 0"), +(2303801, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 3, 3, 0, 0, 0, 0, 19, 23042, 50, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Script - Set Data 3 3 (Severin)"), +(2303801, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Script - Store Invoker"), +(2303801, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 0, 19, 23306, 50, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Script - Send Stored Target (Hazzik)"), +(2303801, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 23306, 50, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Script - Set Data 1 1 (Hazzik)"), +(2303801, 9, 5, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Script - Say Line 5"), +(2303801, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 45, 4, 4, 0, 0, 0, 0, 19, 23042, 50, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Script - Set Data 4 4 (Severin)"), +(2303801, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Sky Commander Adaris - On Script - Set Event Phase 1"); + +DELETE FROM `creature_text` WHERE `CreatureID`=23306; +DELETE FROM `creature_text` WHERE `CreatureID`=23038 AND `GroupID`=5; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(23306, 0, 0, "You over there! I must speak with you!", 15, 0, 100, 0, 0, 0, 21339, 0, "Hazzik"), +(23038, 5, 0, "Do not... bring Terokk into our world, $n... That would be... madness...", 12, 0, 100, 0, 0, 0, 21907, 0, "Sky Commander Adaris"); -- cgit v1.2.3