[Help/Question] {Mangos} Starting items

[Vvdarknessvv]

So I reticently moved from using ArcEMU over to using MaNGOS, which I am enjoy the extremely easy database to manipulate to the ideas and projects I want to do. As of such I am still attempting to become familiar with the Database, and Core set up.

What I need help with is a two pronged question.

First is: Where are the starting items located in MaNGOS. Database or core?

Secondly: If they are not located in the MaNGOS database, and they are in the core could some one please identify the location. If they are in the Database, just tell me the name of the database hub, and ill do my best to to figure out the changes on my own.

Thank you again. I am still sorta of new to all of this stuff, only been at it for about 6 months. So any help is greatly appreciative.

[Dythzer]

The default starting items are always read from the DBC files. You can add custom items by adding them to the playercreateinfo_item table in the world DB.

[Vvdarknessvv]

Dythzer thank you so much for you assistance, that one simple answer has resolved so many things. +Rep to you for the help. ( That is when i can add rep again)

Edit:

New question now that I have found this database area, it only list 4 different identifiers.

that would be Race - Class - Itemid - amount.

Now will this just put what ever gear i give them into there inventory, or will it slot into the right spot based off the item id's slot identifier?

If it goes straight into there bag, how would i set it up so that it goes to there apporiate gear id would that be a core edit?

Secondary question answered thank you all.

[xxdamastaxx]

Sorry for resurrecting a really old and dead thread but I have the exact same question as his "Secondary question".
Will it go to bags or its appropriate slot? If its to bags, how do i set it so it starts in a slot?

[quintenwolfe]

Sorry for resurrecting a really old and dead thread but I have the exact same question as his "Secondary question".
Will it go to bags or its appropriate slot? If its to bags, how do i set it so it starts in a slot?

This might be lengthy....

If you do not modify the .dbc file, items you add to playercreateinfo_item will go into inventory bags if there is already an item assigned from CharStartOutfit.dbc.

Here's what you need:

• http://home.hccnet.nl/s.j.francke/csved/csvedsetup.exe (if you do not have MS Excel or something to edited Comma Separated Values.)
• DBCutil.rar

Install csvedsetup.exe.
Make a folder called DBCUtil and put the contents of DBCutil.rar into it.

Next, take the file: CharStartOutfit.dbc and drag it on top of the DBCUtil.exe file.
It will create:
CharStartOutfit.dbc.csv

next, open it with csvedit.

You will have to read the file carefully.

Column 2 = Race (Corresponding Race list below)
Column 3 = Class (Corresponding Class list below)
Column 4 = Gender (0 for Male, 1 for Female)

Column 6 - 30 are item placements. It differs from Class to Class, but most of them stay the same.
(i.e. Column 6 is normally the Chest area, Column 7 is Legs... etc..etc..)

It will look something like this:
(Don't worry about the first column)

long	byte	byte	byte	byte	long	long	long	long	long	long
1	1	1	0	0	38	39	40	0	49778	-1
14	1	1	1	0	38	39	40	0	49778	-1
79	1	2	0	0	45	43	44	6948	2361	-1
36	1	2	1	0	45	43	44	6948	2361	-1
9	1	4	0	0	49	47	48	28979	2092	-1
361	5	6	1	0	34652	34655	34659	34650	0	34653
33	5	9	0	0	6129	1396	59	35	0	-1
62	5	9	1	0	6129	1396	59	35	0	-1
27	6	1	0	0	6125	139	0	2361	6948	-1
63	6	1	1	0	6125	139	0	2361	6948	-1

As you can see, item placements are different. The way to know, is to lookup the item_id in a particular field and figure out what location it is for that Race/Class combination you wish to modify.

Race_ID:

ID 	Name
1  	Human
2  	Orc
3  	Dwarf
4 	Night Elf
5  	Undead
6 	Tauren
7  	Gnome
8  	Troll
9 	Goblin
10 	Blood Elf
11	Draenei

Class_ID

ID      Name
1  	Warrior
2  	Paladin
3  	Hunter
4  	Rogue
5  	Priest
6  	Death Knight
7  	Shaman
8  	Mage
9  	Warlock
11      Druid

remember, Race in Column2 and Class in Column3.

Now, just go through the item_ids, pick the ones you want to change and put a -1 in place of the item_id, that way when you add items to playercreateinfo_item you don't have to constantly go back and forth, modifying the .dbc and stuff.

Save the .csv and drag the .csv file onto DBCutil.exe and it will create a NEW CharStartOutfit.dbc , put the newly modified file into your server's .dbc folder/directory and your almost done.

Below is adding the items in playercreateinfo_item. Now you're done.


Here is an example of what everything looks like.
Replaced all item_id's for Chest, Shoulders, Head, Hands, Waist, Feet, Legs, Wrist, Main-Hand and Finger with a -1 (Only if they had an ITEM in it already) within CharStartOutfit.dbc:
Always leave 6948.
(6948 is the Hearthstone and as you can tell, it is not always in the same column, depending on Race/Class combination)


(Undead Mage)

34	5	8	0	0	-1	-1	-1	-1	-1	-1	-1	0	6948
61	5	8	1	0	-1	-1	-1	-1	-1	-1	-1	0	6948

After replacing the item_id's with -1, I rebuilt the .dbc, put it on the server and then loaded up my database, 'mangosd' and inserted the following:

REPLACE INTO `playercreateinfo_item` (`race`, `class`, `itemid`, `amount`) VALUES
	(5, 8, 22066, 1),
	(5, 8, 22063, 1),
	(5, 8, 22064, 1),
	(5, 8, 22067, 1),
	(5, 8, 22062, 1),
	(5, 8, 50255, 1),
	(5, 8, 42947, 1),
	(5, 8, 42985, 1),
	(5, 8, 22065, 1),
	(5, 8, 48691, 1);

(Race,Class, ITEM_ID, Amount)

With the SQL method, the items automatically go into the correct slots. (As long as you choose an item that can be worn bu the Race/Class or level).

I also did the same for Blood Elves, Just mad another identical set of inserts but replaced the (5, 8, with (10, 8,

THIS ONLY INSERTS, it does not Replace.. so if you do it again, you will add it twice. You should do a DROP or ALTER instead of REPLACE or INSERT.

Now, anyone who starts a Undead/Mage or Blood Elf/Mage will have the same items.

And that's basically it!

[quintenwolfe]

Forgot to mention:

Reload your server after you make changes to the .dbc and the database.

You do not need to make a client patch for this to work.

I've tested this on mangos-wotlk with a 3.3.5a WoW Client, (12340).

If you need a "Step-by-Step" either email me or send me a PM.