[wasy]

нужно подчистить спауны тех которые через скрипты
запуск ивента каждые 30мин для Q 12020, 12192 - Однажды, напившись в...

из самих установок за два дня просиживания там отловил только эти
186880, 186685 - Буровая установка Черного Железа
189989, 189990 - Обломки буровой установки Черного Железа

пробуем так:

-- [DND] Brewfest Dark Iron Spawn Bunny
SET @ENTRY := 23894;
-- SET @SPELL_MOLE_MACHINE_SPAWN := 73071;
SET @SPELL_MOLE_MACHINE_SPAWN := 43563;
UPDATE `creature_template` SET `AIName`='SmartAI', `flags_extra`=`flags_extra`|128 WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@ENTRY, @ENTRY*100);
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
(@ENTRY, 0, 0, 1, 1, 0, 100, 1, 5000, 285000, 270000, 270000, 11, @SPELL_MOLE_MACHINE_SPAWN, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "[DND] Brewfest Dark Iron Spawn Bunny - Out of Combat - Cast Mole Machine Spawn"), 
(@ENTRY, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 80, @ENTRY*100, 0, 2, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "[DND] Brewfest Dark Iron Spawn Bunny - On Mole Machine Spawn - Run Script"), 
(@ENTRY*100, 9, 0, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 12, 23709, 1, 300000000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 3.85, "[DND] Brewfest Dark Iron Spawn Bunny - On Script - Spawn Dark Iron Guzzler"), 
(@ENTRY*100, 9, 1, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 12, 23709, 1, 300000000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 5.58, "[DND] Brewfest Dark Iron Spawn Bunny - On Script - Spawn Dark Iron Guzzler"), 
(@ENTRY*100, 9, 2, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 12, 23709, 1, 300000000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0.80, "[DND] Brewfest Dark Iron Spawn Bunny - On Script - Spawn Dark Iron Guzzler"), 
(@ENTRY*100, 9, 3, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 12, 23709, 1, 300000000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 2.48, "[DND] Brewfest Dark Iron Spawn Bunny - On Script - Spawn Dark Iron Guzzler");