目录

character_social

<-Back-to:Characters

The `character_social` table

Contains data about character's friends/ignored list.

Structure

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

Description of the fields

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.