The `character_social` table
Contains data about character's friends/ignored list.
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) | SIGNED | NO | '' | Friend Note |
Description of the fields
The character guid. See characters.guid.
The GUID of the friend/ignored. See characters.guid.
| Value | Description |
|---|---|
| 0 | Unused entry - previously listed as friend or blocked (removed/unblocked) |
| 1 | Added as friend |
| 2 | Added as blocked user |
| 3 | Added as friend, and in ignorelist as well |
Note about the friend (which appears beside the friend's name in friend list in Client).
Important note: There can be only 50 friend and 50 ignored characters. If you have problems with friends disappearing, try removing some of them first.