From b93817e01a3e8142c80c4d315023f2d47e2fec71 Mon Sep 17 00:00:00 2001 From: Walter Pagani Date: Thu, 7 Jan 2021 14:38:21 -0300 Subject: docs: Converting from HTML to Markdown part #5 (#334) --- docs/Languages.md | 114 ++-------- docs/account_banned.md | 99 ++------- docs/account_data.md | 83 ++----- docs/account_instance_times.md | 63 +----- docs/achievement_criteria_data.md | 228 ++++--------------- docs/areatrigger_template_polygon_vertices.md | 124 ++--------- docs/arena_team_member.md | 111 ++-------- docs/autobroadcast.md | 75 +------ docs/battleground_template.md | 308 ++++---------------------- docs/character_declinedname.md | 99 ++------- docs/character_gifts.md | 75 +------ docs/character_glyphs.md | 125 ++--------- docs/character_pet_declinedname.md | 111 ++-------- docs/character_skills.md | 75 +------ docs/character_spell.md | 75 +------ docs/character_spell_cooldown.md | 75 +------ docs/creature_respawn.md | 63 +----- docs/creature_template_movement.md | 126 +++-------- docs/game_event_model_equip.md | 88 ++------ docs/game_event_npcflag.md | 63 +----- docs/game_event_quest_condition.md | 75 +------ docs/gameobject_respawn.md | 63 +----- docs/gm_surveys.md | 87 ++------ docs/gossip_menu.md | 55 +---- docs/gossip_menu_option_action.md | 75 +------ docs/guild_bank_item.md | 75 +------ docs/guild_bank_tab.md | 87 ++------ docs/instance_reset.md | 63 +----- docs/instance_template.md | 75 +------ docs/ip_banned.md | 87 ++------ docs/item_enchantment_template.md | 63 +----- docs/item_refund_instance.md | 75 +------ docs/item_set_names.md | 75 +------ docs/lfg_entrances.md | 99 ++------- docs/page_text.md | 78 ++----- docs/pet_name_generation.md | 76 +------ docs/player_classlevelstats.md | 78 +------ docs/playercreateinfo_spell_custom.md | 75 +------ docs/pvpstats_battlegrounds.md | 141 +++--------- docs/scene_template.md | 85 ++----- docs/skill_discovery_template.md | 75 +------ docs/skill_extra_item_template.md | 75 +------ docs/spawn_group_template.md | 57 +---- docs/spell_custom_attr.md | 55 +---- docs/spell_group.md | 51 +---- docs/spell_learn_spell.md | 63 +----- docs/spell_ranks.md | 64 +----- docs/spelldifficulty_dbc.md | 87 ++------ docs/uptime.md | 87 ++------ docs/version.md | 87 ++------ 50 files changed, 719 insertions(+), 3749 deletions(-) (limited to 'docs') diff --git a/docs/Languages.md b/docs/Languages.md index 231eff9..585642b 100644 --- a/docs/Languages.md +++ b/docs/Languages.md @@ -4,12 +4,11 @@ This DBC contains languages that can be used in texts. The player must have competence in this language to understand what is written. -| | | | -|------------|----------|-----------------------------------------| -| **Column** | **Type** | **Notes** | -| 1 | long | The ID of the language. Must be unique. | -| 2 | str | The name of the language goes here. | -| 18 | flags | The purpose of this column is unknown. | +| Column | Type | Notes | +|--------|-------|-----------------------------------------| +| 1 | long | The ID of the language. Must be unique. | +| 2 | str | The name of the language goes here. | +| 18 | flags | The purpose of this column is unknown. | Any unlisted columns are not used within the DBC file. @@ -17,87 +16,22 @@ Any unlisted columns are not used within the DBC file. All of the races, along with their IDs, from the *Languages.dbc* file are as follows. - ---- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

ID

Name

1

Orcish

2

Darnassian

3

Taurahe

6

Dwarvish

7

Common

8

Demonic

9

Titan

10

Thalassian

11

Draconic

12

Kalimag

13

Gnomish

14

Troll

33

Gutterspeak

35

Draenei

36

Zombie

37

Gnomish Binary

38

Goblin Binary

