blob: 918caa0a49a6e39096d6836202e85b508f38ecea (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
|
# groups
[<-Back-to:Characters](database-characters.md)
**The \`groups\` table**
This table holds basic info about groups.
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|----------------------|------------|------------|-----|------|---------|-------|---------|
| [guid][1] | INT | UNSIGNED | PRI | NO | | | |
| [leaderGuid][2] | INT | UNSIGNED | | NO | | | |
| [lootMethod][3] | TINYINT | UNSIGNED | | NO | | | |
| [looterGuid][4] | INT | UNSIGNED | | NO | | | |
| [lootThreshold][5] | TINYINT | UNSIGNED | | NO | | | |
| [icon1][6] | INT | UNSIGNED | | NO | | | |
| [icon2][7] | INT | UNSIGNED | | NO | | | |
| [icon3][8] | INT | UNSIGNED | | NO | | | |
| [icon4][9] | INT | UNSIGNED | | NO | | | |
| [icon5][10] | INT | UNSIGNED | | NO | | | |
| [icon6][11] | INT | UNSIGNED | | NO | | | |
| [icon7][12] | INT | UNSIGNED | | NO | | | |
| [icon8][13] | INT | UNSIGNED | | NO | | | |
| [groupType][14] | TINYINT | UNSIGNED | | NO | | | |
| [difficulty][15] | TINYINT | UNSIGNED | | NO | 0 | | |
| [raiddifficulty][16] | TINYINT | UNSIGNED | | NO | 0 | | |
[1]: #guid
[2]: #leaderguid
[3]: #lootmethod
[4]: #looterguid
[5]: #lootthreshold
[6]: #icon1
[7]: #icon2
[8]: #icon3
[9]: #icon4
[10]: #icon5
[11]: #icon6
[12]: #icon7
[13]: #icon8
[14]: #grouptype
[15]: #difficulty
[16]: #raiddifficulty
**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](#groups-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`
|
