Quest Chain The Ring Of Blood Nagrand fix 7.02

[eyerobot]

The creatures would not despawn. This made fighting multiple times almost impossible because of the corpses piled up.
Killing the blue brothers only required one brother killed for quest completion. Now it requires both.
Now they all despawn immediately except for the final boss, Who i left laying on the ground so players can see that someone else just killed him, And they need to wait for him to respawn.

-- brokentoe 18398
DELETE FROM `smart_scripts` WHERE (`entryorguid`=18398 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 
(18398, 0, 0, 0, 0, 0, 100, 0, 1000, 1000, 9000, 11000, 11, 32023, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Brokentoe - In Combat - Cast 'Hoof Stomp' (Phase 1) (No Repeat) (Dungeon)"),
(18398, 0, 1, 0, 6, 0, 100, 1, 0, 0, 0, 0, 15, 9962, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, "Brokentoe - On Just Died - Quest Credit 'The Ring of Blood: Brokentoe' (No Repeat)"),
(18398, 0, 2, 2, 61, 0, 100, 1, 0, 0, 0, 0, 45, 10, 10, 0, 0, 0, 0, 19, 18471, 0, 0, 0, 0, 0, 0, "Brokentoe - On Just Died - Set Data 10 10 (No Repeat)"),
(18398, 0, 3, 0, 6, 0, 100, 1, 0, 0, 0, 0, 41, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Brokentoe - On Just Died - force Despawn");

-- the blue brothers 18399

UPDATE `quest_template` SET `RequiredNpcOrGo1` = 18399, `RequiredNpcOrGoCount1` = 2 WHERE `Id` = 9967;

DELETE FROM `smart_scripts` WHERE (`entryorguid`=18399 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 
(18399, 0, 0, 0, 4, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Murkblood Twin - On Aggro - Say Line 0 (No Repeat)"),
(18399, 0, 1, 0, 0, 0, 100, 0, 1000, 1000, 2000, 2000, 11, 14873, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Murkblood Twin - In Combat - Cast 'Sinister Strike' (No Repeat)"),
(18399, 0, 2, 0, 0, 0, 100, 0, 5000, 6000, 11000, 12000, 11, 15691, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Murkblood Twin - In Combat - Cast 'Eviscerate' (No Repeat)"),
(18399, 0, 3, 0, 0, 0, 100, 0, 8000, 9000, 15000, 16000, 11, 32319, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Murkblood Twin - In Combat - Cast 'Mutilate' (No Repeat)"),
(18399, 0, 4, 0, 6, 0, 100, 1, 0, 0, 0, 0, 15, 9967, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, "Murkblood Twin - On Just Died - Quest Credit 'The Ring of Blood: The Blue Brothers' (No Repeat)"),
(18399, 0, 5, 5, 61, 0, 100, 1, 0, 0, 0, 0, 45, 11, 11, 0, 0, 0, 0, 19, 18471, 0, 0, 0, 0, 0, 0, "Murkblood Twin - On Just Died - Set Data 11 11 (No Repeat)"),
(18399, 0, 6, 0, 6, 0, 100, 1, 0, 0, 0, 0, 41, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Murkblood Twin - On Death - Force Despawn");

-- Rokdar
DELETE FROM `smart_scripts` WHERE (`entryorguid`=18400 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 
(18400, 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Rokdar the Sundered Lord - Out of Combat - Say Line 0 (No Repeat)"),
(18400, 0, 1, 0, 0, 0, 100, 0, 1000, 1000, 9000, 11000, 11, 16727, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Rokdar the Sundered Lord - In Combat - Cast 'War Stomp' (No Repeat)"),
(18400, 0, 2, 0, 31, 0, 100, 0, 31389, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Rokdar the Sundered Lord - On Target Spellhit 'Knock Away' - Say Line 0 (No Repeat)"),
(18400, 0, 3, 0, 0, 0, 100, 0, 6000, 6000, 12000, 12000, 11, 31389, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Rokdar the Sundered Lord - In Combat - Cast 'Knock Away' (No Repeat)"),
(18400, 0, 4, 0, 0, 0, 100, 0, 20000, 20000, 25000, 25000, 11, 15976, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Rokdar the Sundered Lord - In Combat - Cast 'Puncture' (No Repeat)"),
(18400, 0, 5, 6, 6, 0, 100, 1, 0, 0, 0, 0, 15, 9970, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, "Rokdar the Sundered Lord - On Just Died - Quest Credit 'The Ring of Blood: Rokdar the Sundered Lord' (No Repeat)"),
(18400, 0, 6, 0, 61, 0, 100, 1, 0, 0, 0, 0, 45, 12, 12, 0, 0, 0, 0, 19, 18471, 0, 0, 0, 0, 0, 0, "Rokdar the Sundered Lord - On Just Died - Set Data 12 12 (No Repeat)"),
(18400, 0, 7, 0, 6, 0, 100, 1, 0, 0, 0, 0, 41, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Rokdar the Sundered Lord - On Just Died - Force Despawn");

-- Skra'gath
DELETE FROM `smart_scripts` WHERE (`entryorguid`=18401 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 
(18401, 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 11, 29299, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Skra'gath - Out of Combat - Cast 'Draining Touch' (No Repeat)"),
(18401, 0, 1, 0, 4, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Skra'gath - On Aggro - Say Line 0 (No Repeat)"),
(18401, 0, 2, 0, 0, 0, 100, 0, 6000, 6000, 12000, 12000, 11, 32324, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Skra'gath - In Combat - Cast 'Shadow Burst' (No Repeat)"),
(18401, 0, 3, 4, 6, 0, 100, 1, 0, 0, 0, 0, 15, 9972, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, "Skra'gath - On Just Died - Quest Credit 'The Ring of Blood: Skra'gath' (No Repeat)"),
(18401, 0, 4, 0, 61, 0, 100, 1, 0, 0, 0, 0, 45, 13, 13, 0, 0, 0, 0, 19, 18471, 0, 0, 0, 0, 0, 0, "Skra'gath - On Just Died - Set Data 13 13 (No Repeat)"),
(18401, 0, 5, 0, 6, 0, 100, 1, 0, 0, 0, 0, 41, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Skra'gath - On Just Died - Force Despawn");


-- the warmaul champion
DELETE FROM `smart_scripts` WHERE (`entryorguid`=18402 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 
(18402, 0, 0, 0, 4, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Warmaul Champion - On Aggro - Say Line 0 (No Repeat)"),
(18402, 0, 1, 0, 4, 0, 100, 0, 0, 0, 0, 0, 11, 31403, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Warmaul Champion - On Aggro - Cast 'Battle Shout' (No Repeat)"),
(18402, 0, 2, 0, 9, 0, 100, 1, 5, 30, 1500, 2000, 11, 32323, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Warmaul Champion - Within 5-30 Range - Cast 'Charge' (No Repeat)"),
(18402, 0, 3, 0, 0, 0, 100, 0, 3000, 4000, 6000, 7000, 11, 15708, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Warmaul Champion - In Combat - Cast 'Mortal Strike' (No Repeat)"),
(18402, 0, 4, 0, 0, 0, 100, 0, 1000, 1000, 9000, 11000, 11, 17963, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Warmaul Champion - In Combat - Cast 'Sundering Cleave' (No Repeat)"),
(18402, 0, 5, 6, 6, 0, 100, 1, 0, 0, 0, 0, 15, 9973, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, "Warmaul Champion - On Just Died - Quest Credit 'The Ring of Blood: The Warmaul Champion' (No Repeat)"),
(18402, 0, 6, 0, 61, 0, 100, 1, 0, 0, 0, 0, 45, 14, 14, 0, 0, 0, 0, 19, 18471, 0, 0, 0, 0, 0, 0, "Warmaul Champion - On Just Died - Set Data 14 14 (No Repeat)"),
(18402, 0, 7, 0, 6, 0, 100, 1, 0, 0, 0, 0, 41, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Warmaul Champion - On Just Died - force Despawn");

 

[ExO]

Executed, thanks!