From c681fd4d66521fe6bee35bb2fbd9b5855fca3beb Mon Sep 17 00:00:00 2001 From: Walter Pagani Date: Thu, 7 Jan 2021 10:30:03 -0300 Subject: docs: Converting from HTML to Markdown part #4 (#333) --- docs/account_access.md | 67 +------ docs/areatrigger_involvedrelation.md | 51 +----- docs/battleground_deserters.md | 81 ++------- docs/character_account_data.md | 87 ++------- docs/character_achievement.md | 64 +------ docs/character_achievement_progress.md | 75 ++------ docs/character_arena_stats.md | 73 ++------ docs/character_instance.md | 63 +------ docs/character_queststatus_daily.md | 63 +------ docs/character_queststatus_rewarded.md | 63 +------ docs/character_queststatus_seasonal.md | 63 +------ docs/character_talent.md | 59 +----- docs/command.md | 90 +++------ docs/game_event_condition_save.md | 63 +------ docs/game_event_creature.md | 51 +----- docs/game_event_creature_quest.md | 63 +------ docs/game_event_gameobject_quest.md | 63 +------ docs/game_event_pool.md | 51 +----- docs/game_event_prerequisite.md | 51 +----- docs/game_event_seasonal_questrelation.md | 51 +----- docs/gameobject.md | 267 +++++---------------------- docs/gameobject_questender.md | 51 +----- docs/gm_subsurveys.md | 123 +++---------- docs/item_soulbound_trade_data.md | 51 +----- docs/mail_items.md | 63 +------ docs/mail_level_reward.md | 77 ++------ docs/pet_spell.md | 63 +------ docs/pet_spell_cooldown.md | 63 +------ docs/player_factionchange_achievement.md | 51 +----- docs/player_factionchange_reputations.md | 51 +----- docs/player_factionchange_spells.md | 51 +----- docs/pool_quest.md | 63 +------ docs/pool_template.md | 63 +------ docs/quest_objectives.md | 293 +++++------------------------- docs/realmcharacters.md | 63 +------ docs/reputation_reward_rate.md | 75 ++------ docs/spell_enchant_proc_data.md | 75 ++------ docs/spell_pet_auras.md | 75 ++------ docs/spell_required.md | 51 +----- docs/spell_script_names.md | 51 +----- 40 files changed, 475 insertions(+), 2537 deletions(-) diff --git a/docs/account_access.md b/docs/account_access.md index e988002..604fb48 100644 --- a/docs/account_access.md +++ b/docs/account_access.md @@ -8,64 +8,15 @@ This table holds security access level for any realm in [realmlist](realmlist) t **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

id

int(10)

unsigned

PRI

NO

 

 

 

gmlevel

tinyint(3)

unsigned

 

NO

 

 

 

RealmID

int(11)

signed

PRI

NO

-
-
-1
-
-

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|--------------|------------|------------|-----|------|---------|-------|---------| +| [id][1] | int(10) | unsigned | PRI | NO | | | | +| [gmlevel][2] | tinyint(3) | unsigned | | NO | | | | +| [RealmID][3] | int(11) | signed | PRI | NO | -1 | | | + +[1]: #id +[2]: #gmlevel +[3]: #realmid **Description of the fields** diff --git a/docs/areatrigger_involvedrelation.md b/docs/areatrigger_involvedrelation.md index 530270a..293fe66 100644 --- a/docs/areatrigger_involvedrelation.md +++ b/docs/areatrigger_involvedrelation.md @@ -10,50 +10,13 @@ If there is a record in the table for a quest, then the quest will not be comple **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comments

id

mediumint(8)

unsigned

PRI

NO

0

 

Identifier

quest

mediumint(8)

unsigned

 

NO

0

 

Quest Identifier

+| Field | Type | Attributes | Key | Null | Default | Extra | Comments | +|------------|--------------|------------|-----|------|---------|-------|------------------| +| [id][1] | mediumint(8) | unsigned | PRI | NO | 0 | | Identifier | +| [quest][2] | mediumint(8) | unsigned | | NO | 0 | | Quest Identifier | + +[1]: #id +[2]: #quest **Description of the fields** diff --git a/docs/battleground_deserters.md b/docs/battleground_deserters.md index eaccff7..4861124 100644 --- a/docs/battleground_deserters.md +++ b/docs/battleground_deserters.md @@ -8,60 +8,15 @@ This table holds datas about BattleGrounds deserters. To enable storing this kin **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int

