diff options
| author | Julio A. Leyva Osorio <tony931023@gmail.com> | 2022-01-13 09:06:27 -0500 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-01-13 15:06:27 +0100 |
| commit | a9d7681ed9b7ef7580d8ece93caae3507a298524 (patch) | |
| tree | 9bb33dde9bb765f0ba792e949f467288f1c51f54 /docs/es/mail.md | |
| parent | dc17689bcef62e18dd1ce9dd64d316d604cf8ac6 (diff) | |
| download | wiki-a9d7681ed9b7ef7580d8ece93caae3507a298524.tar.gz wiki-a9d7681ed9b7ef7580d8ece93caae3507a298524.tar.bz2 wiki-a9d7681ed9b7ef7580d8ece93caae3507a298524.zip | |
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>
Diffstat (limited to 'docs/es/mail.md')
| -rw-r--r-- | docs/es/mail.md | 134 |
1 files changed, 134 insertions, 0 deletions
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` |
