Back-to:Characters
The `character_social` table
Contains data about characters' friends/ignored list.
Structure
Field |
Type |
Attributes |
Key |
Null |
Default |
Extra |
Comment |
|
int(10) |
unsigned |
PRI |
NO |
0 |
|
Character Global Unique Identifier |
||
int(10) |
unsigned |
PRI |
NO |
0 |
|
Friend Global Unique Identifier |
||
tinyint(3) |
unsigned |
PRI |
NO |
0 |
|
Friend Flags |
||
varchar(48) |
signed |
|
NO |
_ |
_ |
Friend Note_ |
_ |
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.