groups

Back-to:Characters

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

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