Tabelle: 'character_social'
The `character_social` tableContains data about characters' friends/ignored list. Structure| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|
| guid | int(10) | vorzeichenlos | PRI | nein | 0 | | Character Global Unique Identifier | | friend | int(10) | vorzeichenlos | PRI | nein | 0 | | Friend Global Unique Identifier | | flags | tinyint(3) | vorzeichenlos | PRI | nein | 0 | | Friend Flags | | note | varchar(48) | vorzeichenbehaftet | | nein | | | Friend Note |
Description of the fieldsguidThe GUID of the character. See character.guid friendThe GUID of the friend/ignored. See characters/guid flags| 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 |
noteNote 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.
|
