- 916
- 2015
- 24
- Location
- Barryton Michigan USA
This will make the quest work, But it is still missing the attack choppers, And stealth troopers. I'll add them later.
Code:
-- 25841 Strike From Above
-- 41372 Frostmane Retreat North
-- 41373 Frostmane Retreat South
-- 182090 Vector Coil Fire
-- Guid North 217542 217541 217543 217545 217544
-- Guid South 217546 217536 217535
-- 41375 Bombardment Bunny
-- 41382 Covert Ops Flying Machine
-- 77477 Missile Barrage
-- 56048 Signal Flare
-- 77488 Spell
-- Editing the SmartAI script of [Creature] ENTRY 41372 (name: Frostmane Retreat North)
-- Table creature_template
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 41372;
-- Table smart_scripts
DELETE FROM `smart_scripts` WHERE (source_type = 0 AND entryorguid = 41372);
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
(41372, 0, 0, 1, 38, 0, 100, 0, 1, 1, 0, 0, 50, 182090, 120000, 0, 0, 0, 0, 8, 0, 0, 0, -5704.88, -1039.77, 398.439, 0, 'Frostmane Retreat North - On Data Set 1 1 - Summon Gameobject \'\'Vector Coil Fire (L)\'\''),
(41372, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 50, 182090, 120000, 0, 0, 0, 0, 8, 0, 0, 0, -5711.94, -1034.04, 403.723, 0, 'Frostmane Retreat North - On Data Set 1 1 - Summon Gameobject \'\'Vector Coil Fire (L)\'\''),
(41372, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 50, 182090, 120000, 0, 0, 0, 0, 8, 0, 0, 0, -5698.84, -1023.9, 397.532, 0, 'Frostmane Retreat North - On Data Set 1 1 - Summon Gameobject \'\'Vector Coil Fire (L)\'\''),
(41372, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 50, 182090, 120000, 0, 0, 0, 0, 8, 0, 0, 0, -5697.54, -1025, 403.709, 0, 'Frostmane Retreat North - On Data Set 1 1 - Summon Gameobject \'\'Vector Coil Fire (L)\'\''),
(41372, 0, 4, 5, 61, 0, 100, 0, 0, 0, 0, 0, 50, 182090, 120000, 0, 0, 0, 0, 8, 0, 0, 0, -5686.9, -1028.75, 409.307, 0, 'Frostmane Retreat North - On Data Set 1 1 - Summon Gameobject \'\'Vector Coil Fire (L)\'\''),
(41372, 0, 5, 0, 61, 0, 100, 0, 0, 0, 0, 0, 33, 41372, 0, 0, 0, 0, 0, 21, 80, 0, 0, 0, 0, 0, 0, 'Frostmane Retreat North - On Data Set 1 1 - Quest Credit \'undefined\'');
-- Editing the SmartAI script of [Creature] ENTRY 41373 (name: Frostmane Retreat South)
-- Table creature_template
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 41373;
-- Table smart_scripts
DELETE FROM `smart_scripts` WHERE (source_type = 0 AND entryorguid = 41373);
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
(41373, 0, 0, 1, 38, 0, 100, 0, 1, 1, 0, 0, 50, 182090, 120000, 0, 0, 0, 0, 8, 0, 0, 0, -5691.92, -1032.04, 399.977, 0, 'Frostmane Retreat South - On Data Set 1 1 - Summon Gameobject \'\'Vector Coil Fire (L)\'\''),
(41373, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 50, 182090, 120000, 0, 0, 0, 0, 8, 0, 0, 0, -5806.97, -943.055, 402.822, 0, 'Frostmane Retreat South - On Data Set 1 1 - Summon Gameobject \'\'Vector Coil Fire (L)\'\''),
(41373, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 50, 182090, 120000, 0, 0, 0, 0, 8, 0, 0, 0, -5823.58, -951.701, 397.243, 0, 'Frostmane Retreat South - On Data Set 1 1 - Summon Gameobject \'\'Vector Coil Fire (L)\'\''),
(41373, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 33, 41373, 0, 0, 0, 0, 0, 21, 80, 0, 0, 0, 0, 0, 0, 'Frostmane Retreat South - On Data Set 1 1 - Quest Credit \'\'');
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=77488 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=31 AND `ConditionTarget`=0 AND `ConditionValue1`=3 AND `ConditionValue2`=41375 AND `ConditionValue3`=0;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (13, 1, 77488, 0, 0, 31, 0, 3, 41375, 0, 0, 0, 0, '', 'Signal Flare only targets Bombardment Bunny');
-- Editing the SmartAI script of [Creature] ENTRY 41375 (name: Bombardment Bunny)
-- Table creature_template
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 41375;
-- Table smart_scripts
DELETE FROM `smart_scripts` WHERE (source_type = 0 AND entryorguid = 41375);
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
(41375, 0, 0, 0, 8, 0, 100, 0, 77488, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 41372, 80, 0, 0, 0, 0, 0, 'Bombardment Bunny - On Spellhit \'77488\' - Set Data 1 1'),
(41375, 0, 1, 0, 8, 0, 100, 0, 77488, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 41373, 80, 0, 0, 0, 0, 0, 'Bombardment Bunny - On Spellhit \'77488\' - Set Data 1 1');
-- FULL `creature` of id 41375 Bombardment Bunny
-- Guid
-- 306781 North Left
-- 306782 North Right
-- 306734 South Right
-- 306741 South Left
-- FULL `creature` of id 41375
DELETE FROM `creature` WHERE (id = 41375);
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`) VALUES
(41375, 0, 1, 5098, 1, 1, 0, 0, -5710.63, -1036.22, 397.458, 5.1762, 120, 0, 0, 1, 0, 0, 0, 0, 0),
(41375, 0, 1, 5098, 1, 1, 0, 0, -5695.7, -1025.96, 397.938, 5.71026, 120, 0, 0, 1, 0, 0, 0, 0, 0),
(41375, 0, 1, 5098, 1, 1, 0, 0, -5826.93, -950.668, 393.454, 2.9064, 120, 0, 0, 1, 0, 0, 0, 0, 0),
(41375, 0, 1, 5098, 1, 1, 0, 0, -5806.44, -942.052, 396.882, 0, 120, 0, 0, 1, 0, 0, 0, 0, 0);
-- FULL `gameobject` of id 182090 Vector Coil Fire
DELETE FROM `gameobject` WHERE guid IN (8393, 8394, 8399, 8400, 8401, 8402, 8403, 8404);