Florix

Translation Of Quests

9 posts in this topic

 

Identification of column names


You will find all tables `locales_*` in these columns:
* _loc1: This column corresponds to the Korean client.
* _loc2: This column corresponds to the French client.
* _loc3: This column corresponds to the German client.
* _loc4: This column corresponds to the Chinese client.
* _loc5: This column corresponds to the Taiwanese client.
* _loc6: This column corresponds to the client Spanish (Spain).
* _loc7: This column corresponds to the client Spanish (Latin America).
* _loc8: This column corresponds to the Russian client.

*_loc10: This column corresponds to the Portuguese client.


 
English - no supplement is needed
 

Useful Tools - IMPORTANT


Here are some tools:
$B: line break
$N: character name (example: Welcome Name)
$R: character race (example: Welcome Pandaren)
$C: character class (example: Welcome Warrior)
$G: differentiates male and female. Put male first and then female (and a ":" in the middle)




 

Model of SQL Queries for the translation of quest



A quest is composed of 17 parts (and therefore 17 texts which could be translated):
  • Title: Quest name.
  • Details: Details of the quest.
  • Objectives: Objectives of the overall quest.
  • OfferRewardText: Text displayed while you are on the quest and talk to quest ender (objectives completed).
  • RequestItemsText: Text displayed while you are on the quest and talk to quest ender (objectives not completed).
  • EndText: untreated
  • CompletedText: untreated
  • ObjectiveText1: Objective 1
  • ObjectiveText2: Objective 2
  • ObjectiveText3: Objective 3
  • ObjectiveText4: Objective 4
  • QuestGiverTextWindow: untreated
  • QuestGiverTargetName: untreated
  • QuestTurnTextWindow: untreated
  • QuestTurnTargetName: untreated

I will not give you an example from in game with screenshots, instead I will show you how to do it directly from SQL queries:
 
Note: following example is for translation to French, if you are translating quest to Spanish use _loc6.

Title:
 

UPDATE locales_quest SET `Title_loc2`="#1" WHERE `entry`='#2';
/* Where:
#1 is the name of the quest
#2 corresponds to the Id of the quest (wowhead) */

Details:
 

UPDATE locales_quest SET `Details_loc2`="#1" WHERE `entry`='#2'; 
/* Where:
#1 corresponds to the details of the quest
#2 corresponds to the Id of the quest (wowhead) */

Objectives:
 

UPDATE locales_quest SET `Objectives_loc2`="#1" WHERE `entry`='#2';
/* Where:
#1 corresponds to the objectives of the quest
#2 corresponds to the Id of the quest (wowhead) */

OfferRewardText:
 

UPDATE locales_quest SET `OfferRewardText_loc2`="#1" WHERE `entry`='#2';
/* Where:
#1 is the text displayed while on the quest with the objectives completed (Quest Completed)
#2 corresponds to the Id of the quest (wowhead) */

RequestItemsText:
 

UPDATE locales_quest SET `RequestItemsText_loc2`="#1" WHERE `entry`='#2';
/* Where:
#1 is the text displayed while quest has unfinished objective (Quest Not completed)
#2 corresponds to the Id of the quest (wowhead) */

ObjectiveText1:
 

UPDATE locales_quest SET `ObjectiveText1_loc2`="#1" WHERE `entry`='#2';
/ * Where:
#1 is the text of Objective 1
#2 corresponds to the Id of the quest (wowhead) */

ObjectiveText2:
 

UPDATE locales_quest SET `ObjectiveText2_loc2`="#1" WHERE `entry`='#2';
/* Where:
#1 is the text of Objective 2
#2 corresponds to the Id of the quest (wowhead) */

ObjectiveText3:
 

UPDATE locales_quest SET `ObjectiveText3_loc2`="#1" WHERE `entry`='#2';
/* Where:
#1 is the text of Objective 3
#2 corresponds to the Id of the quest (wowhead) */

ObjectiveText4:
 