- -  - -  +| ID | Name | +|----|----------------| +| 1 | Orcish | +| 2 | Darnassian | +| 3 | Taurahe | +| 6 | Dwarvish | +| 7 | Common | +| 8 | Demonic | +| 9 | Titan | +| 10 | Thalassian | +| 11 | Draconic | +| 12 | Kalimag | +| 13 | Gnomish | +| 14 | Troll | +| 33 | Gutterspeak | +| 35 | Draenei | +| 36 | Zombie | +| 37 | Gnomish Binary | +| 38 | Goblin Binary | diff --git a/docs/account_banned.md b/docs/account_banned.md index b025197..7b30c55 100644 --- a/docs/account_banned.md +++ b/docs/account_banned.md @@ -8,90 +8,21 @@ This table lists all of the accounts that have been banned along with the date w **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

id

int(10)

unsigned

PRI

NO

0

 

Account id

bandate

int(10)

signed

PRI

NO

0

 

 

unbandate

int(10)

unsigned

 

NO

0

 

 

bannedby

varchar(50)

signed

 

NO

 

 

 

banreason

varchar(255)

signed

 

NO

 

 

 

active

tinyint(3)

signed

 

NO

1

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|----------------|--------------|------------|-----|------|---------|-------|------------| +| [id][1] | int(10) | unsigned | PRI | NO | 0 | | Account id | +| [bandate][2] | int(10) | signed | PRI | NO | 0 | | | +| [unbandate][3] | int(10) | unsigned | | NO | 0 | | | +| [bannedby][4] | varchar(50) | signed | | NO | | | | +| [banreason][5] | varchar(255) | signed | | NO | | | | +| [active][6] | tinyint(3) | signed | | NO | 1 | | | + +[1]: #id +[2]: #bandate +[3]: #unbandate +[4]: #bannedby +[5]: #banreason +[6]: #active **Description of the fields** diff --git a/docs/account_data.md b/docs/account_data.md index 9ea8c0c..1484152 100644 --- a/docs/account_data.md +++ b/docs/account_data.md @@ -8,70 +8,17 @@ Contains data about client account and settings. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

account

int(10)

unsigned

PRI

NO

0

 

 

type

tinyint(3)

unsigned

PRI

NO

0

 

 

time

int(10)

unsigned

 

NO

0

 

 

data

blob

signed

 

NO

 

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|--------------|------------|------------|-----|------|---------|-------|---------| +| [account][1] | int(10) | unsigned | PRI | NO | 0 | | | +| [type][2] | tinyint(3) | unsigned | PRI | NO | 0 | | | +| [time][3] | int(10) | unsigned | | NO | 0 | | | +| [data][4] | blob | signed | | NO | | | | + +[1]: #account +[2]: #type +[3]: #time +[4]: #data **Description of the fields** @@ -81,9 +28,11 @@ Contains data about client account and settings. ### type -- 0 = Global-account config cache -- 2 = Global-account bindings cache -- 4 = Global-account macros cache +| Value | Description | +|-------|-------------------------------| +| 0 | Global-account config cache | +| 2 | Global-account bindings cache | +| 4 | Global-account macros cache | ### time diff --git a/docs/account_instance_times.md b/docs/account_instance_times.md index 2abb829..a6760cf 100644 --- a/docs/account_instance_times.md +++ b/docs/account_instance_times.md @@ -8,60 +8,15 @@ This table controls how many instances the account's characters have been in las **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

accountId

int(10)

unsigned

PRI

NO

 

 

 

instanceId

int(10)

unsigned

PRI

NO

0

 

 

releaseTime

bigint(20)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------------|------------|------------|-----|------|---------|-------|---------| +| [accountId][1] | int(10) | unsigned | PRI | NO | | | | +| [instanceId][2] | int(10) | unsigned | PRI | NO | 0 | | | +| [releaseTime][3] | bigint(20) | unsigned | | NO | 0 | | | + +[1]: #accountid +[2]: #instanceid +[3]: #releasetime **Description of the fields** diff --git a/docs/achievement_criteria_data.md b/docs/achievement_criteria_data.md index f7b3781..17f9dac 100644 --- a/docs/achievement_criteria_data.md +++ b/docs/achievement_criteria_data.md @@ -1,6 +1,6 @@ # achievement\_criteria\_data -` Back-to:World ` +[<-Back-to:World](database-world.md) **The \`achievement\_criteria\_data\` table** @@ -8,80 +8,19 @@ This table contains the data that a player needs to obtain / complete in order t **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

