Character social tc2
From TrinityCore Wiki
|
Back to characters database list of tables.
The `character_social` table
Contains data about characters' friends/ignored list.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
| guid | int(10) | unsigned | PRI | NO | 0 | Character Global Unique Identifier | |
| friend | int(10) | unsigned | PRI | NO | 0 | Friend Global Unique Identifier | |
| flags | tinyint(3) | unsigned | PRI | NO | 0 | Friend Flags | |
| note | varchar(48) | signed | NO | Friend Note |
Description of the fields
guid
The GUID of the character. See character.guid
friend
The 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 |
note
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.
