Untitled

INSERT INTO `eventai_scripts` (`creature_id`, `event_type`, `event_inverse_phase_mask`, `event_param1`, `event_param2`, `event_param3`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES
('7999','6','0','100','0','0','2','2000008','0','0','0','0','0','0','0','0','0','0','Tyrande Aggro Yell'),
('7999','0','0','10000','5000','0','11','38935','1','1','0','0','0','0','0','0','0','0','Tyrande Starfire (id:38935) Cast'),
('7999','0','0','4000','2000','0','11','20690','4','0','0','0','0','0','0','0','0','0','Tyrande Moonfire (id:20690) Cast'),
('7999','4','0','22','18','0','2','2000009','0','0','0','0','0','0','0','0','0','0','Tyrande at 20 % HP'),
('7999','8','0','100','0','0','2','2000010','0','0','0','0','0','0','0','0','0','0','Tyrande Death');

INSERT INTO `localized_texts` 
(`id`,`locale_0`,`locale_1`,`locale_2`,`locale_3`,`locale_4`,`locale_5`,`locale_6`,`locale_7`,`comment`) VALUES
('2000008', 'Anu'/dora!', '', '', '', '', '', '', '', 'Tyrande Aggro'),
('2000009', 'I cannot hold them off for long!Elune, give me strength!', '', '', '', '', '', '', '', 'Tyrande at 20 %'),
('2000010', 'NO! All... is... lost.', '', '', '', '', '', '', '', 'Tyrande Death');

Update `creature_template` set `minhealth`='850000', `maxhealth`='900000', `armor`='4000', `mindmg`='3000', `maxdmg`='8000', attackpower='19250', `resistance2`='50', `resistance1`='50', `resistance3`='50', `resistance4`='50', `resistance5`='50', `resistance6`='50', `scriptname`='mob_eventai' where `entry` in (7999);