[Help] Changing Character Starting Items and Spells

[Agent Orange]

Hey guys, I have seen other post about how to change starting items but i havnt seen what the ID is for a Death Knight and i havnt seen any guide on how to change the starting spells also so i was wondering if you could give me a link to a up to date page or post what you know here. Thanks

[Choices]

You can change the spells a player starts with in playercreateinfo_spells

The columns are indexid and spellid. So indexid would be whatever race/class combo you want this spell to start on. Spellid:the spell you want

Now the indexId's for Deathknight are:
56
57
58
59
60
61
62
63
64
65

[Agent Orange]

alright thanks all i need now is the items thing

[Choices]

alright thanks all i need now is the items thing

What items thing?

[Agent Orange]

Finding out how to make a Death Knight start out with different gear then it normally has

[Choices]

Insert into playercreateinfo_items (Indexid, protoid, slotid, amount)

The indexid 's for deathknight are: 56
57
58
59
60
61
62
63
64
65


The protoid means the item you will add.

The slotid is where the item will go, here is the id list:

0----Head
1----Neck
2----Shoulders
3----Body
4----Chest
5----Waist
6----Legs
7----Feet
8----Wrists
9----Hands
10---Finger1
11---Finger2
12---Trinket1
13---Trinket2
14---Back
15---Mainhand
16---Offhand
17---Ranged
18---Tabard
19---Bag Slot 1
20---Bag Slot 2
21---Bag Slot 3
22---Bag Slot 4
23---Backpack Slot 1
24---Backpack Slot 2
25---Backpack Slot 3
26---Backpack Slot 4
27---Backpack Slot 5
28---Backpack Slot 6
29---Backpack Slot 7
30---Backpack Slot 8
31---Backpack Slot 9
32---Backpack Slot 10
33---Backpack Slot 11
34---Backpack Slot 12
35---Backpack Slot 13
36---Backpack Slot 14
37---Backpack Slot 15
38---Backpack Slot 16

Amount is how many of those items you want a player to start with.

Here is an Example:

REPLACE INTO playercreateinfo_items (indexid, protoid, slotid, amount) VALUES ('56', '13072', '9', '1');

Meaning on Human deathknights, the item Stonegrip Gauntlets - Item - World of Warcraft will be on the hands of new dk's

[Agent Orange]

wow thanks man +rep and i have a question. I changed the DK's beginning spells to a different spell id and when i make a new DK it has the same spells as before and i deleted my cache also and they still stayed the same any idea what went wrong?

[Choices]

delete from `playercreateinfo_spells` WHERE `indexid` ='56', '57', '58', '59', '60', '61', '62', '63', '64', '65';

Then add your new spells

[Agent Orange]

ok thanks + another rep since u answered both questions

[Agent Orange]

I think its 50-65 for the ids