How do I add a starting_items to all...

[AdrianD]

How do I add a new item to all possible character combinations in a certain starting zone with starting_items through a query without adding the item individually to each possibility?

For example:

I want to add a "Bone Chips" (13073) so when a new character logs in it is in their inventory.

Thanks

[Nerdgasm]

I do all my stuff manually using Excel then input into the DB, but if you wanted just bonechips for everyone it'd be

ID - 1(Or whatever ID is unsed)
race - 0
Class - 0
deityid - 0
zoneid - 0 - Unless you wanted a specific zone that they start in.
itemid - X(Bonechip id)
item_charges - x(How many ever you want)
gm - 0
slot - -1

[Kingly_Krab]

Try this query (since ID is auto-incrementing you do not need ID in the query).

INSERT INTO `starting_items` (`race`, `class`, `deityid`, `zoneid`, `itemid`, `item_charges`, `gm`, `slot`) VALUES ('0', '0', '0', '0', '13073', '20', '0', '-1');