unsigned

     

type

tinyint

unsigned

     

datetime

datetime

      
+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|---------------|----------|------------|-----|------|---------|-------|---------| +| [guid][1] | int | unsigned | | | | | | +| [type][2] | tinyint | unsigned | | | | | | +| [datetime][3] | datetime | | | | | | | + +[1]: #guid +[2]: #type +[3]: #datetime **Description of the fields** @@ -71,18 +26,14 @@ Link to characters.guid ### type -**0** = player leaves the BG - -**1** = player is kicked from BG because offline - -**2** = player is invited to join and refuses to do it - -**3** = player is invited to join and do nothing (time expires) - -**4** = player is invited to join and logs out +| Value | Description | +|-------|---------------------------------------------------------| +| 0 | player leaves the BG | +| 1 | player is kicked from BG because offline | +| 2 | player is invited to join and refuses to do it | +| 3 | player is invited to join and do nothing (time expires) | +| 4 | player is invited to join and logs out | ### datetime date and time of the event - -  diff --git a/docs/character_account_data.md b/docs/character_account_data.md index b12c3df..b7dea2b 100644 --- a/docs/character_account_data.md +++ b/docs/character_account_data.md @@ -8,70 +8,17 @@ Contains data about character settings. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

 

type

int(3)

unsigned

PRI

NO

0

 

 

time

bigint(10)

unsigned

 

NO

0

 

 

data

blob

signed

 

NO

 

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------|------------|------------|-----|------|---------|-------|---------| +| [guid][1] | int(10) | unsigned | PRI | NO | 0 | | | +| [type][2] | int(3) | unsigned | PRI | NO | 0 | | | +| [time][3] | bigint(10) | unsigned | | NO | 0 | | | +| [data][4] | blob | signed | | NO | | | | + +[1]: #guid +[2]: #type +[3]: #time +[4]: #data **Description of the fields** @@ -81,11 +28,13 @@ The character global unique identifier. See [Characters.guid](2129969.html#chara ### type -- 1 = Config cache per character -- 3 = Bindings cache per character -- 5 = Macros cache per character -- 6 = Layout cache per character -- 7 = Chat cache per character +| Value | Description | +|-------|------------------------------| +| 1 | Config cache per character | +| 3 | Bindings cache per character | +| 5 | Macros cache per character | +| 6 | Layout cache per character | +| 7 | Chat cache per character | ### time diff --git a/docs/character_achievement.md b/docs/character_achievement.md index 1b2356c..5bc3d54 100644 --- a/docs/character_achievement.md +++ b/docs/character_achievement.md @@ -10,59 +10,15 @@ This table holds information on the achievements a character has earned / comple **Structure** - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO


-


-


-

achievement

smallint(5)

unsigned

PRI

NO


-


-


-

date

int(10)

unsigned


-

NO

0


-


-

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------------|-------------|------------|-----|------|---------|-------|---------| +| [guid][1] | int(10) | unsigned | PRI | NO | | | | +| [achievement][2] | smallint(5) | unsigned | PRI | NO | | | | +| [date][3] | int(10) | unsigned | | NO | 0 | | | + +[1]: #guid +[2]: #achievement +[3]: #date **Description of the fields** @@ -76,4 +32,4 @@ The ID of the achievement from [Achievement.dbc](Achievement). ### date -The date/time when this achievement was earned, in Unix time. See [Unix Timestamp Calculator](http://www.unixtimestamp.com/index.php) \ No newline at end of file +The date/time when this achievement was earned, in Unix time. See [Unix Timestamp Calculator](http://www.unixtimestamp.com/index.php) diff --git a/docs/character_achievement_progress.md b/docs/character_achievement_progress.md index 7e58a2f..f662f02 100644 --- a/docs/character_achievement_progress.md +++ b/docs/character_achievement_progress.md @@ -8,70 +8,17 @@ **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

"

 

 

criteria

smallint(5)

unsigned

PRI

NO

"

 

 

counter

int(10)

unsigned

 

NO

"

 

 

date

