The `groups` table
This table holds basic info about groups.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guid | INT | UNSIGNED | PRI | NO | |||
| leaderGuid | INT | UNSIGNED | NO | ||||
| lootMethod | TINYINT | UNSIGNED | NO | ||||
| looterGuid | INT | UNSIGNED | NO | ||||
| lootThreshold | TINYINT | UNSIGNED | NO | ||||
| icon1 | BIGINT | UNSIGNED | NO | ||||
| icon2 | BIGINT | UNSIGNED | NO | ||||
| icon3 | BIGINT | UNSIGNED | NO | ||||
| icon4 | BIGINT | UNSIGNED | NO | ||||
| icon5 | BIGINT | UNSIGNED | NO | ||||
| icon6 | BIGINT | UNSIGNED | NO | ||||
| icon7 | BIGINT | UNSIGNED | NO | ||||
| icon8 | BIGINT | UNSIGNED | NO | ||||
| groupType | TINYINT | UNSIGNED | NO | ||||
| difficulty | TINYINT | UNSIGNED | NO | 0 | |||
| raiddifficulty | TINYINT | UNSIGNED | NO | 0 | |||
| masterLooterGuid | INT | UNSIGNED | NO |
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-13
| Value | Name | Comments |
|---|---|---|
| 0 | GROUPTYPE_NORMAL | |
| 1 | GROUPTYPE_BG | |
| 2 | GROUPTYPE_RAID | |
| 3 | GROUPTYPE_BGRAID |