Add/Change Character Starting Items

[shtzngiggles]

Here is an easy way to add and/or change your character starting items and gear. By Shtzngiggles

Template

 
INSERT INTO playercreateinfo_items ('indexid', 'protoid', 'slotid', 'ammount') values

The indexid is the id for each race/class choice, you can find the list in the playercreateinfo table. Yours should be something like 1 through 55 by default.
It helps to know what each of your index ID's is for, in order to decide what class gear you want to give each class.

When you look in you playercreateinfo table you will see the class column. Here is the list of classes ID's for this.

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

How that you know what ID is for what class you can start giving your starting characters gear. For this example we will give ALL starting warriors Tier 2.
The indexid for warriors is 1 through 8. The next column is protoid which is the item id number. The 3rd column is the slotid, meaning where the item fits on the body or in bag. Here is what I found.

0. Head
1. Neck
2. Shoulder
3. Shirt
4. Chest
5. Belt
6. Pants
7. Boots
8. Bracer
9. Gloves
15. Weapon
17. Ranged
19. Ammo pouch
23. Food/Water etc
24. Food/Water etc
25. Healthstone

The last column is for the amount of each item you want the character to have. Since we are giving warriors tier 2 we only want to set that at 1.

When you finish it should look something like this.

 
INSERT INTO playercreateinfo_items VALUES ('1', '16963', '0', '1');
INSERT INTO playercreateinfo_items VALUES ('1', '16961', '2', '1');
INSERT INTO playercreateinfo_items VALUES ('1', '16966', '4', '1');
INSERT INTO playercreateinfo_items VALUES ('1', '16959', '8', '1');
INSERT INTO playercreateinfo_items VALUES ('1', '16964', '9', '1');
INSERT INTO playercreateinfo_items VALUES ('1', '16960', '5', '1');
INSERT INTO playercreateinfo_items VALUES ('1', '16962', '6', '1');
INSERT INTO playercreateinfo_items VALUES ('1', '16965', '7', '1');
INSERT INTO playercreateinfo_items VALUES ('2', '16963', '0', '1');
INSERT INTO playercreateinfo_items VALUES ('2', '16961', '2', '1');
INSERT INTO playercreateinfo_items VALUES ('2', '16966', '4', '1');
INSERT INTO playercreateinfo_items VALUES ('2', '16959', '8', '1');
INSERT INTO playercreateinfo_items VALUES ('2', '16964', '9', '1');
INSERT INTO playercreateinfo_items VALUES ('2', '16960', '5', '1');
INSERT INTO playercreateinfo_items VALUES ('2', '16962', '6', '1');
INSERT INTO playercreateinfo_items VALUES ('2', '16965', '7', '1');
INSERT INTO playercreateinfo_items VALUES ('3', '16963', '0', '1');
INSERT INTO playercreateinfo_items VALUES ('3', '16961', '2', '1');
INSERT INTO playercreateinfo_items VALUES ('3', '16966', '4', '1');
INSERT INTO playercreateinfo_items VALUES ('3', '16959', '8', '1');
INSERT INTO playercreateinfo_items VALUES ('3', '16964', '9', '1');
INSERT INTO playercreateinfo_items VALUES ('3', '16960', '5', '1');
INSERT INTO playercreateinfo_items VALUES ('3', '16962', '6', '1');
INSERT INTO playercreateinfo_items VALUES ('3', '16965', '7', '1');
INSERT INTO playercreateinfo_items VALUES ('4', '16963', '0', '1');
INSERT INTO playercreateinfo_items VALUES ('4', '16961', '2', '1');
INSERT INTO playercreateinfo_items VALUES ('4', '16966', '4', '1');
INSERT INTO playercreateinfo_items VALUES ('4', '16959', '8', '1');
INSERT INTO playercreateinfo_items VALUES ('4', '16964', '9', '1');
INSERT INTO playercreateinfo_items VALUES ('4', '16960', '5', '1');
INSERT INTO playercreateinfo_items VALUES ('4', '16962', '6', '1');
INSERT INTO playercreateinfo_items VALUES ('4', '16965', '7', '1');
INSERT INTO playercreateinfo_items VALUES ('5', '16963', '0', '1');
INSERT INTO playercreateinfo_items VALUES ('5', '16961', '2', '1');
INSERT INTO playercreateinfo_items VALUES ('5', '16966', '4', '1');
INSERT INTO playercreateinfo_items VALUES ('5', '16959', '8', '1');
INSERT INTO playercreateinfo_items VALUES ('5', '16964', '9', '1');
INSERT INTO playercreateinfo_items VALUES ('5', '16960', '5', '1');
INSERT INTO playercreateinfo_items VALUES ('5', '16962', '6', '1');
INSERT INTO playercreateinfo_items VALUES ('5', '16965', '7', '1');
INSERT INTO playercreateinfo_items VALUES ('6', '16963', '0', '1');
INSERT INTO playercreateinfo_items VALUES ('6', '16961', '2', '1');
INSERT INTO playercreateinfo_items VALUES ('6', '16966', '4', '1');
INSERT INTO playercreateinfo_items VALUES ('6', '16959', '8', '1');
INSERT INTO playercreateinfo_items VALUES ('6', '16964', '9', '1');
INSERT INTO playercreateinfo_items VALUES ('6', '16960', '5', '1');
INSERT INTO playercreateinfo_items VALUES ('6', '16962', '6', '1');
INSERT INTO playercreateinfo_items VALUES ('6', '16965', '7', '1');
INSERT INTO playercreateinfo_items VALUES ('7', '16963', '0', '1');
INSERT INTO playercreateinfo_items VALUES ('7', '16961', '2', '1');
INSERT INTO playercreateinfo_items VALUES ('7', '16966', '4', '1');
INSERT INTO playercreateinfo_items VALUES ('7', '16959', '8', '1');
INSERT INTO playercreateinfo_items VALUES ('7', '16964', '9', '1');
INSERT INTO playercreateinfo_items VALUES ('7', '16960', '5', '1');
INSERT INTO playercreateinfo_items VALUES ('7', '16962', '6', '1');
INSERT INTO playercreateinfo_items VALUES ('7', '16965', '7', '1');
INSERT INTO playercreateinfo_items VALUES ('8', '16963', '0', '1');
INSERT INTO playercreateinfo_items VALUES ('8', '16961', '2', '1');
INSERT INTO playercreateinfo_items VALUES ('8', '16966', '4', '1');
INSERT INTO playercreateinfo_items VALUES ('8', '16959', '8', '1');
INSERT INTO playercreateinfo_items VALUES ('8', '16964', '9', '1');
INSERT INTO playercreateinfo_items VALUES ('8', '16960', '5', '1');
INSERT INTO playercreateinfo_items VALUES ('8', '16962', '6', '1');
INSERT INTO playercreateinfo_items VALUES ('8', '16965', '7', '1');

Also, if you want you characters to have this quipped it helps to delete the gear it already was starting with before you edited it.

Now our starting warriors will have tier 2 equipped.

[Chrispee]

nice mate nice will help some guys out here +1rep for u

[jokerjokes]

Yea very nice.

[Warhawk78]

Good guide.

[secretdragon008]

cool and good,i think i will use this on my server.
+rep for you.

[vb4evr]

Great guide. Thanks

[chanceless]

nice for funservers :P

[mafiaboy]

AMAZING been looking for this!

[subliminal]

very good guide, thats a rep

[Jammerr]

How would you go about making your char start at a certain level on creation?

[Illidan1]

Nice man repost but nice
Also you could use Gastr Website to do it

[Gastricpenguin]

Pirates of Azeroth
Mah new site

[beltic]

yeah, um. thats a bad link. talk about spam!

[Dragonscale]

Thnx For this it WILL Come In Handy

[saiyanseth24]

sry im kind of a noob but
can you do this on all servers or just private ones,
and were do you type that in at?