From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/groups.md | 339 +++++++++++++++++++++++++++++++++++++++++++++++++++++---- 1 file changed, 318 insertions(+), 21 deletions(-) (limited to 'docs/groups.md') diff --git a/docs/groups.md b/docs/groups.md index 9e27c8d..18d63ad 100644 --- a/docs/groups.md +++ b/docs/groups.md @@ -1,21 +1,318 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [groups](groups) - -Column | Type | Description ---- | --- | --- -Guid | int(10) unsigned | -LeaderGuid | int(10) unsigned | -LootMethod | tinyint(3) unsigned | -LooterGuid | int(10) unsigned | -LootThreshold | tinyint(3) unsigned | -Icon1 | int(10) unsigned | -Icon2 | int(10) unsigned | -Icon3 | int(10) unsigned | -Icon4 | int(10) unsigned | -Icon5 | int(10) unsigned | -Icon6 | int(10) unsigned | -Icon7 | int(10) unsigned | -Icon8 | int(10) unsigned | -GroupType | tinyint(3) unsigned | -Difficulty | tinyint(3) unsigned | -RaidDifficulty | tinyint(3) unsigned | -MasterLooterGuid | int(10) unsigned | +# 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](#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` -- cgit