API tools faq
paste
frenado05

Untitled

frenado05
Nov 9th, 2025 (edited)
10
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.04 KB | None | 0 0
raw download clone embed print report
  1. -- призыв демонов Id: 203165 Name: Summon Demon Hunters (авто каст) пока не сделан http://wowhead.com/ru/quest=42869 "Вечный дозор"
  2. DELETE FROM `spell_target_position` WHERE `ID` IN (203167,203169,203170);
  3. INSERT INTO `spell_target_position` (`ID`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `PositionO`, `Flags`, `VerifiedBuild`, `MaxExpansion`, `MinExpansion`) VALUES
  4. (203169, 1220, -819.986, 4309.14, 745.709, 4.24115, 0, 0, 0, 6),
  5. (203170, 1220, -816.846, 4305.62, 745.778, 4.24115, 0, 0, 0, 6),
  6. (203167, 1220, -820.783, 4302.91, 745.74, 4.24115, 0, 0, 0, 6);
  7.  
  8. DELETE FROM `waypoints` WHERE entry = 102801;
  9. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  10. (102801, 0, -821.86804, 4300.676, 746.5446, ''),
  11. (102801, 1, -824.11804, 4296.426, 746.5446, ''),
  12. (102801, 2, -825.86804, 4292.926, 746.5446, ''),
  13. (102801, 3, -828.11804, 4288.926, 746.5446, ''),
  14. (102801, 4, -830.36804, 4284.176, 746.5446, ''),
  15. (102801, 5, -832.11804, 4281.176, 746.5446, ''),
  16. (102801, 6, -833.11804, 4278.676, 746.5446, ''),
  17. (102801, 7, -834.11804, 4276.176, 746.5446, ''),
  18. (102801, 8, -834.61804, 4273.676, 746.5446, ''),
  19. (102801, 9, -834.86804, 4271.176, 746.5446, ''),
  20. (102801, 10, -835.36804, 4268.676, 746.5446, ''),
  21. (102801, 11, -835.9531, 4265.442, 746.2659, '');
  22.  
  23. DELETE FROM `waypoints` WHERE entry = 102802;
  24. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  25. (102802, 0, -823.7951, 4302.214, 746.5291, ''),
  26. (102802, 1, -826.0451, 4298.214, 746.5291, ''),
  27. (102802, 2, -828.2951, 4293.964, 746.5291, ''),
  28. (102802, 3, -830.2951, 4289.964, 746.5291, ''),
  29. (102802, 4, -832.5451, 4285.714, 746.5291, ''),
  30. (102802, 5, -834.5451, 4281.714, 746.5291, ''),
  31. (102802, 6, -835.7951, 4279.214, 746.5291, ''),
  32. (102802, 7, -836.5451, 4276.714, 746.5291, ''),
  33. (102802, 8, -836.7951, 4274.214, 746.5291, ''),
  34. (102802, 9, -837.2951, 4271.214, 746.5291, ''),
  35. (102802, 10, -837.5451, 4268.464, 746.5291, ''),
  36. (102802, 11, -838.1042, 4265.788, 746.2659, '');
  37.  
  38. DELETE FROM `waypoints` WHERE entry = 102803;
  39. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  40. (102803, 0, -819.54016, 4300.509, 746.5641, ''),
  41. (102803, 1, -822.04016, 4296.259, 746.5641, ''),
  42. (102803, 2, -824.54016, 4291.509, 746.5641, ''),
  43. (102803, 3, -826.29016, 4287.759, 746.3141, ''),
  44. (102803, 4, -828.79016, 4283.259, 746.3141, ''),
  45. (102803, 5, -830.79016, 4280.009, 746.3141, ''),
  46. (102803, 6, -831.54016, 4278.259, 746.3141, ''),
  47. (102803, 7, -832.29016, 4276.259, 746.3141, ''),
  48. (102803, 8, -832.54016, 4273.509, 746.3141, ''),
  49. (102803, 9, -833.04016, 4270.509, 746.3141, ''),
  50. (102803, 10, -833.29016, 4267.759, 746.3141, ''),
  51. (102803, 11, -833.7344, 4264.897, 746.2669, '');
  52.  
  53. UPDATE `creature_template_addon` SET `mount` = 67597 WHERE `entry` IN (102801,102802,102803);
  54.  
  55. UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` IN (102801,102802,102803);
  56. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (102801,102802,102803) AND `source_type` = 0;
  57. 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
  58. (102801, 0, 0, 0, 54, 0, 100, 4097, 0, 0, 0, 0, 0, 53, 1, 102801, 0, 0, 0, 0, 0, 815, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'JS - WP START'),
  59. (102801, 0, 1, 0, 40, 0, 100, 4097, 0, 102801, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'wp reach - text'),
  60. (102801, 0, 2, 0, 40, 0, 100, 4097, 11, 102801, 0, 0, 0, 43, 0, 0, 0, 0, 0, 0, 0, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'wp reach - UnMount'),
  61.  
  62. (102802, 0, 0, 0, 54, 0, 100, 4097, 0, 0, 0, 0, 0, 53, 1, 102802, 0, 0, 0, 0, 0, 815, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'JS - WP START'),
  63. (102802, 0, 1, 0, 40, 0, 100, 4097, 11, 102802, 0, 0, 0, 43, 0, 0, 0, 0, 0, 0, 0, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'wp reach - UnMount'),
  64.  
  65.  
  66. (102803, 0, 0, 0, 54, 0, 100, 4097, 0, 0, 0, 0, 0, 53, 1, 102803, 0, 0, 0, 0, 0, 815, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'JS - WP START'),
  67. (102803, 0, 1, 2, 40, 0, 100, 4097, 11, 102803, 0, 0, 0, 43, 0, 0, 0, 0, 0, 0, 0, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'wp reach - UnMount'),
  68. (102803, 0, 2, 0, 61, 0, 100, 4097, 0, 0, 0, 0, 0, 80, 102803*100, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - START TS');
  69.  
  70.  
  71. DELETE FROM `smart_scripts` WHERE `entryorguid` = 102803*100 AND `source_type` = 9;
  72. 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
  73. (102803*100, 9, 0, 0, 0, 0, 100, 0, 1326, 1326, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Say');
  74.  
  75. DELETE FROM `creature_text` WHERE `Entry` = 102801;
  76. INSERT INTO `creature_text` (`Entry`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextID`, `MinTimer`, `MaxTimer`, `SpellID`, `AutoType`, `comment`) VALUES
  77. (102801, 0, 0, '$p! Ты снова с нами!', 12, 0, 100, 0, 0, 0, 105154, 0, 0, 0, 0, 'Кор\'вас Кровавый Шип to Player');
  78.  
  79. DELETE FROM `creature_text` WHERE `Entry` = 102803;
  80. INSERT INTO `creature_text` (`Entry`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextID`, `MinTimer`, `MaxTimer`, `SpellID`, `AutoType`, `TextRange`, `comment`, `MaxExpansion`, `MinExpansion`) VALUES
  81. (102803, 0, 0, 'Вблизи боевые клинки выглядят еще более впечатляющими.', 12, 0, 100, 1, 0, 0, 107832, 0, 0, 0, 0, 0, 'Аша Воронья Песнь to Player', 0, 6),
  82. (102803, 1, 0, 'Вблизи клинки Искусителя выглядят еще более впечатляющими.', 12, 0, 100, 1, 0, 0, 105155, 0, 0, 0, 0, 0, 'Аша Воронья Песнь to Player', 0, 6);
  83.  
  84. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 22 AND `SourceGroup` IN (2) AND `SourceEntry` = 102803;
  85. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  86. (22, 2, 102803, 0, 0, 92, 0, 41863, 66, 1, 0, 0, '', 'Smart - if QC', 0, 6);
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!