criteria_id

mediumint(8)

signed

PRI

NO

NULL

 

 

type

tinyint(3)

unsigned

PRI

NO

0

 

 

value1

medium(8)

unsigned

 

NO

0

 

 

value2

medium(8)

unsigned

 

NO

0

 

 

ScriptName

char(64)

signed

 

NO

 

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------------|--------------|------------|-----|------|---------|-------|---------| +| [criteria_id][1] | mediumint(8) | signed | PRI | NO | NULL | | | +| [type][2] | tinyint(3) | unsigned | PRI | NO | 0 | | | +| [value1][3] | medium(8) | unsigned | | NO | 0 | | | +| [value2][4] | medium(8) | unsigned | | NO | 0 | | | +| [ScriptName][5] | char(64) | signed | | NO | | | | + +[1]: #criteria_id +[2]: #type +[3]: #value1 +[4]: #value2 +[5]: #scriptname **Description of the fields** @@ -93,116 +32,32 @@ This is the ID from [Achievement\_Criteria.dbc](Achievement+Criteria). Depending on this value, it will determine how value1 and value2 are used. - ---- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Type

Name

0

TYPE_NONE

1

TYPE_T_CREATURE

2

TYPE_T_PLAYER_CLASS_RACE

3

TYPE_T_PLAYER_LESS_HEALTH

4

TYPE_T_PLAYER_DEAD

5

TYPE_S_AURA

6

TYPE_S_AREA

7

TYPE_T_AURA

8

TYPE_VALUE

9

TYPE_T_LEVEL

10

TYPE_T_GENDER

11

TYPE_SCRIPT

12

TYPE_MAP_DIFFICULTY

13

TYPE_MAP_PLAYER_COUNT

14

TYPE_T_TEAM

15

TYPE_S_DRUNK

16

TYPE_HOLIDAY

17

TYPE_BG_LOSS_TEAM_SCORE

18

TYPE_INSTANCE_SCRIPT

19

TYPE_S_EQUIPED_ITEM

20

TYPE_MAP_ID

21

TYPE_S_PLAYER_CLASS_RACE

22TYPE_NTH_BIRTHDAY
23TYPE_S_KNOWN_TITLE
+| Type | Name | +|------|---------------------------| +| 0 | TYPE_NONE | +| 1 | TYPE_T_CREATURE | +| 2 | TYPE_T_PLAYER_CLASS_RACE | +| 3 | TYPE_T_PLAYER_LESS_HEALTH | +| 4 | TYPE_T_PLAYER_DEAD | +| 5 | TYPE_S_AURA | +| 6 | TYPE_S_AREA | +| 7 | TYPE_T_AURA | +| 8 | TYPE_VALUE | +| 9 | TYPE_T_LEVEL | +| 10 | TYPE_T_GENDER | +| 11 | TYPE_SCRIPT | +| 12 | TYPE_MAP_DIFFICULTY | +| 13 | TYPE_MAP_PLAYER_COUNT | +| 14 | TYPE_T_TEAM | +| 15 | TYPE_S_DRUNK | +| 16 | TYPE_HOLIDAY | +| 17 | TYPE_BG_LOSS_TEAM_SCORE | +| 18 | TYPE_INSTANCE_SCRIPT | +| 19 | TYPE_S_EQUIPED_ITEM | +| 20 | TYPE_MAP_ID | +| 21 | TYPE_S_PLAYER_CLASS_RACE | +| 22 | TYPE_NTH_BIRTHDAY | +| 23 | TYPE_S_KNOWN_TITLE | ### value1 @@ -300,7 +155,6 @@ Depending on this value, it will determine how value1 and value2 are used. \***TYPE\_S\_PLAYER\_CLASS\_RACE** - - The Source here is a valid class (paste class list). value2 must also be set -   \***TYPE\_NTH\_BIRTHDAY** @@ -308,12 +162,10 @@ Depending on this value, it will determine how value1 and value2 are used. -  Number of Birthday \***TYPE\_S\_KNOWN\_TITLE** -   - The value here is a valid titleId. See CharTitles.dbc -  ### value2 diff --git a/docs/areatrigger_template_polygon_vertices.md b/docs/areatrigger_template_polygon_vertices.md index bb64c5f..50b755c 100644 --- a/docs/areatrigger_template_polygon_vertices.md +++ b/docs/areatrigger_template_polygon_vertices.md @@ -8,111 +8,23 @@ This table contains the description of the shape of an areatrigger. **Structure** - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

