Welcome to AC Web.
Results 1 to 5 of 5
  1. #1

    Allow Humans to be Hunters


    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    I found this on another site

    modify these 2 files...

    1 CharBaseInfo.dbc
    2 CharStartOutfit.dbc

    Add new entry in CharBaseInfo.dbc for race human (1) in first column and for class hunter (2) next column, this will allow the "human" to have the class "hunter" in character selection screen in-game.
    Next use talliis to edit CharStartOutfit.dbc and add a starting outfit for human male and human female.
    the table below has the class and race id's

    Race Ids:
    1 - Human
    2 - Orc
    3 - Dwarf
    4 - Nightelf
    5 - Undead
    6 - Tauren
    7 - Gnome
    8 - Troll
    9 - Goblin
    10 - Bloodelf
    11 - Draenei

    Class Ids:
    1 - Warrior
    2 - Paladin
    3 - Hunter
    4 - Rogue
    5 - Priest
    6 - Death knight
    7 - Shaman
    8 - Mage
    9 - Warlock
    10- Unused
    11 - Druid

    Next create a folder called "DBFilesClient" and drop both DBC files into the folder

    Next open an MPQ editor (included in zip file) create a new blank MPQ and drop the DBFilesClient folder with your 2 DBC files you just edited above in it.

    Now name the MPQ something like "patch-xx.mpq where "xx" can be a number like 4-5-6 or whatever.

    Now drop your new patch-xx.mpq in the WoW game directory /data
    Then take CharBaseInfo.dbc CharStartOutfit.dbc files and drop them to your trinity core folder called ..server/dbc

    Back up and DUMP "player_levelstats" and "playercreateinfo" in your world database, DUMP data and structure before you add my SQL patches encase you have to restore!

    Next open navicat or HeidiSQL and add 2 new SQL patches included in my zip to your World database and execute SQL file called "player_levelstats-HU-hunter.sql" this will add an entry for the new human hunter level stats and playercreateinfo.sql which adds an entry for human/hunter when you create a new character.

    Before you fire up your WoW.exe or your trinity core server clear the WoW folder called "cache" then start your server up then start WoW and when you log in you should be able to create a human hunter.

    when you train you won't have tame beast or dismiss pet, below are the spells "tame beast" and "Dismiss Pet"

    .learn 1515 = tame beast
    .learn 2641 =dismiss pet

    they mention running some .sql files ie player_levelstats-HU-hunter.sql" this will add an entry for the new human hunter level stats and playercreateinfo.sql which adds an entry for human/hunter when you create a new character.

    They dont seem to be around anymore does anytone know what they would contain?

  2. #2
    http://YugoWoW.com/

    Join Date
    Feb 2014
    Location
    http://yugowow.com
    Posts
    2,325
    It's All Classes All Races

  3. #3
    The two sqls file reflect their corresponding table in the database.

    playercreateinfo table contains starting position of a specific race and class.
    player_levelstats table contains data about base stats at a certain level for a specific race and class.

    I bet the playercreateinfo would contain a new row with a race id of 1 and a class id of 3 with the exact same position as any row that is equal to race id of 1. For the other might vary a little depending if a human hunter has a better stat line than a night elf hunter for example.
    However, you could probably copy the base stats from a night elf hunter at all levels for easy implementation.

    Sources: playercreateinfo and player_levelstats.

  4. #4
    Bump!

  5. #5
    Innovation & Emulation

    Join Date
    Feb 2008
    Location
    Great Britain
    Posts
    1,807

    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    This is the basic level 1 data for TC 3.3.5a, I was doing it for a custom class:

    Code:
    INSERT INTO playercreateinfo (race, class, map, zone, position_x, position_y, position_z, orientation) VALUES (1, 12, 0, 12, -8949.95, -132.493, 83.5312, 0);
    INSERT INTO player_levelstats (race, class, LEVEL, str, agi, sta, inte, spi) VALUES (1, 12, 1, 17, 20, 21, 23, 25);
    INSERT INTO player_classlevelstats (class, LEVEL, basehp, basemana) VALUES (12, 1, 20, 0);
    Source: https://github.com/stoneharry/WoW-Custom-Class

 

 

Posting Permissions

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