Znote Shop item to other player

[rafaeru]

Hello, i try to create selection item to other player on Znote ACC. Someone maybe have advice for me how i can write it ?

Like this:

 

[Znote]

If the player is offline, you can transfer the item directly to the table player_depotitems. (find player_id by name in players table, verify that player_id is not in players_online table, then figure out which depotid you want to send item to and add the record in player_depotitem table).

An easier approach would be to just add it to the shop retrieval queue (table znote_shop_orders), then they need to say !shop to retrieve the item.

INSERT INTO `znote_shop_orders` (`account_id`, `type`, `itemid`, `count`)
VALUES ('ACCOUNT_ID', '1', 'ITEMID', 'ITEM_COUNT');

Search after account_id on players table by name (from search field), use that account_id to populate znote_shop_orders table with itemid and count.