summaryrefslogtreecommitdiff
path: root/docs/item_template_locale.md
blob: 0f2d4b433ea90a0e7ee3750969742ba60d477035 (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
# item\_template\_locale

[<-Back-to:World](database-world.md)

**The \`item\_template\_locale\` table**

This table is used to provide to localized clients with localized string for items.

**Structure**

|                                                            |              |                |         |          |             |           |             |
|------------------------------------------------------------|--------------|----------------|---------|----------|-------------|-----------|-------------|
| **Field**                                                  | **Type**     | **Attributes** | **Key** | **Null** | **Default** | **Extra** | **Comment** |
| [entry](#item_template_locale-entry)                       | MEDIUMINT | UNSIGNED       | PRI     | NO       | 0           |           |             |
| [name\_loc1](#item_template_locale-name_loc)               | VARCHAR(100) | SIGNED         |         | NO       | NULL        |           |             |
| [name\_loc2](#item_template_locale-name_loc)               | VARCHAR(100) | SIGNED         |         | NO       | NULL        |           |             |
| [name\_loc3](#item_template_locale-name_loc)               | VARCHAR(100) | SIGNED         |         | NO       | NULL        |           |             |
| [name\_loc4](#item_template_locale-name_loc)               | VARCHAR(100) | SIGNED         |         | NO       | NULL        |           |             |
| [name\_loc5](#item_template_locale-name_loc)               | VARCHAR(100) | SIGNED         |         | NO       | NULL        |           |             |
| [name\_loc6](#item_template_locale-name_loc)               | VARCHAR(100) | SIGNED         |         | NO       | NULL        |           |             |
| [name\_loc7](#item_template_locale-name_loc)               | VARCHAR(100) | SIGNED         |         | NO       | NULL        |           |             |
| [name\_loc8](#item_template_locale-name_loc)               | VARCHAR(100) | SIGNED         |         | NO       | NULL        |           |             |
| [description\_loc1](#item_template_locale-description_loc) | VARCHAR(255) | SIGNED         |         | YES      | NULL        |           |             |
| [description\_loc2](#item_template_locale-description_loc) | VARCHAR(255) | SIGNED         |         | YES      | NULL        |           |             |
| [description\_loc3](#item_template_locale-description_loc) | VARCHAR(255) | SIGNED         |         | YES      | NULL        |           |             |
| [description\_loc4](#item_template_locale-description_loc) | VARCHAR(255) | SIGNED         |         | YES      | NULL        |           |             |
| [description\_loc5](#item_template_locale-description_loc) | VARCHAR(255) | SIGNED         |         | YES      | NULL        |           |             |
| [description\_loc6](#item_template_locale-description_loc) | VARCHAR(255) | SIGNED         |         | YES      | NULL        |           |             |
| [description\_loc7](#item_template_locale-description_loc) | VARCHAR(255) | SIGNED         |         | YES      | NULL        |           |             |
| [description\_loc8](#item_template_locale-description_loc) | VARCHAR(255) | SIGNED         |         | YES      | NULL        |           |             |

**Description of the fields**

### entry

This entry must be the same as  [item\_template.entry](https://trinitycore.atlassian.net/wiki/display/tc/item_template#item_template-entry) and then the row will be used to provide localization support for this creature record.

### name\_loc

Translated content for [item\_template.name](https://trinitycore.atlassian.net/wiki/display/tc/item_template#item_template-name) field for language X.
See localization languages list to know which value to use for X.

### description\_loc

Translated content for  [item\_template.description](https://trinitycore.atlassian.net/wiki/display/tc/item_template#item_template-description) field for language X.
See localization languages list to know which value to use for X.