From a9d7681ed9b7ef7580d8ece93caae3507a298524 Mon Sep 17 00:00:00 2001 From: "Julio A. Leyva Osorio" Date: Thu, 13 Jan 2022 09:06:27 -0500 Subject: chore: some updates and Creation of the wiki files in Spanish (characters) (#607) * Create mail_items.md * Create pet_aura.md * Create log_arena_memberstats * Create log_encounter.md * Create log_money.md * Create mail.md * Create pet_spell.md * Create pet_spell_cooldown.md * Create petition.md * Create petition_sign.md * Create pvpstats_players.md * Create quest_tracker.md * Create recovery_item.md * Create reserved_name.md * Create worldstates.md * Create addons.md * Create bugreport.md * Create channels_bans.md * Create character_battleground_random.md * Create character_brew_of_the_month.md * Create character_queststatus_monthly.md * Create game_event_save.md * Create pool_quest_save.md * Create warden_action.md * Update character_queststatus_monthly.md * Update * Create banned_addons.md * Create character_talent.md * Create corpse.md * Create gm_subsurvey.md * Create guild_bank_eventlog.md * Create version_db_characters.md * Update version_db_auth.md * Update account_instance_times.md * Update character_achievement_progress.md * Update character_gifts.md * Update character_queststatus_daily.md * Update character_queststatus_rewarded.md * Update character_queststatus_seasonal.md * Update character_queststatus_weekly.md * Update character_spell.md * Update game_event_condition_save.md * Update item_soulbound_trade_data.md * Update lfg_data.md Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com> --- docs/es/addons.md | 27 + docs/es/banned_addons.md | 39 ++ docs/es/bugreport.md | 33 ++ docs/es/channels_bans.md | 33 ++ docs/es/character_achievement_progress.md | 37 ++ docs/es/character_battleground_random.md | 23 + docs/es/character_brew_of_the_month.md | 27 + docs/es/character_gifts.md | 41 ++ docs/es/character_queststatus_daily.md | 33 ++ docs/es/character_queststatus_monthly.md | 27 + docs/es/character_queststatus_rewarded.md | 33 ++ docs/es/character_queststatus_seasonal.md | 33 ++ docs/es/character_queststatus_weekly.md | 27 + docs/es/character_spell.md | 33 ++ docs/es/character_talent.md | 38 ++ docs/es/corpse.md | 117 ++++ docs/es/game_event_condition_save.md | 31 ++ docs/es/game_event_save.md | 33 ++ docs/es/gm_subsurvey.md | 41 ++ docs/es/guild_bank_eventlog.md | 79 +++ docs/es/item_soulbound_trade_data.md | 27 + docs/es/lfg_data.md | 33 ++ docs/es/log_arena_memberstats.md | 75 +++ docs/es/log_encounter.md | 51 ++ docs/es/log_money.md | 69 +++ docs/es/mail.md | 134 +++++ docs/es/mail_items.md | 35 ++ docs/es/pet_aura.md | 89 +++ docs/es/pet_spell.md | 35 ++ docs/es/pet_spell_cooldown.md | 35 ++ docs/es/petition.md | 48 ++ docs/es/petition_sign.md | 54 ++ docs/es/pool_quest_save.md | 27 + docs/es/pvpstats_players.md | 65 +++ docs/es/quest_tracker.md | 63 +++ docs/es/recovery_item.md | 41 ++ docs/es/reserved_name.md | 21 + docs/es/version_db_auth.md | 2 +- docs/es/version_db_characters.md | 39 ++ docs/es/warden_action.md | 27 + docs/es/worldstates.md | 891 ++++++++++++++++++++++++++++++ 41 files changed, 2645 insertions(+), 1 deletion(-) create mode 100644 docs/es/addons.md create mode 100644 docs/es/banned_addons.md create mode 100644 docs/es/bugreport.md create mode 100644 docs/es/channels_bans.md create mode 100644 docs/es/character_achievement_progress.md create mode 100644 docs/es/character_battleground_random.md create mode 100644 docs/es/character_brew_of_the_month.md create mode 100644 docs/es/character_gifts.md create mode 100644 docs/es/character_queststatus_daily.md create mode 100644 docs/es/character_queststatus_monthly.md create mode 100644 docs/es/character_queststatus_rewarded.md create mode 100644 docs/es/character_queststatus_seasonal.md create mode 100644 docs/es/character_queststatus_weekly.md create mode 100644 docs/es/character_spell.md create mode 100644 docs/es/character_talent.md create mode 100644 docs/es/corpse.md create mode 100644 docs/es/game_event_condition_save.md create mode 100644 docs/es/game_event_save.md create mode 100644 docs/es/gm_subsurvey.md create mode 100644 docs/es/guild_bank_eventlog.md create mode 100644 docs/es/item_soulbound_trade_data.md create mode 100644 docs/es/lfg_data.md create mode 100644 docs/es/log_arena_memberstats.md create mode 100644 docs/es/log_encounter.md create mode 100644 docs/es/log_money.md create mode 100644 docs/es/mail.md create mode 100644 docs/es/mail_items.md create mode 100644 docs/es/pet_aura.md create mode 100644 docs/es/pet_spell.md create mode 100644 docs/es/pet_spell_cooldown.md create mode 100644 docs/es/petition.md create mode 100644 docs/es/petition_sign.md create mode 100644 docs/es/pool_quest_save.md create mode 100644 docs/es/pvpstats_players.md create mode 100644 docs/es/quest_tracker.md create mode 100644 docs/es/recovery_item.md create mode 100644 docs/es/reserved_name.md create mode 100644 docs/es/version_db_characters.md create mode 100644 docs/es/warden_action.md create mode 100644 docs/es/worldstates.md (limited to 'docs') diff --git a/docs/es/addons.md b/docs/es/addons.md new file mode 100644 index 0000000..3b6a15d --- /dev/null +++ b/docs/es/addons.md @@ -0,0 +1,27 @@ +# addons + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../addons) [Spanish :es:](addons) + +**Tabla \`addons\`** + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| -------------- | ------------ | ---------- | --- | ---- | ------- | ------ | ------- | +| [name][1] | VARCHAR(120) | SIGNED | PRI | NO | '' | PRI | | +| [crc][2] | INT | UNSIGNED | | NO | 0 | | | + +[1]: #name +[2]: #crc + +**Descripción de los campos** + +### name + +`campo-sin-descripción|1` + +### crc + +`campo-sin-descripción|2` diff --git a/docs/es/banned_addons.md b/docs/es/banned_addons.md new file mode 100644 index 0000000..559818e --- /dev/null +++ b/docs/es/banned_addons.md @@ -0,0 +1,39 @@ +# banned\_addons + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../banned_addons) [Spanish :es:](banned_addons) + +**Tabla \`banned\_addons\`** + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| -------------- | ------------ | ---------- | --- | ---- | ----------------- | ------ | ------- | +| [Id][1] | INT | UNSIGNED | PRI | NO | | | | +| [Name][2] | VARCHAR(255) | SIGNED | | NO | | UNIQUE | | +| [Version][3] | VARCHAR(255) | SIGNED | | NO | '' | UNIQUE | | +| [Timestamp][4] | TIMESTAMP | SIGNED | | NO | CURRENT_TIMESTAMP | | | + +[1]: #id +[2]: #name +[3]: #version +[4]: #timestamp + +**Descripción de los campos** + +### Id + +`campo-sin-descripción|1` + +### Name + +`campo-sin-descripción|2` + +### Version + +`campo-sin-descripción|3` + +### Timestamp + +`campo-sin-descripción|4` diff --git a/docs/es/bugreport.md b/docs/es/bugreport.md new file mode 100644 index 0000000..36d8906 --- /dev/null +++ b/docs/es/bugreport.md @@ -0,0 +1,33 @@ +# bugreport + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../bugreport) [Spanish :es:](bugreport) + +**Tabla \`bugreport\`** + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| -------------- | -------- | ---------- | --- | ---- | ------- | -------------- | ---------- | +| [id][1] | INT | UNSIGNED | PRI | NO | | AUTO_INCREMENT | Identifier | +| [type][2] | LONGTEXT | SIGNED | | NO | | | | +| [content][3] | LONGTEXT | SIGNED | | NO | | | | + +[1]: #id +[2]: #type +[3]: #content + +**Descripción de los campos** + +### id + +`campo-sin-descripción|1` + +### type + +`campo-sin-descripción|2` + +### content + +`campo-sin-descripción|3` diff --git a/docs/es/channels_bans.md b/docs/es/channels_bans.md new file mode 100644 index 0000000..a896343 --- /dev/null +++ b/docs/es/channels_bans.md @@ -0,0 +1,33 @@ +# channels\_bans + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../channels_bans) [Spanish :es:](channels_bans) + +**Tabla \`channels\_bans\`** + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| --------------- | ----- | ---------- | --- | ---- | ------- | ------ | ------- | +| [channelId][1] | INT | UNSIGNED | PRI | NO | | | | +| [playerGUID][2] | INT | UNSIGNED | PRI | NO | | | | +| [banTime][3] | INT | UNSIGNED | | NO | | | | + +[1]: #channelid +[2]: #playerguid +[3]: #banTime + +**Descripción de los campos** + +### channelId + +El [channel.id](channels#channelid). + +### playerGUID + +`campo-sin-descripción|2` + +### banTime + +El tiempo de baneo del [channel](channels#channelid). diff --git a/docs/es/character_achievement_progress.md b/docs/es/character_achievement_progress.md new file mode 100644 index 0000000..82442b5 --- /dev/null +++ b/docs/es/character_achievement_progress.md @@ -0,0 +1,37 @@ +# character\_achievement\_progress + +[<-Volver a:Characters](database-characters.md) + +**Tabla \`character\_achievement\_progress\`** + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ------------- | ----------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [guid][1] | INT | UNSIGNED | PRI | NO | | | | +| [criteria][2] | SMALLINT | UNSIGNED | PRI | NO | | | | +| [counter][3] | INT | UNSIGNED | | NO | | | | +| [date][4] | INT | UNSIGNED | | NO | 0 | | | + +[1]: #guid +[2]: #criteria +[3]: #counter +[4]: #date + +**Descripción de los campos** + +### guid + +El GUID del personaje. Consulte [characters.guid](characters#guid). + +### criteria + +Criterios de [Achievement\_Criteria.dbc](achievement_criteria). + +### counter + +`campo-sin-descripción|3` + +### date + +La fecha en la que se obtuvo este logro. Consulte [Unix timestamp Calculator](http://www.unixtimestamp.com/index.php). diff --git a/docs/es/character_battleground_random.md b/docs/es/character_battleground_random.md new file mode 100644 index 0000000..94097e3 --- /dev/null +++ b/docs/es/character_battleground_random.md @@ -0,0 +1,23 @@ +# character\_battleground\_random + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../character_battleground_random) [Spanish :es:](character_battleground_random) + +**Tabla \`character\_battleground\_random\`** + +Esta tabla almacena ID de campos de batalla para sesiones de campo de batalla aleatorias. + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| --------- | -------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | | + +[1]: #guid + +**Descripción de los campos** + +### guid + +El guid del personaje que ya ganó un campo de batalla aleatorio hoy. Ver [characters.guid](characters#guid). diff --git a/docs/es/character_brew_of_the_month.md b/docs/es/character_brew_of_the_month.md new file mode 100644 index 0000000..8dd0adf --- /dev/null +++ b/docs/es/character_brew_of_the_month.md @@ -0,0 +1,27 @@ +# character\_brew\_of\_the\_month + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../character_brew_of_the_month) [Spanish :es:](character_brew_of_the_month) + +**Tabla \`character\_brew\_of\_the\_month\`** + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ---------------- | ---- | ---------- | --- | ---- | ------- | ----- | -------- | +| [guid][1] | INT | UNSIGNED | PRI | NO | | | | +| [lastEventId][2] | INT | UNSIGNED | | NO | 0 | | | + +[1]: #guid +[2]: #lastEventId + +**Descripción de los campos** + +### guid + +`campo-sin-descripción|1` + +### lastEventId + +`campo-sin-descripción|2` diff --git a/docs/es/character_gifts.md b/docs/es/character_gifts.md new file mode 100644 index 0000000..048d8f5 --- /dev/null +++ b/docs/es/character_gifts.md @@ -0,0 +1,41 @@ +# character\_gifts + +[<-Volver a:Characters](database-characters.md) + +**Tabla \`character\_gifts\`** + +Esta tabla contiene datos sobre artículos envueltos o de regalo. + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| -------------- | ---- | ---------- | --- | ---- | ------- | ----- | ------- | +| [guid][1] | INT | UNSIGNED | | NO | 0 | | | +| [item_guid][2] | INT | UNSIGNED | PRI | NO | 0 | | | +| [entry][3] | INT | UNSIGNED | | NO | 0 | | | +| [flags][4] | INT | UNSIGNED | | NO | 0 | | | + +[1]: #guid +[2]: #itemguid +[3]: #entry +[4]: #flags + +**Descripción de los campos** + +### guid + +El GUID del personaje. Consulte [characters.guid](characters#guid). + +### item\_guid + +El GUID del artículo. Consulte [item\_instance.guid](item_instance#guid). + +### entry + +La entrada del artículo. Consulte [item\_template.entry](item_template#entry). + +### flags + +`campo-sin-descripción|4` + +*Nota para futuras investigaciones: max flags 13369920? FieldFlags of ProtoFlags?* diff --git a/docs/es/character_queststatus_daily.md b/docs/es/character_queststatus_daily.md new file mode 100644 index 0000000..40336d3 --- /dev/null +++ b/docs/es/character_queststatus_daily.md @@ -0,0 +1,33 @@ +# character\_queststatus\_daily + +[<-Volver a:Characters](database-characters.md) + +**Tabla \`character\_queststatus\_daily\`** + +Contiene información sobre el estado de las misiones diarias de cada jugador. La misión debe tener el tipo = 87 o la bandera 4096 en QuestFlags. + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|----------- | ------- | ---------- | --- | ---- | ------- | ----- | ------------------------ | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier | +| [quest][2] | INT | UNSIGNED | PRI | NO | 0 | | Quest Identifier | +| [time][3] | INT | UNSIGNED | | NO | 0 | | | + +[1]: #guid +[2]: #quest +[3]: #time + +**Descripción de los campos** + +### guid + +El GUID del carácter. Consulte [characters.guid](characters#guid). + +### quest + +El ID de misión de la misión diaria. Ver [quest\_template.entry](quest\_template#entry). + +### time + +El momento en que se realizó la búsqueda, en tiempo Unix. diff --git a/docs/es/character_queststatus_monthly.md b/docs/es/character_queststatus_monthly.md new file mode 100644 index 0000000..4bd0ff4 --- /dev/null +++ b/docs/es/character_queststatus_monthly.md @@ -0,0 +1,27 @@ +# character\_queststatus\_monthly + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../character_queststatus_monthly) [Spanish :es:](character_queststatus_monthly) + +**Tabla \`character\_queststatus\_monthly\`** + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ----------- | ---- | ---------- | --- | ---- | ------- | ------ | ------------------------ | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier | +| [quest][2] | INT | UNSIGNED | PRI | NO | 0 | | Quest Identifier | + +[1]: #guid +[2]: #quest + +**Descripción de los campos** + +### guid + +El guid del personaje. Ver [characters.guid](characters#guid). + +### quest + +El ID de misión de la misión recompensada. Ver [quest\_template.id](quest_template#id). diff --git a/docs/es/character_queststatus_rewarded.md b/docs/es/character_queststatus_rewarded.md new file mode 100644 index 0000000..eb55196 --- /dev/null +++ b/docs/es/character_queststatus_rewarded.md @@ -0,0 +1,33 @@ +# character\_queststatus\_rewarded + +[<-Volver a:Characters](database-characters.md) + +**Tabla \`character\_queststatus\_rewarded\`** + +Esta tabla contiene información de ** cada ** misión recompensada para un jugador. + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ----------- | ---------- | ---------- | --- | ---- | ------- | ----- | ------------------------ | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier | +| [quest][2] | INT | UNSIGNED | PRI | NO | 0 | | Quest Identifier | +| [active][3] | TINYINT | UNSIGNED | | NO | 1 | | | + +[1]: #guid +[2]: #quest +[3]: #active + +**Descripción de los campos** + +### guid + +El GUID del carácter. Consulte [characters.guid](characters#guid). + +### quest + +El ID de misión de la misión recompensada. Ver [quest\_template.id](quest_template#id). + +### active + +`campo-sin-descripción|3` diff --git a/docs/es/character_queststatus_seasonal.md b/docs/es/character_queststatus_seasonal.md new file mode 100644 index 0000000..572a03c --- /dev/null +++ b/docs/es/character_queststatus_seasonal.md @@ -0,0 +1,33 @@ +# character\_queststatus\_seasonal + +[<-Volver a:Characters](database-characters.md) + +**Tabla \`character\_queststatus\_seasonal\`** + +Contiene información sobre el estado de la misión de temporada (misiones con ZoneOSort of -22) de cada jugador. Las misiones se reinician al final de la entrada de evento correspondiente. + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ---------- | ------- | ---------- | --- | ---- | ------- | ----- | ------------------------ | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier | +| [quest][2] | INT | UNSIGNED | PRI | NO | 0 | | Quest Identifier | +| [event][3] | INT | UNSIGNED | | NO | 0 | | Event Identifier | + +[1]: #guid +[2]: #quest +[3]: #event + +**Descripción de los campos** + +### guid + +El GUID del personaje. Consulte [characters.guid](characters#guid). + +### quest + +El ID de misión de la misión recompensada. Consulte [quest\_template.id](quest_template#id). + +### event + +El eventEntry del evento del juego al que pertenece la misión de temporada. diff --git a/docs/es/character_queststatus_weekly.md b/docs/es/character_queststatus_weekly.md new file mode 100644 index 0000000..33a9ac4 --- /dev/null +++ b/docs/es/character_queststatus_weekly.md @@ -0,0 +1,27 @@ +# character\_queststatus\_weekly + +[<-Volver a:Characters](database-characters.md) + +**Tabla \`character\_queststatus\_weekly\`** + +Contiene información sobre el estado de las misiones semanales de cada jugador. Los temporizadores se reinician al mismo tiempo que se reinician las incursiones. + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ---------- | ------- | ---------- | --- | ---- | ------- | ----- | ------------------------ | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier | +| [quest][2] | INT | UNSIGNED | PRI | NO | 0 | | Quest Identifier | + +[1]: #guid +[2]: #quest + +**Descripción de los campos** + +### guid + +El GUID del personaje. Consulte [characters.guid](characters#guid). + +### quest + +El ID de misión de la misión recompensada. Consulte [quest\_template.id](quest_template#id). diff --git a/docs/es/character_spell.md b/docs/es/character_spell.md new file mode 100644 index 0000000..349846d --- /dev/null +++ b/docs/es/character_spell.md @@ -0,0 +1,33 @@ +# character\_spell + +[<-Volver a:Characters](database-characters.md) + +**Tabla \`character\_spell\`** + +Contiene información para los hechizos de cada personaje. + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ------------- | --------- | ---------- | --- | ---- | ------- | ----- | ------------------------ | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier | +| [spell][2] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | Spell Identifier | +| [specMask][3] | TINYINT | UNSIGNED | | NO | 1 | | | + +[1]: #guid +[2]: #spell +[3]: #specmask + +**Descripción de los campos** + +### guid + +El GUID del personaje. Consulte [characters.guid](characters#guid). + +### spell + +La identificación del hechizo. Consulte la columna 1 de[Spell.dbc](spell). + +### specMask + +Boolean 1 or 0 que significa si el hechizo está activo (aparece en el libro de hechizos). diff --git a/docs/es/character_talent.md b/docs/es/character_talent.md new file mode 100644 index 0000000..c5a5a93 --- /dev/null +++ b/docs/es/character_talent.md @@ -0,0 +1,38 @@ +# character\_talent + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../character_talent) [Spanish :es:](character_talent) + +**Tabla \`character\_talent\`** + +Contiene todos los datos de talentos individuales de cada personaje. Esto solo se usa como una tabla de almacenamiento, los valores se leen desde aquí y se escriben en character\_spell, y viceversa, cuando un jugador cambia de especificación. + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ------------- | --------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [guid][1] | INT | UNSIGNED | PRI | NO | | | | +| [spell][2] | MEDIUMINT | UNSIGNED | PRI | NO | | | | +| [specMask][3] | TINYINT | UNSIGNED | PRI | NO | 0 | | | + +[1]: #guid +[2]: #spell +[3]: #specmask + +**Descripción de los campos** + +### guid + +El guid del personaje. Ver [characters.guid](characters#guid). + +### spell + +El id del hechizo. Ver [Spell.dbc](spell) columna 1. + +### specMask + +| Value | Data | +| ----- | ------------------ | +| 0 | is the first spec | +| 1 | is the second spec | diff --git a/docs/es/corpse.md b/docs/es/corpse.md new file mode 100644 index 0000000..caa70e9 --- /dev/null +++ b/docs/es/corpse.md @@ -0,0 +1,117 @@ +# corpse + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../corpse) [Spanish :es:](corpse) + +**Tabla \`corpse\`** + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ---------------- | -------- | ---------- | --- | ---- | ------- | ------ | ---------------------------------- | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Character Global Unique Identifier | +| [posX][2] | FLOAT | SIGNED | | NO | 0 | | | +| [posY][3] | FLOAT | SIGNED | | NO | 0 | | | +| [posZ][4] | FLOAT | SIGNED | | NO | 0 | | | +| [orientation][5] | FLOAT | SIGNED | | NO | 0 | | | +| [mapId][6] | SMALLINT | UNSIGNED | | NO | 0 | | Map Identifier | +| [phaseMask][7] | INT | UNSIGNED | | NO | 1 | | | +| [displayId][8] | INT | UNSIGNED | | NO | 0 | | | +| [itemCache][9] | TEXT | SIGNED | | NO | | | | +| [bytes1][10] | INT | UNSIGNED | | NO | 0 | | | +| [bytes2][11] | INT | UNSIGNED | | NO | 0 | | | +| [guildId][12] | INT | UNSIGNED | | NO | 0 | | | +| [flags][13] | TINYINT | UNSIGNED | | NO | 0 | | | +| [dynFlags][14] | TINYINT | UNSIGNED | | NO | 0 | | | +| [time][15] | INT | UNSIGNED | | NO | 0 | | | +| [corpseType][16] | TINYINT | UNSIGNED | | NO | 0 | | | +| [instanceId][17] | INT | UNSIGNED | | NO | 0 | | Instance Identifier | + +[1]: #guid +[2]: #posx +[3]: #posy +[4]: #posz +[5]: #orientation +[6]: #mapid +[7]: #phasemask +[8]: #displayid +[9]: #itemcache +[10]: #bytes1 +[11]: #bytes2 +[12]: #guildid +[13]: #flags +[14]: #dynFlags +[15]: #time +[16]: #corpsetype +[17]: #instanceid + +**Descripción de los campos** + +### guid + +El guid del personaje. See [characters.guid](characters#guid). + +### posX + +`campo-sin-descripción|2` + +### posY + +`campo-sin-descripción|3` + +### posZ + +`campo-sin-descripción|4` + +### orientation + +`campo-sin-descripción|5` + +### mapId + +`campo-sin-descripción|6` + +### phaseMask + +`campo-sin-descripción|7` + +### displayId + +`campo-sin-descripción|8` + +### itemCache + +`campo-sin-descripción|9` + +### bytes1 + +`campo-sin-descripción|10` + +### bytes2 + +`campo-sin-descripción|11` + +### guildId + +`campo-sin-descripción|12` + +### flags + +`campo-sin-descripción|13` + +### dynFlags + +`campo-sin-descripción|14` + +### time + +`campo-sin-descripción|15` + +### corpseType + +`campo-sin-descripción|16` + +### instanceId + +`campo-sin-descripción|17` diff --git a/docs/es/game_event_condition_save.md b/docs/es/game_event_condition_save.md new file mode 100644 index 0000000..11134c0 --- /dev/null +++ b/docs/es/game_event_condition_save.md @@ -0,0 +1,31 @@ +# game\_event\_condition\_save + +[<-Volver a:Characters](database-characters.md) + +**Tabla \`game\_event\_condition\_save\`** + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ----------------- | ------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [eventEntry][1] | TINYINT | UNSIGNED | PRI | NO | | | | +| [condition_id][2] | INT | UNSIGNED | PRI | NO | 0 | | | +| [done][3] | FLOAT | SIGNED | | YES | 0 | | | + +[1]: #evententry +[2]: #conditionid +[3]: #done + +**Descripción de los campos** + +### eventEntry + +Este es un enlace a la entrada del evento en la tabla del game\_event. + +### condition\_id + +Consulte [game\_event\_condition.condition\_id](game_event_condition#condition_id). + +### done + +Indica cuánto se ha hecho. Consulte[game\_event\_condition.req\_num](game_event_condition#req_num). diff --git a/docs/es/game_event_save.md b/docs/es/game_event_save.md new file mode 100644 index 0000000..c2e2ce5 --- /dev/null +++ b/docs/es/game_event_save.md @@ -0,0 +1,33 @@ +# game\_event\_save + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../game_event_save) [Spanish :es:](game_event_save) + +**Tabla \`game\_event\_save\`** + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| --------------- | ------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [eventEntry][1] | TINYINT | UNSIGNED | PRI | NO | | | | +| [state][2] | TINYINT | UNSIGNED | | NO | 1 | | | +| [next_start][3] | INT | UNSIGNED | | NO | 0 | | | + +[1]: #evententry +[2]: #state +[3]: #nextstart + +**Descripción de los campos** + +### eventEntry + +`campo-sin-descripción|1` + +### state + +`campo-sin-descripción|2` + +### next\_start + +`campo-sin-descripción|3` diff --git a/docs/es/gm_subsurvey.md b/docs/es/gm_subsurvey.md new file mode 100644 index 0000000..7eb3966 --- /dev/null +++ b/docs/es/gm_subsurvey.md @@ -0,0 +1,41 @@ +# gm\_subsurvey + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../gm_subsurvey) [Spanish :es:](gm_subsurvey) + +**Tabla \`gm\_subsurvey\`** + +Esta tabla contiene las respuestas a las preguntas de la encuesta. Está vinculado a `gm_survey`. + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ------------------ | ---- | ---------- | --- | ---- | ------- | -------------- | ------- | +| [surveyId][1] | INT | UNSIGNED | PRI | NO | | Auto increment | | +| [questionId][2] | INT | UNSIGNED | PRI | NO | 0 | | | +| [answer][3] | INT | UNSIGNED | | NO | 0 | | | +| [answerComment][4] | TEXT | SIGNED | | NO | | | | + +[1]: #surveyid +[2]: #questionid +[3]: #answer +[4]: #answercomment + +**Descripción de los campos** + +### surveyId + +`campo-sin-descripción|1` + +### questionId + +`campo-sin-descripción|2` + +### answer + +`campo-sin-descripción|3` + +### answerComment + +`campo-sin-descripción|4` diff --git a/docs/es/guild_bank_eventlog.md b/docs/es/guild_bank_eventlog.md new file mode 100644 index 0000000..ade5384 --- /dev/null +++ b/docs/es/guild_bank_eventlog.md @@ -0,0 +1,79 @@ +# guild\_bank\_eventlog + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../guild_bank_eventlog) [Spanish :es:](guild_bank_eventlog) + +**Tabla \`guild\_bank\_eventlog\`** + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ------------------- | -------- | ---------- | --- | ---- | ------- | ----- | ------------------------------------------- | +| [guildid][1] | INT | UNSIGNED | PRI | NO | 0 | | Guild Identificator | +| [LogGuid][2] | INT | UNSIGNED | PRI | NO | 0 | | Log record identificator - auxiliary column | +| [TabId][3] | TINYINT | UNSIGNED | PRI | NO | 0 | | Guild bank TabId | +| [EventType][4] | TINYINT | UNSIGNED | | NO | 0 | | Event type | +| [PlayerGuid][5] | INT | UNSIGNED | | NO | 0 | | | +| [ItemOrMoney][6] | INT | UNSIGNED | | NO | 0 | | | +| [ItemStackCount][7] | SMALLINT | UNSIGNED | | NO | 0 | | | +| [DestTabId][8] | TINYINT | UNSIGNED | | NO | 0 | | Destination Tab Id | +| [TimeStamp][9] | INT | UNSIGNED | | NO | 0 | | Event UNIX time | + +[1]: #guildid +[2]: #logguid +[3]: #tabid +[4]: #eventtype +[5]: #playerguid +[6]: #itemormoney +[7]: #itemstackcount +[8]: #desttabid +[9]: #timestamp + +**Descripción de los campos** + +### guildid + +Identificador de la hermandad. + +### LogGuid + +Identificación del registro de Log - columna auxiliar. + +### TabId + +TabId del banco de la hermandad. + +### EventType + +| Value | Description | +| ----- | --------------------------------- | +| 1 | GUILD\_BANK\_LOG\_DEPOSIT\_ITEM | +| 2 | GUILD\_BANK\_LOG\_WITHDRAW\_ITEM | +| 3 | GUILD\_BANK\_LOG\_MOVE\_ITEM | +| 4 | GUILD\_BANK\_LOG\_DEPOSIT\_MONEY | +| 5 | GUILD\_BANK\_LOG\_WITHDRAW\_MONEY | +| 6 | GUILD\_BANK\_LOG\_REPAIR\_MONEY | +| 7 | GUILD\_BANK\_LOG\_MOVE\_ITEM2 | +| 8 | GUILD\_BANK\_LOG\_UNK1 | +| 9 | GUILD\_BANK\_LOG\_BUY\_SLOT | + +### PlayerGuid + +GUID del personaje. + +### ItemOrMoney + +`campo-sin-descripción|6` + +### ItemStackCount + +`campo-sin-descripción|7` + +### DestTabId + +ID de la pestaña de destino. + +### TimeStamp + +Hora del envento en UNIX. diff --git a/docs/es/item_soulbound_trade_data.md b/docs/es/item_soulbound_trade_data.md new file mode 100644 index 0000000..4b0a2b7 --- /dev/null +++ b/docs/es/item_soulbound_trade_data.md @@ -0,0 +1,27 @@ +# item\_soulbound\_trade\_data + +[<-Volver a:Characters](database-characters.md) + +**Tabla \`item\_soulbound\_trade\_data** + +Esta tabla almacena información sobre qué jugadores pueden intercambiar artículos ligados al alma entre ellos. + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ------------------ | ---- | ---------- | --- | ---- | ------- | ------ | ----------------------------------------------------------------------- | +| [itemGuid][1] | INT | UNSIGNED | PRI | NO | | | Item GUID | +| [alowedPlayers][2] | TEXT | SIGNED | | NO | | | Space separated GUID list of players who can receive this item in trade | + +[1]: #itemguid +[2]: #alowedplayers + +**Descripción de los campos** + +### itemGuid + +El GUID del artículo que se puede comercializar. Consulte [item\_instance.guid](item_instance#guid). + +### alowedPlayers + +GUID de jugadores elegibles para el intercambio separados por espacio. Consulte [characters.guid](characters#guid). diff --git a/docs/es/lfg_data.md b/docs/es/lfg_data.md new file mode 100644 index 0000000..f7610e4 --- /dev/null +++ b/docs/es/lfg_data.md @@ -0,0 +1,33 @@ +# lfg\_data + +[<-Volver a:Characters](database-characters.md) + +**Tabla \`lfg\_data\`** + +Esta tabla contiene datos guardados para LFG. Esta tabla está constantemente en uso por parte del núcleo. + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ------------ | ------- | ---------- | --- | ---- | ------- | ----- | ------------------------ | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier | +| [dungeon][2] | INT | UNSIGNED | | NO | 0 | | | +| [state][3] | TINYINT | UNSIGNED | | NO | 0 | | | + +[1]: #guid +[2]: #dungeon +[3]: #state + +**Descripción de los campos** + +### guid + +La guid para este grupo. + +### dungeon + +El ID de la mazmorra de dbc. + +### state + +El estado de este grupo/mazmorra. diff --git a/docs/es/log_arena_memberstats.md b/docs/es/log_arena_memberstats.md new file mode 100644 index 0000000..c5b0da6 --- /dev/null +++ b/docs/es/log_arena_memberstats.md @@ -0,0 +1,75 @@ +# log\_arena\_memberstats + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../log_arena_memberstats) [Spanish :es:](log_arena_memberstats) + +**Tabla \`log\_arena\_memberstats\`** + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| -------------- | -------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [fight_id][1] | INT | UNSIGNED | PRI | NO | | | | +| [member_id][2] | TINYINT | UNSIGNED | PRI | NO | | | | +| [name][3] | CHAR(20) | SIGNED | | NO | | | | +| [guid][4] | INT | UNSIGNED | | NO | | | | +| [team][5] | INT | UNSIGNED | | NO | | | | +| [account][6] | INT | UNSIGNED | | NO | | | | +| [ip][7] | CHAR(15) | SIGNED | | NO | | | | +| [damage][8] | INT | UNSIGNED | | NO | | | | +| [heal][9] | INT | UNSIGNED | | NO | | | | +| [kblows][10] | INT | UNSIGNED | | NO | | | | + +[1]: #fightid +[2]: #memberid +[3]: #name +[4]: #guid +[5]: #team +[6]: #account +[7]: #ip +[8]: #damage +[9]: #heal +[10]: #kblows + +**Descripción de los campos** + +### fight\_id + +`campo-sin-descripción|1` + +### member\_id + +`campo-sin-descripción|2` + +### name + +`campo-sin-descripción|3` + +### guid + +`campo-sin-descripción|4` + +### team + +`campo-sin-descripción|5` + +### account + +`campo-sin-descripción|6` + +### ip + +`campo-sin-descripción|7` + +### damage + +`campo-sin-descripción|8` + +### heal + +`campo-sin-descripción|9` + +### kblows + +`campo-sin-descripción|10` diff --git a/docs/es/log_encounter.md b/docs/es/log_encounter.md new file mode 100644 index 0000000..12b9c5d --- /dev/null +++ b/docs/es/log_encounter.md @@ -0,0 +1,51 @@ +# log\_encounter + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../log_encounter) [Spanish :es:](log_encounter) + +**Tabla \`log\_encounter\`** + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ---------------- | -------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [time][1] | DATATIME | SIGNED | | NO | | | | +| [map][2] | SMALLINT | UNSIGNED | | NO | | | | +| [difficulty][3] | TINYINT | UNSIGNED | | NO | | | | +| [creditType][4] | TINYINT | UNSIGNED | | NO | | | | +| [creditEntry][5] | INT | UNSIGNED | | NO | | | | +| [playersInfo][6] | TEXT | SIGNED | | NO | | | | + +[1]: #time +[2]: #map +[3]: #difficulty +[4]: #credittype +[5]: #creditentry +[6]: #playersinfo + +**Descripción de los campos** + +### time + +`campo-sin-descripción|1` + +### map + +`campo-sin-descripción|2` + +### difficulty + +`campo-sin-descripción|3` + +### creditType + +`campo-sin-descripción|4` + +### creditEntry + +`campo-sin-descripción|5` + +### playersInfo + +`campo-sin-descripción|6` diff --git a/docs/es/log_money.md b/docs/es/log_money.md new file mode 100644 index 0000000..4379255 --- /dev/null +++ b/docs/es/log_money.md @@ -0,0 +1,69 @@ +# log\_money + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../log_money) [Spanish :es:](log_money) + +**Tabla \`log\_money\`** + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ------------------ | -------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [sender_acc][1] | INT | UNSIGNED | | NO | | | | +| [sender_guid][2] | INT | UNSIGNED | | NO | | | | +| [sender_name][3] | CHAR(32) | SIGNED | | NO | | | | +| [sender_ip][4] | CHAR(32) | SIGNED | | NO | | | | +| [receiver_acc][5] | INT | UNSIGNED | | NO | | | | +| [receiver_name][6] | CHAR(32) | SIGNED | | NO | | | | +| [money][7] | BIGINT | UNSIGNED | | NO | | | | +| [topic][8] | CHAR(255)| SIGNED | | NO | | | | +| [date][9] | DATETIME | SIGNED | | NO | | | | + +[1]: #senderacc +[2]: #senderguid +[3]: #sendername +[4]: #senderip +[5]: #receiveracc +[6]: #receivername +[7]: #money +[8]: #topic +[9]: #date + +**Descripción de los campos** + +### sender\_acc + +`campo-sin-descripción|1` + +### sender\_guid + +`campo-sin-descripción|2` + +### sender\_name + +`campo-sin-descripción|3` + +### sender\_ip + +`campo-sin-descripción|4` + +### receiver\_acc + +`campo-sin-descripción|5` + +### receiver\_name + +`campo-sin-descripción|6` + +### money + +`campo-sin-descripción|7` + +### topic + +`campo-sin-descripción|8` + +### date + +`campo-sin-descripción|9` diff --git a/docs/es/mail.md b/docs/es/mail.md new file mode 100644 index 0000000..e4fe762 --- /dev/null +++ b/docs/es/mail.md @@ -0,0 +1,134 @@ +# mail + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../mail) [Spanish :es:](mail) + +**Tabla \`mail\`** + +Esta tabla contiene datos principales sobre todos los correos del juego. + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ------------------- | -------- | ---------- | --- | ---- | ------- | ----- | ---------------------------------- | +| [id][1] | INT | UNSIGNED | PRI | NO | 0 | | Identifier | +| [messageType][2] | TINYINT | UNSIGNED | | NO | 0 | | | +| [stationery][3] | TINYINT | UNSIGNED | | NO | 41 | | | +| [mailTemplateId][4] | SMALLINT | UNSIGNED | | NO | 0 | | | +| [sender][5] | INT | UNSIGNED | | NO | 0 | | Character Global Unique Identifier | +| [receiver][6] | INT | UNSIGNED | | NO | 0 | | Character Global Unique Identifier | +| [subject][7] | LONGTEXT | SIGNED | | YES | | | | +| [body][8] | LONGTEXT | SIGNED | | YES | | | | +| [has_items][9] | TINYINT | UNSIGNED | | NO | 0 | | | +| [expire_time][10] | INT | UNSIGNED | | NO | 0 | | | +| [deliver_time][11] | INT | UNSIGNED | | NO | 0 | | | +| [money][12] | INT | UNSIGNED | | NO | 0 | | | +| [cod][13] | INT | UNSIGNED | | NO | 0 | | | +| [checked][14] | TINYINT | UNSIGNED | | NO | 0 | | | +| [auctionId][14] | INT | UNSIGNED | | NO | 0 | | | + +[1]: #id +[2]: #messagetype +[3]: #stationery +[4]: #mailtemplateid +[5]: #sender +[6]: #receiver +[7]: #subject +[8]: #body +[9]: #hasitems +[10]: #expiretime +[11]: #delivertime +[12]: #money +[13]: #cod +[14]: #checked +[15]: #auctionid + +**Descripción de los campos** + +### id + +Este campo contiene una ID único de cualquier mensaje. + +¡No tengas autoincremento! + +### messageType + +- 0 = Normal +- 1 = doesn't exist +- 2 = Auction +- 3 = Creature +- 4 = Gameobject +- 5 = Item + +### stationery + +Este campo puede contener estos valores: + +- 1 = Test +- 41 = Normal mail layout +- 61 = GM (Blizzard) +- 62 = Auction +- 64 = VAL (???) +- 65 = CHR (???) + +### mailTemplateId + +Id de MailTemplate.dbc + +### sender + +En este campo se contiene el remitente [character.guid](character#guid). + +### receiver + +Aquí está el [character.guid](character#guid) del receptor. + +### subject + +Aquí está el asunto del correo almacenado. + +### body + +El texto contenido en el correo. La longitud máxima es de 8000 caracteres. + +### has_items + +Predeterminado: 0, + +Cuando se establece en 1, ese correo puede contener elementos. + +Para ver los elementos, consulte la tabla [mail\_items](mail_items). + +### expire\_time + +Aquí hay una marca de tiempo que almacena la fecha para el correo de retorno automático al remitente. + +### deliver\_time + +Aquí hay una marca de tiempo que almacena la fecha de envío del correo. + +### money + +La cantidad de dinero en el correo, o dinero para pagar cuando es contra reembolso. + +### cod + +Predeterminado: 0 - Sin COD, + +cuando se establece en 1, ese campo \`money\` almacena oro para contra reembolso. + +### checked + +| Flag | Comment | +| ---- | --------------------------- | +| 0 | MAIL_CHECK_MASK_NONE | +| 1 | MAIL_CHECK_MASK_READ | +| 2 | MAIL_CHECK_MASK_RETURNED | +| 4 | MAIL_CHECK_MASK_COPIED | +| 8 | MAIL_CHECK_MASK_COD_PAYMENT | +| 16 | MAIL_CHECK_MASK_HAS_BODY | + +### auctionId + +`campo-sin-descripción|14` diff --git a/docs/es/mail_items.md b/docs/es/mail_items.md new file mode 100644 index 0000000..e7c790a --- /dev/null +++ b/docs/es/mail_items.md @@ -0,0 +1,35 @@ +# mail\_items + +[<-Volver a:Characters](database-character.md) + +Leer en: [English :gb:](../mail_items) [Spanish :es:](mail_items) + +**Tabla \`mail\_items\`** + +Esta tabla contiene datos sobre los elementos de item\_instance que se envían por correo electrónico. + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| -------------- | ---- | ---------- | --- | ---- | ------- | ----- | ---------------------------------- | +| [mail_id][1] | INT | UNSIGNED | | NO | 0 | | | +| [item_guid][2] | INT | UNSIGNED | PRI | NO | 0 | | | +| [receiver][3] | INT | UNSIGNED | | NO | 0 | | Character Global Unique Identifier | + +[1]: #mailid +[2]: #itemguid +[3]: #receiver + +**Descripción de los campos** + +### mail\_id + +ID de correo al que está adjunto el artículo. + +### item\_guid + +Esta es la guid del elemento de [item\_instance.guid](item_instance#guid). + +### receiver + +Character guid que debería recibir este artículo. diff --git a/docs/es/pet_aura.md b/docs/es/pet_aura.md new file mode 100644 index 0000000..cceaa69 --- /dev/null +++ b/docs/es/pet_aura.md @@ -0,0 +1,89 @@ +# pet\_aura + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../pet_aura) [Spanish :es:](pet_aura) + +**Tabla \`pet\_aura\`** + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| -------------------- | --------- | ---------- | --- | ---- | ------- | ----- | ----------------------------- | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier | +| [casterGuid][2] | BIGINT | UNSIGNED | PRI | NO | 0 | | Full Global Unique Identifier | +| [spell][3] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | | +| [effectMask][4] | TINYINT | UNSIGNED | PRI | NO | 0 | | | +| [recalculateMask][5] | TINYINT | UNSIGNED | | NO | 0 | | | +| [stackCount][6] | TINYINT | UNSIGNED | | NO | 1 | | | +| [amount0][7] | MEDIUMINT | SIGNED | | NO | | | | +| [amount1][8] | MEDIUMINT | SIGNED | | NO | | | | +| [amount2][9] | MEDIUMINT | SIGNED | | NO | | | | +| [base_amount0][10] | MEDIUMINT | SIGNED | | NO | | | | +| [base_amount1][11] | MEDIUMINT | SIGNED | | NO | | | | +| [base_amount2][12] | MEDIUMINT | SIGNED | | NO | | | | +| [maxDuration][13] | INT | SIGNED | | NO | 0 | | | +| [remainTime][14] | INT | SIGNED | | NO | 0 | | | +| [remainCharges][15] | TINYINT | UNSIGNED | | NO | 0 | | | + +[1]: #guid +[2]: #casterguid +[3]: #spell +[4]: #effectmask +[5]: #recalculatemask +[6]: #stackcount +[7]: #amount +[8]: #amount +[9]: #amount +[10]: #baseamount +[11]: #baseamount +[12]: #baseamount +[13]: #maxduration +[14]: #remaintime +[15]: #remaincharges + +**Descripción de los campos** + +### guid + +El GUID del objetivo afectado por el aura. Ver [character\_pet.id](character_pet#id). + +### casterGuid + +El GUID del jugador que lanzó el aura. Ver [characters.guid](characters#guid). + +### spell + +El hechizo desde el que se aplicó el aura. Ver [Spell.dbc](spell) columna 1. + +### effectMask + +El índice de efecto del hechizo del que proviene el aura. Un hechizo tiene hasta tres efectos, siendo el índice 0, 1 o 2. + +### recalculateMask + +`campo-sin-descripción|5` + +### stackCount + +Determina cuántas acumulaciones del hechizo tiene el personaje. + +### amount + +El valor del modificador asociado con el aura. + +### base\_amount + +`campo-sin-descripción|10-12` + +### maxDuration + +La duración máxima del aura. + +### remainTime + +El tiempo restante en segundos en el aura. -1 significa que el aura es indefinida. + +### remainCharges + +El número de cargas que quedan en el aura. diff --git a/docs/es/pet_spell.md b/docs/es/pet_spell.md new file mode 100644 index 0000000..63443cb --- /dev/null +++ b/docs/es/pet_spell.md @@ -0,0 +1,35 @@ +# pet\_spell + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../pet_spell) [Spanish :es:](pet_spell) + +**Tabla \`pet\_spell\`** + +Esta tabla contiene información sobre hechizos de mascotas individuales. + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ----------- | --------- | ---------- | --- | ---- | ------- | ----- | ------------------------ | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier | +| [spell][2] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | Spell Identifier | +| [active][3] | TINYINT | UNSIGNED | | NO | 0 | | | + +[1]: #guid +[2]: #spell +[3]: #active + +**Descripción de los campos** + +### guid + +GUID de la mascota. Ver [character\_pet.id](character_pet#id). + +### spell + +ID del hechizo. Ver [Spell.dbc](spell) columna 1. + +### active + +Boolean 0 o 1 que controla si el hechizo está activo o no. diff --git a/docs/es/pet_spell_cooldown.md b/docs/es/pet_spell_cooldown.md new file mode 100644 index 0000000..74fcbc3 --- /dev/null +++ b/docs/es/pet_spell_cooldown.md @@ -0,0 +1,35 @@ +# pet\_spell\_cooldown + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../pet_spell_cooldown) [Spanish :es:](pet_spell_cooldown) + +**Tabla \`pet\_spell\_cooldown\`** + +Esta tabla contiene información sobre los tiempos de reutilización de hechizos de las mascotas. + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ---------- | --------- | ---------- | --- | ---- | ------- | ----- | ---------------------------------- | +| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier, Low part | +| [spell][2] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | Spell Identifier | +| [time][3] | INT | UNSIGNED | | NO | 0 | | | + +[1]: #guid +[2]: #spell +[3]: #time + +**Descripción de los campos** + +### guid + +El GUID de la mascota. Ver [character\_pet.id](character_pet#id). + +### spell + +El ID del hechizo al que se aplica el tiempo de reutilización. Ver [Spell.dbc](spell) columna 1. + +### time + +El momento en que expira el tiempo de reutilización, en tiempo Unix. diff --git a/docs/es/petition.md b/docs/es/petition.md new file mode 100644 index 0000000..f5018c0 --- /dev/null +++ b/docs/es/petition.md @@ -0,0 +1,48 @@ +# petition + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../petition) [Spanish :es:](petition) + +**Tabla \`petition\`** + +Esta tabla contiene información sobre todas las peticiones en curso para un hermandad o un equipo de arena. + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ----------------- | ----------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [ownerguid][1] | INT | UNSIGNED | PRI | NO | | | | +| [petitionguid][2] | INT | UNSIGNED | | YES | 0 | | | +| [name][3] | VARCHAR(24) | SIGNED | | NO | | | | +| [type][4] | TINYINT | UNSIGNED | PRI | NO | 0 | | | + +[1]: #ownerguid +[2]: #petitionguid +[3]: #name +[4]: #type + +**Descripción de los campos** + +### ownerguid + +GUID del propietario de la petición. Ver [characters.guid](characters#guid). + +### petitionguid + +El GUID del elemento de la petición. Ver [item\_instance.guid](item_instance#guid). + +### name + +El nombre del hermandad o equipo de arena para el que el jugador intenta solicitar las peticiones. + +### type + +El tipo de petición. + +| ID | Type | +|--- | ------------------ | +| 2 | 2vs2 Arena charter | +| 3 | 3vs3 Arena charter | +| 5 | 5vs5 Arena charter | +| 9 | Guild charter | diff --git a/docs/es/petition_sign.md b/docs/es/petition_sign.md new file mode 100644 index 0000000..941b9f2 --- /dev/null +++ b/docs/es/petition_sign.md @@ -0,0 +1,54 @@ +# petition\_sign + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../petition_sign) [Spanish :es:](petition_sign) + +**Tabla \`petition\_sign\`** + +Esta tabla contiene información sobre todas las firmas de una petición para un hermandad o un equipo de arena. + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ------------------- | ------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [ownerguid][1] | INT | UNSIGNED | | NO | | | | +| [petitionguid][2] | INT | UNSIGNED | PRI | NO | 0 | | | +| [playerguid][3] | INT | UNSIGNED | PRI | NO | 0 | | | +| [player_account][4] | INT | UNSIGNED | | NO | 0 | | | +| [type][5] | TINYINT | UNSIGNED | | NO | 0 | | | + +[1]: #ownerguid +[2]: #petitionguid +[3]: #playerguid +[4]: #playeraccount +[5]: #type + +**Descripción de los campos** + +### ownerguid + +El GUID del propietario que intenta formar parte del equipo del hermandad/arena. Ver [characters.guid](characters#guid). + +### petitionguid + +El GUID del artículo de la carta. Ver [item\_template.guid](item_template#guid). + +### playerguid + +El GUID del jugador que ha firmado la carta. Ver [characters.guid](characters#guid). + +### player\_account + +El ID de cuenta del jugador que ha firmado la carta. No hay dos jugadores que puedan firmar la misma carta desde la misma cuenta. + +### type + +El tipo de petición. + +| ID | Type | +|--- | ------------------ | +| 2 | 2vs2 Arena charter | +| 3 | 3vs3 Arena charter | +| 5 | 5vs5 Arena charter | +| 9 | Guild charter | diff --git a/docs/es/pool_quest_save.md b/docs/es/pool_quest_save.md new file mode 100644 index 0000000..8c916eb --- /dev/null +++ b/docs/es/pool_quest_save.md @@ -0,0 +1,27 @@ +# pool\_quest\_save + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../pool_quest_save) [Spanish :es:](pool_quest_save) + +**Tabla \`pool\_quest\_save\`** + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ------------- | ---- | ---------- | --- | ---- | ------- | ----- | ------- | +| [pool_id][1] | INT | UNSIGNED | PRI | NO | 0 | | | +| [quest_id][2] | INT | UNSIGNED | PRI | NO | 0 | | | + +[1]: #poolid +[2]: #questid + +**Descripción de los campos** + +### pool\_id + +[pool\_quest.entry](pool_quest#entry). + +### quest\_id + +[quest\_template.id](quest_template#id). diff --git a/docs/es/pvpstats_players.md b/docs/es/pvpstats_players.md new file mode 100644 index 0000000..ae790ed --- /dev/null +++ b/docs/es/pvpstats_players.md @@ -0,0 +1,65 @@ +# pvpstats\_players + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../pvpstats_players) [Spanish :es:](pvpstats_players) + +**Tabla \`pvpstats\_players\`** + +Esta tabla contiene datos sobre las puntuaciones de BattleGrounds. Para habilitar el almacenamiento de este tipo de información, configure **Battleground.StoreStatistics.Enable = 1** en el archivo **worldserver.config.dist**. + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| -------------------------- | --------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [battleground_id][1] | BIGINT | UNSIGNED | PRI | NO | | | | +| [character_guid][2] | INT | UNSIGNED | PRI | NO | | | | +| [winner][3] | BIT | SIGNED | | NO | | | | +| [score_killing_blows][4] | MEDIUMINT | UNSIGNED | | NO | | | | +| [score_deaths][5] | MEDIUMINT | UNSIGNED | | NO | | | | +| [score_honorable_kills][6] | MEDIUMINT | UNSIGNED | | NO | | | | +| [score_bonus_honor][7] | MEDIUMINT | UNSIGNED | | NO | | | | +| [score_damage_done][8] | MEDIUMINT | UNSIGNED | | NO | | | | +| [score_healing_done][9] | MEDIUMINT | UNSIGNED | | NO | | | | +| [attr_1][10] | MEDIUMINT | UNSIGNED | | NO | 0 | | | +| [attr_2][11] | MEDIUMINT | UNSIGNED | | NO | 0 | | | +| [attr_3][12] | MEDIUMINT | UNSIGNED | | NO | 0 | | | +| [attr_4][13] | MEDIUMINT | UNSIGNED | | NO | 0 | | | +| [attr_5][14] | MEDIUMINT | UNSIGNED | | NO | 0 | | | + +[1]: #battlegroundid +[2]: #characterguid +[3]: #winner +[4]: #score +[5]: #score +[6]: #score +[7]: #score +[8]: #score +[9]: #score +[10]: #attr +[11]: #attr +[12]: #attr +[13]: #attr +[14]: #attr + +**Descripción de los campos** + +### battleground\_id + +Enlace a [pvpstats\_battlegrounds.id](pvpstats_battlegrounds#id). + +### character\_guid + +Enlace a [characters.guid](characters#guid). + +### winner + +1 cuando el jugador ha ganado el BG, 0 en caso contrario. + +### score\_\* + +Todas las puntuaciones que son comunes entre todos los Campos de Batalla. + +### attr\_\* + +Todos los puntajes que no son comunes entre todos los Campos de Batalla. Este campo cambia su media de acuerdo con [pvpstats\_battlegrounds.type](pvpstats_battlegrounds#type). diff --git a/docs/es/quest_tracker.md b/docs/es/quest_tracker.md new file mode 100644 index 0000000..b107567 --- /dev/null +++ b/docs/es/quest_tracker.md @@ -0,0 +1,63 @@ +# quest\_tracker + +[<-Volver a:Character](database-character.md) + +Leer en: [English :gb:](../quest_tracker) [Spanish :es:](quest_tracker) + +**Tabla \`quest\_tracker\`** + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ----------------------- | ------------ | ---------- | --- | ---- | ------- | ----- | ------- | +|[id][1] | MEDIUMINT | UNSIGNED | | NO | 0 | | | +|[character_guid][2] | INT | UNSIGNED | | NO | 0 | | | +|[quest_accept_time][3] | DATETIME | SIGNED | | NO | | | | +|[quest_complete_time][4] | DATETIME | SIGNED | | YES | | | | +|[quest_abandon_time][5] | DATETIME | SIGNED | | YES | | | | +|[completed_by_gm][6] | TINYINT | SIGNED | | NO | 0 | | | +|[core_hash][7] | VARCHAR(120) | SIGNED | | NO | 0 | | | +|[core_revision][8] | VARCHAR(120) | SIGNED | | NO | 0 | | | + +[1]: #id +[2]: #characterguid +[3]: #questaccepttime +[4]: #questcompletetime +[5]: #questabandontime +[6]: #completedbygm +[7]: #corehash +[8]: #corerevision + +**Descripción de los campos** + +### id + +`campo-sin-descripción|1` + +### character\_guid + +Ver [characters.guid](characters#guid). + +### quest\_accept\_time + +Cuando la misión fue aceptada. + +### quest\_complete\_time + +Cuando se completó la misión. + +### quest\_abandon\_time + +Cuando la misión fue abandonada. + +### completed\_by\_gm + +`campo-sin-descripción|6` + +### core\_hash + +`campo-sin-descripción|7` + +### core\_revision + +`campo-sin-descripción|8` diff --git a/docs/es/recovery_item.md b/docs/es/recovery_item.md new file mode 100644 index 0000000..adae262 --- /dev/null +++ b/docs/es/recovery_item.md @@ -0,0 +1,41 @@ +# recovery\_item + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../recovery_item) [Spanish :es:](recovery_item) + +**Tabla \`recovery\_item\`** + +Esta tabla contiene información sobre la clasificación de emparejamiento de personajes en todos los tipos de equipos. + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| -------------- | --------- | ---------- | --- | ---- | ------- | -------------- | ------- | +| [Id][1] | INT | UNSIGNED | PRI | NO | | AUTO_INCREMENT | | +| [Guid][2] | INT | UNSIGNED | | NO | 0 | | | +| [ItemEntry][3] | MEDIUMINT | UNSIGNED | | NO | 0 | | | +| [Count][4] | INT | UNSIGNED | | NO | 0 | | | + +[1]: #id +[2]: #guid +[3]: #itementry +[4]: #count + +**Descripción de los campos** + +### Id + +`campo-sin-descripción|1` + +### Guid + +`campo-sin-descripción|2` + +### ItemEntry + +Ver [item_template.entry](item_template#entry). + +### Count + +La cantidad de artículos. diff --git a/docs/es/reserved_name.md b/docs/es/reserved_name.md new file mode 100644 index 0000000..63e99ba --- /dev/null +++ b/docs/es/reserved_name.md @@ -0,0 +1,21 @@ +# reserved\_name + +[<-Volver a:Characters](database-characters.md) + +Leer en: [English :gb:](../reserved_name) [Spanish :es:](reserved_name) + +**Tabla \`reserved\_name\`** + +**Estructura** + +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| --------- | ----------- | ---------- | --- | ---- | ------- | ----- | ------- | +| [name][1] | VARCHAR(12) | SIGNED | PRI | NO | '' | | | + +[1]: #name + +**Descripción de los campos** + +### name + +`campo-sin-descripción|1` diff --git a/docs/es/version_db_auth.md b/docs/es/version_db_auth.md index 348470b..7598124 100644 --- a/docs/es/version_db_auth.md +++ b/docs/es/version_db_auth.md @@ -36,4 +36,4