int(10)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|---------------|-------------|------------|-----|------|---------|-------|---------| +| [guid][1] | int(10) | unsigned | PRI | NO | | | | +| [criteria][2] | smallint(5) | unsigned | PRI | NO | | | | +| [counter][3] | int(10) | unsigned | | NO | | | | +| [date][4] | int(10) | unsigned | | NO | 0 | | | + +[1]: #guid +[2]: #criteria +[3]: #counter +[4]: #date **Description of the fields** diff --git a/docs/character_arena_stats.md b/docs/character_arena_stats.md index 8c805b9..d2e0820 100644 --- a/docs/character_arena_stats.md +++ b/docs/character_arena_stats.md @@ -8,60 +8,15 @@ This table holds information about character's matchmaker rating in all team typ **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

signed

PRI

NO

 

 

 

slot

tinyint(3)

signed

PRI

NO

 

 

 

matchmakerRating

smallint(5)

signed

 

NO

 

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------------|-------------|------------|-----|------|---------|-------|---------| +| [guid][1] | int(10) | signed | PRI | NO | | | | +| [slot][2] | tinyint(3) | signed | PRI | NO | | | | +| [matchmakerRating][3] | smallint(5) | signed | | NO | | | | + +[1]: #guid +[2]: #slot +[3]: #matchmakerrating **Description of the fields** @@ -73,11 +28,11 @@ The GUID of the character. See characters.guid Arena slot index: -0 - 2v2 - -1 - 3v3 - -2 - 5v5 +| Value | Description | +|-------|-------------| +| 0 | 2v2 | +| 1 | 3v3 | +| 2 | 5v5 | ### matchmakerRating diff --git a/docs/character_instance.md b/docs/character_instance.md index f1c43f3..a29ad1c 100644 --- a/docs/character_instance.md +++ b/docs/character_instance.md @@ -8,60 +8,15 @@ Contains the instance data for characters. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

 

instance

int(10)

unsigned

PRI

NO

0

 

 

permanent

tinyint(3)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|----------------|------------|------------|-----|------|---------|-------|---------| +| [guid][1] | int(10) | unsigned | PRI | NO | 0 | | | +| [instance][2] | int(10) | unsigned | PRI | NO | 0 | | | +| [permanent][3] | tinyint(3) | unsigned | | NO | 0 | | | + +[1]: #guid +[2]: #instance +[3]: #permanent **Description of the fields** diff --git a/docs/character_queststatus_daily.md b/docs/character_queststatus_daily.md index 8bbc83d..994355b 100644 --- a/docs/character_queststatus_daily.md +++ b/docs/character_queststatus_daily.md @@ -8,60 +8,15 @@ Holds information on the daily quest status of every player. The quest must have **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

Global Unique Identifier

quest

int(10)

unsigned

PRI

NO

0

 

Quest 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 | +| [quest][2] | int(10) | unsigned | PRI | NO | 0 | | Quest Identifier | +| [time][3] | int(10) | unsigned | | NO | 0 | | | + +[1]: #guid +[2]: #quest +[3]: #time **Description of the fields** diff --git a/docs/character_queststatus_rewarded.md b/docs/character_queststatus_rewarded.md index 7e3e539..6a1ab88 100644 --- a/docs/character_queststatus_rewarded.md +++ b/docs/character_queststatus_rewarded.md @@ -8,60 +8,15 @@ This table holds information of **every** rewarded quest to a player. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

Global Unique Identifier

quest

int(10)

unsigned

PRI

NO

0

 

Quest Identifier

activetinyint(3)unsigned NO1  
+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-------------|------------|------------|-----|------|---------|-------|--------------------------| +| [guid][1] | int(10) | unsigned | PRI | NO | 0 | | Global Unique Identifier | +| [quest][2] | int(10) | unsigned | PRI | NO | 0 | | Quest Identifier | +| [active][3] | tinyint(3) | unsigned | | NO | 1 | | | + +[1]: #guid +[2]: #quest +[3]: #active **Description of the fields** diff --git a/docs/character_queststatus_seasonal.md b/docs/character_queststatus_seasonal.md index 06e36da..c83da30 100644 --- a/docs/character_queststatus_seasonal.md +++ b/docs/character_queststatus_seasonal.md @@ -8,60 +8,15 @@ Holds information on the seasonal quest (quests with ZoneOrSort of -22) status o **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

Global Unique Identifier

quest

int(10)

unsigned

PRI

NO

0

 

Quest Identifier

