Add or Change Character Starting Items

[spearman360]

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

Template
Code:

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.

Code:


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.

[KingOfWar]

I want a letter that people get when stating any character and it has all the rules and information in it... is that possible?

[spearman360]

It may possible..But I am not sure.

[LumZor]

Sure it is Possible... First create a Letter or a book With The Rules..
Then do this
INSERT INTO playercreateinfo_items VALUES ('4', '#the id of letter#', '7', '1');

to create a letter try to find a different letter in database and try to make a new and very simular... remember a letter item can be stored in more database tables like items_text or something... best thing to do is find a letter nobody will use and just change name and text in it... thats the best way to dont get confused!

[LS12]

Sure it is Possible... First create a Letter or a book With The Rules..
Then do this
INSERT INTO playercreateinfo_items VALUES ('4', '#the id of letter#', '7', '1');

to create a letter try to find a different letter in database and try to make a new and very simular... remember a letter item can be stored in more database tables like items_text or something... best thing to do is find a letter nobody will use and just change name and text in it... thats the best way to dont get confused!


How do i create a letter or a Book?

[Mr. Sandman]

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



This is incorrect. Each indexid is for every class/race combination. It's not only from 1 to 11...

I followed your guide to a tee for making a custom item and having each player start with it (it was a shirt). Long story short, i made it so there was only that item for slot 3 for indexid's 1-11 and not all of the races and classes for races had the item...

To help determine what the indexid for each class and race combo are, you could try searching the item for each id.... I'm way too lazy to do that myself... sorry...

But if you are interested in doing what i did, you will need to remake all slotid 3 items for each indexid that is in your database...

[maymacc]

+rep Spearman, this helped my friend a lot!

[Mr. Sandman]

+rep Spearman, this helped my friend a lot!

i love how you rep him for an incorrect tutorial... fascinating...

[Drifter00]

this was copied from mmowned also.

[maxiex0]

mr sandman not to be rude but it works fine just sometimes server shit just doesnt work on some peoples comps that or u probobly did something wrong

[wartick]

Thanks thanks thanks! I was looking for the eq slot id list for like million years!