blob: bdaf576ff597cde78a2013885bdd23aec66786f9 (
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
47
48
49
50
51
52
53
54
55
56
|
# group\_member
[<-Back-to:Characters](database-characters.md)
**The \`group\_member\` table**
This table holds info about group members.
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
| ---------------- |-------- | ---------- | --- | ---- | ------- | ------ | ------- |
| [guid][1] | INT | UNSIGNED | | NO | | | |
| [memberGuid][2] | INT | UNSIGNED | PRI | NO | | Unique | |
| [memberFlags][3] | TINYINT | UNSIGNED | | NO | 0 | | |
| [subgroup[4] | TINYINT | UNSIGNED | | NO | 0 | | |
| [roles][5] | TINYINT | UNSIGNED | | NO | 0 | | |
[1]: #guid
[2]: #memberguid
[3]: #memberflags
[4]: #subgroup
[5]: #roles
**Description of the fields**
#### guid
GUID of the group. See [groups.guid](groups#guid).
#### memberGuid
GUID of the character member of the group. See [characters.guid](characters#guid).
| Name | Value | Unique |
|----------------------- | ----- | ------ |
| MEMBER_FLAG_ASSISTANT | 0x01 | |
| MEMBER_FLAG_MAINTANK | 0x02 | (U) |
| MEMBER_FLAG_MAINASSIST | 0x04 | (U) |
*(U) = Unique per group.*
### subgroup
Ranging 0-7 (1-8 in client), representing the subgroups of a raid group.
There can only be 5 membes in one subgroup per raid group.
### roles
| Value | Name | Comments |
|------ | ----------- | ---------------------------------------------------------------- |
| 0 | ROLE_NONE | |
| 1 | ROLE_LEADER | The character has signed to Random Dungeon Finder as experienced |
| 2 | ROLE_TANK | The character has signed to Random Dungeon Finder as tank |
| 4 | ROLE_HEALER | The character has signed to Random Dungeon Finder as healer |
| 8 | ROLE_DAMAGE | The character has signed to Random Dungeon Finder as dps |
|
