27349 Break in Communications: Dreadwatch Outpost

[eyerobot]

This is a workaround for non functioning area trigger. But it's better than autocomplete.
Also the village was supposed to be dead and burning, this fixes that.

-- 27349 Break in Communications: Dreadwatch Outpost

-- 45345 Abomination
-- 182090 Vector Coil Fire 
-- 6246 Areatrigger

UPDATE `quest_template` SET `Flags` = 262144, `SpecialFlags` = 0, `RequiredNpcOrGo1` = 45345, `RequiredNpcOrGoCount1` = 1 WHERE `Id` = 27349;

-- 45345 Abomination
UPDATE `creature_template` SET `unit_flags` = 393988, `unit_flags2` = 32769, `dynamicflags` = 32, `AIName` = 'SmartAI', `MovementType` = 0 WHERE `entry` = 45345;

DELETE FROM `smart_scripts` WHERE (`entryorguid`=45345 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 
(45345, 0, 0, 0, 25, 0, 100, 0, 0, 10, 0, 0, 50, 182090, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Spawn - Callt Fire - On Self"),
(45345, 0, 1, 0, 1, 0, 100, 0, 1000, 3000, 1000, 3000, 33, 45345, 0, 0, 0, 0, 0, 17, 0, 20, 0, 0, 0, 0, 0, "On Ooc - Call Killed Credit - Players In Range");

DELETE FROM `creature` WHERE `id`=45345;
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (45345, 0, 0, 0, 1, 1, 0, 0, -1225.52, 1748.66, 19.7435, 1.98643, 120, 0, 0, 0, 0, 0, 0, 393988, 32, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (45345, 0, 0, 0, 1, 1, 0, 0, -1204.19, 1779.53, 20.1174, 2.96818, 120, 0, 0, 0, 0, 0, 0, 393988, 32, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (45345, 0, 0, 0, 1, 1, 0, 0, -1227.81, 1806.72, 20.4106, 5.01807, 120, 0, 0, 0, 0, 0, 0, 393988, 32, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (45345, 0, 0, 0, 1, 1, 0, 0, -1198.83, 1818.77, 22.8919, 3.54545, 120, 0, 0, 0, 0, 0, 0, 393988, 32, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (45345, 0, 0, 0, 1, 1, 0, 0, -1239.14, 1835.96, 20.3683, 5.66995, 120, 0, 0, 0, 0, 0, 0, 393988, 32, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (45345, 0, 0, 0, 1, 1, 0, 0, -1241.61, 1812.86, 21.4697, 4.97094, 120, 0, 0, 0, 0, 0, 0, 393988, 32, 0);

 

[ExO]

Executed thanks