character_social 表

Contains data about character's friends/ignored list.

表结构

Field	Type	Attributes	Key	Null	Default	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

字段说明

guid

The character guid. See characters.guid.

friend

The GUID of the friend/ignored. See characters.guid.

flags

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

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.