AreaTriggerId

int(10)

unsigned

PRI

NO


-


-


-

Idx

int(10)

unsigned

PRI

NO


-


-


-

VerticeX

float

signed


-

NO

0


-


-

VerticeYfloatsigned
-		NO0
-
-
VerticeTargetXfloatsigned
-		YESNULL
-
-

VerticeTargetY

floatsigned
-		YESNULL
-
-
VerifiedBuildint(10)unsigned
-		NO0
-
-
+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|---------------------|---------|------------|-----|------|---------|-------|---------| +| [AreaTriggerId][1] | int(10) | unsigned | PRI | NO | | | | +| [Idx][2] | int(10) | unsigned | PRI | NO | | | | +| [VerticeX][3] | float | signed | | NO | 0 | | | +| [VerticeY][4] | float | signed | | NO | 0 | | | +| [VerticeTargetX][5] | float | signed | | YES | NULL | | | +| [VerticeTargetY][6] | float | signed | | YES | NULL | | | +| [VerifiedBuild][7] | int(10) | unsigned | | NO | 0 | | | + +[1]: #areatriggerid +[2]: #idx +[3]: #verticex +[4]: #verticey +[5]: #verticetargetx +[6]: #verticetargety +[7]: #verifiedbuild **Description of the fields** @@ -135,5 +47,3 @@ This field was used to determine whether a template has been verified from WDB f If value is 0 then it has not been parsed yet. If value is above 0 then it has been parsed with WDB files from that specific client build. - - diff --git a/docs/arena_team_member.md b/docs/arena_team_member.md index 9ab54eb..da9e789 100644 --- a/docs/arena_team_member.md +++ b/docs/arena_team_member.md @@ -8,100 +8,23 @@ This table holds arena info about specific team members. All arena\_team members **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

arenaTeamId

int(10)

unsigned

PRI

NO

0

 

 

guid

int(10)

unsigned

PRI

NO

0

 

 

personalRating

smallint(5)

unsigned

 

NO

0

 

 

weekGames

smallint(5)

unsigned

 

NO

0

 

 

weekWins

smallint(5)

unsigned

 

NO

0

 

 

seasonGames

smallint(5)

unsigned

 

NO

0

 

 

seasonWins

smallint(5)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|---------------------|-------------|------------|-----|------|---------|-------|---------| +| [arenaTeamId][1] | int(10) | unsigned | PRI | NO | 0 | | | +| [guid][2] | int(10) | unsigned | PRI | NO | 0 | | | +| [personalRating][3] | smallint(5) | unsigned | | NO | 0 | | | +| [weekGames][4] | smallint(5) | unsigned | | NO | 0 | | | +| [weekWins][5] | smallint(5) | unsigned | | NO | 0 | | | +| [seasonGames][6] | smallint(5) | unsigned | | NO | 0 | | | +| [seasonWins][7] | smallint(5) | unsigned | | NO | 0 | | | + +[1]: #arenateamid +[2]: #guid +[3]: #personalrating +[4]: #weekgames +[5]: #weekwins +[6]: #seasongames +[7]: #seasonwins **Description of the fields** diff --git a/docs/autobroadcast.md b/docs/autobroadcast.md index 02a48e4..d8d1598 100644 --- a/docs/autobroadcast.md +++ b/docs/autobroadcast.md @@ -8,70 +8,17 @@ This table contains the autobroadcast entries for your realms. Values like it's **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

realmidint(11)signedPRINO-1  

id

tinyint(3)

unsigned

PRI

NO

 

auto_increment

 

weighttinyint(3)unsigned YES1  

text

longtext

 

 

NO

