Boss
REPLACE INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (229170, 0, 21135, 0, 21135, 0, 'Illidan Stormrage', 'The Betrayer', '', 73, 73, 60704000, 60704000, 758800, 75880, 768500, 14, 14, 0, 2, 1, 3, 10896, 20139, 0, 84124, 1500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 108, 229170, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16777215, 16777215, '', 0, 3, 0, 1, 2181, 80428891, 33, 'mob_eventai');
eventAI
DELETE FROM `scriptdev2`.`eventai_scripts` WHERE `creature_id`=229170;
INSERT INTO `scriptdev2`.`eventai_scripts` (`id`,`creature_id`,`event_type`,`event_inverse_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`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
(1, 229170, 2, 0, 100, 1, 100, 90, 2000, 2000, 11, 40157, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(2, 229170, 2, 0, 100, 1, 89, 80, 20000, 30000, 11, 29943, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(3, 229170, 2, 0, 100, 1, 79, 70, 60000, 70000, 11, 41032, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(4, 229170, 2, 0, 100, 1, 69, 60, 40000, 40000, 11, 41541, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(5, 229170, 2, 0, 100, 1, 59, 50, 2000, 2000, 11, 41471, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(6, 229170, 2, 0, 100, 1, 49, 40, 5000, 5000, 11, 41485, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(7, 229170, 2, 0, 100, 1, 39, 30, 5000, 5000, 11, 40595, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(8, 229170, 2, 0, 100, 1, 29, 20, 50000, 50000, 11, 39837, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(9, 229170, 2, 0, 100, 1, 19, 10, 30000, 30000, 11, 31970, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(10, 229170, 2, 0, 100, 1, 9, 0, 60000, 60000, 11, 31306, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
reknete mi kde mam chybu? proste ten boss si spelli kdy chce...