event

int(10)

unsigned

 

NO

0

 

Event Identifier

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------|---------|------------|-----|------|---------|-------|--------------------------| +| [guid][1] | int(10) | unsigned | PRI | NO | 0 | | Global Unique Identifier | +| [quest][2] | int(10) | unsigned | PRI | NO | 0 | | Quest Identifier | +| [event][3] | int(10) | unsigned | | NO | 0 | | Event Identifier | + +[1]: #guid +[2]: #quest +[3]: #event **Description of the fields** diff --git a/docs/character_talent.md b/docs/character_talent.md index af28b4a..37994b2 100644 --- a/docs/character_talent.md +++ b/docs/character_talent.md @@ -8,56 +8,15 @@ Contains all the individual talent data for each character. This is only used as **Structure** - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

NULL


-


-

spell

mediumint(8)

unsigned

PRI

NO

NULL


-


-

talentGroup

tinyint(3)

unsigned

PRI

NO

0


-


-

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------------|--------------|------------|-----|------|---------|-------|---------| +| [guid][1] | int(10) | unsigned | PRI | NO | NULL | | | +| [spell][2] | mediumint(8) | unsigned | PRI | NO | NULL | | | +| [talentGroup][3] | tinyint(3) | unsigned | PRI | NO | 0 | | | + +[1]: #guid +[2]: #spell +[3]: #talentgroup **Description of the fields** diff --git a/docs/command.md b/docs/command.md index fd7adfc..3505a5b 100644 --- a/docs/command.md +++ b/docs/command.md @@ -1,73 +1,33 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [command](command) +# command -

The `command` table

+[<-Back-to:World](database-world.md) -

Holds help and security information for commands. This table does NOT create new commands, it only sets / overrides security and provides help.

+**The `command` table** -

Structure

+Holds help and security information for commands. This table does NOT create new commands, it only sets / overrides security and provides help. - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

name

varchar(50)

signed

PRI

NO

NULL

security

tinyint(3)

unsigned

NO

0

help

longtext

signed

YES

NULL

+**Structure** -

Description of the fields

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|---------------|-------------|------------|-----|------|---------|-------|---------| +| [name][1] | varchar(50) | signed | PRI | NO | NULL | | | +| [security][2] | tinyint(3) | unsigned | | NO | 0 | | | +| [help][3] | longtext | signed | | YES | NULL | | | -

name

-

The name of the command.

+[1]: #name +[2]: #security +[3]: #help -

security

-

The security level required to use the command. Corresponds with account_access.gmlevel in the realm database.

+**Description of the fields** -

help

-

The help text displayed by the .help command.

+### name + +The name of the command. + +### security + +The security level required to use the command. Corresponds with account_access.gmlevel in the realm database. + +### help + +The help text displayed by the .help command. diff --git a/docs/game_event_condition_save.md b/docs/game_event_condition_save.md index 086c34b..3b8d64b 100644 --- a/docs/game_event_condition_save.md +++ b/docs/game_event_condition_save.md @@ -8,60 +8,15 @@ **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

eventEntry

tinyint(3)

unsigned

PRI

NO

 

 

 

condition_id

int(10)

unsigned

PRI

NO

0

 

 

done

float

signed

 

YES

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-------------------|------------|------------|-----|------|---------|-------|---------| +| [eventEntry][1] | tinyint(3) | unsigned | PRI | NO | | | | +| [condition_id][2] | int(10) | unsigned | PRI | NO | 0 | | | +| [done][3] | float | signed | | YES | 0 | | | + +[1]: #evententry +[2]: #condition_id +[3]: #done **Description of the fields** diff --git a/docs/game_event_creature.md b/docs/game_event_creature.md index 170fab8..070d029 100644 --- a/docs/game_event_creature.md +++ b/docs/game_event_creature.md @@ -8,50 +8,13 @@ Contains all creature instances that have to be spawned/unspawned during defined **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

eventEntry

tinyint(3)

signed

 

NO

 

 

Entry of the game event. Put negative entry to remove during event.

guid

int(10)

unsigned

PRI

NO

 

