Custom Trainer spell template for Arcemu, Trinity, Mangos & Oregoncore menu

These ads disappear when you log in.

Results 1 to 1 of 1
  1. #1
    Harambeqt's Avatar Contributor CoreCoins User
    Reputation
    332
    Join Date
    Mar 2010
    Posts
    1,202
    Thanks G/R
    8/28
    Trade Feedback
    0 (0%)

    Custom Trainer spell template for Arcemu, Trinity, Mangos & Oregoncore

    For ArcEmu 3.3.5:

    Trainer_spells table structure

    Code:
    INSERT INTO `trainer_spells`VALUES (NPCTRAINERID, CASTSPELL, SPELLID, LEARNCOST, REQSPELL, REQSKILL, REQSKILLVALUE, REQLEVEL, DELETESPELL, IS_PROF);


    This query will add "Summon Disco Ball" to a npc trainer with the id "13337" and it will require the player to be level 10 or higher and it will cost 10 gold.

    Code:
    INSERT INTO `trainer_spells`VALUES (13337, 0, 50317, 100000, 0, 0, 10, 0, 0, 
    0);







    Trinity, Mangos & OregonCore 3.3.5:

    Npc_trainer table structure
    Code:
    INSERT INTO 'npc_trainer' VALUES NPCTRAINERID, SPELLID, LEARNCOST, REQSKILL, REQSKILLVALUE, REQLEVEL;

    This query will add "Summon Disco Ball" to a npc trainer with the id "13337" and it will require the player to be level 10 or higher and it will cost 10 gold.


    Code:
    INSERT INTO 'npc_trainer' VALUES 13337, 50317, 100000, 0, 0, 10;
    Last edited by Harambeqt; 02-10-2014 at 01:31 PM.
    (https://hackerlol.xyz/) <-- Yes

    These ads disappear when you log in.

Similar Threads

  1. Item Leecher 3.3.2 for ArcEmu/Mangos/Trinity Cores
    By phanonic in forum WoW EMU Programs
    Replies: 13
    Last Post: 02-21-2010, 08:16 AM
  2. Replies: 12
    Last Post: 12-05-2008, 12:46 PM
  3. [Custom] Deathknight Trainer (100% working for Mangos)
    By newfang in forum World of Warcraft Emulator Servers
    Replies: 35
    Last Post: 06-01-2008, 11:34 AM
  4. [Release] Holiday Releases # 1.5 - Custom Boss Template For Lua
    By Snailz in forum World of Warcraft Emulator Servers
    Replies: 10
    Last Post: 02-14-2008, 07:14 AM
  5. [Release] Knaurs [All - In - 2] Custom Trainers for 2.3.0
    By knaur in forum World of Warcraft Emulator Servers
    Replies: 17
    Last Post: 12-27-2007, 06:32 PM
All times are GMT -5. The time now is 11:06 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved. Digital Point modules: Sphinx-based search