blob: 8497e388f592ee7b83e3d900381e61509082343a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
# character\_social
[<-Back-to:Characters](database-characters.md)
**The \`character\_social\` table**
Contains data about character's friends/ignored list.
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
| ----------- | ----------- | ---------- | --- | ---- | ------- | ----- | ---------------------------------- |
| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Character Global Unique Identifier |
| [friend][2] | INT | UNSIGNED | PRI | NO | 0 | | Friend Global Unique Identifier |
| [flags][3] | TINYINT | UNSIGNED | PRI | NO | 0 | | Friend Flags |
| [note][4] | VARCHAR(48) | SIGNED | | NO | '' | | Friend Note |
[1]: #guid
[2]: #friend
[3]: #flags
[4]: #note
**Description of the fields**
### guid
The character guid. See [characters.guid](characters#guid).
### friend
The GUID of the friend/ignored. See [characters.guid](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.
|