Unique

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------|------------|------------|-----|------|---------|--------|---------------------------------------------------------------------| +| [eventEntry][1] | tinyint(3) | signed | | NO | | | Entry of the game event. Put negative entry to remove during event. | +| [guid][2] | int(10) | unsigned | PRI | NO | | Unique | | + +[1]: #evententry +[2]: #guid **Description of the fields** diff --git a/docs/game_event_creature_quest.md b/docs/game_event_creature_quest.md index 190fbc0..76e25f7 100644 --- a/docs/game_event_creature_quest.md +++ b/docs/game_event_creature_quest.md @@ -8,60 +8,15 @@ This table holds information on quests that should only be available when an eve **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

eventEntry

tinyint(3)

unsigned

 

NO

 

 

Entry of the game event.

id

mediumint(8)

unsigned

PRI

NO

0

 

 

quest

mediumint(8)

unsigned

PRI

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------|--------------|------------|-----|------|---------|-------|--------------------------| +| [eventEntry][1] | tinyint(3) | unsigned | | NO | | | Entry of the game event. | +| [id][2] | mediumint(8) | unsigned | PRI | NO | 0 | | | +| [quest][3] | mediumint(8) | unsigned | PRI | NO | 0 | | | + +[1]: #evententry +[2]: #id +[3]: #quest **Description of the fields** diff --git a/docs/game_event_gameobject_quest.md b/docs/game_event_gameobject_quest.md index 69a23fe..b246a44 100644 --- a/docs/game_event_gameobject_quest.md +++ b/docs/game_event_gameobject_quest.md @@ -8,60 +8,15 @@ This table holds information on quests that should only be available when an eve **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

eventEntry

tinyint(3)

unsigned

PRI

NO

 

 

Entry of the game event

id

mediumint(8)

unsigned

PRI

NO

0

 

 

quest

mediumint(8)

unsigned

PRI

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------|--------------|------------|-----|------|---------|-------|-------------------------| +| [eventEntry][1] | tinyint(3) | unsigned | PRI | NO | | | Entry of the game event | +| [id][2] | mediumint(8) | unsigned | PRI | NO | 0 | | | +| [quest][3] | mediumint(8) | unsigned | PRI | NO | 0 | | | + +[1]: #evententry +[2]: #id +[3]: #quest **Description of the fields** diff --git a/docs/game_event_pool.md b/docs/game_event_pool.md index 0c8c8e3..2411bc7 100644 --- a/docs/game_event_pool.md +++ b/docs/game_event_pool.md @@ -8,50 +8,13 @@ This table determines if a given pool is active for a given game event. **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

eventEntry

tinyint(3)

signed

 

NO

 

 

Entry of the game event. Put negative entry to remove during event.

pool_entry

mediumint(8)

unsigned

PRI

NO

0

Unique

Id of the pool

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------|--------------|------------|-----|------|---------|--------|---------------------------------------------------------------------| +| [eventEntry][1] | tinyint(3) | signed | | NO | | | Entry of the game event. Put negative entry to remove during event. | +| [pool_entry][2] | mediumint(8) | unsigned | PRI | NO | 0 | Unique | Id of the pool | + +[1]: #evententry +[2]: #pool_entry **Description of the fields** diff --git a/docs/game_event_prerequisite.md b/docs/game_event_prerequisite.md index 492e9e4..18dfb7a 100644 --- a/docs/game_event_prerequisite.md +++ b/docs/game_event_prerequisite.md @@ -8,50 +8,13 @@ This table contains events that must have been completed to start the given even **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

eventEntry

tinyint(3)

unsigned

PRI

NO

 

 

 

prerequisite_event

mediumint(8)

unsigned

PRI

NO

 

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-------------------------|--------------|------------|-----|------|---------|-------|---------| +| [eventEntry][1] | tinyint(3) | unsigned | PRI | NO | | | | +| [prerequisite_event][2] | mediumint(8) | unsigned | PRI | NO | | | | + +[1]: #evententry +[2]: #prerequisite_event **Description of the fields** diff --git a/docs/game_event_seasonal_questrelation.md b/docs/game_event_seasonal_questrelation.md index 99300b4..ee4e6e5 100644 --- a/docs/game_event_seasonal_questrelation.md +++ b/docs/game_event_seasonal_questrelation.md @@ -8,50 +8,13 @@ Holds information on the game event seasonal quest relations to allow for resett **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

questId

int(10)

unsigned

PRI

NO

0

 

Quest Identifier

eventEntry

mediumint(10)

unsigned

PRI

NO