NULL

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|--------------|------------|------------|-----|------|---------|----------------|---------| +| [realmid][1] | int(11) | signed | PRI | NO | -1 | | | +| [id][2] | tinyint(3) | unsigned | PRI | NO | | auto_increment | | +| [weight][3] | tinyint(3) | unsigned | | YES | 1 | | | +| [text][4] | longtext | | | NO | NULL | | | + +[1]: #realmid +[2]: #id +[3]: #weight +[4]: #text **Description of the fields** diff --git a/docs/battleground_template.md b/docs/battleground_template.md index 3b14117..3961224 100644 --- a/docs/battleground_template.md +++ b/docs/battleground_template.md @@ -1,6 +1,6 @@ # battleground\_template -` Back-to:World ` +[<-Back-to:World](database-world.md) **The \`battleground\_template\` table** @@ -8,202 +8,35 @@ Contains information about the different battlegrounds, like how many players ar **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Atributes

Key

Null

Default

Extra

Comment

id

mediumint(8)

unsigned

PRI

NO

NULL


-


-

MinPlayersPerTeam

smallintint(5)

unsigned


-

NO

0


-


-

MaxPlayersPerTeam

smallint(5)

unsigned


-

NO

0


-


-

MinLvl

tinyint(3)

unsigned


-

NO

0


-


-

MaxLvl

tinyint(3)

unsigned


-

NO

0


-


-

AllianceStartLoc

mediumint(8)

unsigned


-

NO

NULL


-


-

AllianceStartO

float

signed


-

NO

NULL


-


-

HordeStartLoc

mediumint(8)

unsigned


-

NO

NULL


-


-

HordeStartO

float

signed


-

NO

NULL


-


-

StartMaxDist

float

signed


-

NO

0


-


-

Weight

tinyint (2)

unsigned


-

NO

1


-


-

ScriptName

char (64)


-


-

NO


-


-


-

Comment

char (32)


-


-

NO


-


-


-

+| Field | Type | Atributes | Key | Null | Default | Extra | Comment | +|------------------------|----------------|-----------|-----|------|---------|-------|---------| +| [id][1] | mediumint(8) | unsigned | PRI | NO | NULL | | | +| [MinPlayersPerTeam][2] | smallintint(5) | unsigned | | NO | 0 | | | +| [MaxPlayersPerTeam][3] | smallint(5) | unsigned | | NO | 0 | | | +| [MinLvl][4] | tinyint(3) | unsigned | | NO | 0 | | | +| [MaxLvl][5] | tinyint(3) | unsigned | | NO | 0 | | | +| [AllianceStartLoc][6] | mediumint(8) | unsigned | | NO | NULL | | | +| [AllianceStartO][7] | float | signed | | NO | NULL | | | +| [HordeStartLoc][8] | mediumint(8) | unsigned | | NO | NULL | | | +| [HordeStartO][9] | float | signed | | NO | NULL | | | +| [StartMaxDist][10] | float | signed | | NO | 0 | | | +| [Weight][11] | tinyint (2) | unsigned | | NO | 1 | | | +| [ScriptName][12] | char (64) | | | NO | | | | +| [Comment][13] | char (32) | | | NO | | | | + +[1]: #id +[2]: #minplayersperteam +[3]: #maxplayersperteam +[4]: #minlvl +[5]: #maxlvl +[6]: #alliancestartloc +[7]: #alliancestarto +[8]: #hordestartloc +[9]: #hordestarto +[10]: #startmaxdist +[11]: #weight +[12]: #scriptname +[13]: #comment **Description of the fields** @@ -211,72 +44,21 @@ Contains information about the different battlegrounds, like how many players ar The battleground ID. - ---- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

ID

Type

1

Alterac Valley

2

Warsong Gulch

3

Arathi Basin

4

Nagrand Arena

5

Blade's Edge Arena

6

All Arena

7

Eye of the Storm

8

Ruins of Lordaeron

9

Strand of the Ancients

10

Dalaran Sewers

11

The Ring of Valor

30

Isle of Conquest

32

Random battleground

