blob: 21c09eb04c7dc461b5e560369ea60770ecbd5ae6 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
|
# npc\_text\_locale
[<-Back-to:World](database-world.md)
**The \`npc\_text\_locale\` table**
This table is used to provide localized clients with localized string for npc\_texts.
**Structure**
| | | | | | | | |
|---------------------------------------------|--------------|----------------|---------|----------|-------------|-----------|-------------|
| **Field** | **Type** | **Attributes** | **Key** | **Null** | **Default** | **Extra** | **Comment** |
| [ID](#npc_text_locale-ID) | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | |
| [Text0\_0\_loc1](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text0\_0\_loc2](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text0\_0\_loc3](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text0\_0\_loc4](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text0\_0\_loc5](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text0\_0\_loc6](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text0\_0\_loc7](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text0\_0\_loc8](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text0\_1\_loc1](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text0\_1\_loc2](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text0\_1\_loc3](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text0\_1\_loc4](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text0\_1\_loc5](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text0\_1\_loc6](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text0\_1\_loc7](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text0\_1\_loc8](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text1\_0\_loc1](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text1\_0\_loc2](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text1\_0\_loc3](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text1\_0\_loc4](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text1\_0\_loc5](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text1\_0\_loc6](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text1\_0\_loc7](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text1\_0\_loc8](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text1\_1\_loc1](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text1\_1\_loc2](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text1\_1\_loc3](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text1\_1\_loc4](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text1\_1\_loc5](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text1\_1\_loc6](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text1\_1\_loc7](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text1\_1\_loc8](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text2\_0\_loc1](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text2\_0\_loc2](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text2\_0\_loc3](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text2\_0\_loc4](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text2\_0\_loc5](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text2\_0\_loc6](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text2\_0\_loc7](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text2\_0\_loc8](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text2\_1\_loc1](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text2\_1\_loc2](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text2\_1\_loc3](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text2\_1\_loc4](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text2\_1\_loc5](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text2\_1\_loc6](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text2\_1\_loc7](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text2\_1\_loc8](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text3\_0\_loc1](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text3\_0\_loc2](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text3\_0\_loc3](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text3\_0\_loc4](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text3\_0\_loc5](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text3\_0\_loc6](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text3\_0\_loc7](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text3\_0\_loc8](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text3\_1\_loc1](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text3\_1\_loc2](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text3\_1\_loc3](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text3\_1\_loc4](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text3\_1\_loc5](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text3\_1\_loc6](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text3\_1\_loc7](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text3\_1\_loc8](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text4\_0\_loc1](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text4\_0\_loc2](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text4\_0\_loc3](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text4\_0\_loc4](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text4\_0\_loc5](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text4\_0\_loc6](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text4\_0\_loc7](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text4\_0\_loc8](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text4\_1\_loc1](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text4\_1\_loc2](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text4\_1\_loc3](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text4\_1\_loc4](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text4\_1\_loc5](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text4\_1\_loc6](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text4\_1\_loc7](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text4\_1\_loc8](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text5\_0\_loc1](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text5\_0\_loc2](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text5\_0\_loc3](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text5\_0\_loc4](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text5\_0\_loc5](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text5\_0\_loc6](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text5\_0\_loc7](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text5\_0\_loc8](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text5\_1\_loc1](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text5\_1\_loc2](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text5\_1\_loc3](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text5\_1\_loc4](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text5\_1\_loc5](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text5\_1\_loc6](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text5\_1\_loc7](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text5\_1\_loc8](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text6\_0\_loc1](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text6\_0\_loc2](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text6\_0\_loc3](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text6\_0\_loc4](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text6\_0\_loc5](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text6\_0\_loc6](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text6\_0\_loc7](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text6\_0\_loc8](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text6\_1\_loc1](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text6\_1\_loc2](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text6\_1\_loc3](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text6\_1\_loc4](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text6\_1\_loc5](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text6\_1\_loc6](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text6\_1\_loc7](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text6\_1\_loc8](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text7\_0\_loc1](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text7\_0\_loc2](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text7\_0\_loc3](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text7\_0\_loc4](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text7\_0\_loc5](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text7\_0\_loc6](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text7\_0\_loc7](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text7\_0\_loc8](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text7\_1\_loc1](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text7\_1\_loc2](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text7\_1\_loc3](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text7\_1\_loc4](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text7\_1\_loc5](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text7\_1\_loc6](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text7\_1\_loc7](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
| [Text7\_1\_loc8](#npc_text_locale-Text_loc) | longtext | SIGNED | | YES | NULL | | |
**Description of the fields**
### ID
This id must be the same as [npc\_text.ID](https://trinitycore.atlassian.net/wiki/display/tc/npc_text#npc_text-ID) and then the row will be used to provide localization support for this npc\_text record.
### Text\_loc
Translated content for corresponding field [npc\_text.text0 \_0](https://trinitycore.atlassian.net/wiki/display/tc/npc_text#npc_text-text0_0) - [npc\_text-text7\_1](https://trinitycore.atlassian.net/wiki/display/tc/npc_text#npc_text-text7_1) field for language X.
See [localization languages](Localization+lang) list to know which value to use for X.
|