0

 

Entry of the game event

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|-----------------|---------------|------------|-----|------|---------|-------|-------------------------| +| [questId][1] | int(10) | unsigned | PRI | NO | 0 | | Quest Identifier | +| [eventEntry][2] | mediumint(10) | unsigned | PRI | NO | 0 | | Entry of the game event | + +[1]: #questid +[2]: #evententry **Description of the fields** diff --git a/docs/gameobject.md b/docs/gameobject.md index de03340..a4a0b6d 100644 --- a/docs/gameobject.md +++ b/docs/gameobject.md @@ -8,190 +8,41 @@ This table holds the individual object data on each spawned game object in the w **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

NULL

Auto increment

Global Unique Identifier

id

mediumint(8)

unsigned

 

NO

0

 

Gameobject Identifier

map

smallint(5)

unsigned

 

NO

0

 

Map Identifier

spawnMask

tinyint(3)

unsigned

 

NO

1

 

 

phaseMask

smallint(5)

unsigned

 

NO

1

 

 

position_x

float

signed

 

NO

0

 

 

position_y

float

signed

 

NO

0

 

 

position_z

float

signed

 

NO

0

 

 

orientation

float

signed

 

NO

0

 

 

rotation0

float

signed

 

NO

0

 

 

rotation1

float

signed

 

NO

0

 

 

rotation2

float

signed

 

NO

0

 

 

rotation3

float

signed

 

NO

0

 

 

spawntimesecs

int(11)

signed

 

NO

0

 

 

animprogress

tinyint(3)

unsigned

 

NO

0

 

 

state

tinyint(3)

unsigned

 

NO

1

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|---------------------|--------------|------------|-----|------|---------|----------------|--------------------------| +| [guid][1] | int(10) | unsigned | PRI | NO | NULL | Auto increment | Global Unique Identifier | +| [id][2] | mediumint(8) | unsigned | | NO | 0 | | Gameobject Identifier | +| [map][3] | smallint(5) | unsigned | | NO | 0 | | Map Identifier | +| [spawnMask][4] | tinyint(3) | unsigned | | NO | 1 | | | +| [phaseMask][5] | smallint(5) | unsigned | | NO | 1 | | | +| [position_x][6] | float | signed | | NO | 0 | | | +| [position_y][7] | float | signed | | NO | 0 | | | +| [position_z][8] | float | signed | | NO | 0 | | | +| [orientation][9] | float | signed | | NO | 0 | | | +| [rotation0][10] | float | signed | | NO | 0 | | | +| [rotation1][11] | float | signed | | NO | 0 | | | +| [rotation2][12] | float | signed | | NO | 0 | | | +| [rotation3][13] | float | signed | | NO | 0 | | | +| [spawntimesecs][14] | int(11) | signed | | NO | 0 | | | +| [animprogress][15] | tinyint(3) | unsigned | | NO | 0 | | | +| [state][16] | tinyint(3) | unsigned | | NO | 1 | | | + +[1]: #guid +[2]: #id +[3]: #map +[4]: #spawnmask +[5]: #phasemask +[6]: #position_x +[7]: #position_y +[8]: #position_z +[9]: #orientation +[10]: #rotation0 +[11]: #rotation1 +[12]: #rotation2 +[13]: #rotation3 +[14]: #spawntimesecs +[15]: #animprogress +[16]: #state **Description of the fields** @@ -213,45 +64,14 @@ Controls under which difficulties the object is spawned. Just like flags you can add them as you wish so 3 would be: Spawned in 10/25 man normal versions of maps (pre 3.2 all maps) - ---- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Value

Comment

0

Not spawned

1

Spawned only in 10-man-normal versions of maps (includes maps without a heroic mode)

2

Spawned only in 25-man-normal versions of maps (or heroics pre 3.2)

4

Spawned only in 10-man heroic versions of maps

8

Spawned only in 25-man-heroic versions of maps

15

Spawned in all versions of maps

