Starting Gear

[B14d3r11]

Okay my Warriors start off with DK gear, idk why but i want that changed so I need help finding what gives what and to who... i also want to add it so it gives them a item in their bags when they start...

[Mr.Ice.Cold]

Your playercreateinfo_items table has this information I believe. Match the item you want in the slot you want to put it.

[B14d3r11]

but i cannot find it idk what the tables do what

[Mr.Ice.Cold]

Find your world database (Using navicat for example) there should be a table called "playercreateinfo_items". Inside you should find a list of items the player will start with depending on their class. Match the class number using the "playercreateinfo" table. Edit the slotid with the slot (add the additem to your inventory and see what slot it goes in...for example, slot "3" is a shirt slot.) Use the existing tables to help you.

[B14d3r11]

I know that... God people take me for a retard, The reason i cant do it, is because it doesnt even look like the playercreateinfo and playercreateinfo_items dont go together their Valuse/tables dont even look like they go together.

Edit:
Idk how IndexID from playercreateinfo_items goes with the playercreateinfo

[bigjohnson4]

The playercreateinfo table supplies the basic information for all other playercreateinfo_* tables to use. For example, and it's just that, I don't have ArcEmu, let's say the race and class numbers for Human Warrior are 1 (Race) and 1 (Class). That table (playercreateinfo) has that combination matched up only once. Since it's only once, that combination receives a GUID, or Global Unique Identifier, so you don't get it mixed up with other combinations like it. This GUID is the called the Index in your database.

So, in the playercreateinfo_items table, each combination is referenced using the index number for each combination, in this table it's called 'indexid'. The protoid is the item entry, and youshould know the rest of the columns.

[namelessgnome]

Every index in playercreateinfo maps to a Race/Class combination (among other things).

Every entry in playercreateinfo_items maps to a playercreateinfo entry