NPC Trainer Creation > 3.3.5a < menu

User Tag List

Results 1 to 2 of 2
  1. #1
    Nekatus's Avatar Member
    Reputation
    5
    Join Date
    Nov 2013
    Posts
    13
    Thanks G/R
    0/2
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    NPC Trainer Creation > 3.3.5a <

    Hello, i want to show you how you create a own NPC trainer.
    First we need a NPC. A tutorial for npc creation you can find here :
    http://www.ownedcore.com/forums/worl...-database.html (NPC Creation > 3.3.5a < Database)
    when you have create a NPC you have to change the NPC FLAGS to 16(Trainer)
    But the NPC can't teach you anything. Why?
    we need the table "npc_trainer"
    When you open it, you see this:
    NPC Trainer Creation &gt; 3.3.5a &lt;-npc_trainer-jpg
    its very simple
    create a new entry
    ==========
    entry - the entry id >>of your NPC<<
    spell - the spell ID
    spellcost - how much it cost. (in copper)
    reqskill - the skill you need to learn it.(i dont test it yet)
    reqskillvalue - the value of the skill
    reqlevel - i think, the level you need to learn it(i dont test it yet)
    ==========
    thats it.
    but you have to create for every spell a new entry, so i have create a SQL template for it.


    INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`)
    VALUES (0, 0, 0, 0, 0, 0);
    So i show you how you have to fill it for my example on the top of this thread.

    INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`)
    VALUES (558841, 6899, 500, 0, 0, 0);
    so i wrote, that the NPC with the 558841 can teach me the spell 6899 (brown ram) for 500 copper (5silver)
    when you write in the spellcost column "0" its free.
    you can create a own sql batch with this template and copy it for every spell. you only have to change the spell ID.

    Sorry for my bad english, i hope i helped you.
    when i done mistakes, pls text me.
    Last edited by Nekatus; 11-16-2013 at 01:14 PM.

    NPC Trainer Creation &gt; 3.3.5a &lt;
  2. Thanks the77crook, usagi1 (2 members gave Thanks to Nekatus for this useful post)
  3. #2
    the77crook's Avatar Member
    Reputation
    1
    Join Date
    Jul 2009
    Posts
    1
    Thanks G/R
    1/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Helped a lot thank you so much! would give rep if I could lol

Similar Threads

  1. [Request] [Npc / quest creation]
    By cherix in forum WoW EMU Questions & Requests
    Replies: 1
    Last Post: 07-21-2016, 04:11 AM
  2. [Trinity] Can NPC Trainers DELETE/REPLACE a spell?
    By FrostyC in forum WoW EMU Questions & Requests
    Replies: 0
    Last Post: 02-10-2015, 12:26 AM
  3. NPC Trainer Issues - No Dual Spec Option
    By tbdcarakias in forum WoW EMU Questions & Requests
    Replies: 7
    Last Post: 01-05-2010, 01:35 PM
  4. [request more eyes to see the error :)] Mangos Npc trainer
    By Veldor in forum WoW EMU Questions & Requests
    Replies: 0
    Last Post: 11-18-2009, 12:00 AM
  5. [Ascent] List of Class Trainers and Weapon Masters NPC spawn ID's
    By mkenzi in forum World of Warcraft Emulator Servers
    Replies: 5
    Last Post: 10-21-2007, 11:41 AM
All times are GMT -5. The time now is 01:56 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search