Npc text

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

(Различия между версиями)
Перейти к: навигация, поиск
Строка 101: Строка 101:
|-
|-
|[[#emA_B|em0_5]]
|[[#emA_B|em0_5]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 109: Строка 110:
|[[#textA_B|text1_0]]
|[[#textA_B|text1_0]]
|longtext
|longtext
 +
|
|YES
|YES
|
|
Строка 116: Строка 118:
|[[#textA_C|text1_1]]
|[[#textA_C|text1_1]]
|longtext
|longtext
 +
|
|YES
|YES
|
|
Строка 122: Строка 125:
|-
|-
|[[#lang|lang1]]
|[[#lang|lang1]]
-
|tinyint(3) unsigned
+
|tinyint(3)
 +
|unsigned
|NO
|NO
|
|
Строка 130: Строка 134:
|[[#prob|prob1]]
|[[#prob|prob1]]
|float
|float
 +
|
|NO
|NO
|
|
Строка 136: Строка 141:
|-
|-
|[[#emA_B|em1_0]]
|[[#emA_B|em1_0]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 143: Строка 149:
|-
|-
|[[#emA_B|em1_1]]
|[[#emA_B|em1_1]]
-
|smallint(5)) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 150: Строка 157:
|-
|-
|[[#emA_B|em1_2]]
|[[#emA_B|em1_2]]
-
|smallint(5)) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 157: Строка 165:
|-
|-
|[[#emA_B|em1_3]]
|[[#emA_B|em1_3]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 164: Строка 173:
|-
|-
|[[#emA_B|em1_4]]
|[[#emA_B|em1_4]]
-
|smallint(5)) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 171: Строка 181:
|-
|-
|[[#emA_B|em1_5]]
|[[#emA_B|em1_5]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 179: Строка 190:
|[[#textA_B|text2_0]]
|[[#textA_B|text2_0]]
|longtext
|longtext
 +
|
|YES
|YES
|
|
Строка 186: Строка 198:
|[[#textA_C|text2_1]]
|[[#textA_C|text2_1]]
|longtext
|longtext
 +
|
|YES
|YES
|
|
Строка 192: Строка 205:
|-
|-
|[[#lang|lang2]]
|[[#lang|lang2]]
-
|tinyint(3) unsigned
+
|tinyint(3)
 +
|unsigned
|NO
|NO
|
|
Строка 200: Строка 214:
|[[#prob|prob2]]
|[[#prob|prob2]]
|float
|float
 +
|
|NO
|NO
|
|
Строка 206: Строка 221:
|-
|-
|[[#emA_B|em2_0]]
|[[#emA_B|em2_0]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 213: Строка 229:
|-
|-
|[[#emA_B|em2_1]]
|[[#emA_B|em2_1]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 220: Строка 237:
|-
|-
|[[#emA_B|em2_2]]
|[[#emA_B|em2_2]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 227: Строка 245:
|-
|-
|[[#emA_B|em2_3]]
|[[#emA_B|em2_3]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 234: Строка 253:
|-
|-
|[[#emA_B|em2_4]]
|[[#emA_B|em2_4]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 241: Строка 261:
|-
|-
|[[#emA_B|em2_5]]
|[[#emA_B|em2_5]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 249: Строка 270:
|[[#textA_B|text3_0]]
|[[#textA_B|text3_0]]
|longtext
|longtext
 +
|
|YES
|YES
|
|
Строка 256: Строка 278:
|[[#textA_C|text3_1]]
|[[#textA_C|text3_1]]
|longtext
|longtext
 +
|
|YES
|YES
|
|
Строка 262: Строка 285:
|-
|-
|[[#lang|lang3]]
|[[#lang|lang3]]
-
|tinyint(3) unsigned
+
|tinyint(3)
 +
|unsigned
|NO
|NO
|
|
Строка 270: Строка 294:
|[[#prob|prob3]]
|[[#prob|prob3]]
|float
|float
 +
|
|NO
|NO
|
|
Строка 276: Строка 301:
|-
|-
|[[#emA_B|em3_0]]
|[[#emA_B|em3_0]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 283: Строка 309:
|-
|-
|[[#emA_B|em3_1]]
|[[#emA_B|em3_1]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 290: Строка 317:
|-
|-
|[[#emA_B|em3_2]]
|[[#emA_B|em3_2]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 297: Строка 325:
|-
|-
|[[#emA_B|em3_3]]
|[[#emA_B|em3_3]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 304: Строка 333:
|-
|-
|[[#emA_B|em3_4]]
|[[#emA_B|em3_4]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 311: Строка 341:
|-
|-
|[[#emA_B|em3_5]]
|[[#emA_B|em3_5]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 319: Строка 350:
|[[#textA_B|text4_0]]
|[[#textA_B|text4_0]]
|longtext
|longtext
 +
|
|YES
|YES
|
|
Строка 326: Строка 358:
|[[#textA_C|text4_1]]
|[[#textA_C|text4_1]]
|longtext
|longtext
 +
|
|YES
|YES
|
|
Строка 332: Строка 365:
|-
|-
|[[#lang|lang4]]
|[[#lang|lang4]]
-
|tinyint(3) unsigned
+
|tinyint(3)
 +
|unsigned
|NO
|NO
|
|
Строка 340: Строка 374:
|[[#prob|prob4]]
|[[#prob|prob4]]
|float
|float
 +
|
|NO
|NO
|
|
Строка 346: Строка 381:
|-
|-
|[[#emA_B|em4_0]]
|[[#emA_B|em4_0]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 353: Строка 389:
|-
|-
|[[#emA_B|em4_1]]
|[[#emA_B|em4_1]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 360: Строка 397:
|-
|-
|[[#emA_B|em4_2]]
|[[#emA_B|em4_2]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 367: Строка 405:
|-
|-
|[[#emA_B|em4_3]]
|[[#emA_B|em4_3]]
-
|smallint(5)) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 374: Строка 413:
|-
|-
|[[#emA_B|em4_4]]
|[[#emA_B|em4_4]]
-
|smallint(5)) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 381: Строка 421:
|-
|-
|[[#emA_B|em4_5]]
|[[#emA_B|em4_5]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 389: Строка 430:
|[[#textA_B|text5_0]]
|[[#textA_B|text5_0]]
|longtext
|longtext
 +
|
|YES
|YES
|
|
Строка 396: Строка 438:
|[[#textA_C|text5_1]]
|[[#textA_C|text5_1]]
|longtext
|longtext
 +
|
|YES
|YES
|
|
Строка 402: Строка 445:
|-
|-
|[[#lang|lang5]]
|[[#lang|lang5]]
-
|tinyint(3) unsigned
+
|tinyint(3)
 +
|unsigned
|NO
|NO
|
|
Строка 410: Строка 454:
|[[#prob|prob5]]
|[[#prob|prob5]]
|float
|float
 +
|
|NO
|NO
|
|
Строка 416: Строка 461:
|-
|-
|[[#emA_B|em5_0]]
|[[#emA_B|em5_0]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 423: Строка 469:
|-
|-
|[[#emA_B|em5_1]]
|[[#emA_B|em5_1]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 430: Строка 477:
|-
|-
|[[#emA_B|em5_2]]
|[[#emA_B|em5_2]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 437: Строка 485:
|-
|-
|[[#emA_B|em5_3]]
|[[#emA_B|em5_3]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 444: Строка 493:
|-
|-
|[[#emA_B|em5_4]]
|[[#emA_B|em5_4]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 451: Строка 501:
|-
|-
|[[#emA_B|em5_5]]
|[[#emA_B|em5_5]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 459: Строка 510:
|[[#textA_B|text6_0]]
|[[#textA_B|text6_0]]
|longtext
|longtext
 +
|
|YES
|YES
|
|
Строка 466: Строка 518:
|[[#textA_C|text6_1]]
|[[#textA_C|text6_1]]
|longtext
|longtext
 +
|
|YES
|YES
|
|
Строка 472: Строка 525:
|-
|-
|[[#lang|lang6]]
|[[#lang|lang6]]
-
|tinyint(3) unsigned
+
|tinyint(3)
 +
|unsigned
|NO
|NO
|
|
Строка 480: Строка 534:
|[[#prob|prob6]]
|[[#prob|prob6]]
|float
|float
 +
|
|NO
|NO
|
|
Строка 486: Строка 541:
|-
|-
|[[#emA_B|em6_0]]
|[[#emA_B|em6_0]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 493: Строка 549:
|-
|-
|[[#emA_B|em6_1]]
|[[#emA_B|em6_1]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 500: Строка 557:
|-
|-
|[[#emA_B|em6_2]]
|[[#emA_B|em6_2]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 507: Строка 565:
|-
|-
|[[#emA_B|em6_3]]
|[[#emA_B|em6_3]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 514: Строка 573:
|-
|-
|[[#emA_B|em6_4]]
|[[#emA_B|em6_4]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 521: Строка 581:
|-
|-
|[[#emA_B|em6_5]]
|[[#emA_B|em6_5]]
-
|smallint(5) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 529: Строка 590:
|[[#textA_B|text7_0]]
|[[#textA_B|text7_0]]
|longtext
|longtext
 +
|
|YES
|YES
|
|
Строка 536: Строка 598:
|[[#textA_C|text7_1]]
|[[#textA_C|text7_1]]
|longtext
|longtext
 +
|
|YES
|YES
|
|
Строка 551: Строка 614:
|[[#prob|prob7]]
|[[#prob|prob7]]
|float
|float
 +
|
|NO
|NO
|
|

Версия 20:56, 17 августа 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 YES
text1_1 longtext YES
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 YES
text2_1 longtext YES
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 YES
text3_1 longtext YES
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 YES
text4_1 longtext YES
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 YES
text5_1 longtext YES
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 YES
text6_1 longtext YES
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 YES
text7_1 longtext YES
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

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»
Личные инструменты