diff options
| -rw-r--r-- | sql/updates/world/master/2024_12_03_00_world.sql | 70 |
1 files changed, 70 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_12_03_00_world.sql b/sql/updates/world/master/2024_12_03_00_world.sql new file mode 100644 index 00000000000..fe0cd9ca780 --- /dev/null +++ b/sql/updates/world/master/2024_12_03_00_world.sql @@ -0,0 +1,70 @@ +SET @NPCTEXTID := 600052; + +-- Quest +DELETE FROM `creature_questender` WHERE (`id`=224708 AND `quest` IN (82800,0)); +INSERT INTO `creature_questender` (`id`, `quest`, `VerifiedBuild`) VALUES +(224708, 82800, 57689); -- A Sedimental Moment ended by Cenderragg + +-- Creature Text +DELETE FROM `creature_text` WHERE `CreatureID` = 226838; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(226838, 0, 0, 'Thank you, $c. I will not forget this.', 12, 0, 100, 0, 0, 0, 0, 0, 'Opalcreg Worker to Player'), +(226838, 0, 1, 'Thank you for working to restore the mine.', 12, 0, 100, 0, 0, 0, 0, 0, 'Opalcreg Worker to Player'), +(226838, 0, 2, 'Cogs bless you.', 12, 0, 100, 0, 0, 0, 0, 0, 'Opalcreg Worker to Player'); + +-- Gossip +DELETE FROM `creature_template_gossip` WHERE (`CreatureID`=226838 AND `MenuID`=35321); +INSERT INTO `creature_template_gossip` (`CreatureID`, `MenuID`, `VerifiedBuild`) VALUES +(226838, 35321, 57689); -- Opalcreg Worker + +DELETE FROM `npc_text` WHERE `ID` BETWEEN @NPCTEXTID+0 AND @NPCTEXTID+0; +INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES +(@NPCTEXTID+0, 1, 0, 0, 0, 0, 0, 0, 0, 267009, 0, 0, 0, 0, 0, 0, 0, 57689); -- 226838 (Opalcreg Worker) + +DELETE FROM `gossip_menu` WHERE (`MenuID`=35321 AND `TextID`=@NPCTEXTID+0); +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(35321, @NPCTEXTID+0, 57689); -- 226838 (Opalcreg Worker) + +DELETE FROM `gossip_menu_option` WHERE (`MenuID`=35321 AND `OptionID` IN (1,0,2,3)); +INSERT INTO `gossip_menu_option` (`MenuID`, `GossipOptionID`, `OptionID`, `OptionNpc`, `OptionText`, `OptionBroadcastTextID`, `Language`, `Flags`, `ActionMenuID`, `ActionPoiID`, `GossipNpcOptionID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `SpellID`, `OverrideIconID`, `VerifiedBuild`) VALUES +(35321, 123365, 1, 0, 'We grabbed so much more. Don\'t worry.', 0, 0, 1, 0, 0, NULL, 0, 0, NULL, 0, NULL, NULL, 57689), +(35321, 122997, 0, 0, 'There\'s still a whole lot of nerubians out there. Good luck.', 0, 0, 1, 0, 0, NULL, 0, 0, NULL, 0, NULL, NULL, 57689), +(35321, 123364, 2, 0, 'The Stormriders will be here at any moment!', 0, 0, 1, 0, 0, NULL, 0, 0, NULL, 0, NULL, NULL, 57689), +(35321, 123363, 3, 0, 'Then all my sacrifice... was for nothing?', 0, 0, 1, 0, 0, NULL, 0, 0, NULL, 0, NULL, NULL, 57689); + +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 14) AND (`SourceGroup` IN (35321)); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `Comment`) VALUES +(14, 35321, @NPCTEXTID+0, 0, 0, 9, 0, 82800, 0, 0, '', 0, 'Player for which gossip text is shown has quest A Sedimental Moment (82800) active'); + +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 15) AND (`SourceGroup` IN (35321)); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `Comment`) VALUES +(15, 35321, 0, 0, 0, 9, 0, 82800, 0, 0, '', 0, 'Player for which gossip text is shown has quest A Sedimental Moment (82800) active'), +(15, 35321, 1, 0, 0, 9, 0, 82800, 0, 0, '', 0, 'Player for which gossip text is shown has quest A Sedimental Moment (82800) active'), +(15, 35321, 2, 0, 0, 9, 0, 82800, 0, 0, '', 0, 'Player for which gossip text is shown has quest A Sedimental Moment (82800) active'), +(15, 35321, 3, 0, 0, 9, 0, 82800, 0, 0, '', 0, 'Player for which gossip text is shown has quest A Sedimental Moment (82800) active'); + +-- Opalcreg Worker smart ai +SET @ENTRY := 226838; +UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY; +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`, `action_param7`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`, `Difficulties`) VALUES +(@ENTRY, 0, 0, 1, 62, 0, 100, 0, 35321, 0, 0, 0, 0, 80, 22683800, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On gossip action 0 from menu 35321 selected - Self: Start timed action list id #Opalcreg Worker #0 (22683800) (update out of combat)', ''), +(@ENTRY, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On gossip action 0 from menu 35321 selected - Gossip player: Close gossip', ''), +(@ENTRY, 0, 2, 3, 62, 0, 100, 0, 35321, 1, 0, 0, 0, 80, 22683800, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On gossip action 1 from menu 35321 selected - Self: Start timed action list id #Opalcreg Worker #0 (22683800) (update out of combat)', ''), +(@ENTRY, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On gossip action 1 from menu 35321 selected - Gossip player: Close gossip', ''), +(@ENTRY, 0, 4, 5, 62, 0, 100, 0, 35321, 2, 0, 0, 0, 80, 22683800, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On gossip action 2 from menu 35321 selected - Self: Start timed action list id #Opalcreg Worker #0 (22683800) (update out of combat)', ''), +(@ENTRY, 0, 5, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On gossip action 2 from menu 35321 selected - Gossip player: Close gossip', ''), +(@ENTRY, 0, 6, 7, 62, 0, 100, 0, 35321, 3, 0, 0, 0, 80, 22683800, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On gossip action 3 from menu 35321 selected - Self: Start timed action list id #Opalcreg Worker #0 (22683800) (update out of combat)', ''), +(@ENTRY, 0, 7, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On gossip action 3 from menu 35321 selected - Gossip player: Close gossip', ''); + +-- Timed list 22683800 smart ai +SET @ENTRY := 22683800; +DELETE FROM `smart_scripts` WHERE `source_type` = 9 AND `entryOrGuid` = @ENTRY; +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`, `action_param7`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`, `Difficulties`) VALUES +(@ENTRY, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 149, 8, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'After 0 seconds - Self: Become personal clone for Last action invoker for 0 seconds (manual despawn)', ''), +(@ENTRY, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 0 seconds - Self: Set npc flags NONE', ''), +(@ENTRY, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 17, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 0 seconds - Self: Set emote state to 0', ''), +(@ENTRY, 9, 3, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 23, 0, 0, 0, 0, 0, 0, 0, 'After 1 seconds - Owner/Summoner: Talk 0 to invoker', ''), +(@ENTRY, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 33, 226838, 0, 0, 0, 0, 0, 0, 23, 0, 0, 0, 0, 0, 0, 0, 'After 0 seconds - Owner/Summoner: Give kill credit Opalcreg Worker (226838)', ''), +(@ENTRY, 9, 5, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 114, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 8, 0, 0, 'After 2 seconds - Self: Move forward by 0, left by 8, up by 0 yards', ''), +(@ENTRY, 9, 6, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 2 seconds - Self: Despawn instantly', ''); |