character_social
Contains data about characters friends/ignored list.
Note: There can be only 50 friend and 50 ignored characters. If you have problems with friends disappearing, try removing some of them first.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guid | int | unsigned | PRI | NO | 0 | Character Global Unique Identifier | |
| friend | int | unsigned | PRI | NO | 0 | Friend Global Unique Identifier | |
| flags | tinyint | unsigned | PRI | NO | 0 | Friend Flags | |
| note | varchar(48) | NO | '' | Friend Note | |||
Description of fields
guid
The guid of the character.
friend
The character guid of the friend/ignored.
flags
SocialFlag excerpt: A player can be friend and blocked at the same time (0x3).
| Value | Flag | Name | Comment |
|---|---|---|---|
| 0 | 0x00 | Unused entry - previously listed as friend or blocked (removed/unblocked) | |
| 1 | 0x01 | SOCIAL_FLAG_FRIEND | Added as friend |
| 2 | 0x02 | SOCIAL_FLAG_IGNORED | Added as blocked user |
note
Note about the friend (which appears beside the friend's name in friend list in Client).