UPDATE locales_quest SET `ObjectiveText4_loc2`="#1" WHERE `entry`='#2';
/* Where:
#1 is the text of Objective 4
#2 corresponds to the Id of the quest (wowhead) */



Take this quest for an example:  À la recherche du varech

Example
  • Title: À la recherche du varech
  • Details: Je peux préparer une potion d'invisibilité pour Maybell, qui lui permettra de s'échapper du vignoble des Maclure et de rejoindre Tommy Joe. Mais pour préparer cette potion, j'ai besoin de varech cristallin.$B$BCette plante pousse habituellement dans l'océan, mais parfois les murlocs en récoltent. Il faut aller voir si les murlocs près du lac de Cristal n'en auraient pas en ce moment. Le lac de Cristal est à l'est de Comté-de-l’Or.
  • Objectives: Apportez 4 Feuilles de Varech cristallin à William Pilon de Comté-de-l’Or.
  • OfferRewardText: Vous avez les feuilles. Bien joué ! Maintenant, juste un instant, le temps que je concocte la potion...
  • RequestItemsText: Avez-vous ce varech cristallin ? Je suis sûr que Maybell est impatiente de voir son galant...
  • ObjectiveText1: Feuille de varech cristallin

Original Topic: http://community.pandashan.com/index.php?/topic/26926-translation-of-quests/#entry156205 

3 people like this

Share this post


Link to post
Share on other sites

very good is difficult FIND this information

 

Share this post


Link to post
Share on other sites

And about portuguese translate?

 

Share this post


Link to post
Share on other sites
13 hours ago, mkdinho said:

And about portuguese translate?

 

_loc10 = portuguese

Share this post


Link to post
Share on other sites

and for Italian?

Share this post


Link to post
Share on other sites

_loc=9 (from MoP) = Italian

Share this post


Link to post
Share on other sites
Locale  Index
------  -----
 enUS     0  (default enGB)
 koKR     1
 frFR     2
 deDE     3
 zhCN     4
 zhTW     5
 esES     6
 esMX     7
 ruRU     8
 itIT     9  (MoP only)
 ptBR    10  (MoP only)
 ptPT    11  (MoP only)

Share this post


Link to post
Share on other sites
On 10/5/2015 at 4:58 PM, Florix said:

 

Identification of column names


You will find all tables `locales_*` in these columns:
* _loc1: This column corresponds to the Korean client.
* _loc2: This column corresponds to the French client.
* _loc3: This column corresponds to the German client.
* _loc4: This column corresponds to the Chinese client.
* _loc5: This column corresponds to the Taiwanese client.
* _loc6: This column corresponds to the client Spanish (Spain).
* _loc7: This column corresponds to the client Spanish (Latin America).
* _loc8: This column corresponds to the Russian client.

*_loc10: This column corresponds to the Portuguese client.

 

*_loc9: This column corresponds to the Italian client
*_loc11: This column corresponds to the prBR client

Share this post


Link to post
Share on other sites

For anyone interested (especially French and Spanish players)

text values always have to be put between two ' for example:

`Title_loc2`='Une Lumière purificatrice',


When there's a  (  '  ) in the text normally, you need to put a \ in front of the ' otherwise it will end the value there (because the value is between two of them). For example:

`Details_loc2`='Ce temple est l\'un des endroits les plus sacrés de toute l\'Outreterre.',

Hope this helps! Also, the line break ($B) is only one 'enter' so if there is an empty line between two text lines on wowhead/retail, you need to put two line breaks next to each other. for example:
 

'The Timbermaw tend to stay to themselves, $N. While we do allow safe passage to those that have proven they can be trusted, we try to avoid other furbolg tribes if at all possible.$B$BLately I have noticed that the Winterfall tribe has become increasingly hostile towards us. They seem to be in a state of rage, completely engulfed by their own fear and hatred of anything they do not understand.$B$BIf you could reduce their numbers this would help us greatly, $N.',


Hope that helps!
Narf
 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now