- +| Value | Comment | +|-------|--------------------------------------------------------------------------------------| +| 0 | Not spawned | +| 1 | Spawned only in 10-man-normal versions of maps (includes maps without a heroic mode) | +| 2 | Spawned only in 25-man-normal versions of maps (or heroics pre 3.2) | +| 4 | Spawned only in 10-man heroic versions of maps | +| 8 | Spawned only in 25-man-heroic versions of maps | +| 15 | Spawned in all versions of maps | ### phaseMask @@ -297,4 +117,3 @@ For chests or doors. - 1 = closed - 0 = open - diff --git a/docs/gameobject_questender.md b/docs/gameobject_questender.md index 2a92c9d..219168e 100644 --- a/docs/gameobject_questender.md +++ b/docs/gameobject_questender.md @@ -8,50 +8,13 @@ Holds game object quest taker relations. The game objects in this table should a **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

id

mediumint(8)

unsigned

PRI

NO

0

 

 

quest

mediumint(8)

unsigned

PRI

NO

0

 

Quest Identifier

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------|--------------|------------|-----|------|---------|-------|------------------| +| [id][1] | mediumint(8) | unsigned | PRI | NO | 0 | | | +| [quest][2] | mediumint(8) | unsigned | PRI | NO | 0 | | Quest Identifier | + +[1]: #id +[2]: #quest **Description of the fields** diff --git a/docs/gm_subsurveys.md b/docs/gm_subsurveys.md index 7a7da13..df6285d 100644 --- a/docs/gm_subsurveys.md +++ b/docs/gm_subsurveys.md @@ -8,100 +8,23 @@ **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

surveyid

int(10)

signed

PRI

NO

 

 

 

subsurveyid

int(11)

unsigned

PRI

NO

0

 

 

rank

int(11)

unsigned

 

NO

0

 

 

comment

longtext

signed

 

NO

 

 

 

played

int(10)

unsigned

 

NO

0

 

 

wins2

int(10)

unsigned

 

NO

0

 

 

rank

int(10)

unsigned

 

NO

0

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------------|----------|------------|-----|------|---------|-------|---------| +| [surveyid][1] | int(10) | signed | PRI | NO | | | | +| [subsurveyid][2] | int(11) | unsigned | PRI | NO | 0 | | | +| [rank][3] | int(11) | unsigned | | NO | 0 | | | +| [comment][4] | longtext | signed | | NO | | | | +| [played][5] | int(10) | unsigned | | NO | 0 | | | +| [wins2][6] | int(10) | unsigned | | NO | 0 | | | +| [rank][7] | int(10) | unsigned | | NO | 0 | | | + +[1]: #surveyid +[2]: #subsurveyid +[3]: #rank +[4]: #comment +[5]: #played +[6]: #wins2 +[7]: #rank **Description of the fields** @@ -120,3 +43,15 @@ ### comment `field-no-description|4` + +### played + +`field-no-description|5` + +### wins2 + +`field-no-description|6` + +### rank + +`field-no-description|7` diff --git a/docs/item_soulbound_trade_data.md b/docs/item_soulbound_trade_data.md index 1c30076..bdb431b 100644 --- a/docs/item_soulbound_trade_data.md +++ b/docs/item_soulbound_trade_data.md @@ -8,50 +8,13 @@ This table stores information about which players can trade soulbound items betw **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

itemGuid

int(10)

unsigned

PRI

NO

 

Unique

Item GUID

alowedplayers

text

signed

PRI

NO

 

 

Space separated GUID list of players who can receive this item in trade

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|--------------------|---------|------------|-----|------|---------|--------|-------------------------------------------------------------------------| +| [itemGuid][1] | int(10) | unsigned | PRI | NO | | Unique | Item GUID | +| [alowedplayers][2] | text | signed | PRI | NO | | | Space separated GUID list of players who can receive this item in trade | + +[1]: #itemguid +[2]: #alowedplayers **Description of the fields** diff --git a/docs/mail_items.md b/docs/mail_items.md index ea3e8d8..35ce219 100644 --- a/docs/mail_items.md +++ b/docs/mail_items.md @@ -8,60 +8,15 @@ This table contains data regarding items from item\_instance which are being sen **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

mail_id

int(10)

unsigned

 

NO

0

 

 

item_guid

int(10)

unsigned

PRI

NO

0

 

 

receiver

int(10)

unsigned

 

NO

0

 

Character Global Unique Identifier

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|----------------|---------|------------|-----|------|---------|-------|------------------------------------| +| [mail_id][1] | int(10) | unsigned | | NO | 0 | | | +| [item_guid][2] | int(10) | unsigned | PRI | NO | 0 | | | +| [receiver][3]