SQL

[Syndicate]

How to add items in inventory using SQL?


ID# 552 ( CHAR ID )

[Feefty]

INSERT INTO `inventory` (`char_id`, `nameid`, `amount`, `identify`) VALUES (CHARID, ITEMID, AMOUNT, 1)

Edited February 13, 2013 by Feefty

[Hyvraine]

Uhh I'm using eAthena

 

INSERT INTO inventory (char_id, nameid, amount, equip, identify, refine, attribute, card0, card1, card2, card3, expire_time)

VALUES (ENTERCHARIDHERE, 552, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0)

 

Just change the ? to the charid of the player

 

of course I'm not good at this so you may ignore this post

 

Edit: oops

Edited February 13, 2013 by kenshn111

[Syndicate]

thabks