WoW-Info — информационный World of Warcraft портал

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`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `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 (300003, 0, 21135, 0, 21135, 0, 'Illidan Stormrage', 'The Betrayer', '', 73, 73, 6370400, 6370400, 7588, 7588, 7685, 1882, 1882, 0, 2, 1, 3, 7896, 16139, 0, 20000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 300003, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 798439, 1527647, '', 0, 3, 0, 1, 442, 617299803, 33, '');

DELETE FROM `creature_loot_template` WHERE (`entry`=300003);
INSERT INTO `creature_loot_template` VALUES  
(300003, 29434, 100, 1, 10, 10, 0, 0, 0),
(300003, 32837, 99, 2, 1, 1, 0, 0, 0),
(300003, 32838, 99, 3, 1, 1, 0, 0, 0),
(300003, 32545, 40, 4, 1, 1, 0, 0, 0),
(300003, 32525, 35, 5, 1, 1, 0, 0, 0),
(300003, 32235, 35, 6, 1, 1, 0, 0, 0),
(300003, 32521, 35, 7, 1, 1, 0, 0, 0),
(300003, 32497, 45, 8, 1, 1, 0, 0, 0),
(300003, 32483, 45, 9, 1, 1, 0, 0, 0),
(300003, 32496, 45, 10, 1, 1, 0, 0, 0),
(300003, 31089, 95, 11, 1, 1, 0, 0, 0),
(300003, 31091, 95, 12, 1, 1, 0, 0, 0),
(300003, 31090, 95, 13, 1, 1, 0, 0, 0),
(300003, 32471, 35, 14, 1, 1, 0, 0, 0),
(300003, 32500, 35, 15, 1, 1, 0, 0, 0),
(300003, 32374, 35, 16, 1, 1, 0, 0, 0),
(300003, 32375, 35, 17, 1, 1, 0, 0, 0),
(300003, 32336, 100, 18, 1, 1, 0, 0, 0);

DELETE FROM `creature_equip_template` WHERE (`entry`=442);
INSERT INTO `creature_equip_template` (`entry`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `equipinfo1`, `equipinfo2`, `equipinfo3`, `equipslot1`, `equipslot2`, `equipslot3`) VALUES (442, 45479, 45481, 0, 33490690, 33490690, 0, 269, 269, 0);