AzerothCore
groups
The `groups` table
This table holds basic info about groups.
Structure
Field |
Type |
Attributes |
Key |
Null |
Default |
Extra |
Comment |
int(10) |
unsigned |
PRI |
NO |
||||
int(10) |
unsigned |
NO |
|
|
|||
tinyint(3) |
unsigned |
|
NO |
||||
int(10) |
unsigned |
NO |
|
|
|||
tinyint(3) |
unsigned |
|
NO |
||||
int(10) |
unsigned |
NO |
|
|
|||
int(10) |
unsigned |
|
NO |
||||
int(10) |
unsigned |
NO |
|
|
|||
int(10) |
unsigned |
|
NO |
||||
int(10) |
unsigned |
NO |
|
||||
int(10) |
unsigned |
|
NO |
||||
int(10) |
unsigned |
NO |
|||||
int(10) |
unsigned |
|
NO |
||||
tinyint(3) |
unsigned |
NO |
|||||
tinyint(3) |
unsigned |
|
NO |
0 |
|
|
|
tinyint(3) |
unsigned |
|
NO |
0 |
|
|
Description of the fields
guid
The ID of the group. This number is unique to each group and is the main method to identify a group.
leaderGuid
The GUID of the character. See characters.guid
lootMethod
Value |
Name |
Comments |
|---|---|---|
0 |
FREE_FOR_ALL |
|
1 |
ROUND_ROBIN |
|
2 |
MASTER_LOOT |
|
3 |
GROUP_LOOT |
|
4 |
NEED_BEFORE_GREED |
|
looterGuid
Master looter's guid. See characters.guid If lootMethod is not 2, then it's group leader's guid.
lootThreshold
field-no-description|5
icon1-8
field-no-description|6
groupType
Value |
Name |
Comments |
|---|---|---|
0 |
GROUPTYPE_NORMAL |
|
1 |
GROUPTYPE_BG |
|
2 |
GROUPTYPE_RAID |
|
3 |
GROUPTYPE_BGRAID |
GROUPTYPE_BG + GROUPTYPE_RAID, // mask |
4 |
GROUPTYPE_UNK1 |
|
8 |
GROUPTYPE_LFG |
|
difficulty
field-no-description|8
raiddifficulty
field-no-description|9