-- https://tracker.legionbugs.com/view.php?id=36065
DELETE FROM `smart_scripts` WHERE `entryorguid` = 48037 AND `source_type` = 0;
DELETE FROM `smart_scripts` WHERE `entryorguid` = 48037*100 AND `source_type` = 9;
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`,`event_param5`,
 `action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,
 `action_param_float`,`action_delay`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,
 `target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES

-- ==================== GOSSIP ====================
(48037, 0, 0, 1, 62, 0, 100, 0, 12381, 0, 0, 0, 0, 2, 14, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Gossip - Set Hostile'),
(48037, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Attack'),

-- ==================== RESET ====================
(48037, 0, 2, 0, 25, 0, 100, 1, 0, 0, 0, 0, 0, 42, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Reset - Cant die will be left 1% hp'),
(48037, 0, 3, 0, 25, 0, 100, 1, 0, 0, 0, 0, 0, 2, 35, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Reset - Set Faction 35'),
(48037, 0, 4, 0, 25, 0, 100, 1, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Reset - Phase 1 Autoattacks'),
(48037, 0, 5, 0, 25, 0, 100, 0, 0, 0, 0, 0, 0, 103, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Reset Root'),
(48037, 0, 6, 0, 25, 0, 100, 0, 0, 0, 0, 0, 0, 18, 32768, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Reset - Remove Immune Flag'),

-- ==================== EVADE ====================
(48037, 0, 7, 0, 7, 0, 100, 0, 0, 0, 0, 0, 0, 41, 3000, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Evade - Despawn'),

-- ==================== ФАЗА 1 (автоатаки) ====================
(48037, 0, 8, 9, 101, 1, 100, 0, 0, 1, 0, 0, 0, 11, 89361, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Phase 1 - HP 1% - Heal'),
(48037, 0, 9, 0, 61, 1, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Say Text 0'),

-- Снятие хила → 89352 + переход в фазу 2 (с маленькой задержкой)
(48037, 0, 10, 11, 78, 1, 100, 0, 89361, 0, 0, 0, 0, 11, 89352, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Phase 1 - Heal removed - Cast 89352'),
(48037, 0, 11, 12, 61, 1, 100, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Say Text 1'),
(48037, 0, 12, 0, 61, 1, 100, 0, 0, 0, 0, 0, 0, 22, 2, 0, 0, 0, 0, 0, 0, 400, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Set Phase 2'),

-- ==================== ФАЗА 2 (91314) ====================
(48037, 0, 13, 0, 0, 2, 100, 0, 1000, 2000, 8000, 10000, 0, 11, 91314, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Phase 2 - Cast 91314'),

-- Бафф 89352 пропал → назад в фазу 1
(48037, 0, 14, 0, 78, 2, 100, 0, 89352, 4, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Phase 2 - 89352 removed - Phase 1'),

(48037, 0, 15, 16, 101, 2, 100, 0, 0, 1, 0, 0, 0, 11, 89361, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Phase 2 - HP 1% - Heal'),
(48037, 0, 16, 0, 61, 2, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Say Text 0'),

-- Снятие хила → 89353 + переход в фазу 3 (с маленькой задержкой)
(48037, 0, 17, 18, 78, 2, 100, 0, 89361, 0, 0, 0, 0, 11, 89353, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Phase 2 - Heal removed - Cast 89353'),
(48037, 0, 18, 19, 61, 2, 100, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Say Text 2'),
(48037, 0, 19, 20, 61, 2, 100, 0, 0, 0, 0, 0, 0, 28, 89352, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - UNAURA 89352'),
(48037, 0, 20, 0, 61, 2, 100, 0, 0, 0, 0, 0, 0, 22, 3, 0, 0, 0, 0, 0, 0, 400, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Set Phase 3'),

-- ==================== ФАЗА 3 (91313) ====================
(48037, 0, 21, 0, 0, 4, 100, 0, 1000, 2000, 20000, 22000, 0, 11, 91313, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Phase 3 - Cast 91313'),

-- Бафф 89353 пропал → назад в фазу 1
(48037, 0, 22, 0, 78, 4, 100, 0, 89353, 4, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Phase 3 - 89353 removed - Phase 1'),

-- Финальный шаг
(48037, 0, 23, 24, 101, 4, 100, 0, 0, 1, 0, 0, 0, 11, 89361, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Phase 3 - HP 1% - Heal'),
(48037, 0, 24, 0, 61, 4, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Say Text 0'),
(48037, 0, 25, 0, 78, 4, 100, 0, 89361, 0, 0, 0, 0, 80, 48037*100, 2, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - TS'),

-- ==================== TIMED ACTION LIST ====================
(48037*100, 9, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 0, 11, 89355, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Cast 89355'),
(48037*100, 9, 1, 0, 0, 0, 100, 1, 0, 0, 0, 0, 0, 33, 48037, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Kill Credit'),
(48037*100, 9, 2, 0, 0, 0, 100, 1, 0, 0, 0, 0, 0, 18, 559360, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Set Unit Flags'),
(48037*100, 9, 3, 0, 0, 0, 100, 1, 0, 0, 0, 0, 0, 28, 89353, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'UNAURA 89353'),
(48037*100, 9, 4, 0, 0, 0, 100, 1, 0, 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Stop Attack'),
(48037*100, 9, 5, 0, 0, 0, 100, 1, 0, 0, 0, 0, 0, 103, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Stop move'),
(48037*100, 9, 6, 0, 0, 0, 100, 1, 2685, 2685, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Say'),
(48037*100, 9, 7, 0, 0, 0, 100, 1, 5815, 5815, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Despawn');

DELETE FROM `creature_text` WHERE `Entry` = 48037;
INSERT INTO `creature_text` (`Entry`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextID`, `MinTimer`, `MaxTimer`, `SpellID`, `AutoType`, `TextRange`, `comment`, `MaxExpansion`, `MinExpansion`) VALUES
(48037, 0, 0, 'Получена взбучка. Идет настройка боевых параметров...', 12, 0, 100, 0, 0, 0, 48287, 0, 0, 0, 0, 0, '', 0, 3),
(48037, 0, 1, 'Результат боя: постыдное поражение. Идет запись новых приемов в боевой режим.', 12, 0, 100, 0, 0, 0, 48288, 0, 0, 0, 0, 0, '', 0, 3),
(48037, 0, 2, 'Поражение. Уровень позора: высокий. Идет настройка стратегии для последующих боев.', 12, 0, 100, 0, 0, 0, 48289, 0, 0, 0, 0, 0, '', 0, 3),
(48037, 0, 3, 'Получена взбучка. Идет оптимизация стратегии для последующих боев...', 12, 0, 100, 0, 0, 0, 48286, 0, 0, 0, 0, 0, '', 0, 3),
(48037, 1, 0, 'Курс самоподготовки завершен!', 12, 0, 100, 0, 0, 0, 48294, 0, 0, 0, 0, 0, '', 0, 3),
(48037, 2, 0, 'Достигнут достаточный уровень подготовки. Возвращаюсь к исполнению сторожевых функций. Спасибо.', 12, 0, 100, 0, 0, 0, 48295, 0, 0, 0, 0, 0, '', 0, 3);