Welcome to AC Web.
Results 1 to 8 of 8

Thread: 3.3.5 Trainers

  1. #1

    3.3.5 Trainers


    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    I made Class Trainers, Weapons Trainer and Riding Trainer for the new 3.3.5 core : b283565d8adb+

    Enjoy folks

    https://github.com/Fullhouser/Class-...%20Trainer.sql

  2. #2
    K A P P A L O U N G E

    Join Date
    Sep 2011
    Location
    Germany
    Posts
    2,414
    May be useful for some.

    +rep for release

  3. #3
    well done , thank you

  4. #4
    Awesome! when importing this into the DB where does it go? The world DB?

  5. #5


    Join Date
    Apr 2008
    Location
    Security supervisor
    Posts
    957
    Quote Originally Posted by Grizzlykiwi View Post
    Awesome! when importing this into the DB where does it go? The world DB?
    Yes.

    It'll select the tables on its own.

  6. #6
    I am to add a gossip menu so I can add talent reset to these guys, I cant seem to figure it out, any help would be appreciated.

  7. #7
    Quote Originally Posted by Mallor View Post
    Yes.

    It'll select the tables on its own.

    Another question does this replace all the trainers? or does it create a trainer which you can spawn that covers everything?

  8. #8

    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    Quote Originally Posted by Grizzlykiwi View Post
    Another question does this replace all the trainers? or does it create a trainer which you can spawn that covers everything?
    It creates an NPC for each class. So, there should be 10 NPCs + two more, 'Weapons Trainer' and 'Riding Trainer'.

    REPLACE INTO `creature_template` (entry,modelid1,name,subname,minlevel,maxlevel,fac tion,npcflag,scale,unit_class,type) VALUES
    (900000,24036,'Warrior Trainer','Server Trainer',80,80,35,51,2,2,7),
    (900001,24032,'Paladin Trainer','Server Trainer',80,80,35,51,2,2,7),
    (900002,24030,'Hunter Trainer','Server Trainer',80,80,35,51,2,2,7),
    (900003,23777,'Rogue Trainer','Server Trainer',80,80,35,51,2,2,7),
    (900004,24033,'Priest Trainer','Server Trainer',80,80,35,51,2,2,7),
    (900005,28516,'Death Knight Trainer','Server Trainer',80,80,35,51,2,2,7),
    (900006,24034,'Shaman Trainer','Server Trainer',80,80,35,51,2,2,7),
    (900007,24031,'Mage Trainer','Server Trainer',80,80,35,51,2,2,7),
    (900008,24035,'Warlock Trainer','Server Trainer',80,80,35,51,2,2,7),
    (900009,24029,'Druid Trainer','Server Trainer',80,80,35,51,2,2,7);

    REPLACE INTO `creature_template` (entry,modelid1,name,subname,minlevel,maxlevel,fac tion,npcflag,scale,unit_class,type) VALUES
    (900011,30790,'Riding Trainer','Server Trainer',80,80,35,16,1,2,7);
    REPLACE INTO `creature_template` (entry,modelid1,name,subname,minlevel,maxlevel,fac tion,npcflag,scale,unit_class,type) VALUES
    (900012,30790,'Weapons Trainer','Server Trainer',80,80,35,16,1,2,7);
    Last edited by mindsear; 02-19-2019 at 10:28 PM.

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •