Estructura
Esta tabla contiene los textos que se usan para el gossip. Hay que investigar más sobre esta tabla.
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| ID | MEDIUMINT | UNSIGNED | PRI | NO | 0 | ||
| text0_0 | longtext | SIGNED | YES | NULL | |||
| text0_1 | longtext | SIGNED | YES | NULL | |||
| lang0 | TINYINT | UNSIGNED | NO | 0 | |||
| Probability0 | FLOAT | SIGNED | NO | 0 | |||
| em0_0 | SMALLINT | UNSIGNED | NO | 0 | |||
| em0_1 | SMALLINT | UNSIGNED | NO | 0 | |||
| em0_2 | SMALLINT | UNSIGNED | NO | 0 | |||
| em0_3 | SMALLINT | UNSIGNED | NO | 0 | |||
| em0_4 | SMALLINT | UNSIGNED | NO | 0 | |||
| em0_5 | SMALLINT | UNSIGNED | NO | 0 | |||
| text1_0 | longtext | SIGNED | YES | NULL | |||
| text1_1 | longtext | SIGNED | YES | NULL | |||
| lang1 | TINYINT | UNSIGNED | NO | 0 | |||
| Probability1 | FLOAT | SIGNED | NO | 0 | |||
| em1_0 | SMALLINT | UNSIGNED | NO | 0 | |||
| em1_1 | SMALLINT | UNSIGNED | NO | 0 | |||
| em1_2 | SMALLINT | UNSIGNED | NO | 0 | |||
| em1_3 | SMALLINT | UNSIGNED | NO | 0 | |||
| em1_4 | SMALLINT | UNSIGNED | NO | 0 | |||
| em1_5 | SMALLINT | UNSIGNED | NO | 0 | |||
| text2_0 | longtext | SIGNED | YES | NULL | |||
| text2_1 | longtext | SIGNED | YES | NULL | |||
| lang2 | TINYINT | UNSIGNED | NO | 0 | |||
| Probability2 | FLOAT | SIGNED | NO | 0 | |||
| em2_0 | SMALLINT | UNSIGNED | NO | 0 | |||
| em2_1 | SMALLINT | UNSIGNED | NO | 0 | |||
| em2_2 | SMALLINT | UNSIGNED | NO | 0 | |||
| em2_3 | SMALLINT | UNSIGNED | NO | 0 | |||
| em2_4 | SMALLINT | UNSIGNED | NO | 0 | |||
| em2_5 | SMALLINT | UNSIGNED | NO | 0 | |||
| text3_0 | longtext | SIGNED | YES | NULL | |||
| text3_1 | longtext | SIGNED | YES | NULL | |||
| lang3 | TINYINT | UNSIGNED | NO | 0 | |||
| Probability3 | FLOAT | SIGNED | NO | 0 | |||
| em3_0 | SMALLINT | UNSIGNED | NO | 0 | |||
| em3_1 | SMALLINT | UNSIGNED | NO | 0 | |||
| em3_2 | SMALLINT | UNSIGNED | NO | 0 | |||
| em3_3 | SMALLINT | UNSIGNED | NO | 0 | |||
| em3_4 | SMALLINT | UNSIGNED | NO | 0 | |||
| em3_5 | SMALLINT | UNSIGNED | NO | 0 | |||
| text4_0 | longtext | SIGNED | YES | NULL | |||
| text4_1 | longtext | SIGNED | YES | NULL | |||
| lang4 | TINYINT | UNSIGNED | NO | 0 | |||
| Probability4 | FLOAT | SIGNED | NO | 0 | |||
| em4_0 | SMALLINT | UNSIGNED | NO | 0 | |||
| em4_1 | SMALLINT | UNSIGNED | NO | 0 | |||
| em4_2 | SMALLINT | UNSIGNED | NO | 0 | |||
| em4_3 | SMALLINT | UNSIGNED | NO | 0 | |||
| em4_4 | SMALLINT | UNSIGNED | NO | 0 | |||
| em4_5 | SMALLINT | UNSIGNED | NO | 0 | |||
| text5_0 | longtext | SIGNED | YES | NULL | |||
| text5_1 | longtext | SIGNED | YES | NULL | |||
| lang5 | TINYINT | UNSIGNED | NO | 0 | |||
| Probability5 | FLOAT | SIGNED | NO | 0 | |||
| em5_0 | SMALLINT | UNSIGNED | NO | 0 | |||
| em5_1 | SMALLINT | UNSIGNED | NO | 0 | |||
| em5_2 | SMALLINT | UNSIGNED | NO | 0 | |||
| em5_3 | SMALLINT | UNSIGNED | NO | 0 | |||
| em5_4 | SMALLINT | UNSIGNED | NO | 0 | |||
| em5_5 | SMALLINT | UNSIGNED | NO | 0 | |||
| text6_0 | longtext | SIGNED | YES | NULL | |||
| text6_1 | longtext | SIGNED | YES | NULL | |||
| lang5 | TINYINT | UNSIGNED | NO | 0 | |||
| Probability6 | FLOAT | SIGNED | NO | 0 | |||
| em6_0 | SMALLINT | UNSIGNED | NO | 0 | |||
| em6_1 | SMALLINT | UNSIGNED | NO | 0 | |||
| em6_2 | SMALLINT | UNSIGNED | NO | 0 | |||
| em6_3 | SMALLINT | UNSIGNED | NO | 0 | |||
| em6_4 | SMALLINT | UNSIGNED | NO | 0 | |||
| em6_5 | SMALLINT | UNSIGNED | NO | 0 | |||
| text7_0 | longtext | SIGNED | YES | NULL | |||
| text7_1 | longtext | SIGNED | YES | NULL | |||
| lang7 | TINYINT | UNSIGNED | NO | 0 | |||
| Probability7 | FLOAT | SIGNED | NO | 0 | |||
| em7_0 | SMALLINT | UNSIGNED | NO | 0 | |||
| em7_1 | SMALLINT | UNSIGNED | NO | 0 | |||
| em7_2 | SMALLINT | UNSIGNED | NO | 0 | |||
| em7_3 | SMALLINT | UNSIGNED | NO | 0 | |||
| em7_4 | SMALLINT | UNSIGNED | NO | 0 | |||
| em7_5 | SMALLINT | UNSIGNED | NO | 0 | |||
| VerifiedBuild | SMALLINT | SIGNED | YES | 1 |
Descripción de los campos
Este es el ID de la entrada de texto.
Este es el texto localizado que se muestra si el NPC es masculino.
Este es el texto localizado que se muestra si el NPC es femenino.
El valor del campo `broadcast_text`.`ID` para el `MaleText` en la tabla `broadcast_text`.
El idioma del texto en el juego. Consulta esta página para los IDs de idioma disponibles. Si se pone a 0, entonces no requiere conocer ningún idioma específico.
La probabilidad de que el NPC diga text0_0 o text0_1 según el género del NPC.
El ID del emote que el NPC debe hacer al mostrar el texto. Los emotes se reproducen uno tras otro en orden. Para ver una lista de emotes, consulta Emotes.DBC
Este campo se usaba para determinar si una plantilla ha sido verificada a partir de archivos WDB.
Si el valor es 0, entonces aún no ha sido parseada.
Si el valor es mayor que 0, entonces ha sido parseada con archivos WDB de esa build de cliente específica.
Si el valor es -1, entonces es solo un marcador de posición hasta que se encuentren datos adecuados en los WDB.