Solved sending item with attributes to offline player's inbox

[zbizu]

How do I send item with actionid/text/description to player's inbox without clearing these attributes?
Sending stuff to online player's inbox via metatables doesn't work yet.

I tried to do it via sql query, but I don't know how to encode that for attributes column:

 

[andypsylon]

https://github.com/otland/forgottenserver/issues/550

local letter = Player(cid):getInbox():addItem(2598, 1, true, 1)
letter:setAttribute(ITEM_ATTRIBUTE_TEXT, "ja servus")

 

[zbizu]

What if player is offline?
I have player name and guid only so I can't use Player metatable

 

[andypsylon]

move it to login.lua

 

[zbizu]

Good idea.
Could you help me with installation query(alter table, data type with defaults + relations)? I want to create table like this:
player_id(relation with players table) | itemid(number 0-30k) | amount(0-100) | price(long number) | actionid(long number) | description(text) | text(text) | writer_guid(relation with players table) | date(long number, eg: 1,394,013,642)

 

[andypsylon]

not really

 

[zbizu]

Ok. I'll write it myself.
Solved, thank you.

Query I used(in case someone needed it):

CREATE TABLE IF NOT EXISTS `onlogin_sendtoinbox` (
  `player_id` int(11) NOT NULL DEFAULT '0',
  `itemtype` smallint(6) NOT NULL DEFAULT '0',
  `count` smallint(5) NOT NULL DEFAULT '0',
  `price` bigint(20) unsigned NOT NULL DEFAULT '0',
  `actionid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `description` varchar(255) NOT NULL DEFAULT '',
  `text` varchar(1023) NOT NULL DEFAULT '',
  `writer_guid` int(11) NOT NULL DEFAULT 0,
  `written_at` bigint(20) NOT NULL,
  FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB