character_gifts
This table holds data about wrapped/gift items.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guid | int | unsigned | MUL | NO | 0 | ||
| item_guid | int | unsigned | PRI | NO | 0 | ||
| entry | int | unsigned | NO | 0 | |||
| flags | int | unsigned | NO | 0 | |||
Description of fields
guid
The guid of the character.
item_guid
The item guid of the wrapped item.
entry
The item entry of the wrapped item.
flags
ITEM_FIELD_FLAGS of the wrapped item.
excerpt:
| Value | Flag | Name | Comment |
|---|---|---|---|
| 1 | 0x00000001 | ITEM_FIELD_FLAG_SOULBOUND | Item is soulbound and cannot be traded |
| 4 | 0x00000004 | ITEM_FIELD_FLAG_UNLOCKED | Item had lock but can be opened now |
| 8 | 0x00000008 | ITEM_FIELD_FLAG_WRAPPED | Item is wrapped and contains another item |
| 256 | 0x00000100 | ITEM_FIELD_FLAG_BOP_TRADEABLE | Allows trading soulbound items |
| 512 | 0x00000200 | ITEM_FIELD_FLAG_READABLE | Opens text page when right clicked |
| 4096 | 0x00001000 | ITEM_FIELD_FLAG_REFUNDABLE | Item can be returned to vendor for its original cost (extended cost) |
| 262144 | 0x00040000 | ITEM_FIELD_FLAG_UNK13 | ? |
| 524288 | 0x00080000 | ITEM_FIELD_FLAG_UNK14 | ? |
| 786944 | 0x000C0200 | ITEM_FLAG_MAIL_TEXT_MASK | |