Npc text

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

(Различия между версиями)
Перейти к: навигация, поиск
(Перевел)
Строка 14: Строка 14:
|'''Field'''
|'''Field'''
|'''Type'''
|'''Type'''
 +
|'''Attributes'''
|'''Null'''
|'''Null'''
|'''Key'''
|'''Key'''
|'''Default'''
|'''Default'''
-
|'''Extra'''
+
|'''Comments'''
|-
|-
|[[#ID|ID]]
|[[#ID|ID]]
-
|int(11) unsigned
+
|mediumint(8)
 +
|unsigned
|NO
|NO
|PRI
|PRI
Строка 28: Строка 30:
|[[#text0_0|text0_0]]
|[[#text0_0|text0_0]]
|longtext
|longtext
-
|YES
+
|
 +
|
|
|
|
|
Строка 35: Строка 38:
|[[#text0_1|text0_1]]
|[[#text0_1|text0_1]]
|longtext
|longtext
-
|YES
+
|
 +
|
|
|
|
|
Строка 41: Строка 45:
|-
|-
|[[#lang0|lang0]]
|[[#lang0|lang0]]
-
|bigint(20) unsigned
+
|tinyint(3)
 +
|unsigned
|NO
|NO
|
|
Строка 49: Строка 54:
|[[#prob0|prob0]]
|[[#prob0|prob0]]
|float
|float
 +
|
|NO
|NO
|
|
Строка 55: Строка 61:
|-
|-
|[[#em0_0|em0_0]]
|[[#em0_0|em0_0]]
-
|bigint(20) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 62: Строка 69:
|-
|-
|[[#em0_1|em0_1]]
|[[#em0_1|em0_1]]
-
|bigint(20) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 69: Строка 77:
|-
|-
|[[#em0_2|em0_2]]
|[[#em0_2|em0_2]]
-
|bigint(20) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 76: Строка 85:
|-
|-
|[[#em0_3|em0_3]]
|[[#em0_3|em0_3]]
-
|bigint(20) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 83: Строка 93:
|-
|-
|[[#em0_4|em0_4]]
|[[#em0_4|em0_4]]
-
|bigint(20) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 90: Строка 101:
|-
|-
|[[#em0_5|em0_5]]
|[[#em0_5|em0_5]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 111: Строка 122:
|-
|-
|[[#lang1|lang1]]
|[[#lang1|lang1]]
-
|bigint(20) unsigned
+
|tinyint(3) unsigned
|NO
|NO
|
|
Строка 125: Строка 136:
|-
|-
|[[#em1_0|em1_0]]
|[[#em1_0|em1_0]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 132: Строка 143:
|-
|-
|[[#em1_1|em1_1]]
|[[#em1_1|em1_1]]
-
|bigint(20) unsigned
+
|smallint(5)) unsigned
|NO
|NO
|
|
Строка 139: Строка 150:
|-
|-
|[[#em1_2|em1_2]]
|[[#em1_2|em1_2]]
-
|bigint(20) unsigned
+
|smallint(5)) unsigned
|NO
|NO
|
|
Строка 146: Строка 157:
|-
|-
|[[#em1_3|em1_3]]
|[[#em1_3|em1_3]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 153: Строка 164:
|-
|-
|[[#em1_4|em1_4]]
|[[#em1_4|em1_4]]
-
|bigint(20) unsigned
+
|smallint(5)) unsigned
|NO
|NO
|
|
Строка 160: Строка 171:
|-
|-
|[[#em1_5|em1_5]]
|[[#em1_5|em1_5]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 181: Строка 192:
|-
|-
|[[#lang2|lang2]]
|[[#lang2|lang2]]
-
|bigint(20) unsigned
+
|tinyint(3) unsigned
|NO
|NO
|
|
Строка 195: Строка 206:
|-
|-
|[[#em2_0|em2_0]]
|[[#em2_0|em2_0]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 202: Строка 213:
|-
|-
|[[#em2_1|em2_1]]
|[[#em2_1|em2_1]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 209: Строка 220:
|-
|-
|[[#em2_2|em2_2]]
|[[#em2_2|em2_2]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 216: Строка 227:
|-
|-
|[[#em2_3|em2_3]]
|[[#em2_3|em2_3]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 223: Строка 234:
|-
|-
|[[#em2_4|em2_4]]
|[[#em2_4|em2_4]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 230: Строка 241:
|-
|-
|[[#em2_5|em2_5]]
|[[#em2_5|em2_5]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 251: Строка 262:
|-
|-
|[[#lang3|lang3]]
|[[#lang3|lang3]]
-
|bigint(20) unsigned
+
|tinyint(3) unsigned
|NO
|NO
|
|
Строка 265: Строка 276:
|-
|-
|[[#em3_0|em3_0]]
|[[#em3_0|em3_0]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 272: Строка 283:
|-
|-
|[[#em3_1|em3_1]]
|[[#em3_1|em3_1]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 279: Строка 290:
|-
|-
|[[#em3_2|em3_2]]
|[[#em3_2|em3_2]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 286: Строка 297:
|-
|-
|[[#em3_3|em3_3]]
|[[#em3_3|em3_3]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 293: Строка 304:
|-
|-
|[[#em3_4|em3_4]]
|[[#em3_4|em3_4]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 300: Строка 311:
|-
|-
|[[#em3_5|em3_5]]
|[[#em3_5|em3_5]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 321: Строка 332:
|-
|-
|[[#lang4|lang4]]
|[[#lang4|lang4]]
-
|bigint(20) unsigned
+
|tinyint(3) unsigned
|NO
|NO
|
|
Строка 335: Строка 346:
|-
|-
|[[#em4_0|em4_0]]
|[[#em4_0|em4_0]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 342: Строка 353:
|-
|-
|[[#em4_1|em4_1]]
|[[#em4_1|em4_1]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 349: Строка 360:
|-
|-
|[[#em4_2|em4_2]]
|[[#em4_2|em4_2]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 356: Строка 367:
|-
|-
|[[#em4_3|em4_3]]
|[[#em4_3|em4_3]]
-
|bigint(20) unsigned
+
|smallint(5)) unsigned
|NO
|NO
|
|
Строка 363: Строка 374:
|-
|-
|[[#em4_4|em4_4]]
|[[#em4_4|em4_4]]
-
|bigint(20) unsigned
+
|smallint(5)) unsigned
|NO
|NO
|
|
Строка 370: Строка 381:
|-
|-
|[[#em4_5|em4_5]]
|[[#em4_5|em4_5]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 391: Строка 402:
|-
|-
|[[#lang5|lang5]]
|[[#lang5|lang5]]
-
|bigint(20) unsigned
+
|tinyint(3) unsigned
|NO
|NO
|
|
Строка 405: Строка 416:
|-
|-
|[[#em5_0|em5_0]]
|[[#em5_0|em5_0]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 412: Строка 423:
|-
|-
|[[#em5_1|em5_1]]
|[[#em5_1|em5_1]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 419: Строка 430:
|-
|-
|[[#em5_2|em5_2]]
|[[#em5_2|em5_2]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 426: Строка 437:
|-
|-
|[[#em5_3|em5_3]]
|[[#em5_3|em5_3]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 433: Строка 444:
|-
|-
|[[#em5_4|em5_4]]
|[[#em5_4|em5_4]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 440: Строка 451:
|-
|-
|[[#em5_5|em5_5]]
|[[#em5_5|em5_5]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 461: Строка 472:
|-
|-
|[[#lang6|lang6]]
|[[#lang6|lang6]]
-
|bigint(20) unsigned
+
|tinyint(3) unsigned
|NO
|NO
|
|
Строка 475: Строка 486:
|-
|-
|[[#em6_0|em6_0]]
|[[#em6_0|em6_0]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 482: Строка 493:
|-
|-
|[[#em6_1|em6_1]]
|[[#em6_1|em6_1]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 489: Строка 500:
|-
|-
|[[#em6_2|em6_2]]
|[[#em6_2|em6_2]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 496: Строка 507:
|-
|-
|[[#em6_3|em6_3]]
|[[#em6_3|em6_3]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 503: Строка 514:
|-
|-
|[[#em6_4|em6_4]]
|[[#em6_4|em6_4]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 510: Строка 521:
|-
|-
|[[#em6_5|em6_5]]
|[[#em6_5|em6_5]]
-
|bigint(20) unsigned
+
|smallint(5) unsigned
|NO
|NO
|
|
Строка 531: Строка 542:
|-
|-
|[[#lang7|lang7]]
|[[#lang7|lang7]]
-
|bigint(20) unsigned
+
|tinyint(3)
 +
|unsigned
|NO
|NO
|
|
Строка 545: Строка 557:
|-
|-
|[[#em7_0|em7_0]]
|[[#em7_0|em7_0]]
-
|bigint(20) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 552: Строка 565:
|-
|-
|[[#em7_1|em7_1]]
|[[#em7_1|em7_1]]
-
|bigint(20) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 559: Строка 573:
|-
|-
|[[#em7_2|em7_2]]
|[[#em7_2|em7_2]]
-
|bigint(20) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 566: Строка 581:
|-
|-
|[[#em7_3|em7_3]]
|[[#em7_3|em7_3]]
-
|bigint(20) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 573: Строка 589:
|-
|-
|[[#em7_4|em7_4]]
|[[#em7_4|em7_4]]
-
|bigint(20) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|
Строка 580: Строка 597:
|-
|-
|[[#em7_5|em7_5]]
|[[#em7_5|em7_5]]
-
|bigint(20) unsigned
+
|smallint(5)
 +
|unsigned
|NO
|NO
|
|

Версия 20:46, 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.

text0_0

Is this the first choice of locale 0?

text0_1

Second choice?

lang0

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

prob0

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

em0_0

Emote on greet?

em0_1

Emote on ?

em0_2

Emote on ?

em0_3

Emote on ?

em0_4

Emote on ?

em0_5

Emote on ?

text1_0

text1_1

lang1

prob1

em1_0

em1_1

em1_2

em1_3

em1_4

em1_5

text2_0

text2_1

lang2

prob2

em2_0

em2_1

em2_2

em2_3

em2_4

em2_5

text3_0

text3_1

lang3

prob3

em3_0

em3_1

em3_2

em3_3

em3_4

em3_5

text4_0

text4_1

lang4

prob4

em4_0

em4_1

em4_2

em4_3

em4_4

em4_5

text5_0

text5_1

lang5

prob5

em5_0

em5_1

em5_2

em5_3

em5_4

em5_5

text6_0

text6_1

lang6

prob6

em6_0

em6_1

em6_2

em6_3

em6_4

em6_5

text7_0

text7_1

lang7

prob7

em7_0

em7_1

em7_2

em7_3

em7_4

em7_5

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