Before I start typing out this guide, I will admit that I'm no expert on DBC editing and that some of this information may be incorrect. If you know of any additional information, notice an error, etc.. just comment and I'll do my best to keep this thread updated.
There are a few things that you'll need before editing a DBC file. I've seen many different programs, and even more people recommending each program over every other program, but the vast majority either didn't work or corrupted the DBC files. I'll only be recommending the programs that work for me. So, before you continue reading, please
download this; it contains everything that I use. These programs will only work on Windows.
Just in case anyone wants to know what I'm running:
- Windows 8, x64 -- Home
- Debian 7 x32 -- Server
- TrinityCore -- Latest version as of 15/June/2014
- WoTLK 3.3.5a
Assuming that you've followed my instructions to download the
toolsthat we'll be using in this tutorial, lets begin!
Tip:
When editing any files that can be packed into an MPQ file, you can just go into your /Data/enUS/ folder and create a new folder, lets call it patch-enUS-n.mpq, and place all of the files that you would place into the MPQ file in there. This is extremely useful if you don't want to keep on creating a new MPQ file every time you go to test new edits. When you release the edits you should place them into an MPQ file as it hides everything from the average user.
Credits to MyLilSuccy for this information.
If you already know how to edit DBC files, which I'm going to assume that most of the people reading this don't, then you can skip to the end of this post and check out my notes on the DBC files. Although I would recommend doing a quick read-through of the tutorial.
The rest of this will be a simple explanation of how to alter the Male Human Warrior's starting gear. Although this example is fairly specific, it does cover everything you'll need to edit any race, class, and gender combination.
-----------------------------------------------------------------------------------------------------------------------------------
Now that you've downloaded the tools and have a folder of clean, unedited, DBC files to work with and revert to in-case of any unforeseen errors, lets begin!
Go to the folder containing your DBC files, copy the
CharStartOutfit.dbc file into the
/Tools/DBCUtil/ folder, and then double-click on
DBCUtil.exe. Now go to the
/Tools/CSVed/ folder, double-click on
CSVed.exe, select
File then
Open... and select
/Tools/DBCUtil/CharStartOutfit.dbc.csv. To edit a record in CSVed you simply need to double-click on the row and then click the
Apply Changes button in the bottom-left corner of the edit form window. Before we go any further I
must mention that the
CharStartOutfit.dbc file is an utter mess and because of this I will be writing the rest of this tutorial in the belief that you are changing
all of the starting outfits for all of the races and their class/gender combinations. The first thing that you should do in
CSVed is to select all of the records, then right-click on a record, and delete all of them. This will allow you to create a simple, easy to read, and easy to edit file to replace the mess that Blizzard has left us with.
I will be using some customized gear as this tutorial was written as I was editing the starting gear on my server. To avoid any confusion and to allow you to easily follow this tutorial, here are the queries for the items we will be using:
View query here:
http://pastebin.com/quwVRbsJI haven't tested this query as it's a direct export from the database on my server, but it should work and if it doesn't just tell me.
Now that you've got the three items we'll be using imported into your database and you have an empty
CharStartOutfit.dbc file open in
CSVed we can begin inputting our data. The first things we need to enter is a unique row ID in the first column, race ID in the second column, class ID in the third, gender ID in the fourth, and to leave the fifth column as zero. If you're looking for the race and class IDs you can find them near the end of this post. In this case we will be entering 1, 1, 1, 0, and 0 in each of the first five columns. These numbers mean that this record is the first record which represents a Human Warrior who is Male.
For the next three columns we will input
800001,
800003, and
800002. These are the entry IDs of the chestpiece, pants, and boots of the set our Male Human Warrior will start with. These IDs can be in any order, just write down which order you put them in for future reference. Columns
nine to
twenty-nine will all have
-1 as their value as we aren't going to allow the Male Human Warrior to start with anything other than a chestpiece, pants, and boots.
Columns
thirty to
thirty-two will define which pieces of gear will show up on the character creation screen. Because of this you do not need to list the display ID of every single item the character starts with. Because the Male Human Warrior will start with a chestpiece, pants, and boots we will be listing all three display IDs. I've prepared four different queries for you to use with your database to find the display IDs of whichever items you're using. Pick one of them and where it says to put numbers just input the correct numbers and run the query.
View query here:
http://pastebin.com/zkG5DRweBecause we're using the custom items I've supplied we will enter
52958,
14450, and
9929 in each of the columns from
thirty to
thirty-two. The rest of the display ID columns from
thirty-three to
fifty-three will contain
-1 as we have no other display IDs to enter. The final numbers to enter are
4,
7, and
8 in columns
fifty-four to
fifty-six. These three numbers say that the items in columns
six to
eight and the display IDs in columns
thirty to
thirty-two represent a chestpiece, pants, and boots. You can find more information on these values near the end of this post.
Now that you've finished setting up the Male Human Warrior you can click
File and then
Save. Now go into
/Tools/DBCUtil/, delete
CharStartOutfit.dbc if it still exists, and then drag
CharStartOutfit.dbc.csv onto
DBCUtil.exe to create the new
CharStartOutfit.dbc. This file needs to be copied into your
/Server/bin/data/dbc/ folder as well as added to a
.MPQ file that all of your users should be given. If you require instruction on how to create a new MPQ file you can refer to
this tutorial.
Your server doesn't need to be restarted after adding the
CharStartOutfit.dbc to the
/Server/bin/data/dbc/ folder, but your client will need to be restarted after placing the MPQ file into your
/WoW/Data/ folder as far as I know.
Below are a few images to show the finished product of all this work:
-----------------------------------------------------------------------------------------------------------------------------------
CharStartOutfit.dbc Column Information:- Column 1 - This is a unique ID of the row.
- Column 2 - This is the Race ID.
- Column 3 - This is the Class ID.
- Column 4 - This represents either Male (0) or Female (1).
- Column 5 - Unknown. Leave this as 0.
- Columns 6 to 29 - The entry IDs of the items this race/class/gender combination will start with.
- Columns 30 to 53 - The display IDs of the items this race/class/gender combination will start with. This is only used on the character creation screen so you only need to enter the display IDs of the armor/weapons.
- Columns 54 to 77 - The InventoryType of each item.
When entering in the display IDs and InventoryTypes of each item you must write them in the exact same order as the items appear in columns 6 to 29.
InventoryTypes:- NonEquip = 0
- Head = 1
- Neck = 2
- Shoulders = 3
- Body = 4
- Chest = 5
- Waist = 6
- Legs = 7
- Feet = 8
- Wrists = 9
- Hands = 10
- Finger = 11
- Trinket = 12
- Weapon = 13
- Shield = 14
- Ranged = 15
- Cloak = 16
- TwoHandedWeapon = 17
- Bag = 18
- Tabard = 19
- Robe = 20
- MainHandWeapon = 21
- OffHandWeapon = 22
- Holdable = 23
- Ammo = 24
- Thrown = 25
- RangedRight = 26
- Quiver = 27
- Relic = 28
Class IDs:- Warrior = 1
- Paladin = 2
- Hunter = 3
- Rogue = 4
- Priest =5
- Deathknight = 6
- Shaman = 7
- Mage = 8
- Warlock = 9
- Druid = 11
Race IDs:- Human = 1
- Dwarf = 2
- Night Elf = 3
- Undead = 4
- Tauren = 5
- Gnome = 6
- Troll =7
- Blood Elf =8
- Draenei =10
- Orc = 11
-----------------------------------------------------------------------------------------------------------------------------------
If you want to stay up-to-date with my latest tutorials or if you just want an easier way to view all of my tutorials and releases in one place then take a look at
my blog.
