frenado05

Untitled

Jul 31st, 2026
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.00 KB | None | 0 0
  1. UPDATE `creature_template` SET `unit_flags` = 524624, `unit_flags2` = 2099200, `unit_flags3` = 1073741825 WHERE `entry` IN (36065,36066);
  2.  
  3. -- 1. ТИРИОН
  4. DELETE FROM `creature` WHERE `id`=35361;
  5. INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `spawnDifficulties`, `phaseMask`, `PhaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `wander_distance`, `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
  6. (37320, 35361, 571, 0, 0, 1, 0, 1, 0, 0, 1, 8516.2294921875, 855.98614501953125, 558.2279052734375, 1.620458722114562988, 1500, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3);
  7.  
  8. -- его спавн 100% 8516.2294921875, 855.98614501953125, 558.2279052734375, 1.620458722114562988
  9.  
  10. -- 3. ТЕКСТЫ
  11. DELETE FROM `creature_text` WHERE `entry` IN(35361,35501);
  12. INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES
  13. (35501, 0, 0, 'Верховный лорд Тирион Фордринг подходит к арене, чтобы обратиться к прибывшим на турнир! Выслушайте его!', 14, 0, 100, 22, 0, 0, 'Herald Beluus',35812),
  14. (35361, 0, 0, 'Бойцы Орды и Альянса! Приветствуем вас под знаменами Серебряного Авангарда!', 12, 0, 100, 5, 0, 0, 'Highlord Tirion Fordring',35799),
  15. (35361, 1, 0, 'Цель наша находится на юге. Мы дойдем до цитадели и ударим в самое сердце логова Плети.', 12, 0, 100, 25, 0, 0, 'Highlord Tirion Fordring',35800),
  16. (35361, 2, 0, 'Но к этому заданию нельзя подходить легкомысленно.', 12, 0, 100, 0, 0, 0, 'Highlord Tirion Fordring',35801),
  17. (35361, 3, 0, 'Мы не можем просто собрать всех, кто способен держать в руках оружие, и выступить в поход – это закончится бессмысленным кровопролитием.', 12, 0, 100, 0, 0, 0, 'Highlord Tirion Fordring',35802),
  18. (35361, 4, 0, 'Вместо этого мы соберем группу лучших воинов и нанесем сокрушительный удар. Ради этого мы и создали Серебряный Турнир.', 12, 0, 100, 0, 0, 0, 'Highlord Tirion Fordring',35803),
  19. (35361, 5, 0, 'В этих стенах мы испытаем твое искусство боя против самых смертоносных обитателей Нордскола, и предводители оценят твое мастерство.', 12, 0, 100, 0, 0, 0, 'Highlord Tirion Fordring',35805),
  20. (35361, 6, 0, 'Мы будем оценивать твою смелость, твою силу и ловкость. Эти игры покажут все лучшее, на что способны обитатели Азерота.', 12, 0, 100, 0, 0, 0, 'Highlord Tirion Fordring',35806),
  21. (35361, 7, 0, 'Победители займут достойное место в рядах войска, которое выступит на цитадель. Мы сплотимся перед лицом врага, и Артас падет!', 12, 0, 100, 0, 0, 0, 'Highlord Tirion Fordring',35807);
  22.  
  23. -- 4. ОБНОВЛЕНИЕ ТЕМПЛЕЙТОВ
  24. UPDATE `creature_template` SET `speed_walk` = 1.5 WHERE `entry` = 35361;
  25. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN(35361,35501);
  26.  
  27. DELETE FROM `creature_template_addon` WHERE `entry`=35361;
  28. INSERT INTO `creature_template_addon` (`entry`, `mount`, `StandState`, `SheathState`, `auras`) VALUES
  29. (35361, 0, 0, 1, '57545');
  30.  
  31. -- 5. SMART_SCRIPTS
  32. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (35361) AND `source_type` IN(0);
  33. DELETE FROM `smart_scripts` WHERE `entryorguid` IN (35361*100) AND `source_type` IN(9);
  34. 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
  35. (35361, 0, 0, 0, 11, 0, 100, 1, 0, 0, 0, 0, 0, 53, 0, 35361, 0, 0, 1000, 0, 0, 6062, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Tirion - On Game Event 1060 Start - Start WP'),
  36. (35361, 0, 1, 0, 40, 0, 100, 1, 7, 35361, 0, 0, 0, 84, 0, 0, 0, 0, 0, 0, 0, 0, 10, 35382, 35501, 0, 0, 0, 0, 0, 0, 'WP REACH - Say'),
  37. (35361, 0, 2, 3, 40, 0, 100, 1, 32, 35361, 0, 0, 0, 54, 93003, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'WP REACH - PAUSE'),
  38. (35361, 0, 3, 0, 61, 0, 100, 1, 0, 0, 0, 0, 0, 80, 35361*100, 2, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - TS'),
  39.  
  40. (35361*100, 9, 0, 0, 0, 0, 100, 1, 125, 125, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY'),
  41. (35361*100, 9, 1, 0, 0, 0, 100, 1, 9331, 9331, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY'),
  42. (35361*100, 9, 2, 0, 0, 0, 100, 1, 9711, 9711, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY'),
  43. (35361*100, 9, 3, 0, 0, 0, 100, 1, 6085, 6085, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY'),
  44. (35361*100, 9, 4, 0, 0, 0, 100, 1, 13370, 13370, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY'),
  45. (35361*100, 9, 5, 0, 0, 0, 100, 1, 12107, 12107, 0, 0, 0, 1, 5, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY'),
  46. (35361*100, 9, 6, 0, 0, 0, 100, 1, 14574, 14574, 0, 0, 0, 1, 6, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY'),
  47. (35361*100, 9, 7, 0, 0, 0, 100, 1, 12163, 12163, 0, 0, 0, 1, 7, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY'),
  48. (35361*100, 9, 8, 0, 0, 0, 100, 1, 9587, 9587, 0, 0, 0, 5, 5, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY'),
  49. (35361*100, 9, 9, 0, 0, 0, 100, 1, 3642, 3642, 0, 0, 0, 5, 397, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'TS - SAY');
  50.  
  51.  
  52. DELETE FROM `waypoints` WHERE entry = 35361;
  53. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  54.  
  55.  
  56. -- Сегмент 1
  57. (35361, 0, 8515.224, 882.30365, 558.4176, 'WayPoint 1'), -- prev_dist: — | .go 8515.224, 882.30365, 558.4176 -- WayPoint 1 ++
  58. (35361, 1, 8515.224, 883.30365, 558.4176, 'WayPoint 2'), -- prev_dist: 1.09 | .go 8515.224, 883.30365, 558.4176 -- WayPoint 2 ++
  59. (35361, 2, 8515.345, 907.9549, 547.1799, 'Point 1'), -- prev_dist: 24.52 | .go 8515.345, 907.9549, 547.1799 -- Point 1 ++
  60.  
  61. -- Сегмент 2
  62. (35361, 3, 8515.41, 919.31104, 547.6386, 'WayPoint 6'), -- prev_dist: 12.03 | .go 8515.41, 919.31104, 547.6386 -- WayPoint 6
  63. (35361, 4, 8515.66, 925.06104, 547.8886, 'WayPoint 7'), -- prev_dist: 6.61 | .go 8515.66, 925.06104, 547.8886 -- WayPoint 7
  64. (35361, 5, 8515.724, 933.0382, 547.55383, 'Point 2'), -- prev_dist: 8.78 | .go 8515.724, 933.0382, 547.55383 -- Point 2
  65.  
  66. -- Сегмент 3
  67. (35361, 6, 8515.119, 964.8108, 547.47015, 'Point 3'), -- prev_dist: 31.55 | .go 8515.119, 964.8108, 547.47015 -- Point 3
  68.  
  69. -- Сегмент 4
  70. (35361, 7, 8515.473, 997.53125, 547.47015, 'Point 4'), -- prev_dist: 32.76 | .go 8515.473, 997.53125, 547.47015 -- Point 4
  71.  
  72. -- Сегмент 5
  73. (35361, 8, 8515.443, 1012.5035, 547.47015, 'Point 5'), -- prev_dist: 14.93 | .go 8515.443, 1012.5035, 547.47015 -- Point 5
  74.  
  75. -- Сегмент 6
  76. (35361, 9, 8507.748, 1021.4761, 547.3815, 'WayPoint 12'), -- prev_dist: 9.30 | .go 8507.748, 1021.4761, 547.3815 -- WayPoint 12
  77. (35361, 10, 8505.039, 1024.2552, 547.2927, 'Point 6'), -- prev_dist: 4.26 | .go 8505.039, 1024.2552, 547.2927 -- Point 6
  78.  
  79. -- Сегмент 7
  80. (35361, 11, 8488.572, 1022.4636, 547.3068, 'Point 7'), -- prev_dist: 18.10 | .go 8488.572, 1022.4636, 547.3068 -- Point 7
  81.  
  82. -- Сегмент 8
  83. (35361, 12, 8477.175, 1011.3143, 547.29266, 'Point 8'), -- prev_dist: 14.42 | .go 8477.175, 1011.3143, 547.29266 -- Point 8
  84.  
  85. -- Сегмент 9
  86. (35361, 13, 8476.75, 979.3264, 547.29266, 'Point 9'), -- prev_dist: 32.55 | .go 8476.75, 979.3264, 547.29266 -- Point 9
  87.  
  88. -- Сегмент 10
  89. (35361, 14, 8477.176, 957.4167, 547.29266, 'Point 10'), -- prev_dist: 22.06 | .go 8477.176, 957.4167, 547.29266 -- Point 10
  90.  
  91. -- Сегмент 11
  92. (35361, 15, 8476.847, 931.9757, 547.29346, 'Point 11'), -- prev_dist: 25.42 | .go 8476.847, 931.9757, 547.29346 -- Point 11
  93.  
  94. -- Сегмент 12
  95. (35361, 16, 8471.972, 895.5625, 547.29266, 'Point 12'), -- prev_dist: 36.53 | .go 8471.972, 895.5625, 547.29266 -- Point 12
  96.  
  97. -- Сегмент 13
  98. (35361, 17, 8469.604, 875.2882, 547.29266, 'Point 13'), -- prev_dist: 20.34 | .go 8469.604, 875.2882, 547.29266 -- Point 13
  99.  
  100. -- Сегмент 14
  101. (35361, 18, 8458.653, 868.74133, 547.29266, 'Point 14'), -- prev_dist: 12.20 | .go 8458.653, 868.74133, 547.29266 -- Point 14
  102.  
  103. -- Сегмент 15
  104. (35361, 19, 8447.609, 869.55554, 547.29266, 'Point 15'), -- prev_dist: 11.43 | .go 8447.609, 869.55554, 547.29266 -- Point 15
  105.  
  106. -- Сегмент 16
  107. (35361, 20, 8439.721, 864.42017, 547.29266, 'Point 16'), -- prev_dist: 9.04 | .go 8439.721, 864.42017, 547.29266 -- Point 16
  108.  
  109. -- Сегмент 17
  110. (35361, 21, 8435.716, 840.38196, 547.29266, 'Point 17'), -- prev_dist: 24.18 | .go 8435.716, 840.38196, 547.29266 -- Point 17
  111.  
  112. -- Сегмент 18
  113. (35361, 22, 8431.082, 829.7786, 547.7235, 'WayPoint 25'), -- prev_dist: 11.82 | .go 8431.082, 829.7786, 547.7235 -- WayPoint 25
  114. (35361, 23, 8429.75, 826.98956, 547.65436, 'Point 18'), -- prev_dist: 3.11 | .go 8429.75, 826.98956, 547.65436 -- Point 18
  115.  
  116. -- Сегмент 19
  117. (35361, 24, 8427.604, 825.03564, 548.10516, 'WayPoint 28'), -- prev_dist: 3.02 | .go 8427.604, 825.03564, 548.10516 -- WayPoint 28
  118. (35361, 25, 8426.604, 823.53564, 548.35516, 'WayPoint 29'), -- prev_dist: 1.84 | .go 8426.604, 823.53564, 548.35516 -- WayPoint 29
  119. (35361, 26, 8422.285, 819.19446, 548.2012, 'Point 19'), -- prev_dist: 5.19 | .go 8422.285, 819.19446, 548.2012 -- Point 19
  120.  
  121. -- Сегмент 20
  122. (35361, 27, 8421.18, 819.29956, 548.2444, 'WayPoint 31'), -- prev_dist: 1.09 | .go 8421.18, 819.29956, 548.2444 -- WayPoint 31
  123. (35361, 28, 8420.18, 819.29956, 547.9944, 'WayPoint 32'), -- prev_dist: 1.09 | .go 8420.18, 819.29956, 547.9944 -- WayPoint 32
  124. (35361, 29, 8419.18, 819.29956, 547.7444, 'WayPoint 33'), -- prev_dist: 1.09 | .go 8419.18, 819.29956, 547.7444 -- WayPoint 33
  125. (35361, 30, 8411.253, 818.5035, 547.29285, 'Point 20'), -- prev_dist: 8.14 | .go 8411.253, 818.5035, 547.29285 -- Point 20
  126.  
  127. -- Сегмент 21
  128. (35361, 31, 8411.196, 819.83496, 547.5965, 'WayPoint 36'), -- prev_dist: 0.82 | .go 8411.196, 819.83496, 547.5965 -- WayPoint 36
  129. (35361, 32, 8410.82, 823.86456, 549.8405, 'Point 21'), -- prev_dist: 0.53 | .go 8410.82, 823.86456, 549.8405 -- Point 21
  130.  
  131. -- Сегмент 22
  132. (35361, 33, 8410.824, 826.7101, 549.8283, 'Point 22'), -- prev_dist: 2.89 | .go 8410.824, 826.7101, 549.8283 -- Point 22 -- Speech
  133.  
  134. -- Сегмент 23
  135. (35361, 34, 8411.066, 823.7274, 550.0732, 'WayPoint 42'), -- prev_dist: 0.29 | .go 8411.066, 823.7274, 550.0732 -- WayPoint 42
  136. (35361, 35, 8414.816, 822.4774, 549.3232, 'WayPoint 43'), -- prev_dist: 4.12 | .go 8414.816, 822.4774, 549.3232 -- WayPoint 43
  137. (35361, 36, 8420.816, 823.2274, 547.8232, 'WayPoint 45'), -- prev_dist: 5.47 | .go 8420.816, 823.2274, 547.8232 -- WayPoint 45
  138. (35361, 37, 8422.566, 823.4774, 548.0732, 'WayPoint 46'), -- prev_dist: 1.93 | .go 8422.566, 823.4774, 548.0732 -- WayPoint 46
  139. (35361, 38, 8429.316, 824.9774, 548.0732, 'WayPoint 48'), -- prev_dist: 5.47 | .go 8429.316, 824.9774, 548.0732 -- WayPoint 48
  140. (35361, 39, 8433.81, 825.7448, 547.31805, 'Point 23'), -- prev_dist: 2.72 | .go 8433.81, 825.7448, 547.31805 -- Point 23
  141.  
  142. -- Сегмент 24
  143. (35361, 40, 8440.775, 861.7101, 547.29266, 'Point 24'), -- prev_dist: 36.09 | .go 8440.775, 861.7101, 547.29266 -- Point 24
  144.  
  145. -- Сегмент 25
  146. (35361, 41, 8464.726, 873.53644, 547.31976, 'Point 25'), -- prev_dist: 24.07 | .go 8464.726, 873.53644, 547.31976 -- Point 25
  147.  
  148. -- Сегмент 26
  149. (35361, 42, 8466.572, 883.52386, 548.0348, 'WayPoint 57'), -- prev_dist: 2.19 | .go 8466.572, 883.52386, 548.0348 -- WayPoint 57
  150. (35361, 43, 8467.822, 889.27386, 547.5348, 'WayPoint 59'), -- prev_dist: 4.37 | .go 8467.822, 889.27386, 547.5348 -- WayPoint 59
  151. (35361, 44, 8468.322, 891.27386, 547.7848, 'WayPoint 60'), -- prev_dist: 2.19 | .go 8468.322, 891.27386, 547.7848 -- WayPoint 60
  152. (35361, 45, 8468.822, 894.02386, 547.5348, 'WayPoint 61'), -- prev_dist: 2.73 | .go 8468.822, 894.02386, 547.5348 -- WayPoint 61
  153. (35361, 46, 8469.929, 899.9844, 547.25555, 'Point 26'), -- prev_dist: 5.82 | .go 8469.929, 899.9844, 547.25555 -- Point 26
  154.  
  155. -- Сегмент 27
  156. (35361, 47, 8476.481, 926.3351, 547.29266, 'Point 27'), -- prev_dist: 26.27 | .go 8476.481, 926.3351, 547.29266 -- Point 27
  157.  
  158. -- Сегмент 28
  159. (35361, 48, 8476.862, 953.03125, 547.29266, 'Point 28'), -- prev_dist: 26.39 | .go 8476.862, 953.03125, 547.29266 -- Point 28
  160.  
  161. -- Сегмент 29
  162. (35361, 49, 8477.09, 987.23956, 547.29266, 'Point 29'), -- prev_dist: 34.25 | .go 8477.09, 987.23956, 547.29266 -- Point 29
  163.  
  164. -- Сегмент 30
  165. (35361, 50, 8478.45, 1009.6198, 547.3533, 'Point 30'), -- prev_dist: 22.37 | .go 8478.45, 1009.6198, 547.3533 -- Point 30
  166.  
  167. -- Сегмент 31
  168. (35361, 51, 8488.758, 1013.2058, 548.7428, 'WayPoint 69'), -- prev_dist: 13.13 | .go 8488.758, 1013.2058, 548.7428 -- WayPoint 69
  169. (35361, 52, 8490.758, 1013.9558, 548.9928, 'WayPoint 70'), -- prev_dist: 2.24 | .go 8490.758, 1013.9558, 548.9928 -- WayPoint 70
  170. (35361, 53, 8497.206, 1016.1024, 548.6386, 'Point 31'), -- prev_dist: 4.37 | .go 8497.206, 1016.1024, 548.6386 -- Point 31
  171.  
  172. -- Сегмент 32
  173. (35361, 54, 8500.346, 1016.15717, 548.61646, 'WayPoint 79'), -- prev_dist: 3.28 | .go 8500.346, 1016.15717, 548.61646 -- WayPoint 79
  174. (35361, 55, 8507.096, 1016.15717, 548.11646, 'WayPoint 80'), -- prev_dist: 7.37 | .go 8507.096, 1016.15717, 548.11646 -- WayPoint 80
  175. (35361, 56, 8515.049, 1016.1094, 547.47015, 'Point 32'), -- prev_dist: 5.77 | .go 8515.049, 1016.1094, 547.47015 -- Point 32
  176.  
  177. -- Сегмент 33
  178. (35361, 57, 8514.734, 985.2101, 547.47015, 'Point 33'), -- prev_dist: 31.02 | .go 8514.734, 985.2101, 547.47015 -- Point 33
  179.  
  180. -- Сегмент 34
  181. (35361, 58, 8513.855, 960.7274, 547.47015, 'Point 34'), -- prev_dist: 24.26 | .go 8513.855, 960.7274, 547.47015 -- Point 34
  182.  
  183. -- Сегмент 35
  184. (35361, 59, 8514.587, 926.6441, 547.5838, 'Point 35'), -- prev_dist: 33.77 | .go 8514.587, 926.6441, 547.5838 -- Point 35
  185.  
  186. -- Сегмент 36
  187. (35361, 60, 8512.683, 925.0258, 547.8898, 'WayPoint 87'), -- prev_dist: 2.76 | .go 8512.683, 925.0258, 547.8898 -- WayPoint 87
  188. (35361, 61, 8512.683, 919.0258, 547.6398, 'WayPoint 88'), -- prev_dist: 6.56 | .go 8512.683, 919.0258, 547.6398 -- WayPoint 88
  189. (35361, 62, 8512.683, 916.7758, 547.6398, 'WayPoint 89'), -- prev_dist: 2.19 | .go 8512.683, 916.7758, 547.6398 -- WayPoint 89
  190. (35361, 63, 8513.183, 908.7758, 547.6398, 'WayPoint 90'), -- prev_dist: 6.56 | .go 8513.183, 908.7758, 547.6398 -- WayPoint 90
  191. (35361, 64, 8515.335, 891.7778, 554.2045, 'Point 36'), -- prev_dist: 9.35 | .go 8515.335, 891.7778, 554.2045 -- Point 36
  192.  
  193. -- Сегмент 37
  194. (35361, 65, 8515.333, 882.9192, 558.2311, 'WayPoint 92'), -- prev_dist: 9.56 | .go 8515.333, 882.9192, 558.2311 -- WayPoint 92
  195. (35361, 66, 8515.333, 855.1692, 558.2311, 'WayPoint 94'), -- prev_dist: 27.01 | .go 8515.333, 855.1692, 558.2311 -- WayPoint 94
  196. (35361, 67, 8515.287, 853.75696, 558.14044, 'Point 37'); -- prev_dist: 1.43 | .go 8515.287, 853.75696, 558.14044 -- Point 37
Advertisement
Add Comment
Please, Sign In to add comment