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/group_member.md | 187 ++++++++++++++++++++++++++++++++++++++++++++++++--- 1 file changed, 178 insertions(+), 9 deletions(-) (limited to 'docs/group_member.md') diff --git a/docs/group_member.md b/docs/group_member.md index fb25ee8..9ed789b 100644 --- a/docs/group_member.md +++ b/docs/group_member.md @@ -1,9 +1,178 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [group_member](group_member) - -Column | Type | Description ---- | --- | --- -Guid | int(10) unsigned | -MemberGuid | int(10) unsigned | -MemberFlags | tinyint(3) unsigned | -Subgroup | tinyint(3) unsigned | -Roles | tinyint(3) unsigned | +# group\_member + +`Back-to:Characters` + +**The \`group\_member\` table** + +This table holds info about group members. + +**Structure** + +  + +  + + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

 

NO

_

  

memberGuid

int(10)

unsigned

PRI

NO

 

Unique

 

memberFlags

tinyint(3)

unsigned

 

NO

0

  

subgroup

tinyint(3)

unsigned

 

NO

0

  

roles

tinyint(3)

unsigned

 

NO

0

  
+ +**Description of the fields** + +#### guid + +GUID of the group. See [groups.guid](http://collab.kpsn.org/display/tc/Groups+tc2#Groupstc2-guid). + +#### memberGuid + +GUID of the character member of the group. See [characters.guid](http://collab.kpsn.org/display/tc/Characters+tc2#Characterstc2-guid). + + +++++ + + + + + + + + + + + + + + + + + +
MEMBER_FLAG_ASSISTANT
0x01
 
MEMBER_FLAG_MAINTANK
0x02
(U)
MEMBER_FLAG_MAINASSIST
0x04
(U)
+ +  + +*(U) = Unique per group.* + +### subgroup + +Ranging 0-7 (1-8 in client), representing the subgroups of a raid group. +There can only be 5 membes in one subgroup per raid group. + +### roles + + +++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Value

Name

Comments

0

ROLE_NONE

 

1

ROLE_LEADER

The character has signed to Random Dungeon Finder as experienced

2

ROLE_TANK

The character has signed to Random Dungeon Finder as tank

4

ROLE_HEALER

The character has signed to Random Dungeon Finder as healer

8

ROLE_DAMAGE

The character has signed to Random Dungeon Finder as dps

+ + -- cgit