Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE `creature_template` SET `unit_flags` = 524624, `unit_flags2` = 2099200, `unit_flags3` = 1073741825 WHERE `entry` IN (36065,36066);
- -- 1. ТИРИОН
- DELETE FROM `creature` WHERE `id`=35361;
- 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
- (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);
- -- его спавн 100% 8516.2294921875, 855.98614501953125, 558.2279052734375, 1.620458722114562988
- -- 3. ТЕКСТЫ
- DELETE FROM `creature_text` WHERE `entry` IN(35361,35501);
- INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES
- (35501, 0, 0, 'Верховный лорд Тирион Фордринг подходит к арене, чтобы обратиться к прибывшим на турнир! Выслушайте его!', 14, 0, 100, 22, 0, 0, 'Herald Beluus',35812),
- (35361, 0, 0, 'Бойцы Орды и Альянса! Приветствуем вас под знаменами Серебряного Авангарда!', 12, 0, 100, 5, 0, 0, 'Highlord Tirion Fordring',35799),
- (35361, 1, 0, 'Цель наша находится на юге. Мы дойдем до цитадели и ударим в самое сердце логова Плети.', 12, 0, 100, 25, 0, 0, 'Highlord Tirion Fordring',35800),
- (35361, 2, 0, 'Но к этому заданию нельзя подходить легкомысленно.', 12, 0, 100, 0, 0, 0, 'Highlord Tirion Fordring',35801),
- (35361, 3, 0, 'Мы не можем просто собрать всех, кто способен держать в руках оружие, и выступить в поход – это закончится бессмысленным кровопролитием.', 12, 0, 100, 0, 0, 0, 'Highlord Tirion Fordring',35802),
- (35361, 4, 0, 'Вместо этого мы соберем группу лучших воинов и нанесем сокрушительный удар. Ради этого мы и создали Серебряный Турнир.', 12, 0, 100, 0, 0, 0, 'Highlord Tirion Fordring',35803),
- (35361, 5, 0, 'В этих стенах мы испытаем твое искусство боя против самых смертоносных обитателей Нордскола, и предводители оценят твое мастерство.', 12, 0, 100, 0, 0, 0, 'Highlord Tirion Fordring',35805),
- (35361, 6, 0, 'Мы будем оценивать твою смелость, твою силу и ловкость. Эти игры покажут все лучшее, на что способны обитатели Азерота.', 12, 0, 100, 0, 0, 0, 'Highlord Tirion Fordring',35806),
- (35361, 7, 0, 'Победители займут достойное место в рядах войска, которое выступит на цитадель. Мы сплотимся перед лицом врага, и Артас падет!', 12, 0, 100, 0, 0, 0, 'Highlord Tirion Fordring',35807);
- -- 4. ОБНОВЛЕНИЕ ТЕМПЛЕЙТОВ
- UPDATE `creature_template` SET `speed_walk` = 1.5 WHERE `entry` = 35361;
- UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN(35361,35501);
- DELETE FROM `creature_template_addon` WHERE `entry`=35361;
- INSERT INTO `creature_template_addon` (`entry`, `mount`, `StandState`, `SheathState`, `auras`) VALUES
- (35361, 0, 0, 1, '57545');
- -- 5. SMART_SCRIPTS
- DELETE FROM `smart_scripts` WHERE `entryorguid` IN (35361) AND `source_type` IN(0);
- DELETE FROM `smart_scripts` WHERE `entryorguid` IN (35361*100) AND `source_type` IN(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
- (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'),
- (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'),
- (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'),
- (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'),
- (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'),
- (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'),
- (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'),
- (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'),
- (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'),
- (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'),
- (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'),
- (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'),
- (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'),
- (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');
- DELETE FROM `waypoints` WHERE entry = 35361;
- INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
- -- Сегмент 1
- (35361, 0, 8515.224, 882.30365, 558.4176, 'WayPoint 1'), -- prev_dist: — | .go 8515.224, 882.30365, 558.4176 -- WayPoint 1 ++
- (35361, 1, 8515.224, 883.30365, 558.4176, 'WayPoint 2'), -- prev_dist: 1.09 | .go 8515.224, 883.30365, 558.4176 -- WayPoint 2 ++
- (35361, 2, 8515.345, 907.9549, 547.1799, 'Point 1'), -- prev_dist: 24.52 | .go 8515.345, 907.9549, 547.1799 -- Point 1 ++
- -- Сегмент 2
- (35361, 3, 8515.41, 919.31104, 547.6386, 'WayPoint 6'), -- prev_dist: 12.03 | .go 8515.41, 919.31104, 547.6386 -- WayPoint 6
- (35361, 4, 8515.66, 925.06104, 547.8886, 'WayPoint 7'), -- prev_dist: 6.61 | .go 8515.66, 925.06104, 547.8886 -- WayPoint 7
- (35361, 5, 8515.724, 933.0382, 547.55383, 'Point 2'), -- prev_dist: 8.78 | .go 8515.724, 933.0382, 547.55383 -- Point 2
- -- Сегмент 3
- (35361, 6, 8515.119, 964.8108, 547.47015, 'Point 3'), -- prev_dist: 31.55 | .go 8515.119, 964.8108, 547.47015 -- Point 3
- -- Сегмент 4
- (35361, 7, 8515.473, 997.53125, 547.47015, 'Point 4'), -- prev_dist: 32.76 | .go 8515.473, 997.53125, 547.47015 -- Point 4
- -- Сегмент 5
- (35361, 8, 8515.443, 1012.5035, 547.47015, 'Point 5'), -- prev_dist: 14.93 | .go 8515.443, 1012.5035, 547.47015 -- Point 5
- -- Сегмент 6
- (35361, 9, 8507.748, 1021.4761, 547.3815, 'WayPoint 12'), -- prev_dist: 9.30 | .go 8507.748, 1021.4761, 547.3815 -- WayPoint 12
- (35361, 10, 8505.039, 1024.2552, 547.2927, 'Point 6'), -- prev_dist: 4.26 | .go 8505.039, 1024.2552, 547.2927 -- Point 6
- -- Сегмент 7
- (35361, 11, 8488.572, 1022.4636, 547.3068, 'Point 7'), -- prev_dist: 18.10 | .go 8488.572, 1022.4636, 547.3068 -- Point 7
- -- Сегмент 8
- (35361, 12, 8477.175, 1011.3143, 547.29266, 'Point 8'), -- prev_dist: 14.42 | .go 8477.175, 1011.3143, 547.29266 -- Point 8
- -- Сегмент 9
- (35361, 13, 8476.75, 979.3264, 547.29266, 'Point 9'), -- prev_dist: 32.55 | .go 8476.75, 979.3264, 547.29266 -- Point 9
- -- Сегмент 10
- (35361, 14, 8477.176, 957.4167, 547.29266, 'Point 10'), -- prev_dist: 22.06 | .go 8477.176, 957.4167, 547.29266 -- Point 10
- -- Сегмент 11
- (35361, 15, 8476.847, 931.9757, 547.29346, 'Point 11'), -- prev_dist: 25.42 | .go 8476.847, 931.9757, 547.29346 -- Point 11
- -- Сегмент 12
- (35361, 16, 8471.972, 895.5625, 547.29266, 'Point 12'), -- prev_dist: 36.53 | .go 8471.972, 895.5625, 547.29266 -- Point 12
- -- Сегмент 13
- (35361, 17, 8469.604, 875.2882, 547.29266, 'Point 13'), -- prev_dist: 20.34 | .go 8469.604, 875.2882, 547.29266 -- Point 13
- -- Сегмент 14
- (35361, 18, 8458.653, 868.74133, 547.29266, 'Point 14'), -- prev_dist: 12.20 | .go 8458.653, 868.74133, 547.29266 -- Point 14
- -- Сегмент 15
- (35361, 19, 8447.609, 869.55554, 547.29266, 'Point 15'), -- prev_dist: 11.43 | .go 8447.609, 869.55554, 547.29266 -- Point 15
- -- Сегмент 16
- (35361, 20, 8439.721, 864.42017, 547.29266, 'Point 16'), -- prev_dist: 9.04 | .go 8439.721, 864.42017, 547.29266 -- Point 16
- -- Сегмент 17
- (35361, 21, 8435.716, 840.38196, 547.29266, 'Point 17'), -- prev_dist: 24.18 | .go 8435.716, 840.38196, 547.29266 -- Point 17
- -- Сегмент 18
- (35361, 22, 8431.082, 829.7786, 547.7235, 'WayPoint 25'), -- prev_dist: 11.82 | .go 8431.082, 829.7786, 547.7235 -- WayPoint 25
- (35361, 23, 8429.75, 826.98956, 547.65436, 'Point 18'), -- prev_dist: 3.11 | .go 8429.75, 826.98956, 547.65436 -- Point 18
- -- Сегмент 19
- (35361, 24, 8427.604, 825.03564, 548.10516, 'WayPoint 28'), -- prev_dist: 3.02 | .go 8427.604, 825.03564, 548.10516 -- WayPoint 28
- (35361, 25, 8426.604, 823.53564, 548.35516, 'WayPoint 29'), -- prev_dist: 1.84 | .go 8426.604, 823.53564, 548.35516 -- WayPoint 29
- (35361, 26, 8422.285, 819.19446, 548.2012, 'Point 19'), -- prev_dist: 5.19 | .go 8422.285, 819.19446, 548.2012 -- Point 19
- -- Сегмент 20
- (35361, 27, 8421.18, 819.29956, 548.2444, 'WayPoint 31'), -- prev_dist: 1.09 | .go 8421.18, 819.29956, 548.2444 -- WayPoint 31
- (35361, 28, 8420.18, 819.29956, 547.9944, 'WayPoint 32'), -- prev_dist: 1.09 | .go 8420.18, 819.29956, 547.9944 -- WayPoint 32
- (35361, 29, 8419.18, 819.29956, 547.7444, 'WayPoint 33'), -- prev_dist: 1.09 | .go 8419.18, 819.29956, 547.7444 -- WayPoint 33
- (35361, 30, 8411.253, 818.5035, 547.29285, 'Point 20'), -- prev_dist: 8.14 | .go 8411.253, 818.5035, 547.29285 -- Point 20
- -- Сегмент 21
- (35361, 31, 8411.196, 819.83496, 547.5965, 'WayPoint 36'), -- prev_dist: 0.82 | .go 8411.196, 819.83496, 547.5965 -- WayPoint 36
- (35361, 32, 8410.82, 823.86456, 549.8405, 'Point 21'), -- prev_dist: 0.53 | .go 8410.82, 823.86456, 549.8405 -- Point 21
- -- Сегмент 22
- (35361, 33, 8410.824, 826.7101, 549.8283, 'Point 22'), -- prev_dist: 2.89 | .go 8410.824, 826.7101, 549.8283 -- Point 22 -- Speech
- -- Сегмент 23
- (35361, 34, 8411.066, 823.7274, 550.0732, 'WayPoint 42'), -- prev_dist: 0.29 | .go 8411.066, 823.7274, 550.0732 -- WayPoint 42
- (35361, 35, 8414.816, 822.4774, 549.3232, 'WayPoint 43'), -- prev_dist: 4.12 | .go 8414.816, 822.4774, 549.3232 -- WayPoint 43
- (35361, 36, 8420.816, 823.2274, 547.8232, 'WayPoint 45'), -- prev_dist: 5.47 | .go 8420.816, 823.2274, 547.8232 -- WayPoint 45
- (35361, 37, 8422.566, 823.4774, 548.0732, 'WayPoint 46'), -- prev_dist: 1.93 | .go 8422.566, 823.4774, 548.0732 -- WayPoint 46
- (35361, 38, 8429.316, 824.9774, 548.0732, 'WayPoint 48'), -- prev_dist: 5.47 | .go 8429.316, 824.9774, 548.0732 -- WayPoint 48
- (35361, 39, 8433.81, 825.7448, 547.31805, 'Point 23'), -- prev_dist: 2.72 | .go 8433.81, 825.7448, 547.31805 -- Point 23
- -- Сегмент 24
- (35361, 40, 8440.775, 861.7101, 547.29266, 'Point 24'), -- prev_dist: 36.09 | .go 8440.775, 861.7101, 547.29266 -- Point 24
- -- Сегмент 25
- (35361, 41, 8464.726, 873.53644, 547.31976, 'Point 25'), -- prev_dist: 24.07 | .go 8464.726, 873.53644, 547.31976 -- Point 25
- -- Сегмент 26
- (35361, 42, 8466.572, 883.52386, 548.0348, 'WayPoint 57'), -- prev_dist: 2.19 | .go 8466.572, 883.52386, 548.0348 -- WayPoint 57
- (35361, 43, 8467.822, 889.27386, 547.5348, 'WayPoint 59'), -- prev_dist: 4.37 | .go 8467.822, 889.27386, 547.5348 -- WayPoint 59
- (35361, 44, 8468.322, 891.27386, 547.7848, 'WayPoint 60'), -- prev_dist: 2.19 | .go 8468.322, 891.27386, 547.7848 -- WayPoint 60
- (35361, 45, 8468.822, 894.02386, 547.5348, 'WayPoint 61'), -- prev_dist: 2.73 | .go 8468.822, 894.02386, 547.5348 -- WayPoint 61
- (35361, 46, 8469.929, 899.9844, 547.25555, 'Point 26'), -- prev_dist: 5.82 | .go 8469.929, 899.9844, 547.25555 -- Point 26
- -- Сегмент 27
- (35361, 47, 8476.481, 926.3351, 547.29266, 'Point 27'), -- prev_dist: 26.27 | .go 8476.481, 926.3351, 547.29266 -- Point 27
- -- Сегмент 28
- (35361, 48, 8476.862, 953.03125, 547.29266, 'Point 28'), -- prev_dist: 26.39 | .go 8476.862, 953.03125, 547.29266 -- Point 28
- -- Сегмент 29
- (35361, 49, 8477.09, 987.23956, 547.29266, 'Point 29'), -- prev_dist: 34.25 | .go 8477.09, 987.23956, 547.29266 -- Point 29
- -- Сегмент 30
- (35361, 50, 8478.45, 1009.6198, 547.3533, 'Point 30'), -- prev_dist: 22.37 | .go 8478.45, 1009.6198, 547.3533 -- Point 30
- -- Сегмент 31
- (35361, 51, 8488.758, 1013.2058, 548.7428, 'WayPoint 69'), -- prev_dist: 13.13 | .go 8488.758, 1013.2058, 548.7428 -- WayPoint 69
- (35361, 52, 8490.758, 1013.9558, 548.9928, 'WayPoint 70'), -- prev_dist: 2.24 | .go 8490.758, 1013.9558, 548.9928 -- WayPoint 70
- (35361, 53, 8497.206, 1016.1024, 548.6386, 'Point 31'), -- prev_dist: 4.37 | .go 8497.206, 1016.1024, 548.6386 -- Point 31
- -- Сегмент 32
- (35361, 54, 8500.346, 1016.15717, 548.61646, 'WayPoint 79'), -- prev_dist: 3.28 | .go 8500.346, 1016.15717, 548.61646 -- WayPoint 79
- (35361, 55, 8507.096, 1016.15717, 548.11646, 'WayPoint 80'), -- prev_dist: 7.37 | .go 8507.096, 1016.15717, 548.11646 -- WayPoint 80
- (35361, 56, 8515.049, 1016.1094, 547.47015, 'Point 32'), -- prev_dist: 5.77 | .go 8515.049, 1016.1094, 547.47015 -- Point 32
- -- Сегмент 33
- (35361, 57, 8514.734, 985.2101, 547.47015, 'Point 33'), -- prev_dist: 31.02 | .go 8514.734, 985.2101, 547.47015 -- Point 33
- -- Сегмент 34
- (35361, 58, 8513.855, 960.7274, 547.47015, 'Point 34'), -- prev_dist: 24.26 | .go 8513.855, 960.7274, 547.47015 -- Point 34
- -- Сегмент 35
- (35361, 59, 8514.587, 926.6441, 547.5838, 'Point 35'), -- prev_dist: 33.77 | .go 8514.587, 926.6441, 547.5838 -- Point 35
- -- Сегмент 36
- (35361, 60, 8512.683, 925.0258, 547.8898, 'WayPoint 87'), -- prev_dist: 2.76 | .go 8512.683, 925.0258, 547.8898 -- WayPoint 87
- (35361, 61, 8512.683, 919.0258, 547.6398, 'WayPoint 88'), -- prev_dist: 6.56 | .go 8512.683, 919.0258, 547.6398 -- WayPoint 88
- (35361, 62, 8512.683, 916.7758, 547.6398, 'WayPoint 89'), -- prev_dist: 2.19 | .go 8512.683, 916.7758, 547.6398 -- WayPoint 89
- (35361, 63, 8513.183, 908.7758, 547.6398, 'WayPoint 90'), -- prev_dist: 6.56 | .go 8513.183, 908.7758, 547.6398 -- WayPoint 90
- (35361, 64, 8515.335, 891.7778, 554.2045, 'Point 36'), -- prev_dist: 9.35 | .go 8515.335, 891.7778, 554.2045 -- Point 36
- -- Сегмент 37
- (35361, 65, 8515.333, 882.9192, 558.2311, 'WayPoint 92'), -- prev_dist: 9.56 | .go 8515.333, 882.9192, 558.2311 -- WayPoint 92
- (35361, 66, 8515.333, 855.1692, 558.2311, 'WayPoint 94'), -- prev_dist: 27.01 | .go 8515.333, 855.1692, 558.2311 -- WayPoint 94
- (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