Serverlands

[WORLD] Template NPC - Insert the Creature & Command

Jan 15th, 2022 (edited)
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.97 KB | None | 0 0
  1. Set @NpcName = "TemplateNPC",
  2.     @NpcSubname = "",
  3.     @NpcEntry = 55002,
  4.     @NpcDisplayID = 31833,
  5.     @NpcLevel = 80;
  6.  
  7. 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`, `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`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `DamageModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `spell_school_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES
  8. (@NpcEntry, 0, 0, 0, 0, 0, @NpcDisplayID, 0, 0, 0, @NpcName, @NpcSubname, '', 0, @NpcLevel, @NpcLevel, 0, 35, 1, 1, 1.14286, 1, 1, 0, 2000, 2000, 1, 1, 2, 0, 2048, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 50, 50, 1, 1, 1, 0, 0, 1, 0, 0, 0, 'TemplateNPC', 12340);
  9. INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`) VALUES
  10. (55002, 'Here you can select a character template which will Gear, Gem, Spec, and finish glyphs for your toon instantly.\r\n\r\nSelect your spec:', 'Here you can select a character template which will Gear, Gem, Spec, and finish glyphs for your toon instantly.\r\n\r\nSelect your spec:');
  11.  
  12. INSERT INTO `command` (`name`, `permission`, `help`) VALUES
  13. ('templatenpc reload', 607, 'Syntax: .templatenpc reload\nType .templatenpc reload to reload TemplateNPC custom script.');
Add Comment
Please, Sign In to add comment