EQEmulator Forums - SQL statement for adding starting items?

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - SQL statement for adding starting items? (https://www.eqemulator.org/forums/showthread.php?t=25912)

hayward6

08-09-2008 11:33 AM

SQL statement for adding starting items?

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

08-09-2008 07:38 PM

Code:

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:

Code:

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

Just take the query above and plug those in =)

hayward6

08-19-2008 12:32 PM

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

08-22-2008 11:15 AM

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

All times are GMT -4. The time now is 04:25 AM.