API tools faq
paste
frenado05

Untitled

frenado05
Nov 19th, 2025 (edited)
14
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.66 KB | None | 0 0
raw download clone embed print report
  1. -- https://tracker.legionbugs.com/view.php?id=30833 Шон братишка
  2. UPDATE `creature_template` SET `npcflag` = 1, `AIName` = 'SmartAI', `gossip_menu_id` = 21021 WHERE `entry` = 121086;
  3. DELETE FROM `smart_scripts` WHERE `entryorguid` = 121086 AND `source_type` = 0;
  4. 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_param_float`, `action_delay`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  5. (121086, 0, 0, 1, 22, 0, 100, 0, 101, 60000, 60000, 0, 0, 81, 3, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'on receive emote npc flag'),
  6. (121086, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 0, 67, 1, 60000, 60000, 0, 0, 100, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Timed Event'),
  7. (121086, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 5, 3, 0, 0, 0, 0, 0, 0, 1258, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Wave'),
  8. (121086, 0, 3, 0, 59, 0, 100, 0, 1, 0, 0, 0, 0, 81, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On Timed Event Back Flag'),
  9. (121086, 0, 4, 5, 62, 0, 100, 0, 21031, 0, 21000, 21000, 0, 90, 8, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Gossip - Select Standstate 8'),
  10. (121086, 0, 5, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 67, 2, 20722, 20722, 0, 0, 100, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Timed Event'),
  11. (121086, 0, 6, 0, 59, 0, 100, 0, 2, 0, 0, 0, 0, 91, 8, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'On Timed Event Back Standstate 0'),
  12. (121086, 0, 7, 8, 62, 0, 100, 0, 21022, 0, 5000, 5000, 0, 5, 18, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Gossip - Select OneShotCry'),
  13. (121086, 0, 8, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 91, 9, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Back Standstate 0'),
  14. (121086, 0, 9, 10, 62, 0, 100, 0, 21022, 1, 5000, 5000, 0, 85, 241519, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Gossip - Select Cast - Put a Ring On It'),
  15. (121086, 0, 10, 11, 61, 0, 100, 0, 0, 0, 0, 0, 0, 56, 147433, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - AddItemRing to Bag'),
  16. (121086, 0, 11, 12, 61, 0, 100, 0, 0, 0, 0, 0, 0, 91, 9, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Back Standstate 0'),
  17. (121086, 0, 12, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 5, 4, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - OneShotCheer');
  18.  
  19. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `SourceGroup` = 2 AND `SourceEntry` = 241519;
  20. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  21. (13, 2, 241519, 0, 0, 31, 0, 3, 121086, 0, 0, 0, '', 'cast on mob', 0, 6);
  22.  
  23. -- Конд на меню у Шона Братухи
  24. DELETE FROM `conditions` where SourceTypeOrReferenceId IN (14) and SourceGroup IN (21021);
  25. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  26. (14, 21021, 121086, 0, 0, 2, 0, 147433, 1, 1, 1, 0, '', 'Gossip option', 0, 6), -- <Шон выжидающе смотрит на вас.>
  27. (14, 21021, 1210860, 0, 0, 108, 1, 2, 0, 0, 0, 0, '', 'Gossip option', 0, 6), -- Это ты?! Это тебя я видел в своих снах?!
  28. (14, 21021, 1210860, 0, 0, 2, 0, 147433, 1, 1, 1, 0, '', 'Gossip option', 0, 6), -- Это ты?! Это тебя я видел в своих снах?!
  29. (14, 21021, 1210866, 0, 0, 2, 0, 147433, 1, 1, 0, 0, '', 'Gossip option', 0, 6); -- У меня просто слов нет... Я теперь счастливее всех на свете! Вперед, навстречу следующему приключению!
  30.  
  31. DELETE FROM `conditions` where SourceTypeOrReferenceId IN (15) and SourceGroup IN (21021);
  32. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  33. (15, 21021, 0, 0, 0, 108, 1, 2, 0, 1, 0, 0, '', 'Gossip option', 0, 6), -- ...
  34. (15, 21021, 0, 0, 0, 2, 0, 147433, 1, 1, 1, 0, '', 'Gossip option', 0, 6); -- ...
  35.  
  36. DELETE FROM `creature` WHERE `id` = 121086;
  37. INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `MovementType`, `randomMoveType`, `randomMoveMinTimer`, `randomMoveMaxTimer`, `ScriptName`, `npcflag`, `npcflag2`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `isActive`, `personal_size`, `isTeemingSpawn`, `MiscData`, `GroupID`, `inhabitType`, `id_alliance`, `id_horde`, `VerifiedBuild`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  38. (121086, 530, 3518, 3624, 1, 1, '', 0, 0, -1930.26, 9107.16, 263.771, 0, 120, 0, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 6);
  39.  
  40. DELETE FROM `npc_text` WHERE `ID` IN (1210861,1210862,1210863,1210864,1210865,1210866);
  41. INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextID0`, `BroadcastTextID1`, `BroadcastTextID2`, `BroadcastTextID3`, `BroadcastTextID4`, `BroadcastTextID5`, `BroadcastTextID6`, `BroadcastTextID7`, `VerifiedBuild`) VALUES
  42. (1210861, 1, 0, 0, 0, 0, 0, 0, 0, 130158, 0, 0, 0, 0, 0, 0, 0, 0),
  43. (1210862, 1, 0, 0, 0, 0, 0, 0, 0, 130159, 0, 0, 0, 0, 0, 0, 0, 0),
  44. (1210863, 1, 0, 0, 0, 0, 0, 0, 0, 130160, 0, 0, 0, 0, 0, 0, 0, 0),
  45. (1210864, 1, 0, 0, 0, 0, 0, 0, 0, 130209, 0, 0, 0, 0, 0, 0, 0, 0),
  46. (1210865, 1, 0, 0, 0, 0, 0, 0, 0, 130161, 0, 0, 0, 0, 0, 0, 0, 0),
  47. (1210866, 1, 0, 0, 0, 0, 0, 0, 0, 130162, 0, 0, 0, 0, 0, 0, 0, 0);
  48.  
  49. DELETE FROM `gossip_menu` WHERE `MenuID` = 21024;
  50. INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `FriendshipFactionID`, `VerifiedBuild`) VALUES
  51. (21024, 1210861, 0, 0);
  52.  
  53. DELETE FROM `gossip_menu_option` WHERE `MenuID` = 21024;
  54. INSERT INTO `gossip_menu_option` (`MenuID`, `OrderIndex`, `OptionIcon`, `OptionText`, `OptionType`, `Language`, `OptionBroadcastTextID`, `Flags`, `SpellID`, `OverrideIconID`, `GossipNpcOptionID`, `OptionNpcflag`, `OptionNpcflag2`, `OpenShipmentId`, `VerifiedBuild`, `MaxExpansion`, `MinExpansion`) VALUES
  55. (21024, 0, 0, 'Надеюсь, ты их отыщешь.', 1, 0, 130189, 0, NULL, NULL, NULL, 1, 0, 0, 0, 0, 6),
  56. (21024, 1, 0, 'Мне то же самое снилось про тебя!', 1, 0, 130190, 0, NULL, NULL, NULL, 1, 0, 0, 0, 0, 6);
  57.  
  58. DELETE FROM `gossip_menu` WHERE `MenuID` = 21023;
  59. INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `FriendshipFactionID`, `VerifiedBuild`) VALUES
  60. (21023, 1210862, 0, 0);
  61.  
  62. DELETE FROM `gossip_menu_option` WHERE `MenuID` = 21023;
  63. DELETE FROM `gossip_menu_option_action` WHERE `MenuID` IN (21024,21031,21022);
  64. INSERT INTO `gossip_menu_option_action` (`MenuID`, `OptionIndex`, `ActionMenuId`, `ActionPoiId`) VALUES
  65. (21024, 0, 21023, 0),
  66. (21024, 1, 21031, 0),
  67. (21031, 0, 21022, 0),
  68. (21022, 0, 21025, 0),
  69. (21022, 1, 21026, 0);
  70.  
  71. DELETE FROM `gossip_menu` WHERE `MenuID` = 21031;
  72. INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `FriendshipFactionID`, `VerifiedBuild`) VALUES
  73. (21031, 1210863, 0, 0);
  74.  
  75. DELETE FROM `gossip_menu_option` WHERE `MenuID` = 21031;
  76. INSERT INTO `gossip_menu_option` (`MenuID`, `OrderIndex`, `OptionIcon`, `OptionText`, `OptionType`, `Language`, `OptionBroadcastTextID`, `Flags`, `SpellID`, `OverrideIconID`, `GossipNpcOptionID`, `OptionNpcflag`, `OptionNpcflag2`, `OpenShipmentId`, `VerifiedBuild`, `MaxExpansion`, `MinExpansion`) VALUES
  77. (21031, 0, 0, '...', 1, 0, 130188, 0, NULL, NULL, NULL, 1, 0, 0, 0, 0, 6); -- тут на колени встаёт
  78.  
  79. DELETE FROM `gossip_menu` WHERE `MenuID` = 21022;
  80. INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `FriendshipFactionID`, `VerifiedBuild`) VALUES
  81. (21022, 1210864, 0, 0);
  82.  
  83. DELETE FROM `gossip_menu_option` WHERE `MenuID` = 21022;
  84. INSERT INTO `gossip_menu_option` (`MenuID`, `OrderIndex`, `OptionIcon`, `OptionText`, `OptionType`, `Language`, `OptionBroadcastTextID`, `Flags`, `SpellID`, `OverrideIconID`, `GossipNpcOptionID`, `OptionNpcflag`, `OptionNpcflag2`, `OpenShipmentId`, `VerifiedBuild`, `MaxExpansion`, `MinExpansion`) VALUES
  85. (21022, 0, 0, 'Мне очень жаль. Я просто не могу...', 1, 0, 130192, 0, NULL, NULL, NULL, 1, 0, 0, 0, 0, 6),
  86. (21022, 1, 0, 'Да!', 1, 0, 130191, 0, NULL, NULL, NULL, 1, 0, 0, 0, 0, 6);
  87.  
  88. DELETE FROM `gossip_menu_option` WHERE `MenuID` = 21025;
  89. DELETE FROM `gossip_menu` WHERE `MenuID` = 21025;
  90. INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `FriendshipFactionID`, `VerifiedBuild`) VALUES
  91. (21025, 1210865, 0, 0);
  92.  
  93. DELETE FROM `gossip_menu_option` WHERE `MenuID` = 21026;
  94. DELETE FROM `gossip_menu` WHERE `MenuID` = 21026;
  95. INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `FriendshipFactionID`, `VerifiedBuild`) VALUES
  96. (21026, 1210866, 0, 0);
  97.  
  98. DELETE FROM `gossip_menu` WHERE `MenuID` = 21021 AND `TextID` = 1210866;
  99. INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `FriendshipFactionID`, `VerifiedBuild`) VALUES
  100. (21021, 1210866, 0, 0);
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!