AzerothCore
Posts (Latest 10 updated) :
Read all

character_social

<-Back-to:Characters

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.