目录

achievement_reward_locale

<-Back-to:World

The `achievement_reward_locale` table

It is the table that stores the translations of the table achievement_reward, so that the game client can display the messages in different languages.

Structure

Field Type Attributes Key Null Default Extra Comment
ID MEDIUMINT UNSIGNED PRI NO 0
Locale VARCHAR(4) PRI NO
Subject text YES
Text text YES

Description of the fields

ID

It is the ID of the achievement obtained from achievement_reward

Locale

This is the language of the gaming client.

ID Language
0 enUS
1 koKR
2 frFR
3 deDE
4 zhCN
5 zhTW
6 esES
7 esMX
8 ruRU

Subject

It is the text of the column Subject of the table achievement_reward

Text

It is the text of the column Body of the table achievement_reward

Example

DELETE FROM `achievement_reward_locale` WHERE `ID`=13 AND `Locale`="esES";
INSERT INTO `achievement_reward_locale` (`ID`, `Locale`, `Subject`, `Text`) VALUES
(13, "esES", "Nivel 80", "Alcanza el nivel 80.");