{: #git-wiki-toc}
The `groups` table
This table holds basic info about groups.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
---|---|---|---|---|---|---|---|
guid | int(10) | unsigned | PRI | NO | |||
leaderGuid | int(10) | unsigned | NO | ||||
lootMethod | tinyint(3) | unsigned | NO | ||||
looterGuid | int(10) | unsigned | NO | ||||
lootThreshold | tinyint(3) | unsigned | NO | ||||
icon1 | int(10) | unsigned | NO | ||||
icon2 | int(10) | unsigned | NO | ||||
icon3 | int(10) | unsigned | NO | ||||
icon4 | int(10) | unsigned | NO | ||||
icon5 | int(10) | unsigned | NO | ||||
icon6 | int(10) | unsigned | NO | ||||
icon7 | int(10) | unsigned | NO | ||||
icon8 | int(10) | unsigned | NO | ||||
groupType | tinyint(3) | unsigned | NO | ||||
difficulty | tinyint(3) | unsigned | NO | 0 | |||
raiddifficulty | tinyint(3) | unsigned | NO | 0 |
Description of the fields
The ID of the group. This number is unique to each group and is the main method to identify a group.
The GUID of the character. See characters.guid
Value | Name | Comments |
---|---|---|
0 | FREE_FOR_ALL | |
1 | ROUND_ROBIN | |
2 | MASTER_LOOT | |
3 | GROUP_LOOT | |
4 | NEED_BEFORE_GREED |
Master looter's guid. See characters.guid If lootMethod is not 2, then it's group leader's guid.
field-no-description|5
field-no-description|6
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 |
field-no-description|8
field-no-description|9