Npc text

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

Версия 20:46, 17 августа 2010 (просмотреть исходный код) NeatElves (Обсуждение | вклад) ← Предыдущая правка		Версия 20:50, 17 августа 2010 (просмотреть исходный код) NeatElves (Обсуждение | вклад) Следующая правка →
Строка 28:		Строка 28:
	|		|
	|-		|-
-	|[[#text0_0|text0_0]]	+	|[[#textA_B|text0_0]]
	|longtext		|longtext
	|		|
Строка 36:		Строка 36:
	|		|
	|-		|-
-	|[[#text0_1|text0_1]]	+	|[[#textA_B|text0_1]]
	|longtext		|longtext
	|		|
Строка 44:		Строка 44:
	|		|
	|-		|-
-	|[[#lang0|lang0]]	+	|[[#lang|lang0]]
	|tinyint(3)		|tinyint(3)
	|unsigned		|unsigned
Строка 52:		Строка 52:
	|		|
	|-		|-
-	|[[#prob0|prob0]]	+	|[[#prob|prob0]]
	|float		|float
	|		|
Строка 60:		Строка 60:
	|		|
	|-		|-
-	|[[#em0_0|em0_0]]	+	|[[#emA_B|em0_0]]
	|smallint(5)		|smallint(5)
	|unsigned		|unsigned
Строка 68:		Строка 68:
	|		|
	|-		|-
-	|[[#em0_1|em0_1]]	+	|[[#emA_B|em0_1]]
	|smallint(5)		|smallint(5)
	|unsigned		|unsigned
Строка 76:		Строка 76:
	|		|
	|-		|-
-	|[[#em0_2|em0_2]]	+	|[[#emA_B|em0_2]]
	|smallint(5)		|smallint(5)
	|unsigned		|unsigned
Строка 84:		Строка 84:
	|		|
	|-		|-
-	|[[#em0_3|em0_3]]	+	|[[#emA_B|em0_3]]
	|smallint(5)		|smallint(5)
	|unsigned		|unsigned
Строка 92:		Строка 92:
	|		|
	|-		|-
-	|[[#em0_4|em0_4]]	+	|[[#emA_B|em0_4]]
	|smallint(5)		|smallint(5)
	|unsigned		|unsigned
Строка 100:		Строка 100:
	|		|
	|-		|-
-	|[[#em0_5|em0_5]]	+	|[[#emA_B|em0_5]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 121:		Строка 121:
	|		|
	|-		|-
-	|[[#lang1|lang1]]	+	|[[#lang|lang1]]
	|tinyint(3) unsigned		|tinyint(3) unsigned
	|NO		|NO
Строка 128:		Строка 128:
	|		|
	|-		|-
-	|[[#prob1|prob1]]	+	|[[#prob|prob1]]
	|float		|float
	|NO		|NO
Строка 135:		Строка 135:
	|		|
	|-		|-
-	|[[#em1_0|em1_0]]	+	|[[#emA_B|em1_0]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 142:		Строка 142:
	|		|
	|-		|-
-	|[[#em1_1|em1_1]]	+	|[[#emA_B|em1_1]]
	|smallint(5)) unsigned		|smallint(5)) unsigned
	|NO		|NO
Строка 149:		Строка 149:
	|		|
	|-		|-
-	|[[#em1_2|em1_2]]	+	|[[#emA_B|em1_2]]
	|smallint(5)) unsigned		|smallint(5)) unsigned
	|NO		|NO
Строка 156:		Строка 156:
	|		|
	|-		|-
-	|[[#em1_3|em1_3]]	+	|[[#emA_B|em1_3]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 163:		Строка 163:
	|		|
	|-		|-
-	|[[#em1_4|em1_4]]	+	|[[#emA_B|em1_4]]
	|smallint(5)) unsigned		|smallint(5)) unsigned
	|NO		|NO
Строка 170:		Строка 170:
	|		|
	|-		|-
-	|[[#em1_5|em1_5]]	+	|[[#emA_B|em1_5]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 191:		Строка 191:
	|		|
	|-		|-
-	|[[#lang2|lang2]]	+	|[[#lang|lang2]]
	|tinyint(3) unsigned		|tinyint(3) unsigned
	|NO		|NO
Строка 198:		Строка 198:
	|		|
	|-		|-
-	|[[#prob2|prob2]]	+	|[[#prob|prob2]]
	|float		|float
	|NO		|NO
Строка 205:		Строка 205:
	|		|
	|-		|-
-	|[[#em2_0|em2_0]]	+	|[[#emA_B|em2_0]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 212:		Строка 212:
	|		|
	|-		|-
-	|[[#em2_1|em2_1]]	+	|[[#emA_B|em2_1]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 219:		Строка 219:
	|		|
	|-		|-
-	|[[#em2_2|em2_2]]	+	|[[#emA_B|em2_2]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 226:		Строка 226:
	|		|
	|-		|-
-	|[[#em2_3|em2_3]]	+	|[[#emA_B|em2_3]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 233:		Строка 233:
	|		|
	|-		|-
-	|[[#em2_4|em2_4]]	+	|[[#emA_B|em2_4]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 240:		Строка 240:
	|		|
	|-		|-
-	|[[#em2_5|em2_5]]	+	|[[#emA_B|em2_5]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 261:		Строка 261:
	|		|
	|-		|-
-	|[[#lang3|lang3]]	+	|[[#lang|lang3]]
	|tinyint(3) unsigned		|tinyint(3) unsigned
	|NO		|NO
Строка 268:		Строка 268:
	|		|
	|-		|-
-	|[[#prob3|prob3]]	+	|[[#prob|prob3]]
	|float		|float
	|NO		|NO
Строка 275:		Строка 275:
	|		|
	|-		|-
-	|[[#em3_0|em3_0]]	+	|[[#emA_B|em3_0]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 282:		Строка 282:
	|		|
	|-		|-
-	|[[#em3_1|em3_1]]	+	|[[#emA_B|em3_1]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 289:		Строка 289:
	|		|
	|-		|-
-	|[[#em3_2|em3_2]]	+	|[[#emA_B|em3_2]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 296:		Строка 296:
	|		|
	|-		|-
-	|[[#em3_3|em3_3]]	+	|[[#emA_B|em3_3]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 303:		Строка 303:
	|		|
	|-		|-
-	|[[#em3_4|em3_4]]	+	|[[#emA_B|em3_4]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 310:		Строка 310:
	|		|
	|-		|-
-	|[[#em3_5|em3_5]]	+	|[[#emA_B|em3_5]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 331:		Строка 331:
	|		|
	|-		|-
-	|[[#lang4|lang4]]	+	|[[#lang|lang4]]
	|tinyint(3) unsigned		|tinyint(3) unsigned
	|NO		|NO
Строка 338:		Строка 338:
	|		|
	|-		|-
-	|[[#prob4|prob4]]	+	|[[#prob|prob4]]
	|float		|float
	|NO		|NO
Строка 345:		Строка 345:
	|		|
	|-		|-
-	|[[#em4_0|em4_0]]	+	|[[#emA_B|em4_0]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 352:		Строка 352:
	|		|
	|-		|-
-	|[[#em4_1|em4_1]]	+	|[[#emA_B|em4_1]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 359:		Строка 359:
	|		|
	|-		|-
-	|[[#em4_2|em4_2]]	+	|[[#emA_B|em4_2]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 366:		Строка 366:
	|		|
	|-		|-
-	|[[#em4_3|em4_3]]	+	|[[#emA_B|em4_3]]
	|smallint(5)) unsigned		|smallint(5)) unsigned
	|NO		|NO
Строка 373:		Строка 373:
	|		|
	|-		|-
-	|[[#em4_4|em4_4]]	+	|[[#emA_B|em4_4]]
	|smallint(5)) unsigned		|smallint(5)) unsigned
	|NO		|NO
Строка 380:		Строка 380:
	|		|
	|-		|-
-	|[[#em4_5|em4_5]]	+	|[[#emA_B|em4_5]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 401:		Строка 401:
	|		|
	|-		|-
-	|[[#lang5|lang5]]	+	|[[#lang|lang5]]
	|tinyint(3) unsigned		|tinyint(3) unsigned
	|NO		|NO
Строка 408:		Строка 408:
	|		|
	|-		|-
-	|[[#prob5|prob5]]	+	|[[#prob|prob5]]
	|float		|float
	|NO		|NO
Строка 415:		Строка 415:
	|		|
	|-		|-
-	|[[#em5_0|em5_0]]	+	|[[#emA_B|em5_0]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 422:		Строка 422:
	|		|
	|-		|-
-	|[[#em5_1|em5_1]]	+	|[[#emA_B|em5_1]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 429:		Строка 429:
	|		|
	|-		|-
-	|[[#em5_2|em5_2]]	+	|[[#emA_B|em5_2]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 436:		Строка 436:
	|		|
	|-		|-
-	|[[#em5_3|em5_3]]	+	|[[#emA_B|em5_3]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 443:		Строка 443:
	|		|
	|-		|-
-	|[[#em5_4|em5_4]]	+	|[[#emA_B|em5_4]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 450:		Строка 450:
	|		|
	|-		|-
-	|[[#em5_5|em5_5]]	+	|[[#emA_B|em5_5]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 471:		Строка 471:
	|		|
	|-		|-
-	|[[#lang6|lang6]]	+	|[[#lang|lang6]]
	|tinyint(3) unsigned		|tinyint(3) unsigned
	|NO		|NO
Строка 478:		Строка 478:
	|		|
	|-		|-
-	|[[#prob6|prob6]]	+	|[[#prob|prob6]]
	|float		|float
	|NO		|NO
Строка 485:		Строка 485:
	|		|
	|-		|-
-	|[[#em6_0|em6_0]]	+	|[[#emA_B|em6_0]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 492:		Строка 492:
	|		|
	|-		|-
-	|[[#em6_1|em6_1]]	+	|[[#emA_B|em6_1]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 499:		Строка 499:
	|		|
	|-		|-
-	|[[#em6_2|em6_2]]	+	|[[#emA_B|em6_2]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 506:		Строка 506:
	|		|
	|-		|-
-	|[[#em6_3|em6_3]]	+	|[[#emA_B|em6_3]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 513:		Строка 513:
	|		|
	|-		|-
-	|[[#em6_4|em6_4]]	+	|[[#emA_B|em6_4]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 520:		Строка 520:
	|		|
	|-		|-
-	|[[#em6_5|em6_5]]	+	|[[#emA_B|em6_5]]
	|smallint(5) unsigned		|smallint(5) unsigned
	|NO		|NO
Строка 541:		Строка 541:
	|		|
	|-		|-
-	|[[#lang7|lang7]]	+	|[[#lang|lang7]]
	|tinyint(3)		|tinyint(3)
	|unsigned		|unsigned
Строка 549:		Строка 549:
	|		|
	|-		|-
-	|[[#prob7|prob7]]	+	|[[#prob|prob7]]
	|float		|float
	|NO		|NO
Строка 556:		Строка 556:
	|		|
	|-		|-
-	|[[#em7_0|em7_0]]	+	|[[#emA_B|em7_0]]
	|smallint(5)		|smallint(5)
	|unsigned		|unsigned
Строка 564:		Строка 564:
	|		|
	|-		|-
-	|[[#em7_1|em7_1]]	+	|[[#emA_B|em7_1]]
	|smallint(5)		|smallint(5)
	|unsigned		|unsigned
Строка 572:		Строка 572:
	|		|
	|-		|-
-	|[[#em7_2|em7_2]]	+	|[[#emA_B|em7_2]]
	|smallint(5)		|smallint(5)
	|unsigned		|unsigned
Строка 580:		Строка 580:
	|		|
	|-		|-
-	|[[#em7_3|em7_3]]	+	|[[#emA_B|em7_3]]
	|smallint(5)		|smallint(5)
	|unsigned		|unsigned
Строка 588:		Строка 588:
	|		|
	|-		|-
-	|[[#em7_4|em7_4]]	+	|[[#emA_B|em7_4]]
	|smallint(5)		|smallint(5)
	|unsigned		|unsigned
Строка 596:		Строка 596:
	|		|
	|-		|-
-	|[[#em7_5|em7_5]]	+	|[[#emA_B|em7_5]]
	|smallint(5)		|smallint(5)
	|unsigned		|unsigned

---

Версия 20:50, 17 августа 2010

Содержание 1 ID 2 text0_0 3 text0_1 4 lang0 5 prob0 6 em0_0 7 em0_1 8 em0_2 9 em0_3 10 em0_4 11 em0_5 12 text1_0 13 text1_1 14 lang1 15 prob1 16 em1_0 17 em1_1 18 em1_2 19 em1_3 20 em1_4 21 em1_5 22 text2_0 23 text2_1 24 lang2 25 prob2 26 em2_0 27 em2_1 28 em2_2 29 em2_3 30 em2_4 31 em2_5 32 text3_0 33 text3_1 34 lang3 35 prob3 36 em3_0 37 em3_1 38 em3_2 39 em3_3 40 em3_4 41 em3_5 42 text4_0 43 text4_1 44 lang4 45 prob4 46 em4_0 47 em4_1 48 em4_2 49 em4_3 50 em4_4 51 em4_5 52 text5_0 53 text5_1 54 lang5 55 prob5 56 em5_0 57 em5_1 58 em5_2 59 em5_3 60 em5_4 61 em5_5 62 text6_0 63 text6_1 64 lang6 65 prob6 66 em6_0 67 em6_1 68 em6_2 69 em6_3 70 em6_4 71 em6_5 72 text7_0 73 text7_1 74 lang7 75 prob7 76 em7_0 77 em7_1 78 em7_2 79 em7_3 80 em7_4 81 em7_5

К описанию таблиц базы данных 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