Character social tc2

Back-to:Characters

The `character_social` table

Contains data about characters' friends/ignored list.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
Character social tc2	int(10)	unsigned	PRI	NO	0		Character Global Unique Identifier
Character social tc2	int(10)	unsigned	PRI	NO	0		Friend Global Unique Identifier
Character social tc2	tinyint(3)	unsigned	PRI	NO	0		Friend Flags
Character social tc2	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.