+| ID | Type | +|----|------------------------| +| 1 | Alterac Valley | +| 2 | Warsong Gulch | +| 3 | Arathi Basin | +| 4 | Nagrand Arena | +| 5 | Blade's Edge Arena | +| 6 | All Arena | +| 7 | Eye of the Storm | +| 8 | Ruins of Lordaeron | +| 9 | Strand of the Ancients | +| 10 | Dalaran Sewers | +| 11 | The Ring of Valor | +| 30 | Isle of Conquest | +| 32 | Random battleground | ### MinPlayersPerTeam diff --git a/docs/character_declinedname.md b/docs/character_declinedname.md index e5597c3..3ae8abf 100644 --- a/docs/character_declinedname.md +++ b/docs/character_declinedname.md @@ -8,90 +8,21 @@ **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(11)

unsigned

PRI

NO

0

 

Global Unique Identifier

genitive

varchar(15)

signed

 

NO

NULL

 

 

dative

varchar(15)

signed

 

NO

NULL

 

 

accusative

varchar(15)

signed

 

NO

NULL

 

 

instrumental

varchar(15)

signed

 

NO

NULL

 

 

prepositional

varchar(15)

signed

 

NO

NULL

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|--------------------|-------------|------------|-----|------|---------|-------|--------------------------| +| [guid][1] | int(11) | unsigned | PRI | NO | 0 | | Global Unique Identifier | +| [genitive][2] | varchar(15) | signed | | NO | NULL | | | +| [dative][3] | varchar(15) | signed | | NO | NULL | | | +| [accusative][4] | varchar(15) | signed | | NO | NULL | | | +| [instrumental][5] | varchar(15) | signed | | NO | NULL | | | +| [prepositional][6] | varchar(15) | signed | | NO | NULL | | | + +[1]: #guid +[2]: #genitive +[3]: #dative +[4]: #accusative +[5]: #instrumental +[6]: #prepositional **Description of the fields** diff --git a/docs/character_gifts.md b/docs/character_gifts.md index 468a58d..6aa297f 100644 --- a/docs/character_gifts.md +++ b/docs/character_gifts.md @@ -8,70 +8,17 @@ This table holds data about wrapped/gift items. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

 

NO

0

 

 

item_guid

int(10)

unsigned

PRI

NO

0

 

 

entry

int(10)

unsigned

 

NO

0

 

 

flags

int(10)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|----------------|---------|------------|-----|------|---------|-------|---------| +| [guid][1] | int(10) | unsigned | | NO | 0 | | | +| [item_guid][2] | int(10) | unsigned | PRI | NO | 0 | | | +| [entry][3] | int(10) | unsigned | | NO | 0 | | | +| [flags][4] | int(10) | unsigned | | NO | 0 | | | + +[1]: #guid +[2]: #item_guid +[3]: #entry +[4]: #flags **Description of the fields** diff --git a/docs/character_glyphs.md b/docs/character_glyphs.md index 22e5f65..22206dd 100644 --- a/docs/character_glyphs.md +++ b/docs/character_glyphs.md @@ -8,110 +8,25 @@ Contains all the individual glyph data for each character. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

 

 

 

spec

tinyint(3)

unsigned

PRI

NO

0

 

 

glyph1

smallint(5)

unsigned

 

YES

0

 

 

glyph2

smallint(5)

unsigned

 

YES

0

 

 

glyph3

smallint(5)

unsigned

 

YES

0

 

 

glyph4

smallint(5)

unsigned

 

YES

0

 

 

glyph5

smallint(5)

unsigned

 

YES

0

 

 

glyph6

smallint(5)

unsigned

 

YES

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-------------|-------------|------------|-----|------|---------|-------|---------| +| [guid][1] | int(10) | unsigned | PRI | NO | | | | +| [spec][2] | tinyint(3) | unsigned | PRI | NO | 0 | | | +| [glyph1][3] | smallint(5) | unsigned | | YES | 0 | | | +| [glyph2][4] | smallint(5) | unsigned | | YES | 0 | | | +| [glyph3][5] | smallint(5) | unsigned | | YES | 0 | | | +| [glyph4][6] | smallint(5) | unsigned | | YES | 0 | | | +| [glyph5][7] | smallint(5) | unsigned | | YES | 0 | | | +| [glyph6][8] | smallint(5) | unsigned | | YES | 0 | | | + +[1]: #guid +[2]: #spec +[3]: #glyph1 +[4]: #glyph2 +[5]: #glyph3 +[6]: #glyph4 +[7]: #glyph5 +[8]: #glyph6 **Description of the fields** @@ -123,6 +38,6 @@ The GUID of the character. See characters.guid spec = 0 is the first spec, spec = 1 is the second spec. -### glyph1-6 +### glyph 1-6 The GlyphProperties entry of the glyphs in that particular spec. diff --git a/docs/character_pet_declinedname.md b/docs/character_pet_declinedname.md index 1e73c3a..9cf43e3 100644 --- a/docs/character_pet_declinedname.md +++ b/docs/character_pet_declinedname.md @@ -8,100 +8,23 @@ **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

