DELETE FROM `creature_text` WHERE `Entry` = 47462;
INSERT INTO `creature_text` (`Entry`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextID`, `MinTimer`, `MaxTimer`, `SpellID`, `AutoType`, `TextRange`, `comment`, `MaxExpansion`, `MinExpansion`) VALUES
(47462, 0, 0, 'The flames of Ragnaros will burn you all.', 14, 0, 100, 0, 0, 0, 50366, 0, 0, 0, 0, 0, 'Archduke Calcinder to Player', 0, 3),
(47462, 1, 0, '%s слабеет! Теперь отгоняй его!', 41, 0, 100, 0, 0, 0, 47654, 0, 0, 0, 9, 0, 'Эрцгерцог Кальциндер to 0', 0, 3),
(47462, 2, 0, 'Fools!  You cannot defeat me!  I will only return again...', 14, 0, 100, 0, 0, 0, 47657, 0, 0, 0, 1, 0, 'Archduke Calcinder to 0', 0, 3),
(47462, 3, 0, 'NOOOOOO!  THIS CANNOT BE!  I... AM... IMMORTAL...!', 14, 0, 100, 0, 0, 0, 47656, 0, 0, 0, 6, 0, 'Archduke Calcinder to Player', 0, 3);

DELETE FROM `smart_scripts` WHERE `entryorguid` = 47462 AND `source_type` = 0;
DELETE FROM `smart_scripts` WHERE `entryorguid` = 47462*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
(47462, 0, 0, 0, 25, 0, 100, 0, 0, 0, 0, 0, 0, 42, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, '47462 - Cant die will be left 1% hp'),
(47462, 0, 1, 0, 25, 0, 100, 0, 0, 0, 0, 0, 0, 242, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Reset Timed Event'),
(47462, 0, 2, 0, 4, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'On Aggro - Say'),
(47462, 0, 3, 4, 101, 0, 100, 1, 0, 45, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Hp 45% - Say'),
(47462, 0, 4, 5, 61, 0, 100, 0, 0, 0, 0, 0, 0, 80, 47462*100, 2, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'TS'),

(47462*100, 9, 0, 0, 0, 0, 100, 1, 8000, 8000, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'TS'),
(47462, 0, 5, 0, 61, 0, 100, 1, 0, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 0, 1000, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Say'),
(47462, 0, 6, 7, 8, 0, 100, 0, 88547, 0, 60000, 60000, 0, 242, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Reset Timed Event'),

(47462, 0, 7, 8, 8, 0, 100, 0, 88547, 0, 60000, 60000, 0, 20, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Stop Attack'),
(47462, 0, 8, 9, 61, 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'),
(47462, 0, 9, 10, 61, 0, 100, 1, 0, 0, 0, 0, 0, 5, 474, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - Emote'),
(47462, 0, 10, 0, 61, 0, 100, 1, 0, 0, 0, 0, 0, 33, 47462, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Link - KC');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `SourceGroup` = 1 AND `SourceEntry` = 88547;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`, `MaxExpansion`, `MinExpansion`) VALUES
(13, 1, 88547, 0, 0, 31, 0, 3, 47462, 0, 0, 0, '', 'Target must be creature 47462', 0, 3),
(13, 1, 88547, 0, 0, 38, 0, 45, 4, 0, 0, 0, '', 'Target HP <= 45%', 0, 3);

UPDATE `creature_template` SET `AIName` = 'SmartAI', `flags_extra` = 130 WHERE `entry` = 47464;
DELETE FROM `smart_scripts` WHERE `entryorguid` = 47464 AND `source_type` = 0;
DELETE FROM `smart_scripts` WHERE `entryorguid` = 47464*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`, `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
(47464, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 80, 47464*100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'JS - TS'),

(47464*100, 9, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 11, 88545, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'TS - Cast'),
(47464*100, 9, 1, 0, 0, 0, 100, 1, 3203, 3203, 0, 0, 84, 3, 0, 0, 0, 0, 0, 19, 47462, 100, 0, 0, 0, 0, 0, 'SAY'),
(47464*100, 9, 2, 0, 0, 0, 100, 1, 4844, 4844, 0, 0, 41, 0, 0, 0, 0, 0, 0, 19, 47462, 100, 0, 0, 0, 0, 0, 'Despawn - Mob');