Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELETE FROM `creature_template` WHERE entry = 100002;
- DELETE FROM `creature_equip_template` WHERE CreatureID = 100002;
- INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `ItemID2`, `ItemID3`, `VerifiedBuild`) VALUES (100002, 1, 45899, 0, 0, 0);
- INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `DamageModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES (100002, 0, 0, 0, 0, 0, 28127, 0, 0, 0, 'Roi Varian Wyrnn', 'Roi de Hurlevent', '', 9834, 85, 85, 0, 35, 3, 1, 1.42857, 1, 3, 0, 2500, 2500, 1, 1, 1, 0, 2048, 0, 0, 0, 0, 0, 0, 7, 68, 0, 0, 0, 0, 0, 0, 0, 0, 0, 47502, 46924, 46968, 0, 0, 0, 0, 0, 0, 0, 1000000, 2500000, '', 0, 3, 1, 100, 10, 1, 10, 1, 1, 0, 1, 0, 0, '', 12340);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement