11567 The Ancient Armor of the Kvaldir

[eyerobot]

This fixes the bombers and their scripts. Gives new vehicle id's. Making it possible to fly to your destination. However there is a problem with the waypoints being processed for the bombers. The bomber always drops you before you reach your destination. And the bombers travel way too slow. Right now i have no idea how to fix those problems. But this quest can be completed as is, With a little swimming.

-- 11567 The Ancient Armor of the Kvaldir

-- 27932 Harry's Bomber Out
-- 32682 Harry's Bomber RETURN
-- 28277 Harry's Bomber Stable

UPDATE `creature_template` SET `VehicleId` = 34 WHERE `entry` = 27932;
UPDATE `creature_template` SET `VehicleId` = 34 WHERE `entry` = 32682;


DELETE FROM `smart_scripts` WHERE (`entryorguid`=27932 AND `source_type`=0);
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 
(27932, 0, 0, 0, 27, 0, 100, 1, 0, 0, 0, 0, 53, 1, 27932, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Harry's Bomber- On Passeger Boarded - Start wp"),
(27932, 0, 1, 0, 58, 0, 100, 1, 9, 27932, 0, 0, 11, 50630, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Harry's Bomber- On Waypoint Ended - Eject Passengers");

DELETE FROM `smart_scripts` WHERE (`entryorguid`=32682 AND `source_type`=0);
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 
(32682, 0, 0, 0, 27, 0, 100, 1, 0, 0, 0, 0, 53, 1, 32682, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Harry's Bomber- On passeger Boarded - Start wp"),
(32682, 0, 1, 0, 58, 0, 100, 1, 9, 32682, 0, 0, 11, 50630, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Harry's Bomber- On waypoint ended - Eject passengers");

DELETE FROM `gossip_menu_option` WHERE `menu_id`=10218 AND `id`=0;
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `OptionbroadCastTextId`, `BoxBroadcastTextId`) VALUES (10218, 0, 0, '<Get in the bomber and return to Scalawag Point.>', 1, 1, 0, 0, 0, 0, '', 33058, NULL);

 

[ExO]

Executed to the newest Emucoach 4.3.4 repack, VIP.

Thanks!