API tools faq
paste
frenado05

Untitled

frenado05
Nov 13th, 2025
13
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.22 KB | None | 0 0
raw download clone embed print report
  1. -- https://tracker.legionbugs.com/view.php?id=33826
  2. DELETE FROM `creature` WHERE `guid` = 263997;
  3. UPDATE `creature_template_wdb` SET `Displayid1` = 67912, `Displayid2` = 0 WHERE `Entry` = 109739;
  4. UPDATE `gameobject_template` SET `AIName` = 'SmartGameObjectAI' WHERE `entry` = 246466;
  5. UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 109739;
  6. UPDATE `creature_template` SET `unit_flags` = 33600, `unit_flags2` = 34816 WHERE `entry` = 109739;
  7.  
  8. DELETE FROM `smart_scripts` WHERE `entryorguid` = 246466 AND `source_type` = 1;
  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`, `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
  10. (246466, 1, 0, 0, 20, 0, 100, 0, 40890, 0, 0, 0, 0, 220, 109739, 3, 83000, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, -833.1285, 4458.416, 589.0225, 3.012685, 'REWARD_QUEST - SUMMON_CREATURE_IN_PERS_VISIBILITY');
  11.  
  12. DELETE FROM `smart_scripts` WHERE `entryorguid` = 109739 AND `source_type` = 0;
  13. DELETE FROM `smart_scripts` WHERE `entryorguid` = 109739*100 AND `source_type` = 9;
  14. DELETE FROM `smart_scripts` WHERE `entryorguid` = 109739*100+1 AND `source_type` = 9;
  15. 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
  16. (109739, 0, 0, 1, 54, 0, 100, 1, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Just summ - Say Text'),
  17. (109739, 0, 1, 0, 61, 0, 100, 1, 0, 0, 0, 0, 0, 53, 0, 109739, 0, 0, 500, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'WP START'),
  18. (109739, 0, 2, 0, 40, 0, 100, 1, 9, 109739, 0, 0, 0, 54, 2500, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'WP PUASE'),
  19. (109739, 0, 3, 4, 40, 0, 100, 1, 11, 109739, 0, 0, 0, 54, 25000, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'WP PUASE'),
  20. (109739, 0, 4, 0, 61, 0, 100, 1, 0, 0, 0, 0, 0, 128, 10851, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'ANIM KIT'),
  21.  
  22. (109739, 0, 5, 0, 55, 0, 100, 1, 11, 109739, 0, 0, 0, 80, 109739*100, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'TS'), -- alliance ts
  23. (109739, 0, 6, 0, 55, 0, 100, 1, 11, 109739, 0, 0, 0, 80, 109739*100+1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'TS'), -- horde ts
  24. (109739, 0, 7, 0, 40, 0, 100, 1, 47, 109739, 0, 0, 0, 27, 4, 1000, 68661, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- визуал кит
  25.  
  26. (109739*100, 9, 0, 0, 0, 0, 100, 0, 4500, 4500, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- текст 1
  27. (109739*100, 9, 1, 0, 0, 0, 100, 0, 8500, 8500, 0, 0, 0, 1, 2, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- текст 2
  28.  
  29. (109739*100+1, 9, 0, 0, 0, 0, 100, 0, 4500, 4500, 0, 0, 0, 1, 3, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- текст 1
  30. (109739*100+1, 9, 1, 0, 0, 0, 100, 0, 8500, 8500, 0, 0, 0, 1, 2, 0, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, ''); -- текст 2
  31.  
  32. -- конд на смарт выше
  33. DELETE FROM conditions WHERE SourceTypeOrReferenceId IN (22) AND SourceGroup IN (6) and SourceEntry IN (109739) AND SourceId = 0;
  34. DELETE FROM conditions WHERE SourceTypeOrReferenceId IN (22) AND SourceGroup IN (7) and SourceEntry IN (109739) AND SourceId = 0;
  35. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
  36. (22, 6, 109739, 0, 0, 6, 2, 469, 0, 0, 0, 0, '', 'True If player Alliance', 0, 6),
  37. (22, 7, 109739, 0, 0, 6, 2, 67, 0, 0, 0, 0, '', 'True If player Horde', 0, 6);
  38.  
  39.  
  40. DELETE FROM `creature_text` WHERE `Entry` = 109739;
  41. INSERT INTO `creature_text` (`Entry`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextID`, `MinTimer`, `MaxTimer`, `SpellID`, `AutoType`, `comment`) VALUES
  42. (109739, 0, 0, 'Сегодня мы празднуем великую победу, оплаченную кровью друзей и близких.', 12, 0, 100, 1, 0, 64071, 115734, 0, 0, 0, 0, 'Тиранда Шелест Ветра to Player'),
  43. (109739, 1, 0, 'Благодаря твоей смелости древние земли Валь\'шары смогут исцелиться.', 12, 0, 100, 1, 0, 69980, 115731, 0, 0, 0, 0, 'Тиранда Шелест Ветра to Player'),
  44. (109739, 2, 0, 'Теперь у нас есть Слезы Элуны. Пусть они принесут нам победу над Пылающим Легионом!', 12, 0, 100, 0, 0, 69979, 115736, 0, 0, 0, 0, 'Тиранда Шелест Ветра to Player'),
  45. (109739, 3, 0, 'У меня много причин не любить Орду, но твои доблесть и отвага спасли Валь\'шару.', 12, 0, 100, 1, 0, 64073, 115735, 0, 0, 0, 0, 'Тиранда Шелест Ветра to Player');
  46.  
  47.  
  48. DELETE FROM `waypoints` WHERE `entry` = 109739;
  49. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  50. (109739, 0, -832.9151, 4458.658, 589.1392, NULL),
  51. (109739, 1, -837.4213, 4461.1406, 588.8866, NULL),
  52. (109739, 2, -840.4928, 4463.837, 589.11206, NULL),
  53. (109739, 3, -843.9928, 4466.587, 589.11206, NULL),
  54. (109739, 4, -844.6861, 4467.158, 588.94366, NULL),
  55. (109739, 5, -845.1937, 4467.745, 589.1604, NULL),
  56. (109739, 6, -852.6937, 4466.995, 589.1604, NULL),
  57. (109739, 7, -854.6937, 4466.995, 588.9104, NULL),
  58. (109739, 8, -855.6937, 4466.745, 588.9104, NULL),
  59. (109739, 9, -856.7014, 4470.3315, 588.87714, NULL),
  60. (109739, 10, -857.9044, 4468.8604, 588.9319, NULL),
  61. (109739, 11, -858.4044, 4467.6104, 589.1819, NULL),
  62. (109739, 12, -859.1074, 4467.3887, 588.9866, NULL),
  63. (109739, 13, -858.46606, 4467.6963, 589.204, NULL),
  64. (109739, 14, -856.96606, 4467.9463, 588.954, NULL),
  65. (109739, 15, -856.0104, 4467.839, 588.8337, NULL),
  66. (109739, 16, -853.051, 4468.0605, 589.1013, NULL),
  67. (109739, 17, -852.551, 4468.0605, 589.1013, NULL),
  68. (109739, 18, -844.801, 4468.5605, 589.1013, NULL),
  69. (109739, 19, -844.26135, 4468.0444, 588.93085, NULL),
  70. (109739, 20, -842.3751, 4466.754, 589.21655, NULL),
  71. (109739, 21, -839.5485, 4464.197, 588.9161, NULL),
  72. (109739, 22, -837.37836, 4462.538, 589.30176, NULL),
  73. (109739, 23, -836.37836, 4461.788, 589.30176, NULL),
  74. (109739, 24, -833.12836, 4459.038, 589.30176, NULL),
  75. (109739, 25, -830.2746, 4456.471, 588.9915, NULL),
  76. (109739, 26, -824.6317, 4452.1543, 592.6217, NULL),
  77. (109739, 27, -823.1317, 4450.9043, 593.6217, NULL),
  78. (109739, 28, -822.1317, 4449.9043, 593.8717, NULL),
  79. (109739, 29, -817.4858, 4446.425, 596.7768, NULL),
  80. (109739, 30, -816.4858, 4445.425, 597.2768, NULL),
  81. (109739, 31, -815.29266, 4444.375, 597.96954, NULL),
  82. (109739, 32, -813.85266, 4443.4004, 598.86145, NULL),
  83. (109739, 33, -812.85266, 4442.6504, 599.11145, NULL),
  84. (109739, 34, -811.85266, 4441.9004, 598.86145, NULL),
  85. (109739, 35, -810.9406, 4440.859, 598.5814, NULL),
  86. (109739, 36, -806.33234, 4437.1123, 598.5936, NULL),
  87. (109739, 37, -801.6154, 4433.277, 598.78345, NULL),
  88. (109739, 38, -799.78894, 4432.01, 599.1819, NULL),
  89. (109739, 39, -798.28894, 4430.76, 599.1819, NULL),
  90. (109739, 40, -796.85803, 4429.4263, 599.29755, NULL),
  91. (109739, 41, -793.5607, 4426.9004, 600.8443, NULL),
  92. (109739, 42, -791.5255, 4425.3096, 601.61035, NULL),
  93. (109739, 43, -787.7965, 4422.11, 602.57947, NULL),
  94. (109739, 44, -784.50574, 4419.46, 602.6815, NULL),
  95. (109739, 45, -782.50574, 4418.21, 602.9315, NULL),
  96. (109739, 46, -779.75574, 4416.21, 602.9315, NULL),
  97. (109739, 47, -780.215, 4415.31, 602.7835, NULL);
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!