Npc text
La tabla `npc_text`
Contiene todos los textos de los menús de gossip de las criaturas. Estos datos están sacados del servidor oficial,
por lo que no hay que preocuparse de las posiciones en las distintas celdas.
Estructura
| Field | Type | Atributes | Key | NULL | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| ID | mediumint(8) | unsigned | PRI | NO | 0 | ||
| text0_0 | longtext | signed | YES | NULL | |||
| text0_1 | longtext | signed | YES | NULL | |||
| lang0 | tinyint(3) | unsigned | NO | 0 | |||
| prob0 | float | signed | NO | 0 | |||
| em0_0 | smallint(5) | unsigned | NO | 0 | |||
| em0_1 | smallint(5) | unsigned | NO | 0 | |||
| em0_2 | smallint(5) | unsigned | NO | 0 | |||
| em0_3 | smallint(5) | unsigned | NO | 0 | |||
| em0_4 | smallint(5) | unsigned | NO | 0 | |||
| em0_5 | smallint(5) | unsigned | NO | 0 | |||
| text1_0 | longtext | signed | YES | NULL | |||
| text1_1 | longtext | signed | YES | NULL | |||
| lang1 | tinyint(3) | unsigned | NO | 0 | |||
| prob1 | float | signed | NO | 0 | |||
| em1_0 | smallint(5) | unsigned | NO | 0 | |||
| em1_1 | smallint(5) | unsigned | NO | 0 | |||
| em1_2 | smallint(5) | unsigned | NO | 0 | |||
| em1_3 | smallint(5) | unsigned | NO | 0 | |||
| em1_4 | smallint(5) | unsigned | NO | 0 | |||
| em1_5 | smallint(5) | unsigned | NO | 0 | |||
| text2_0 | longtext | signed | YES | NULL | |||
| text2_1 | longtext | signed | YES | NULL | |||
| lang2 | tinyint(3) | unsigned | NO 0 | ||||
| prob2 | float | signed | NO | 0 | |||
| em2_0 | smallint(5) | unsigned | NO | 0 | |||
| em2_1 | smallint(5) | unsigned | NO | 0 | |||
| em2_2 | smallint(5) | unsigned | NO | 0 | |||
| em2_3 | smallint(5) | unsigned | NO | 0 | |||
| em2_4 | smallint(5) | unsigned | NO | 0 | |||
| em2_5 | smallint(5) | unsigned | NO | 0 | |||
| text3_0 | longtext | signed | YES | NULL | |||
| text3_1 | longtext | signed | YES | NULL | |||
| lang3 | tinyint(3) | unsigned | NO | 0 | |||
| prob3 | float | signed | NO | 0 | |||
| em3_0 | smallint(5) | unsigned | NO | 0 | |||
| em3_1 smallint(5) | unsigned | NO | 0 | ||||
| em3_2 | smallint(5) | unsigned | NO | 0 | |||
| em3_3 | smallint(5) | unsigned | NO | 0 | |||
| em3_4 | smallint(5) | unsigned | NO | 0 | |||
| em3_5 | smallint(5) | unsigned | NO | 0 | |||
| text4_0 | longtext | signed | YES | NULL | |||
| text4_1 | longtext | signed | YES | NULL | |||
| lang4 | tinyint(3) | unsigned | NO | 0 | |||
| prob4 | float | signed | NO | 0 | |||
| em4_0 | smallint(5) | unsigned | NO | 0 | |||
| em4_1 | smallint(5) | unsigned | NO | 0 | |||
| em4_2 | smallint(5) | unsigned | NO | 0 | |||
| em4_3 | smallint(5) | unsigned | NO | 0 | |||
| em4_4 | smallint(5) | unsigned | NO | 0 | |||
| em4_5 | smallint(5) | unsigned | NO | 0 | |||
| text5_0 | longtext | signed | YES | NULL | |||
| text5_1 | longtext | signed | YES | NULL | |||
| lang5 | tinyint(3) | unsigned | NO | 0 | |||
| prob5 | float | signed | NO | 0 | |||
| em5_0 | smallint(5) | unsigned | NO | 0 | |||
| em5_1 | smallint(5) | unsigned | NO | 0 | |||
| em5_2 | smallint(5) | unsigned | NO | 0 | |||
| em5_3 | smallint(5) | unsigned | NO | 0 | |||
| em5_4 | smallint(5) | unsigned | NO | 0 | |||
| em5_5 | smallint(5) | unsigned | NO | 0 | |||
| text6_0 | longtext | signed | YES | NULL | |||
| text6_1 | longtext | signed | YES | NULL | |||
| lang6 | tinyint(3) | unsigned | NO | 0 | |||
| prob6 | float | signed | NO | 0 | |||
| em6_0 | smallint(5) | unsigned | NO | 0 | |||
| em6_1 | smallint(5) | unsigned | NO | 0 | |||
| em6_2 | smallint(5) | unsigned | NO | 0 | |||
| em6_3 | smallint(5) | unsigned | NO | 0 | |||
| em6_4 | smallint(5) | unsigned | NO | 0 | |||
| em6_5 | smallint(5) | unsigned | NO | 0 | |||
| text7_0 | longtext | signed | YES | NULL | |||
| text7_1 | longtext | signed | YES | NULL | |||
| lang7 | tinyint(3) | unsigned | NO | 0 | |||
| prob7 | float | signed | NO | 0 | |||
| em7_0 | smallint(5) | unsigned | NO | 0 | |||
| em7_1 | smallint(5) | unsigned | NO | 0 | |||
| em7_2 | smallint(5) | unsigned | NO | 0 | |||
| em7_3 | smallint(5) | unsigned | NO | 0 | |||
| em7_4 | smallint(5) | unsigned | NO | 0 | |||
| em7_5 | smallint(5) | unsigned | NO | 0 | |||
| WDBVerified | smallint(5) | signed | YES | 1 |
Descripción de los campos
ID
La ID del texto. Este valor viene del servidor oficial.
text0_0-7_0
En estos campos va el texto.
text0_1-7_1
En estos campos va el texto.
===lang0-7 El lenguaje en el que se mostrará el texto. Ver Languages.dbc.
prob0-7
La probabilidad de que ese texto sea elegido.
===em0_0 La emoción que hace la criatura al empezar el texto.
em0_1-7_1
La emoción que hace la criatura después de la 0.
em0_2-7_2
La emoción que hace la criatura después de la 1.
em0_3-7_3
La emoción que hace la criatura después de la 2.
em0_4-7_4
La emoción que hace la criatura después de la 3.
em0_5-7_5
La emoción que hace la criatura después de la 4.
WDBVerified
Usado por el equipo de TrinityCore para registar si los datos han sido comparados con el oficial. No nos interesa.