Npc text

Материал из YTDB DataBase

(Различия между версиями)
Перейти к: навигация, поиск
 
(4 промежуточные версии не показаны)
Строка 2: Строка 2:
| __TOC__
| __TOC__
|}
|}
 +
[[Category: Mangos world database tables]]
К описанию таблиц [[mangosdb_struct|базы данных mangos]].
К описанию таблиц [[mangosdb_struct|базы данных mangos]].
Строка 36: Строка 37:
|
|
|-
|-
-
|[[#textA_B|text0_1]]
+
|[[#textA_C|text0_1]]
|longtext
|longtext
|
|
Строка 101: Строка 102:
|-
|-
|[[#emA_B|em0_5]]
|[[#emA_B|em0_5]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 107: Строка 109:
|
|
|-
|-
-
|[[#text1_0|text1_0]]
+
|[[#textA_B|text1_0]]
|longtext
|longtext
-
|YES
+
|
 +
|
|
|
|
|
|
|
|-
|-
-
|[[#text1_1|text1_1]]
+
|[[#textA_C|text1_1]]
|longtext
|longtext
-
|YES
+
|
 +
|
|
|
|
|
Строка 122: Строка 126:
|-
|-
|[[#lang|lang1]]
|[[#lang|lang1]]
-
|tinyint(3) unsigned
+
|tinyint(3)
 +
|unsigned
|NO
|NO
|
|
Строка 130: Строка 135:
|[[#prob|prob1]]
|[[#prob|prob1]]
|float
|float
 +
|
|NO
|NO
|
|
Строка 136: Строка 142:
|-
|-
|[[#emA_B|em1_0]]
|[[#emA_B|em1_0]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 143: Строка 150:
|-
|-
|[[#emA_B|em1_1]]
|[[#emA_B|em1_1]]
-
|smallint(5)) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 150: Строка 158:
|-
|-
|[[#emA_B|em1_2]]
|[[#emA_B|em1_2]]
-
|smallint(5)) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 157: Строка 166:
|-
|-
|[[#emA_B|em1_3]]
|[[#emA_B|em1_3]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 164: Строка 174:
|-
|-
|[[#emA_B|em1_4]]
|[[#emA_B|em1_4]]
-
|smallint(5)) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 171: Строка 182:
|-
|-
|[[#emA_B|em1_5]]
|[[#emA_B|em1_5]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 177: Строка 189:
|
|
|-
|-
-
|[[#text2_0|text2_0]]
+
|[[#textA_B|text2_0]]
|longtext
|longtext
-
|YES
+
|
 +
|
|
|
|
|
|
|
|-
|-
-
|[[#text2_1|text2_1]]
+
|[[#textA_C|text2_1]]
|longtext
|longtext
-
|YES
+
|
 +
|
|
|
|
|
Строка 192: Строка 206:
|-
|-
|[[#lang|lang2]]
|[[#lang|lang2]]
-
|tinyint(3) unsigned
+
|tinyint(3)
 +
|unsigned
|NO
|NO
|
|
Строка 200: Строка 215:
|[[#prob|prob2]]
|[[#prob|prob2]]
|float
|float
 +
|
|NO
|NO
|
|
Строка 206: Строка 222:
|-
|-
|[[#emA_B|em2_0]]
|[[#emA_B|em2_0]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 213: Строка 230:
|-
|-
|[[#emA_B|em2_1]]
|[[#emA_B|em2_1]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 220: Строка 238:
|-
|-
|[[#emA_B|em2_2]]
|[[#emA_B|em2_2]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 227: Строка 246:
|-
|-
|[[#emA_B|em2_3]]
|[[#emA_B|em2_3]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 234: Строка 254:
|-
|-
|[[#emA_B|em2_4]]
|[[#emA_B|em2_4]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 241: Строка 262:
|-
|-
|[[#emA_B|em2_5]]
|[[#emA_B|em2_5]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 247: Строка 269:
|
|
|-
|-
-
|[[#text3_0|text3_0]]
+
|[[#textA_B|text3_0]]
|longtext
|longtext
-
|YES
+
|
 +
|
|
|
|
|
|
|
|-
|-
-
|[[#text3_1|text3_1]]
+
|[[#textA_C|text3_1]]
|longtext
|longtext
-
|YES
+
|
 +
|
|
|
|
|
Строка 262: Строка 286:
|-
|-
|[[#lang|lang3]]
|[[#lang|lang3]]
-
|tinyint(3) unsigned
+
|tinyint(3)
 +
|unsigned
|NO
|NO
|
|
Строка 270: Строка 295:
|[[#prob|prob3]]
|[[#prob|prob3]]
|float
|float
 +
|
|NO
|NO
|
|
Строка 276: Строка 302:
|-
|-
|[[#emA_B|em3_0]]
|[[#emA_B|em3_0]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 283: Строка 310:
|-
|-
|[[#emA_B|em3_1]]
|[[#emA_B|em3_1]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 290: Строка 318:
|-
|-
|[[#emA_B|em3_2]]
|[[#emA_B|em3_2]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 297: Строка 326:
|-
|-
|[[#emA_B|em3_3]]
|[[#emA_B|em3_3]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 304: Строка 334:
|-
|-
|[[#emA_B|em3_4]]
|[[#emA_B|em3_4]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 311: Строка 342:
|-
|-
|[[#emA_B|em3_5]]
|[[#emA_B|em3_5]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 317: Строка 349:
|
|
|-
|-
-
|[[#text4_0|text4_0]]
+
|[[#textA_B|text4_0]]
|longtext
|longtext
-
|YES
+
|
 +
|
|
|
|
|
|
|
|-
|-
-
|[[#text4_1|text4_1]]
+
|[[#textA_C|text4_1]]
|longtext
|longtext
-
|YES
+
|
 +
|
|
|
|
|
Строка 332: Строка 366:
|-
|-
|[[#lang|lang4]]
|[[#lang|lang4]]
-
|tinyint(3) unsigned
+
|tinyint(3)
 +
|unsigned
|NO
|NO
|
|
Строка 340: Строка 375:
|[[#prob|prob4]]
|[[#prob|prob4]]
|float
|float
 +
|
|NO
|NO
|
|
Строка 346: Строка 382:
|-
|-
|[[#emA_B|em4_0]]
|[[#emA_B|em4_0]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 353: Строка 390:
|-
|-
|[[#emA_B|em4_1]]
|[[#emA_B|em4_1]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 360: Строка 398:
|-
|-
|[[#emA_B|em4_2]]
|[[#emA_B|em4_2]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 367: Строка 406:
|-
|-
|[[#emA_B|em4_3]]
|[[#emA_B|em4_3]]
-
|smallint(5)) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 374: Строка 414:
|-
|-
|[[#emA_B|em4_4]]
|[[#emA_B|em4_4]]
-
|smallint(5)) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 381: Строка 422:
|-
|-
|[[#emA_B|em4_5]]
|[[#emA_B|em4_5]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 387: Строка 429:
|
|
|-
|-
-
|[[#text5_0|text5_0]]
+
|[[#textA_B|text5_0]]
|longtext
|longtext
-
|YES
+
|
 +
|
|
|
|
|
|
|
|-
|-
-
|[[#text5_1|text5_1]]
+
|[[#textA_C|text5_1]]
|longtext
|longtext
-
|YES
+
|
 +
|
|
|
|
|
Строка 402: Строка 446:
|-
|-
|[[#lang|lang5]]
|[[#lang|lang5]]
-
|tinyint(3) unsigned
+
|tinyint(3)
 +
|unsigned
|NO
|NO
|
|
Строка 410: Строка 455:
|[[#prob|prob5]]
|[[#prob|prob5]]
|float
|float
 +
|
|NO
|NO
|
|
Строка 416: Строка 462:
|-
|-
|[[#emA_B|em5_0]]
|[[#emA_B|em5_0]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 423: Строка 470:
|-
|-
|[[#emA_B|em5_1]]
|[[#emA_B|em5_1]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 430: Строка 478:
|-
|-
|[[#emA_B|em5_2]]
|[[#emA_B|em5_2]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 437: Строка 486:
|-
|-
|[[#emA_B|em5_3]]
|[[#emA_B|em5_3]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 444: Строка 494:
|-
|-
|[[#emA_B|em5_4]]
|[[#emA_B|em5_4]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 451: Строка 502:
|-
|-
|[[#emA_B|em5_5]]
|[[#emA_B|em5_5]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 457: Строка 509:
|
|
|-
|-
-
|[[#text6_0|text6_0]]
+
|[[#textA_B|text6_0]]
|longtext
|longtext
-
|YES
+
|
 +
|
|
|
|
|
|
|
|-
|-
-
|[[#text6_1|text6_1]]
+
|[[#textA_C|text6_1]]
|longtext
|longtext
-
|YES
+
|
 +
|
|
|
|
|
Строка 472: Строка 526:
|-
|-
|[[#lang|lang6]]
|[[#lang|lang6]]
-
|tinyint(3) unsigned
+
|tinyint(3)
 +
|unsigned
|NO
|NO
|
|
Строка 480: Строка 535:
|[[#prob|prob6]]
|[[#prob|prob6]]
|float
|float
 +
|
|NO
|NO
|
|
Строка 486: Строка 542:
|-
|-
|[[#emA_B|em6_0]]
|[[#emA_B|em6_0]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 493: Строка 550:
|-
|-
|[[#emA_B|em6_1]]
|[[#emA_B|em6_1]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 500: Строка 558:
|-
|-
|[[#emA_B|em6_2]]
|[[#emA_B|em6_2]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 507: Строка 566:
|-
|-
|[[#emA_B|em6_3]]
|[[#emA_B|em6_3]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 514: Строка 574:
|-
|-
|[[#emA_B|em6_4]]
|[[#emA_B|em6_4]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 521: Строка 582:
|-
|-
|[[#emA_B|em6_5]]
|[[#emA_B|em6_5]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 527: Строка 589:
|
|
|-
|-
-
|[[#text7_0|text7_0]]
+
|[[#textA_B|text7_0]]
|longtext
|longtext
-
|YES
+
|
 +
|
|
|
|
|
|
|
|-
|-
-
|[[#text7_1|text7_1]]
+
|[[#textA_C|text7_1]]
|longtext
|longtext
-
|YES
+
|
 +
|
|
|
|
|
Строка 551: Строка 615:
|[[#prob|prob7]]
|[[#prob|prob7]]
|float
|float
 +
|
|NO
|NO
|
|
Строка 608: Строка 673:
<big>'''Описание полей'''</big>
<big>'''Описание полей'''</big>
====ID====
====ID====
-
ID Текста. Берется из WDB cache.
+
Идентификатор текста. Берется из WDB cache.
 +
 
====textA_B====
====textA_B====
Is this the first choice of locale 0?
Is this the first choice of locale 0?

Текущая версия на 17:26, 10 декабря 2010

Содержание

К описанию таблиц базы данных mangos.


Таблица `npc_text`

В этой таблице содержатся тексты, которые используются для gossip.


Структура

Field Type Attributes Null Key Default Comments
ID mediumint(8) unsigned NO PRI 0
text0_0 longtext
text0_1 longtext
lang0 tinyint(3) unsigned NO 0
prob0 float 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
text1_1 longtext
lang1 tinyint(3) unsigned NO 0
prob1 float 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
text2_1 longtext
lang2 tinyint(3) unsigned NO 0
prob2 float 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
text3_1 longtext
lang3 tinyint(3) unsigned NO 0
prob3 float 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
text4_1 longtext
lang4 tinyint(3) unsigned NO 0
prob4 float 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
text5_1 longtext
lang5 tinyint(3) unsigned NO 0
prob5 float 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
text6_1 longtext
lang6 tinyint(3) unsigned NO 0
prob6 float 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
text7_1 longtext
lang7 tinyint(3) unsigned NO 0
prob7 float 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


Описание полей

ID

Идентификатор текста. Берется из WDB cache.

textA_B

Is this the first choice of locale 0?

textA_C

Second choice?

lang

Язык текста в игре

prob

Вероятность, с которой NPC произнесет этот текст

emA_B

Emote on greet?

Источник — «http://wiki.ytdb.ru:89/index.php/Npc_text»
Личные инструменты