id

int(10)

unsigned

PRI

NO

0

 

 

owner

int(10)

unsigned

 

NO

0

 

 

genitive

varchar(12)

signed

 

NO

NULL

 

 

dative

varchar(12)

signed

 

NO

NULL

 

 

accusative

varchar(12)

signed

 

NO

NULL

 

 

instrumental

varchar(12)

signed

 

NO

NULL

 

 

prepositional

varchar(12)

signed

 

NO

NULL

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|--------------------|-------------|------------|-----|------|---------|-------|---------| +| [id][1] | int(10) | unsigned | PRI | NO | 0 | | | +| [owner][2] | int(10) | unsigned | | NO | 0 | | | +| [genitive][3] | varchar(12) | signed | | NO | NULL | | | +| [dative][4] | varchar(12) | signed | | NO | NULL | | | +| [accusative][5] | varchar(12) | signed | | NO | NULL | | | +| [instrumental][6] | varchar(12) | signed | | NO | NULL | | | +| [prepositional][7] | varchar(12) | signed | | NO | NULL | | | + +[1]: #id +[2]: #owner +[3]: #genitive +[4]: #dative +[5]: #accusative +[6]: #instrumental +[7]: #prepositional **Description of the fields** diff --git a/docs/character_skills.md b/docs/character_skills.md index 5191748..7b7777e 100644 --- a/docs/character_skills.md +++ b/docs/character_skills.md @@ -8,70 +8,17 @@ This table holds a listing of all skill for each character. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

Global Unique Identifier

skill

smallint(5)

unsigned

PRI

NO

0

 

 

value

smallint(5)

unsigned

 

NO

0

 

 

max

smallint(5)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------|-------------|------------|-----|------|---------|-------|--------------------------| +| [guid][1] | int(10) | unsigned | PRI | NO | 0 | | Global Unique Identifier | +| [skill][2] | smallint(5) | unsigned | PRI | NO | 0 | | | +| [value][3] | smallint(5) | unsigned | | NO | 0 | | | +| [max][4] | smallint(5) | unsigned | | NO | 0 | | | + +[1]: #guid +[2]: #skill +[3]: #value +[4]: #max **Description of the fields** diff --git a/docs/character_spell.md b/docs/character_spell.md index 6acd0ee..939b6b3 100644 --- a/docs/character_spell.md +++ b/docs/character_spell.md @@ -8,70 +8,17 @@ Holds information for each character's spells. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

Global Unique Identifier

spell

mediumint(8)

unsigned

PRI

NO

0

 

Spell Identifier

active

tinyint(3)

unsigned

 

NO

1

 

 

disabled

tinyint(3)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|---------------|--------------|------------|-----|------|---------|-------|--------------------------| +| [guid][1] | int(10) | unsigned | PRI | NO | 0 | | Global Unique Identifier | +| [spell][2] | mediumint(8) | unsigned | PRI | NO | 0 | | Spell Identifier | +| [active][3] | tinyint(3) | unsigned | | NO | 1 | | | +| [disabled][4] | tinyint(3) | unsigned | | NO | 0 | | | + +[1]: #guid +[2]: #spell +[3]: #active +[4]: #disabled **Description of the fields** diff --git a/docs/character_spell_cooldown.md b/docs/character_spell_cooldown.md index 3733860..0cb01f9 100644 --- a/docs/character_spell_cooldown.md +++ b/docs/character_spell_cooldown.md @@ -8,70 +8,17 @@ Holds the remaining cooldowns from either character spells or item spells for ea **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

