Красногорье - Спасение штейгера Ослоу

**Премудрый** · 17.10.2021, 15:13

1. Задание: https://ru.wowhead.com/quest=26520
2. После подчинения Эттина, не показывает на карте зону выполнения задания.
3. Должна быть указана на камень.
4. BFA/PTR

**Thermaplugg** · 20.01.2023, 01:58

чтобы не создавать новую тему, дополню эту

2. при использовании предмета https://www.wowhead.com/item=58895 на https://www.wowhead.com/npc=43094 задание автоматически завершается не дав подчинить https://www.wowhead.com/npc=43197 для дальнейшего прохождения и с игрока слетает детект инвиз аура или персональная фаза
3. как должно быть https://www.youtube.com/watch?v=fZsGozzFBr4
4. 19.01.23 / Realm BFA
5. неизвестно
6. -
7. баг постоянен

просто оставлю это тут

Скрытый текст

Код:

-- Quest: 26520 / Saving Foreman Oslow

UPDATE `creature_template` SET `faction`=12, `unit_flags`=0, `AIName`='SmartAI', `ScriptName`='' WHERE `entry`=341;
UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`=''/*npc_bridge_worker_alex AND npc_canyon_ettin*/ WHERE `entry` IN (43094, 43197, 648, 649, 650, 651, 652, 653);
UPDATE `creature_template_addon` SET `bytes1`=0, `emote`=0 WHERE `entry` IN (341, 648, 649, 650, 651, 652, 653);
UPDATE `creature_addon` SET `bytes1`=0, `emote`=0 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (341, 648, 649, 650, 651, 652, 653));

DELETE FROM `conditions` WHERE `SourceEntry` IN (80704, 80702) AND `SourceTypeOrReferenceId` IN (13, 17);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(13, 2, 80704, 0, 0, 31, 0, 3, 43197, 0, 0, 0, 0, '', 'Effect_1 hits Subdued Canyon Ettin'),
(13, 2, 80704, 0, 1, 31, 0, 3, 43094, 0, 0, 0, 0, '', 'Effect_1 hits Canyon Ettin'),
(17, 0, 80704, 0, 0, 29, 0, 341, 15, 0, 0, 0, 0, '', 'Control Ettin can only be used Near npc'),
(17, 0, 80704, 0, 1, 29, 0, 43094, 15, 0, 0, 0, 0, '', 'Control Ettin can only be used Near npc');

DELETE FROM `smart_scripts` WHERE `entryorguid` IN (341, 648, 649, 650, 651, 652, 653, 43094, 43197) AND `source_type`=0 OR `entryorguid` IN (3410000, 3410001, 3410002, 3410003, 3410004, 3410005, 3410006, 3410007, 3410008, 3410009) AND `source_type`=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`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
(341, 0, 0, 1, 1, 0, 100, 1, 1, 1, 0, 0, 18, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Respawn - Set Immune Flags'),
(341, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 90, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Respawn - Set Dead Emote'),
(341, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 80, 3410000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Respawn - Run Script'),
(3410000, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 19, 648, 5, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Store Target'),
(3410000, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 64, 2, 0, 0, 0, 0, 0, 19, 649, 5, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Store Target'),
(3410000, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 64, 3, 0, 0, 0, 0, 0, 19, 650, 5, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Store Target'),
(3410000, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 64, 4, 0, 0, 0, 0, 0, 19, 651, 5, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Store Target'),
(3410000, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 64, 5, 0, 0, 0, 0, 0, 19, 652, 5, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Store Target'),
(3410000, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 64, 6, 0, 0, 0, 0, 0, 19, 653, 5, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Store Target'),
(3410000, 9, 6, 0, 0, 0, 100, 0, 1, 1, 0, 0, 17, 431, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Play Emote Bridge Worker Trent'),
(3410000, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 431, 0, 0, 0, 0, 0, 12, 2, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Play Emote Bridge Worker Dimitri'),
(3410000, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 431, 0, 0, 0, 0, 0, 12, 3, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Play Emote Bridge Worker Jess'),
(3410000, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 431, 0, 0, 0, 0, 0, 12, 4, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Play Emote Bridge Worker Daniel'),
(3410000, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 431, 0, 0, 0, 0, 0, 12, 5, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Play Emote Bridge Worker Matthew'),
(3410000, 9, 11, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 431, 0, 0, 0, 0, 0, 12, 6, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Play Emote Bridge Worker Alex'),
(3410000, 9, 12, 0, 0, 0, 100, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Set Phase 1'),
(341, 0, 3, 0, 1, 1, 100, 0, 0, 0, 90000, 90000, 1, 0, 4000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - OOC - Say Line Self'),
(341, 0, 4, 0, 52, 0, 100, 0, 0, 341, 0, 0, 87, 3410001, 3410002, 3410003, 3410004, 3410005, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Text Over - Run Random Script'),
(3410001, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 2000, 0, 0, 0, 0, 12, 6, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Say Line Bridge Worker Alex'),
(3410002, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 1, 2000, 0, 0, 0, 0, 12, 6, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Say Line Bridge Worker Alex'),
(3410003, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 2, 2000, 0, 0, 0, 0, 12, 6, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Say Line Bridge Worker Alex'),
(3410004, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 3, 2000, 0, 0, 0, 0, 12, 6, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Say Line Bridge Worker Alex'),
(3410005, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 4, 2000, 0, 0, 0, 0, 12, 6, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Say Line Bridge Worker Alex'),
(341, 0, 5, 0, 52, 0, 100, 0, 0, 653, 0, 0, 1, 1, 0, 0, 0, 0, 0, 12, 5, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Text Over - Say Line Bridge Worker Matthew'),
(341, 0, 6, 0, 52, 0, 100, 0, 4, 653, 0, 0, 1, 1, 0, 0, 0, 0, 0, 12, 5, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Text Over - Say Line Bridge Worker Matthew'),
(341, 0, 7, 0, 52, 0, 100, 0, 1, 653, 0, 0, 80, 3410006, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Text Over - Run Script'),
(3410006, 9, 0, 0, 0, 0, 100, 0, 0, 100, 0, 0, 1, 0, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Say Line Bridge Worker Trent'),
(3410006, 9, 1, 0, 0, 0, 100, 0, 0, 200, 0, 0, 1, 0, 0, 0, 0, 0, 0, 12, 2, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Say Line Bridge Worker Dimitri'),
(3410006, 9, 2, 0, 0, 0, 100, 0, 0, 400, 0, 0, 1, 0, 0, 0, 0, 0, 0, 12, 3, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Say Line Bridge Worker Jess'),
(3410006, 9, 3, 0, 0, 0, 100, 0, 0, 800, 0, 0, 1, 0, 0, 0, 0, 0, 0, 12, 4, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Say Line Bridge Worker Daniel'),
(3410006, 9, 4, 0, 0, 0, 100, 0, 0, 1200, 0, 0, 1, 0, 0, 0, 0, 0, 0, 12, 5, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Say Line Bridge Worker Matthew'),
(341, 0, 8, 0, 38, 1, 100, 0, 1, 1, 0, 0, 80, 3410007, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Data Set - Run Script'),
(3410007, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 0, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Remove Emote Bridge Worker Trent'),
(3410007, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 0, 0, 0, 0, 0, 0, 12, 2, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Remove Emote Bridge Worker Dimitri'),
(3410007, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 0, 0, 0, 0, 0, 0, 12, 3, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Remove Emote Bridge Worker Jess'),
(3410007, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 0, 0, 0, 0, 0, 0, 12, 4, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Remove Emote Bridge Worker Daniel'),
(3410007, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 0, 0, 0, 0, 0, 0, 12, 5, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Remove Emote Bridge Worker Matthew'),
(3410007, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 0, 0, 0, 0, 0, 0, 12, 6, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Remove Emote Bridge Worker Alex'),
(3410007, 9, 6, 0, 0, 0, 100, 0, 1, 1, 0, 0, 45, 1, 1, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Set Data Bridge Worker Trent'),
(3410007, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 12, 2, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Set Data Bridge Worker Dimitri'),
(3410007, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 12, 3, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Set Data Bridge Worker Jess'),
(3410007, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 12, 4, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Set Data Bridge Worker Daniel'),
(3410007, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 12, 5, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Set Data Bridge Worker Matthew'),
(3410007, 9, 11, 0, 0, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 12, 6, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Set Data Bridge Worker Alex'),
(3410007, 9, 12, 0, 0, 0, 100, 0, 0, 0, 0, 0, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Set Phase 2'),
(341, 0, 9, 0, 38, 2, 100, 0, 1, 2, 0, 0, 80, 3410008, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Data Set - Run Script'),
(3410008, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 91, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Remove Dead Emote Self'),
(3410008, 9, 1, 0, 0, 0, 100, 0, 0, 100, 0, 0, 1, 1, 2000, 0, 0, 0, 0, 12, 4, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Say Line Bridge Worker Daniel'),
(3410008, 9, 2, 0, 0, 0, 100, 0, 0, 200, 0, 0, 1, 2, 2000, 0, 0, 0, 0, 12, 5, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Say Line Bridge Worker Matthew'),
(3410008, 9, 3, 0, 0, 0, 100, 0, 0, 400, 0, 0, 1, 5, 2000, 0, 0, 0, 0, 12, 6, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Say Line Bridge Worker Alex'),
(3410008, 9, 4, 0, 0, 0, 100, 0, 0, 800, 0, 0, 17, 431, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Play Emote Bridge Worker Trent'),
(3410008, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 431, 0, 0, 0, 0, 0, 12, 2, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Play Emote Bridge Worker Dimitri'),
(3410008, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 431, 0, 0, 0, 0, 0, 12, 3, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Play Emote Bridge Worker Jess'),
(3410008, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 431, 0, 0, 0, 0, 0, 12, 4, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Play Emote Bridge Worker Daniel'),
(3410008, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 431, 0, 0, 0, 0, 0, 12, 5, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Play Emote Bridge Worker Matthew'),
(3410008, 9, 9, 0, 0, 0, 100, 0, 0, 0, 0, 0, 17, 431, 0, 0, 0, 0, 0, 12, 6, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Play Emote Bridge Worker Alex'),
(3410008, 9, 10, 0, 0, 0, 100, 0, 0, 1200, 0, 0, 17, 64, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Play Emote Self'),
(341, 0, 10, 0, 38, 2, 100, 0, 1, 3, 0, 0, 80, 3410009, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Data Set - Run Script'),
(3410009, 9, 0, 0, 0, 0, 100, 0, 1, 1, 0, 0, 41, 30000, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Despawn Bridge Worker Trent'),
(3410009, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 41, 30000, 0, 0, 0, 0, 0, 12, 2, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Despawn Bridge Worker Dimitri'),
(3410009, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 41, 30000, 0, 0, 0, 0, 0, 12, 3, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Despawn Bridge Worker Jess'),
(3410009, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 41, 30000, 0, 0, 0, 0, 0, 12, 4, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Despawn Bridge Worker Daniel'),
(3410009, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 41, 30000, 0, 0, 0, 0, 0, 12, 5, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Despawn Bridge Worker Matthew'),
(3410009, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 41, 30000, 0, 0, 0, 0, 0, 12, 6, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Despawn Bridge Worker Alex'),
(3410009, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 41, 30000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Foreman Oslow - On Script - Despawn Self'),
(648, 0, 0, 1, 38, 0, 100, 0, 1, 1, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bridge Worker - On Data Set - Set Run'),
(648, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, -9281.44, -2285.27, 67.5123, 0, 'Bridge Worker - On Data Set - Move to Pos'),
(648, 0, 2, 0, 34, 0, 100, 0, 8, 1, 0, 0, 67, 6480001, 1000, 1000, 0, 0, 100, 1, 0, 0, 0, 0, 0, 0, 0, 'Bridge Worker - On Pos - Run Script'),
(648, 0, 3, 0, 59, 0, 100, 0, 6480001, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 341, 10, 0, 0, 0, 0, 0, 'Bridge Worker - On Script - Set Orientation'),
(649, 0, 0, 1, 38, 0, 100, 0, 1, 1, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bridge Worker - On Data Set - Set Run'),
(649, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, -9282.81, -2293.28, 67.5089, 0, 'Bridge Worker - On Data Set - Move to Pos'),
(649, 0, 2, 0, 34, 0, 100, 0, 8, 1, 0, 0, 67, 6480001, 1000, 1000, 0, 0, 100, 1, 0, 0, 0, 0, 0, 0, 0, 'Bridge Worker - On Pos - Run Script'),
(649, 0, 3, 0, 59, 0, 100, 0, 6480001, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 341, 10, 0, 0, 0, 0, 0, 'Bridge Worker - On Script - Set Orientation'),
(650, 0, 0, 1, 38, 0, 100, 0, 1, 1, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bridge Worker - On Data Set - Set Run'),
(650, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, -9282.27, -2290.95, 67.5319, 0, 'Bridge Worker - On Data Set - Move to Pos'),
(650, 0, 2, 0, 34, 0, 100, 0, 8, 1, 0, 0, 67, 6480001, 1000, 1000, 0, 0, 100, 1, 0, 0, 0, 0, 0, 0, 0, 'Bridge Worker - On Pos - Run Script'),
(650, 0, 3, 0, 59, 0, 100, 0, 6480001, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 341, 10, 0, 0, 0, 0, 0, 'Bridge Worker - On Script - Set Orientation'),
(651, 0, 0, 1, 38, 0, 100, 0, 1, 1, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bridge Worker - On Data Set - Set Run'),
(651, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, -9281.77, -2287.55, 67.5869, 0, 'Bridge Worker - On Data Set - Move to Pos'),
(651, 0, 2, 0, 34, 0, 100, 0, 8, 1, 0, 0, 67, 6480001, 1000, 1000, 0, 0, 100, 1, 0, 0, 0, 0, 0, 0, 0, 'Bridge Worker - On Pos - Run Script'),
(651, 0, 3, 0, 59, 0, 100, 0, 6480001, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 341, 10, 0, 0, 0, 0, 0, 'Bridge Worker - On Script - Set Orientation'),
(652, 0, 0, 1, 38, 0, 100, 0, 1, 1, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bridge Worker - On Data Set - Set Run'),
(652, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, -9280.71, -2283.21, 67.5747, 0, 'Bridge Worker - On Data Set - Move to Pos'),
(652, 0, 2, 0, 34, 0, 100, 0, 8, 1, 0, 0, 67, 6480001, 1000, 1000, 0, 0, 100, 1, 0, 0, 0, 0, 0, 0, 0, 'Bridge Worker - On Pos - Run Script'),
(652, 0, 3, 0, 59, 0, 100, 0, 6480001, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 341, 10, 0, 0, 0, 0, 0, 'Bridge Worker - On Script - Set Orientation'),
(653, 0, 0, 1, 38, 0, 100, 0, 1, 1, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bridge Worker - On Data Set - Set Run'),
(653, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, -9279.86, -2281.42, 67.5854, 0, 'Bridge Worker - On Data Set - Move to Pos'),
(653, 0, 2, 0, 34, 0, 100, 0, 8, 1, 0, 0, 67, 6480001, 1000, 1000, 0, 0, 100, 1, 0, 0, 0, 0, 0, 0, 0, 'Bridge Worker - On Pos - Run Script'),
(653, 0, 3, 0, 59, 0, 100, 0, 6480001, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 341, 10, 0, 0, 0, 0, 0, 'Bridge Worker - On Script - Set Orientation'),
(43197, 0, 0, 1, 8, 0, 100, 1, 80704, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Subdued Canyon Ettin - On Spellhit - Store Target'),
(43197, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 18, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Subdued Canyon Ettin - On Spellhit - Set Immune Flags'),
(43197, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Subdued Canyon Ettin - On Spellhit - Set Run'),
(43197, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 69, 5, 0, 0, 0, 0, 0, 8, 0, 0, 0, -9269.33, -2289.54, 68.9225, 0, 'Subdued Canyon Ettin - On Spellhit - Move to Pos'),
(43197, 0, 4, 5, 34, 0, 100, 0, 8, 5, 0, 0, 86, 82566, 0, 19, 43196, 5, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Subdued Canyon Ettin - On Pos - Cross Cast Lift Boulder Ride'),
(43197, 0, 5, 6, 61, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 341, 5, 0, 0, 0, 0, 0, 'Subdued Canyon Ettin - On Pos - Set Data Foreman Oslow'),
(43197, 0, 6, 0, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 4000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Subdued Canyon Ettin - On Pos - Say Line'),
(43197, 0, 7, 8, 52, 0, 100, 0, 0, 43197, 0, 0, 1, 1, 4000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Subdued Canyon Ettin - On Text Over - Say Line'),
(43197, 0, 8, 9, 52, 0, 100, 0, 1, 43197, 0, 0, 45, 1, 2, 0, 0, 0, 0, 19, 341, 5, 0, 0, 0, 0, 0, 'Subdued Canyon Ettin - On Text Over - Set Data Foreman Oslow'),
(43197, 0, 9, 0, 61, 0, 100, 0, 0, 0, 0, 0, 67, 4319700, 4000, 4000, 0, 0, 100, 1, 0, 0, 0, 0, 0, 0, 0, 'Subdued Canyon Ettin - On Text Over - Run Script'),
(43197, 0, 10, 0, 59, 0, 100, 0, 4319700, 0, 0, 0, 1, 2, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Subdued Canyon Ettin - On Script - Say Line'),
(43197, 0, 11, 12, 52, 0, 100, 0, 2, 43197, 0, 0, 53, 1, 43197, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Subdued Canyon Ettin - On Text Over - Start WP'),
(43197, 0, 12, 13, 61, 0, 100, 0, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Subdued Canyon Ettin - On Text Over - Set Active'),
(43197, 0, 13, 0, 61, 0, 100, 0, 0, 0, 0, 0, 45, 1, 3, 0, 0, 0, 0, 19, 341, 5, 0, 0, 0, 0, 0, 'Subdued Canyon Ettin - On Text Over - Set Data Foreman Oslow'),
(43197, 0, 14, 15, 40, 0, 100, 0, 4, 43197, 0, 0, 28, 82566, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Subdued Canyon Ettin - On WP - Remove Lift Boulder Ride'),
(43197, 0, 15, 16, 61, 0, 100, 0, 0, 0, 0, 0, 33, 341, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 'Subdued Canyon Ettin - On WP - KillCredit'),
(43197, 0, 16, 0, 61, 0, 100, 0, 0, 0, 0, 0, 67, 4319701, 4000, 4000, 0, 0, 100, 1, 0, 0, 0, 0, 0, 0, 0, 'Subdued Canyon Ettin - On WP - Run Script'),
(43197, 0, 17, 0, 59, 0, 100, 0, 4319701, 0, 0, 0, 1, 3, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Subdued Canyon Ettin - On Script - Say Line'),
(43197, 0, 18, 19, 52, 0, 100, 0, 3, 43197, 0, 0, 41, 0, 0, 0, 0, 0, 0, 19, 43196, 5, 0, 0, 0, 0, 0, 'Subdued Canyon Ettin - On Text Over - Despawn Huge Boulder'),
(43197, 0, 19, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Subdued Canyon Ettin - On Text Over - Despawn Self'),
(43094, 0, 0, 0, 0, 0, 100, 0, 8000, 8000, 18000, 22000, 11, 88421, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Cast Log Smash'),
(43094, 0, 1, 0, 8, 0, 100, 0, 80704, 0, 0, 0, 86, 80702, 1, 7, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Canyon Ettin - On Spellhit - Cross Cast Control Ettin'),
(43094, 0, 2, 3, 8, 0, 100, 0, 80702, 0, 0, 0, 18, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Canyon Ettin - On Spellhit - Set Immune Flags'),
(43094, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Canyon Ettin - On Spellhit - Despawn'),
(43094, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 24, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Canyon Ettin - On Spellhit - Evade');

DELETE FROM `waypoints` WHERE `entry`=43197;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES 
(43197, 1, -9275.12, -2306.08, 69.0627, 'Subdued Canyon Ettin'),
(43197, 2, -9282.11, -2317.83, 65.9215, 'Subdued Canyon Ettin'),
(43197, 3, -9295.27, -2327.51, 61.7534, 'Subdued Canyon Ettin'),
(43197, 4, -9322.29, -2341.49, 61.2445, 'Subdued Canyon Ettin');

DELETE FROM `creature_text` WHERE `CreatureID` IN (341, 648, 649, 650, 651, 652, 653, 43197);
INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES 
(341, 0, 0, 'Somebody... please... get... rock... off... me...', 12, 0, 100, 0, 0, 0, 43173, 0, 'Foreman Oslow'),
(341, 0, 1, 'Hurts... Hurts so bad...', 12, 0, 100, 0, 0, 0, 43174, 0, 'Foreman Oslow'),
(341, 0, 2, 'Please... kill... me...', 12, 0, 100, 0, 0, 0, 43175, 0, 'Foreman Oslow'),
(341, 0, 3, 'I... just... wanted... to... build... the... damned... bridge...', 12, 0, 100, 0, 0, 0, 43176, 0, 'Foreman Oslow'),
(648, 0, 0, 'HO!', 12, 0, 100, 0, 0, 0, 43183, 0, 'Bridge Worker Trent'),
(649, 0, 0, 'HO!', 12, 0, 100, 0, 0, 0, 43183, 0, 'Bridge Worker Dimitri'),
(650, 0, 0, 'HO!', 12, 0, 100, 0, 0, 0, 43183, 0, 'Bridge Worker Jess'),
(651, 0, 0, 'HO!', 12, 0, 100, 0, 0, 0, 43183, 0, 'Bridge Worker Daniel'),
(651, 1, 0, 'NOOOOOO!!!', 12, 0, 100, 0, 0, 0, 43231, 0, 'Bridge Worker Daniel'),
(652, 0, 0, 'HO!', 12, 0, 100, 0, 0, 0, 43183, 0, 'Bridge Worker Matthew'),
(652, 1, 0, 'I\'M PUSHIN\' AS HARD AS I CAN! THING WEIGHS A TON!', 12, 0, 100, 0, 0, 0, 43186, 0, 'Bridge Worker Matthew'),
(652, 2, 0, 'NO, NO, NO! Please!', 12, 0, 100, 0, 0, 0, 43230, 0, 'Bridge Worker Matthew'),
(653, 0, 0, 'PUT YOUR BACKS INTO IT, BOYS!', 12, 0, 100, 0, 0, 0, 43181, 0, 'Bridge Worker Alex'),
(653, 1, 0, 'HEAVE!', 12, 0, 100, 0, 0, 0, 43182, 0, 'Bridge Worker Alex'),
(653, 2, 0, 'DAMN ROCK WON\'T BUDGE!', 12, 0, 100, 0, 0, 0, 43184, 0, 'Bridge Worker Alex'),
(653, 3, 0, 'We\'ll get you out of there, Foreman, just HANG ON!', 12, 0, 100, 0, 0, 0, 43187, 0, 'Bridge Worker Alex'),
(653, 4, 0, 'PUSH HARDER!', 12, 0, 100, 0, 0, 0, 43185, 0, 'Bridge Worker Alex'),
(653, 5, 0, 'ANYWHERE BUT THE BRIDGE!', 12, 0, 100, 0, 0, 0, 43232, 0, 'Bridge Worker Alex'),
(43197, 0, 0, 'ROCK NOT SO HEAVY! PUNY HUMIES!', 12, 0, 100, 0, 0, 0, 43218, 0, 'Subdued Canyon Ettin'),
(43197, 1, 0, 'Where trow? TROW ON BRIDGE??', 12, 0, 100, 0, 0, 0, 43220, 0, 'Subdued Canyon Ettin'),
(43197, 2, 0, 'OK! Me trow in water!', 12, 0, 100, 0, 0, 0, 43222, 0, 'Subdued Canyon Ettin'),
(43197, 3, 0, 'BYE, BYE, DADDY!', 14, 0, 100, 0, 0, 0, 43226, 0, 'Subdued Canyon Ettin');

[свернуть]