[Guide] How to add starting items to your players!

[metehan]

Hell this is my 4th guide. I hope it is easy to understand!
1. Go to table called "Playercreateinfo_items".
It should be located in your World DB which is usually named "World" or "Ascent" or "aworld". It should NOT be named "logon" or "character". If you are looking in those databases, you are looking in the wrong ones. Once you open this table, it should look like this.
.
2.Now look at the column called "indexid". This column determines what race/class combo this row determines.
2a. To find what index id corresponds to what Race/Class Combo. First go to the table called "playercreateinfo" then look at the Columns called race and class. Here is what races and classes correspond with what numbers in those columns

Race IDs
1 Human 
2 Orc 
3 Dwarf 
4 Night Elf 
5 Undead 
6 Tauren 
7 Gnome 
8 Troll 
10 Blood Elf 
11 Draenie

Class IDs
1 Warrior 
2 Paladin 
3 Hunter 
4 Rogue 
5 Priest 
7 Shaman 
8 Mage 
9 Warlock 
11 Druid

Thanks to SectorSeven for these lists. You can find them here. http://www.mmowned.com/forums/emulat...guy-needs.html
Ok, say I want to find the index ID for dranei hunters. I will look in the race column for "11". Then once filter that down, I will look for a "3" in the class column. Then I will look at the index ID column for the row that has the "11" in the race column and the "3" in the class column. And I should find a 46.
.
3. Ok now that you have found the correct Index ID go back to your "playercreateinfo_items" table. And create a new column and enter the desired index ID, in the Index column, I will use 46 as an example.
It should look like this so far.

4. Now in the protoID column for the new row I just completed. I will add the Item ID of the item I want this character to start with.
5. Now the column called "slotid" is for the ID of the bag slot you want the item to be in when the character is created. Make sure your not using an already used one!
Here is a list of bagslots to use.

0=head 
1=neck 
2=shoulders 
3=shirt 
4=chest 
5=waist 
6=legs 
7=feet 
8=wrists 
9=gloves 
10=finger1 
11=finger2 
12=trinket1 
13=trinket2 
14= Back 
15= Main Hand 
16= Off Hand 
17= Ranged 
18= Tabard 

INVENTORY BAG SLOTS = 19 amd goes to 22 (the 4 bagslots next to the backpack) 

INVENTORY ITEM = 23 and goes to 39 (the backpack slots) 

BANK ITEMS = 39 and goes to 66 (bankslots) 

BANK BAG SLOTS = 67 and goes to 73 (bagslots in bank) 

KEYRING = 86 and goes to 118

Credits to latruwski for this list.
4. How many of those do you want the player to start with? 5? 6? or 1? Well put that in the column called amount and your done!!(If your making it more than one make sure the item is stackable.)
Your done, gratz.

[Gastricpenguin]

Easier method:
ORN - SQL Generator

[diagnol]

Good guide very handy+Rep

[metehan]

Good guide very handy+Rep

That would be nice if you had any rep power -_-

[malthi]

maybe im going to use this

[Cursed]

Thanks for the guide (+rep) and thanks Gastric for that site...

Edit: I gave you some before oO so I have to spread...

[mupo]

hehe hope no dumb people try it IT TAKES A LIL BIT OF A BRAIN but great guide

[Gzus15]

nice guide, helped my server alot