Global Unique Identifier, Low part

spell

mediumint(8)

unsigned

PRI

NO

0

 

Spell Identifier

item

int(10)

unsigned

 

NO

0

 

Item Identifier

time

int(10)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------|--------------|------------|-----|------|---------|-------|------------------------------------| +| [guid][1] | int(10) | unsigned | PRI | NO | 0 | | Global Unique Identifier, Low part | +| [spell][2] | mediumint(8) | unsigned | PRI | NO | 0 | | Spell Identifier | +| [item][3] | int(10) | unsigned | | NO | 0 | | Item Identifier | +| [time][4] | int(10) | unsigned | | NO | 0 | | | + +[1]: #guid +[2]: #spell +[3]: #item +[4]: #time **Description of the fields** diff --git a/docs/creature_respawn.md b/docs/creature_respawn.md index 798046d..4c6b31c 100644 --- a/docs/creature_respawn.md +++ b/docs/creature_respawn.md @@ -8,60 +8,15 @@ This table holds the respawn time when creatures should be respawned in the worl **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

Global Unique Identifier

respawntime

int(10)

unsigned

 

NO

0

 

 

instance

int(10)

unsigned

PRI

NO

0

 

Instance Identifier

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------------|---------|------------|-----|------|---------|-------|--------------------------| +| [guid][1] | int(10) | unsigned | PRI | NO | 0 | | Global Unique Identifier | +| [respawntime][2] | int(10) | unsigned | | NO | 0 | | | +| [instance][3] | int(10) | unsigned | PRI | NO | 0 | | Instance Identifier | + +[1]: #guid +[2]: #respawntime +[3]: #instance **Description of the fields** diff --git a/docs/creature_template_movement.md b/docs/creature_template_movement.md index f87395d..c6e6fc1 100644 --- a/docs/creature_template_movement.md +++ b/docs/creature_template_movement.md @@ -6,96 +6,42 @@ This table contains the description of creatures movements, where the creature c **Structure** - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
FieldTypeAttributesKeyNullDefaultExtraComment
CreatureIdint(10)unsignedPRINO0
-
-
Groundtinyint(3)unsigned
-		NO0
-
-
Swimtinyint(3)unsigned
-		NO0
-
-
Flighttinyint(3)unsigned
-		NO0
-
-
Rootedtinyint(3)unsigned
-		NO0
-
-
- -| | -|----------------------------------------------------------------| -| Ground States:  "None"=0, "Run"=1, "Hover"=2 - - Swim States:     "None"=0, "Swim"=1 - - Flight States:      "None"=0, "DisableGravity"=1, "CanFly" =2; - - Rooted States:   "None"=0, "Rooted "=1 | +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------|------------|------------|-----|------|---------|-------|---------| +| [CreatureId][1] | int(10) | unsigned | PRI | NO | 0 | | | +| [Ground][2] | tinyint(3) | unsigned | | NO | 0 | | | +| [Swim][3] | tinyint(3) | unsigned | | NO | 0 | | | +| [Flight][4] | tinyint(3) | unsigned | | NO | 0 | | | +| [Rooted][5] | tinyint(3) | unsigned | | NO | 0 | | | + +[1]: #creatureid +[2]: #ground +[3]: #swim +[4]: #flight +[5]: #rooted + +### CreatureId + +This is the [creature\_template.entry](http://www.azerothcore.org/wiki/creature_template#creature_template-entry) to which the script is linked to. + +### Ground + +- "None"=0 +- "Run"=1 +- "Hover"=2 + +### Swim +- "None"=0 +- "Swim"=1 + +### Flight +- "None"=0 +- "DisableGravity"=1 +- "CanFly" =2 + +### Rooted +- "None"=0 +- "Rooted"=1 Notice: diff --git a/docs/game_event_model_equip.md b/docs/game_event_model_equip.md index eb6d660..d95331d 100644 --- a/docs/game_event_model_equip.md +++ b/docs/game_event_model_equip.md @@ -8,73 +8,26 @@ Contains all creature instances that need to change display id and/or equipment **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

eventEntry

tinyint(3)

signed

 

NO

0

 

Entry of the game event.

guid

int(10)

unsigned

PRI

NO

0

Unique