The last line of defense

-- ------------------------------------------ --
-- quest "The Last Line Of Defense" 13086 fix --
-- ------------------------------------------ --

-- on retail players can use Argent Canons to pew-pew quest mobs,
-- since it's more like science-fiction for us, players are allowed to kill mobs by sword and fire.
-- NPC "Frostbrood Destroyer" 30575 needed for quest credit #2 added and spawned
UPDATE `creature_template`
SET
`faction_A` = '2068',
`faction_H` = '2068',
`minrangedmg` = '345',
`maxrangedmg` = '509',
`minlevel` = '80',
`maxlevel` = '80',
`armor` = '9729',
`mindmg` = '1170',
`maxdmg` = '3470',
`attackpower` = '342',
`dmg_multiplier` = '2',
`minhealth` = '315000',
`maxhealth` = '315000',
`InhabitType` = '3'
WHERE
`entry` = '30575';
DELETE FROM `creature` WHERE `id` = '30575';
INSERT INTO `creature` (id, map, position_x, position_y, position_z, orientation, spawntimesecs) VALUES
(30575, 571, 6335.826172, 82.110123, 409.224274, 3.138359, 300),
(30575, 571, 6457.640625, 171.508743, 409.985840, 2.494332, 300),
(30575, 571, 6319.731445, 212.167740, 391.011688, 4.739780, 300),
(30575, 571, 6034.281250, 63.817360, 394.400238, 0.973792, 300);
UPDATE `creature`
SET
`id` = '30575'
WHERE
`id` = '30674';
-- Argent Towers spawned for better look, but they don't work
DELETE FROM `creature` WHERE `id` = '30236';
INSERT INTO `creature` (id, map, position_x, position_y, position_z, orientation, spawntimesecs) VALUES
(30236, 571, 6296.888672, 53.354115, 404.575562, 0.782158, 900),
(30236, 571, 6255.935059, 92.995056, 404.473083, 1.567560
, 900),
(30236, 571, 6219.520508, 59.812351, 394.064758, 1.944548
, 900),
(30236, 571, 6162.470215, 60.321831, 394.067474, 2.089845, 900);
-- since for quest credit #1 can be killed difrent mobs, script is the best solution for counting frags
DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN ('30204', '30333', '30205', '30206', '30673', '31043');
INSERT INTO `creature_ai_scripts` (creature_id, event_type, event_chance, action1_type, action1_param1, action1_param2, comment) VALUES
(30204, 6, 100, 33, 30670, 6, "Gives quest 13086 credit"),
(30333, 6, 100, 33, 30670, 6, "Gives quest 13086 credit"),
(30205, 6, 100, 33, 30670, 6, "Gives quest 13086 credit"),
(30206, 6, 100, 33, 30670, 6, "Gives quest 13086 credit"),
(30673, 6, 100, 33, 30670, 6, "Gives quest 13086 credit"),
(31043, 6, 100, 33, 30670, 6, "Gives quest 13086 credit");