From b2a2ea0534d321c9027469fbe6b985dc84343399 Mon Sep 17 00:00:00 2001 From: Walter Pagani Date: Tue, 5 Jan 2021 15:53:36 -0300 Subject: chore(wiki): HTML -> Markdown (#328) --- docs/PageTextMaterial.md | 83 ++------- docs/character_action.md | 189 +++---------------- docs/character_social.md | 105 ++--------- docs/creature_summon_groups.md | 244 ++++-------------------- docs/game_event_battleground_holiday.md | 124 ++---------- docs/group_member.md | 172 +++-------------- docs/groups.md | 321 +++++--------------------------- docs/linked_respawn.md | 105 ++--------- docs/petition.md | 113 ++--------- docs/petition_sign.md | 125 ++----------- 10 files changed, 242 insertions(+), 1339 deletions(-) (limited to 'docs') diff --git a/docs/PageTextMaterial.md b/docs/PageTextMaterial.md index 6fd9cd1..27fd59f 100644 --- a/docs/PageTextMaterial.md +++ b/docs/PageTextMaterial.md @@ -3,7 +3,7 @@ <noinclude>| `Back-to:DBC` -<big>**PageTextMaterial.dbc**</big> +**PageTextMaterial.dbc** This DBC contains material used to display a gossip window for quest or page text. @@ -11,76 +11,21 @@ This DBC contains material used to display a gossip window for quest or page tex ## Structure - ----- - - - - - - - - - - - - - - - - - - - -
Column
Field
Type
1
ID
Integer
2
sRefCon
String
+| Column | Field | Type | +|--------|---------|---------| +| 1 | ID | Integer | +| 2 | sRefCon | String | ## **Content** </noinclude> - ---- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

ID

Name

1

Parchment

2

Stone

3

Marble

4

Silver

5

Bronze

6

Valentine

7

Illidan

- - +| ID | Name | +|----|-----------| +| 1 | Parchment | +| 2 | Stone | +| 3 | Marble | +| 4 | Silver | +| 5 | Bronze | +| 6 | Valentine | +| 7 | Illidan | diff --git a/docs/character_action.md b/docs/character_action.md index 6327f0f..fa5d77e 100644 --- a/docs/character_action.md +++ b/docs/character_action.md @@ -8,80 +8,13 @@ Contains all the individual button data for each character. A button is any of t **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

 

spec

tinyint(3)

unsigned

PRI

NO

0

 

 

button

tinyint(3)

unsigned

PRI

NO

0

 

 

action

int(10)

unsigned

 

NO

0

 

 

type

tinyint(3)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|--------|------------|------------|-----|------|---------|-------|---------| +| guid | int(10) | unsigned | PRI | NO | 0 | | | +| spec | tinyint(3) | unsigned | PRI | NO | 0 | | | +| button | tinyint(3) | unsigned | PRI | NO | 0 | | | +| action | int(10) | unsigned | | NO | 0 | | | +| type | tinyint(3) | unsigned | | NO | 0 | | | **Description of the fields** @@ -101,60 +34,18 @@ Special bars are used for stances, auras, pets, stealth, and other similar speci **Possible values** - ---- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Button IDs

Set (key)

1-11

1 (SHIFT + 1)

12-23

2 (SHIFT + 2)

24-35

3 (SHIFT + 3) h1. Right Side Bar

36-47

4 (SHIFT + 4) Right Side Bar 2

48-59

5 (SHIFT + 5) h1. Bottom Right Bar

60-71

6 (SHIFT + 6) Bottom Left Bar

72-83

1 SpecialA

84-95

1 SpecialB

96-107

1 SpecialC

108-119

1 SpecialD

+| Button IDs | Set (key) | +|------------|------------------------------------| +| 1-11 | 1 (SHIFT + 1) | +| 12-23 | 2 (SHIFT + 2) | +| 24-35 | 3 (SHIFT + 3) h1. Right Side Bar | +| 36-47 | 4 (SHIFT + 4) Right Side Bar 2 | +| 48-59 | 5 (SHIFT + 5) h1. Bottom Right Bar | +| 60-71 | 6 (SHIFT + 6) Bottom Left Bar | +| 72-83 | 1 SpecialA | +| 84-95 | 1 SpecialB | +| 96-107 | 1 SpecialC | +| 108-119 | 1 SpecialD | ### action @@ -166,37 +57,11 @@ The type of action: **Possible types** - ---- - - - - - - - - - - - - - - - - - - - - - - - - - - -

0

Spell

1

Click

32

Eq set

64

Macro

65

Click macro

128

Item

- - +| Value | Description | +|-------|-------------| +| 0 | Spell | +| 1 | Click | +| 32 | Eq set | +| 64 | Macro | +| 65 | Click macro | +| 128 | Item | diff --git a/docs/character_social.md b/docs/character_social.md index 0d3048b..1f56ac0 100644 --- a/docs/character_social.md +++ b/docs/character_social.md @@ -8,70 +8,17 @@ Contains data about characters' friends/ignored list. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

Character Global Unique Identifier

friend

int(10)

unsigned

PRI

NO

0

 

Friend Global Unique Identifier

flags

tinyint(3)

unsigned

PRI

NO

0

 

Friend Flags

note

varchar(48)

signed

 

NO

  

Friend Note

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-------------|-------------|------------|-----|------|---------|-------|------------------------------------| +| [guid][1] | int(10) | unsigned | PRI | NO | 0 | | Character Global Unique Identifier | +| [friend][2] | int(10) | unsigned | PRI | NO | 0 | | Friend Global Unique Identifier | +| [flags][3] | tinyint(3) | unsigned | PRI | NO | 0 | | Friend Flags | +| [note][4] | varchar(48) | signed | | NO | | | Friend Note | + +[1]: #guid +[2]: #friend +[3]: #flags +[4]: #note **Description of the fields** @@ -85,30 +32,12 @@ The GUID of the friend/ignored. See characters.guid ### flags - ---- - - - - - - - - - - - - - - - - - - -

0

Unused entry - previously listed as friend or blocked (removed/unblocked)

1

Added as friend

2

Added as blocked user

3

Added as friend, and in ignorelist as well

+| Value | Description | +|-------|---------------------------------------------------------------------------| +| 0 | Unused entry - previously listed as friend or blocked (removed/unblocked) | +| 1 | Added as friend | +| 2 | Added as blocked user | +| 3 | Added as friend, and in ignorelist as well | ### note diff --git a/docs/creature_summon_groups.md b/docs/creature_summon_groups.md index b7cffb6..84432ae 100644 --- a/docs/creature_summon_groups.md +++ b/docs/creature_summon_groups.md @@ -8,130 +8,29 @@ This table holds data about temporary summoned creatures. It is possible to grou ## Structure - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

summonerId

mediumint(8)

unsigned

 

NO

0

 

 

summonerType

tinyint(3)

unsigned

 

NO

0

 

 

groupIdtinyint(3)unsigned NO0  
entrymediumint(8)unsigned NO0  

position_x

float

 

 

NO

0

 

 

position_y

float

 

 

NO

0

 

 

position_z

float

 

 

NO

0

 

 

orientation

float

 

 

NO

0

 

 

summonTypetinyint(3)unsigned NO0  
summonTimeint(10)unsigned NO0  
+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-------------------|--------------|------------|-----|------|---------|-------|---------| +| [summonerId][1] | mediumint(8) | unsigned | | NO | 0 | | | +| [summonerType][2] | tinyint(3) | unsigned | | NO | 0 | | | +| [groupId][3] | tinyint(3) | unsigned | | NO | 0 | | | +| [entry][4] | mediumint(8) | unsigned | | NO | 0 | | | +| [position_x][5] | float | | | NO | 0 | | | +| [position_y][6] | float | | | NO | 0 | | | +| [position_z][7] | float | | | NO | 0 | | | +| [orientation][8] | float | | | NO | 0 | | | +| [summonType][9] | tinyint(3) | unsigned | | NO | 0 | | | +| [summonTime][10] | int(10) | unsigned | | NO | 0 | | | + +[1]: #summonerid +[2]: #summonertype +[3]: #groupid +[4]: #entry +[5]: #position_x +[6]: #position_y +[7]: #position_z +[8]: #orientation +[9]: #summontype +[10]: #summontime ## **Description of the fields** @@ -143,32 +42,11 @@ Summoner's id depending on [summonerType](#creature_summon_groups-summonerType) Summoner's type: - ---- - - - - - - - - - - - - - - - - - - - - -

Value

Type

0

SUMMONER_TYPE_CREATURE

1

SUMMONER_TYPE_GAMEOBJECT

2

SUMMONER_TYPE_MAP

+| Value | Type | +|-------|--------------------------| +| 0 | SUMMONER_TYPE_CREATURE | +| 1 | SUMMONER_TYPE_GAMEOBJECT | +| 2 | SUMMONER_TYPE_MAP | ### groupId @@ -196,62 +74,16 @@ Orientation the summoned creature will get when spawned ### summonType - ----- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Value

Name

Comments

1

TEMPSUMMON_TIMED_OR_DEAD_DESPAWN

Despawns after a specified time OR when the creature disappears

2

TEMPSUMMON_TIMED_OR_CORPSE_DESPAWN

Despawns after a specified time OR when the creature dies

3

TEMPSUMMON_TIMED_DESPAWN

Despawns after a specified time

4

TEMPSUMMON_TIMED_DESPAWN_OUT_OF_COMBAT

Despawns after a specified time after the creature is out of combat

5

TEMPSUMMON_CORPSE_DESPAWN

Despawns instantly after death

6

TEMPSUMMON_CORPSE_TIMED_DESPAWN

Despawns after a specified time after death

7

TEMPSUMMON_DEAD_DESPAWN

Despawns when the creature disappears

8

TEMPSUMMON_MANUAL_DESPAWN

Despawns when UnSummon() is called

+| Value | Name | Comments | +|-------|----------------------------------------|---------------------------------------------------------------------| +| 1 | TEMPSUMMON_TIMED_OR_DEAD_DESPAWN | Despawns after a specified time OR when the creature disappears | +| 2 | TEMPSUMMON_TIMED_OR_CORPSE_DESPAWN | Despawns after a specified time OR when the creature dies | +| 3 | TEMPSUMMON_TIMED_DESPAWN | Despawns after a specified time | +| 4 | TEMPSUMMON_TIMED_DESPAWN_OUT_OF_COMBAT | Despawns after a specified time after the creature is out of combat | +| 5 | TEMPSUMMON_CORPSE_DESPAWN | Despawns instantly after death | +| 6 | TEMPSUMMON_CORPSE_TIMED_DESPAWN | Despawns after a specified time after death | +| 7 | TEMPSUMMON_DEAD_DESPAWN | Despawns when the creature disappears | +| 8 | TEMPSUMMON_MANUAL_DESPAWN | Despawns when UnSummon() is called | ### summonTime diff --git a/docs/game_event_battleground_holiday.md b/docs/game_event_battleground_holiday.md index bb47a0e..6476cc9 100644 --- a/docs/game_event_battleground_holiday.md +++ b/docs/game_event_battleground_holiday.md @@ -8,50 +8,13 @@ This table is used to add a holiday to a battleground, for things like extra rep **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

eventEntry

tinyint(3)

unsigned

PRI

NO

 

Unique

Entry of the game event

bgflag

int(10)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------|------------|------------|-----|------|---------|--------|-------------------------| +| [eventEntry][1] | tinyint(3) | unsigned | PRI | NO | | Unique | Entry of the game event | +| [bgflag][2] | int(10) | unsigned | | NO | 0 | | | + +[1]: #evententry +[2]: #bgflag **Description of the fields** @@ -63,63 +26,16 @@ This is entry id of the game\_event that was setup to add the holiday. This is a bitmask field that decides which battle grounds are affected for this given holiday. - ---- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

bit

Battleground

1

Alterac Valley

4

Warsong Gulch

8

Arathi Basin

16

Nagrand Arena

32

Blade's Edge Arena

64

All Arena

128

Eye of the Storm

256

Ruins of Lordaeron

512

Strand of the Ancients

1024

Dalaran Sewers

2048

The Ring of Valor

- - +| bit | Battleground | +|------|------------------------| +| 1 | Alterac Valley | +| 4 | Warsong Gulch | +| 8 | Arathi Basin | +| 16 | Nagrand Arena | +| 32 | Blade's Edge Arena | +| 64 | All Arena | +| 128 | Eye of the Storm | +| 256 | Ruins of Lordaeron | +| 512 | Strand of the Ancients | +| 1024 | Dalaran Sewers | +| 2048 | The Ring of Valor | diff --git a/docs/group_member.md b/docs/group_member.md index 73277c1..d22c4df 100644 --- a/docs/group_member.md +++ b/docs/group_member.md @@ -8,84 +8,19 @@ 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

  
+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------------|------------|------------|-----|------|---------|--------|---------| +| [guid][1] | int(10) | unsigned | | NO | | | | +| [memberGuid][2] | int(10) | unsigned | PRI | NO | | Unique | | +| [memberFlags][3] | tinyint(3) | unsigned | | NO | 0 | | | +| [subgroup[4] | tinyint(3) | unsigned | | NO | 0 | | | +| [roles][5] | tinyint(3) | unsigned | | NO | 0 | | | + +[1]: #guid +[2]: #memberguid +[3]: #memberflags +[4]: #subgroup +[5]: #roles **Description of the fields** @@ -97,32 +32,11 @@ GUID of the group. See [groups.guid](Groups+tc2#Groupstc2-guid). GUID of the character member of the group. See [characters.guid](Characters+tc2#Characterstc2-guid). - ----- - - - - - - - - - - - - - - - - - -
MEMBER_FLAG_ASSISTANT
0x01
 
MEMBER_FLAG_MAINTANK
0x02
(U)
MEMBER_FLAG_MAINASSIST
0x04
(U)
- -  +| Name | Value | Unique | +|------------------------|-------|--------| +| MEMBER_FLAG_ASSISTANT | 0x01 | | +| MEMBER_FLAG_MAINTANK | 0x02 | (U) | +| MEMBER_FLAG_MAINASSIST | 0x04 | (U) | *(U) = Unique per group.* @@ -133,46 +47,10 @@ 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

- - +| 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 | diff --git a/docs/groups.md b/docs/groups.md index ef22315..65d6d81 100644 --- a/docs/groups.md +++ b/docs/groups.md @@ -8,190 +8,41 @@ 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

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|----------------------|------------|------------|-----|------|---------|-------|---------| +| [guid][1] | int(10) | unsigned | PRI | NO | | | | +| [leaderGuid][2] | int(10) | unsigned | | NO | | | | +| [lootMethod][3] | tinyint(3) | unsigned | | NO | | | | +| [looterGuid][4] | int(10) | unsigned | | NO | | | | +| [lootThreshold][5] | tinyint(3) | unsigned | | NO | | | | +| [icon1][6] | int(10) | unsigned | | NO | | | | +| [icon2][7] | int(10) | unsigned | | NO | | | | +| [icon3][8] | int(10) | unsigned | | NO | | | | +| [icon4][9] | int(10) | unsigned | | NO | | | | +| [icon5][10] | int(10) | unsigned | | NO | | | | +| [icon6][11] | int(10) | unsigned | | NO | | | | +| [icon7][12] | int(10) | unsigned | | NO | | | | +| [icon8][13] | int(10) | unsigned | | NO | | | | +| [groupType][14] | tinyint(3) | unsigned | | NO | | | | +| [difficulty][15] | tinyint(3) | unsigned | | NO | 0 | | | +| [raiddifficulty][16] | tinyint(3) | 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** @@ -205,47 +56,13 @@ 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

 

+| Value | Name | Comments | +|-------|-------------------|----------| +| 0 | FREE_FOR_ALL | | +| 1 | ROUND_ROBIN | | +| 2 | MASTER_LOOT | | +| 3 | GROUP_LOOT | | +| 4 | NEED_BEFORE_GREED | | ### looterGuid @@ -262,52 +79,14 @@ If [lootMethod](#groups-lootMethod) is not 2, then it's group leader's guid. ### 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

 

+| 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 diff --git a/docs/linked_respawn.md b/docs/linked_respawn.md index a3476af..797210e 100644 --- a/docs/linked_respawn.md +++ b/docs/linked_respawn.md @@ -9,60 +9,15 @@ Gameobjects can be linked too! **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

 

 

Dependent Creature

linkedGuid

int(10)

unsigned

 

NO

 

 

Master Creature

linkType

tinyint(3)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------|------------|------------|-----|------|---------|-------|--------------------| +| [guid][1] | int(10) | unsigned | PRI | NO | | | Dependent Creature | +| [linkedGuid][2] | int(10) | unsigned | | NO | | | Master Creature | +| [linkType][3] | tinyint(3) | unsigned | | NO | 0 | | | + +[1]: #guid +[2]: #linkedguid +[3]: #linktype **Description of the fields** @@ -76,39 +31,9 @@ This is the guid of the [creature](http://www.azerothcore.org/wiki/creature#guid ### linkedType - ----- - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Value

Dependent

Master

0

creature

creature

1

creature

gameobject

2

gameobject

gameobject

3

gameobject

creature

- - +| Value | Dependent | Master | +|-------|------------|------------| +| 0 | creature | creature | +| 1 | creature | gameobject | +| 2 | gameobject | gameobject | +| 3 | gameobject | creature | diff --git a/docs/petition.md b/docs/petition.md index b8e5b51..1ea1023 100644 --- a/docs/petition.md +++ b/docs/petition.md @@ -8,70 +8,17 @@ This table holds information on all ongoing petitions for a guild or for an aren **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

ownerguid

int(10)

unsigned

PRI

NO

 

 

 

petitionguid

int(10)

unsigned

 

YES

0

 

 

name

varchar(24)

signed

 

NO

 

 

 

type

tinyint(3)

unsigned

PRI

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-------------------|-------------|------------|-----|------|---------|-------|---------| +| [ownerguid][1] | int(10) | unsigned | PRI | NO | | | | +| [petitionguid][2] | int(10) | unsigned | | YES | 0 | | | +| [name][3] | varchar(24) | signed | | NO | | | | +| [type][4] | tinyint(3) | unsigned | PRI | NO | 0 | | | + +[1]: #ownerguid +[2]: #petitionguid +[3]: #name +[4]: #type **Description of the fields** @@ -91,35 +38,9 @@ The name of the guild or arena team that the player is trying to ask for petitio The type of the petition. - ---- - - - - - - - - - - - - - - - - - - - - - - - - -

ID

Type

2

2vs2 Arena charter

3

3vs3 Arena charter

5

5vs5 Arena charter

9

Guild charter

- - +| ID | Type | +|----|--------------------| +| 2 | 2vs2 Arena charter | +| 3 | 3vs3 Arena charter | +| 5 | 5vs5 Arena charter | +| 9 | Guild charter | diff --git a/docs/petition_sign.md b/docs/petition_sign.md index 4f34524..91d7de5 100644 --- a/docs/petition_sign.md +++ b/docs/petition_sign.md @@ -8,80 +8,19 @@ This table holds information on all the signatures of a petition for either a gu **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

ownerguid

int(10)

unsigned

 

NO

 

 

 

petitionguid

int(10)

unsigned

PRI

NO

0

 

 

playerguid

int(10)

unsigned

PRI

NO

0

 

 

player_account

int(10)

unsigned

 

NO

0

 

 

type

tinyint(3)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|---------------------|------------|------------|-----|------|---------|-------|---------| +| [ownerguid][1] | int(10) | unsigned | | NO | | | | +| [petitionguid][2] | int(10) | unsigned | PRI | NO | 0 | | | +| [playerguid][3] | int(10) | unsigned | PRI | NO | 0 | | | +| [player_account][4] | int(10) | unsigned | | NO | 0 | | | +| [type][5] | tinyint(3) | unsigned | | NO | 0 | | | + +[1]: #ownerguid +[2]: #petitionguid +[3]: #playerguid +[4]: #player_account +[5]: #type **Description of the fields** @@ -105,35 +44,9 @@ The account ID of the player that has signed the charter. No two players can sig The type of the petition. - ---- - - - - - - - - - - - - - - - - - - - - - - - - -

ID

Type

2

2vs2 Arena charter

3

3vs3 Arena charter

5

5vs5 Arena charter

9

Guild charter

- - +| ID | Type | +|----|--------------------| +| 2 | 2vs2 Arena charter | +| 3 | 3vs3 Arena charter | +| 5 | 5vs5 Arena charter | +| 9 | Guild charter | -- cgit