blob: e80e6bdeae64922f89191d1bab424156722ebd03 (
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
|
# broadcast\_text\_locale
**The \`broadcast\_text\_locale\` table**
This table will have **localized texts** for \`broadcast\_text\` table. Used in [gossips](gossip_menu_option), [creature texts](creature_text) and [npc\_text](npc_text)s.
Its purpose is (will be) used as a globalized table containing the localized texts as mentionned above.
**Structure**
| Field | Type | Key | Null | Default | Extra | Comment |
|-----------------------------|--------------|------|------|---------|-------|---------|
| [ID](#ID) | MEDIUMINT | PRI | NO | 0 | | |
| [locale](#locale) | VARCHAR(4) | PRI | NO | NULL | | |
| [MaleText](#MaleText) | text | | YES | NULL | | |
| [FemaleText](#FemaleText) | text | | YES | NULL | | |
| VerifiedBuild | SMALLINT | | YES | 0 | | |
### Description of the fields
### ID
The unique ID value for the text, pointing to ID of the text at broadcast_text table.
### locale
The language in what the text will be broadcasted.
Can have 8 values : deDE, esES, esMX, frFR, koKR, ruRU, zhCN, zhTW
### MaleText
The localized text that the male creature will broadcast, or male players can read from gossip menu.
### FemaleText
The localized text that the female creature will broadcast, or female players can read from gossip menu.
#### WDBVerified
This field is used by the AzerothCore Team to determine whether a template has been verified from WDB files (ADB files for this one).
If value is 0 then it has not been parsed yet.
If value is above 0 then it has been parsed with WDB files from that specific client build.
If value is -1 then it is just a place holder until proper data are found on WDBs.
If value is [-Client Build](https://www.azerothcore.org/wiki/realmlist "DB:Auth:realmlist") then it was parsed with WDB files from that specific [client build](https://www.azerothcore.org/wiki/realmlist#gamebuild "DB:Auth:realmlist") and manually edited later for some special necessity.
|
