How to create a custom npc in either Navicat or HeidiSQL menu

User Tag List

Results 1 to 7 of 7
  1. #1
    stubbsy27993's Avatar Private
    Reputation
    1
    Join Date
    May 2010
    Posts
    9
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to create a custom npc in either Navicat or HeidiSQL

    Hey i know its probably a freaquently asked question or a realy noob question but i just made a Private server and i want to know how to create a custom NPC, USING A DB EDITER
    i dnt want to know about npc creators or programs or scripting one, i know it can be done just by using navicat or heidiSQL but how?

    I need to know what to type where
    and btw i cant script because microsoft c++ 2010 wont compile trinitycore for whatever reason it cant open .vcproj files wich is the core

    Can someone please help me i cant find anything about making a npc in the db editor
    +Rep for any helpers with ANSWERS

    These ads disappear when you log in.

  2. #2
    Mnemon's Avatar Private
    Reputation
    4
    Join Date
    Apr 2007
    Posts
    8
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The easiest way man is to head to WoW Vendetta - Wage Your War | WoW-V.com, create an account, and use the creation tool they have. After you make an NPC (or whatever) you have the option of saving an SQL file that you can just import into your database.

    Then you have to spawn the NPC in game.

    Once you do that a few times you can figure out what each of the fields is for and head right into the DB and make changes yourself.

    What server are you using? If you're using Mangos I can give you more specific directions.
    Last edited by Mnemon; 06-07-2010 at 08:58 AM.

  3. #3
    stubbsy27993's Avatar Private
    Reputation
    1
    Join Date
    May 2010
    Posts
    9
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Im using trinity core,
    does it matter that its a repack because all the sql's i get from wow-v it wont let me add.
    Trinity's basicly the same as Mangos, any ideas what tables to change?
    Know any guides?

  4. #4
    secretdragon008's Avatar Knight
    Reputation
    43
    Join Date
    Sep 2007
    Posts
    217
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You can create a new creature/npc in your creature_template in your world db.
    Read here to know what each field means

  5. #5
    Eric Graham's Avatar Member
    Reputation
    1
    Join Date
    Mar 2016
    Posts
    2
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Can you direct me to a link that works ...You can create a new creature/npc in your creature_template in your world db.
    Read here to know what each field means .. the link is down. I would appreciate any assistance. email me at [email protected] if need be.

  6. #6
    Hellspawn17's Avatar Member
    Reputation
    1
    Join Date
    Apr 2020
    Posts
    7
    Thanks G/R
    1/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Okay first you have to log in to the database with Hedisql then open the world database usually named world Ascent or mangos. Then find the creature table usally called Creature_template or Creature_Names

    Fill in the entries for the NPC you want like for example

    Entry would be your NPC id like for example 66617 (also used in game to spawn your npc)

    Name the name of your npc
    Sub name the name under your NPCs name

    Info_str is left blank

    Flags1 usally set to 1 so you can interact with the NPC

    Type the type of creature the NPC will be usally 7 for humanoid figure

    Family usally left 0 but is the family your npc belongs to like a pack of wolfs


    Rank the rank 0-3 0 being normal 1-3 being boss levels meaning Elite Elite Rare and Boss

    Killcredit1 left 0

    Killcredit2 left 0

    MaleDisplayid the display id of your npc can be found on other NPC in list or looked up online

    Femaledisplayid left 0

    MaleDisplayid2 left 0

    Female displayid2 left 0

    Unknown float 1 put 1

    Unknown float 2 put 1

    Leader put 1 for like a king or boss leave 0 for neutral

    Questitem 1 -6 left 0 (used for custom quest rewards)

    Waypointid left 0

    Now make sure to hit Ctrl enter to save

    Now open Creature_proto

    Insert a new coloum and fill it out

    Entry (same id as the NPC from above)

    Min level the minimum level of your Npc

    Maxlevel the maximum level of your Npc

    Faction put to 6 to be neutral to both races (horde and Alliance)

    Min health the lowest amount of health your npc has

    Max health the highest amount of health your Npc has

    Mana how much Mana your Npc has

    Scale put to 1 for normal size or higher for huge size

    NPC flags (here is the fun part) NPC FLAGS 0 (Nothing) 1 (Gossip) 2 (Quests) 3 (Quests) (Gossip) 16 (Tra - Pastebin.com
    Tells you what the NPC flags are and do

    Attack time how fast or slow your npc will attack mobs

    Attack type the type of attack your npc will use

    Min damage the least amount of damage your npc deals to mobs

    Max damage the highest amount of damage your npc deals to mobs

    Can ranged 0-1 (0 = no 1= yes)

    Rangedattacktime how fast your npc will use ranged attack

    Rangedmindamage the least amount of ranged damage your npc deals to mobs

    Rangedmaxdamage the highest amount of damage your npc deals to mobs

    Respawntime how fast or long it takes your npc to respwan after death

    Armor the amount of armor your npc has

    Resistance 1-6 (highest amount available is 255 for each) how resistant your npc is to the game elements

    Combat_reach how far your npc can fight mobs from or how close

    Bonding radius leave 1

    Auras (used for auras haven't looked into it yet so leave blank)

    Boss weather or not your npc is a Boss or not

    Money (how much money your npc has calculated by copper value so 1000000 is 1 gold)

    Invisibility_type left 0

    Walkspeed how fast your npc walks put to 0 for stationary

    Runspeed how fast your npc runs put to 0 for stationary

    Flyspeed how fast your npc flys put to 0 for stationary

    Extra_a9_flags left 0

    Spell 1-4 put spell IDs here for spells you want your npc to use

    Spell flags left 0

    Modimmunitys weather or not the .modify command will affect your npc or not

    Is training dummy left 0 unless want a NPC for target practice then put to 1

    Guardtype left 0

    Summonguard left 0

    Now press Ctrl enter

    And that is how you make a custom NPC in your Hedisql database with no other programs or apps.

  7. #7
    Hellspawn17's Avatar Member
    Reputation
    1
    Join Date
    Apr 2020
    Posts
    7
    Thanks G/R
    1/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    To summon the NPC in game use the command .NPC Spawn (entry id)

    Make sure you are a gm with the GM table being set to az for all GM commands under accounts table in your database otherwise you won't be able to spawn in your Npc

Similar Threads

  1. How to create a warp NPC in C++
    By mager1794 in forum WoW EMU Guides & Tutorials
    Replies: 21
    Last Post: 09-09-2008, 06:18 PM
  2. How to make a custom NPC on Mangos?
    By WhiteCrow in forum WoW EMU Questions & Requests
    Replies: 1
    Last Post: 08-18-2008, 09:18 AM
  3. [Guide] How to create a Warp-NPC (Teleporter)
    By nikey_007 in forum WoW EMU Guides & Tutorials
    Replies: 19
    Last Post: 06-26-2008, 08:30 AM
  4. [Guide] How To Make A Custom NPC With Pics!
    By Xtinction in forum WoW EMU Guides & Tutorials
    Replies: 4
    Last Post: 05-18-2008, 01:30 PM
  5. [question] how to make an custom npc cast spells?
    By INS4N3K1LL in forum World of Warcraft Emulator Servers
    Replies: 5
    Last Post: 05-18-2008, 07:45 AM
All times are GMT -5. The time now is 09:25 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2021 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search