...
Back-to:Characters
The `groups` tabletable-no-description
This table holds basic info about groups.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment | |||||||||
int(1110) | unsigned | PRI | NO | _ | _ | _ | -_ | leaderGuid_ | int(1110)_ | unsigned_ | _ | NO_ | _ |
|
| |
tinyint(43) | unsigned |
| NO | _ | _ | _ | -_ | looterGuid_ | int(1110)_ | unsigned_ | _ | NO_ | _ |
|
| |
tinyint(43) | unsigned |
| NO | _ | _ | _ | -_ | icon1_ | int(1110)_ | unsigned_ | _ | NO_ | _ |
|
| |
int(1110) | unsigned |
| NO | _ | _ | _ | -_ | icon3_ | int(1110)_ | unsigned_ | _ | NO_ | _ |
|
| |
int(1110) | unsigned |
| NO | _ | _ | _ | -_ | icon5_ | int(1110)_ | unsigned_ | _ | NO_ | _ |
|
| |
int(1110) | unsigned |
| NO | _ | _ | _ | -_ | icon7_ | int(1110)_ | unsigned_ | _ | NO_ | _ |
|
| |
int(1110) | unsigned |
| NO | _ | _ | _ | -_ | groupType_ | mediumint tinyint(83)_ | unsigned_ | _ | NO_ | _ |
|
| |
tinyint(3) | unsigned |
| NO | 0 |
|
| ||||||||||
int tinyint(113) | unsigned |
| NO | 0 |
|
|
Description of the fields
guid
field-no-description|1
leaderGuid
field-no-description|2
lootMethod
field-no-description|3
looterGuid
field-no-description|4
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
...
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
...