SQL statement for adding starting items?

[hayward6]

I want to add a specific item to every starting player, how is that done without going through each line and adding it? I hated to ask this since its a simple and short question... sorry

[So_1337]

INSERT INTO starting_items VALUES (179,0,0,0,0,59943,1,0,0);
This inserts the Kobold Skull Charm into everyone's charm slot when they start their character.

Your column names go in this order:

id, race, class, deityid, zoneid, itemid, item_charges, gm, slot

Just take the query above and plug those in =)

[hayward6]

Is there a way to add it to the next available inventory slot? I think the wiki has slot numbers so i'll go check there.

Thank you,

[tweak24]

Your best bet would be to make them auto equip it but the wiki has a list of all slots including if needed bags