Back-to:Characters
The `groups` table
This table holds basic info about groups.
Structure
Field |
Type |
Attributes |
Key |
Null |
Default |
Extra |
Comment |
|||||||||
int(10) |
unsigned |
PRI |
NO |
_ |
_ |
_ |
-_ |
leaderGuid_ |
int(10)_ |
unsigned_ |
_ |
NO_ |
_ |
|
|
|
tinyint(3) |
unsigned |
|
NO |
_ |
_ |
_ |
-_ |
looterGuid_ |
int(10)_ |
unsigned_ |
_ |
NO_ |
_ |
|
|
|
tinyint(3) |
unsigned |
|
NO |
_ |
_ |
_ |
-_ |
icon1_ |
int(10)_ |
unsigned_ |
_ |
NO_ |
_ |
|
|
|
int(10) |
unsigned |
|
NO |
_ |
_ |
_ |
-_ |
icon3_ |
int(10)_ |
unsigned_ |
_ |
NO_ |
_ |
|
|
|
int(10) |
unsigned |
|
NO |
_ |
_ |
_ |
-_ |
icon5_ |
int(10)_ |
unsigned_ |
_ |
NO_ |
_ |
|
|
|
int(10) |
unsigned |
|
NO |
_ |
_ |
_ |
-_ |
icon7_ |
int(10)_ |
unsigned_ |
_ |
NO_ |
_ |
|
|
|
int(10) |
unsigned |
|
NO |
_ |
_ |
_ |
-_ |
groupType_ |
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