How do I add a starting_items to all...
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 |
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 |
Try this query (since ID is auto-incrementing you do not need ID in the query).
Code:
INSERT INTO `starting_items` (`race`, `class`, `deityid`, `zoneid`, `itemid`, `item_charges`, `gm`, `slot`) VALUES ('0', '0', '0', '0', '13073', '20', '0', '-1'); |
All times are GMT -4. The time now is 11:56 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.