EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)
-   -   How do I add a starting_items to all... (https://www.eqemulator.org/forums/showthread.php?t=39063)

AdrianD 12-02-2014 01:55 PM

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

Nerdgasm 01-13-2015 03:02 AM

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 01-13-2015 04:43 AM

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.