Groups tc2

Back to characters database list of tables.

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

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

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

icon1-8

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

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

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

raiddifficulty

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.