Quest Name = 'Counterattack!' | '人马无双!'
Quest ID = 4021
-- Adjust Conditions
UPDATE `world`.`conditions` SET `ConditionValue2` = 8, `Comment` = 'Regthar Deathgate - On Quest State - Gossip Menu Option Available' WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 1882 AND `ConditionTypeOrReference` = 47 AND `ConditionValue1` = 4021;
-- Add Creature Summon Groups
INSERT INTO `world`.`creature_summon_groups` (`summonerId`, `summonerType`, `groupId`, `entry`, `position_x`, `position_y`, `position_z`, `orientation`, `summonType`, `summonTime`, `Comment`) VALUES
(3389, 0, 0, 9457, -267.937, -1897.09, 91.6676, 2.25017, 1, 300000, 'Regthar Deathgate - Horde Defender'),
(3389, 0, 0, 9457, -295.886, -1903.197, 91.6668, 1.44121, 1, 300000, 'Regthar Deathgate - Horde Defender'),
(3389, 0, 0, 9457, -283.507, -1903.22, 91.6676, 1.84961, 1, 300000, 'Regthar Deathgate - Horde Defender'),
(3389, 0, 0, 9458, -293.212, -1912.51, 91.6673, 1.42794, 1, 300000, 'Regthar Deathgate - Horde Axe Thrower'),
(3389, 0, 1, 9524, -280.037, -1888.35, 92.2549, 2.28087, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 1, 9524, -292.107, -1899.54, 91.667, 4.78158, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 1, 9524, -305.57, -1869.88, 92.7754, 2.45131, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 1, 9524, -289.972, -1882.76, 92.5714, 3.43148, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 1, 9524, -277.454, -1873.39, 92.7773, 4.75724, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 1, 9524, -271.581, -1847.51, 93.4329, 4.39124, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 1, 9524, -269.982, -1828.6, 92.4754, 4.68655, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 1, 9523, -279.267, -1827.92, 92.3128, 1.35332, 1, 60000, 'Regthar Deathgate - Kolkar Stormseer'),
(3389, 0, 1, 9523, -297.42, -1847.41, 93.2295, 5.80967, 1, 60000, 'Regthar Deathgate - Kolkar Stormseer'),
(3389, 0, 1, 9523, -310.607, -1831.89, 95.9363, 0.371571, 1, 60000, 'Regthar Deathgate - Kolkar Stormseer'),
(3389, 0, 1, 9523, -329.177, -1842.43, 95.3891, 0.516085, 1, 60000, 'Regthar Deathgate - Kolkar Stormseer'),
(3389, 0, 1, 9523, -324.448, -1860.63, 94.3221, 4.97793, 1, 60000, 'Regthar Deathgate - Kolkar Stormseer'),
(3389, 0, 2, 9524, -290.588, -1858, 92.5026, 4.14698, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 2, 9523, -286.103, -1846.18, 92.544, 6.11047, 1, 60000, 'Regthar Deathgate - Kolkar Stormseer'),
(3389, 0, 2, 9524, -304.978, -1844.7, 94.4432, 1.61721, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 2, 9523, -308.105, -1859.08, 93.8039, 2.80709, 1, 60000, 'Regthar Deathgate Kolkar Stormseer'),
(3389, 0, 2, 9524, -297.089, -1867.68, 92.5601, 2.21804, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 2, 9523, -286.988, -1876.47, 92.7447, 1.39494, 1, 60000, 'Regthar Deathgate Kolkar Stormseer'),
(3389, 0, 2, 9524, -291.86, -1893.04, 92.0213, 1.96121, 1, 60000, 'Regthar Deathgate - Kolkar Invader'),
(3389, 0, 2, 9524, -298.297, -1846.85, 93.3672, 4.97792, 1, 60000, 'Regthar Deathgate - Kolkar Invader');
-- Adjust SAI
DELETE FROM `world`.`smart_scripts` WHERE `entryorguid` IN (3389,338900,9523,9524,9456,9457,9458);
INSERT INTO `world`.`smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(3389, 0, 0, 1, '', 62, 0, 100, 0, 1882, 0, 0, 0, 0, '', 1, 0, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - On Gossip Option Select - Say Group 0'),
(3389, 0, 1, 2, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 72, 0, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - Link - Close Gossip '),
(3389, 0, 2, 3, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 80, 338900, 2, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - Link - Run Timed ActionList'),
(3389, 0, 3, 0, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 22, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - Link - Set Phase 1'),
(3389, 0, 4, 0, '', 1, 1, 100, 0, 3000, 6000, 45000, 60000, 0, '', 87, 338901, 338902, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - OOC(P1)- Run Random Timed ActionList'),
(3389, 0, 5, 6, '', 77, 1, 100, 0, 1, 30, 1000, 1000, 0, '', 12, 9456, 1, 250000, 0, 0, 0, 0, NULL, 8, 0, 0, 0, 0, NULL, -296.718, -1846.38, 93.2334, 5.02897, 'Regthar Deathgate - On Counter Set 1 30 - Summon Creature \'Warlord Krom\'zar\''),
(3389, 0, 6, 7, '', 61, 1, 100, 0, 0, 0, 0, 0, 0, '', 22, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - Link - Set Phase 0'),
(3389, 0, 7, 0, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 78, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - Link - Call Script Reset'),
(338900, 9, 0, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 107, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - On Script - Summon Group 0'),
(338901, 9, 0, 0, '', 0, 1, 100, 0, 3000, 8000, 0, 0, 0, '', 107, 1, 1, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - On Script - Summon Group 1'),
(338902, 9, 0, 0, '', 0, 1, 100, 0, 3000, 8000, 0, 0, 0, '', 107, 2, 1, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Regthar Deathgate - On Script - Summon Group 2'),
(9523, 0, 0, 0, '', 11, 0, 100, 0, 0, 0, 0, 0, 0, '', 89, 5, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Stormseer - On Respawn - Start Random Movement'),
(9523, 0, 1, 0, '', 0, 0, 100, 0, 0, 0, 3400, 4800, 0, '', 11, 9532, 64, 0, 0, 0, 0, 0, NULL, 2, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Stormseer - IC - Cast \'Lightning Bolt\''),
(9523, 0, 2, 0, '', 0, 0, 100, 0, 10000, 15000, 15000, 20000, 0, '', 11, 6535, 0, 0, 0, 0, 0, 0, NULL, 2, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Stormseer - IC - Cast \'Lightning Cloud\''),
(9523, 0, 3, 0, '', 6, 0, 100, 0, 0, 0, 0, 0, 0, '', 63, 1, 1, 0, 0, 0, 0, 0, NULL, 10, 302651, 3389, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Stormseer - On Death - Set Counter 1 1'),
(9524, 0, 0, 0, '', 11, 0, 100, 0, 0, 0, 0, 0, 0, '', 89, 5, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Invader - On Respawn - Start Random Movement'),
(9524, 0, 1, 0, '', 0, 0, 100, 0, 0, 3500, 0, 0, 0, '', 11, 6268, 0, 0, 0, 0, 0, 0, NULL, 2, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Invader - IC - Cast \'Rushing Charge\' (No Repeat)'),
(9524, 0, 2, 0, '', 0, 0, 100, 0, 4000, 5500, 12000, 16000, 0, '', 11, 11976, 0, 0, 0, 0, 0, 0, NULL, 2, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Invader - IC - Cast \'Strike\''),
(9524, 0, 3, 0, '', 9, 0, 100, 0, 0, 5, 18000, 21000, 0, '', 11, 8014, 0, 0, 0, 0, 0, 0, NULL, 2, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Invader - Within 0-5 Range - Cast \'Tetanus\''),
(9524, 0, 4, 0, '', 6, 0, 100, 0, 0, 0, 1, 0, 0, '', 63, 1, 1, 0, 0, 0, 0, 0, NULL, 10, 302651, 3389, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Invader - On Death - Set Counter 1 1'),
(9457, 0, 0, 0, '', 6, 0, 100, 0, 0, 0, 0, 0, 0, '', 1, 1, 0, 0, 0, 0, 0, 0, NULL, 9, 3389, 0, 300, 0, NULL, 0, 0, 0, 0, 'Horde Defender - On Death - \'Regthar Deathgate\' Say Group 1'),
(9457, 0, 1, 0, '', 6, 0, 100, 0, 0, 0, 0, 0, 0, '', 12, 9457, 1, 450000, 0, 0, 0, 0, NULL, 8, 0, 0, 0, 0, NULL, -280.703, -1908.01, 91.6668, 1.77351, 'Horde Defender - On Death - Summon \'Horde Defender\''),
(9457, 0, 2, 0, '', 11, 0, 100, 0, 0, 0, 0, 0, 0, '', 89, 5, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Horde Defender - On Respawn - Start Random Movement'),
(9458, 0, 0, 0, '', 0, 0, 100, 0, 0, 0, 2300, 3900, 0, '', 11, 10277, 64, 0, 0, 0, 0, 0, NULL, 2, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Horde Axe Thrower - In Combat CMC - Cast \'Throw\''),
(9458, 0, 1, 0, '', 6, 0, 100, 0, 0, 0, 0, 0, 0, '', 12, 9458, 1, 450000, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, NULL, -293.212, -1912.51, 91.6673, 1.42794, 'Horde Axe Thrower - On Death - Summon \'Horde Axe Thrower\''),
(9458, 0, 2, 0, '', 11, 0, 100, 0, 0, 0, 0, 0, 0, '', 89, 5, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Horde Axe Thrower - On Respawn - Start Random Movement'),
(9456, 0, 0, 0, '', 0, 0, 100, 0, 0, 1000, 4000, 6000, 0, '', 11, 11976, 0, 0, 0, 0, 0, 0, NULL, 2, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Warlord Krom\'zar - IC - Cast \'Strike\''),
(9456, 0, 1, 0, '', 6, 0, 100, 0, 0, 0, 0, 0, 0, '', 11, 13965, 2, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Warlord Krom\'zar - On Death - Cast \'Create Krom\'zar\'s Banner\''),
(9456, 0, 4, 0, '', 11, 0, 100, 0, 0, 0, 0, 0, 0, '', 89, 5, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Warlord Krom\'zar - On Respawn - Start Random Movement'),
(9456, 0, 5, 0, '', 11, 0, 100, 0, 0, 0, 0, 0, 0, '', 1, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Warlord Krom\'zar - On Respawn - Say Group 0');