Posted October 5, 2015 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
Posted January 17, 2016 very good is difficult FIND this information Share this post Link to post Share on other sites
Posted April 11, 2016 And about portuguese translate? Share this post Link to post Share on other sites
Posted April 12, 2016 13 hours ago, mkdinho said: And about portuguese translate? _loc10 = portuguese Share this post Link to post Share on other sites
Posted April 12, 2016 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
Posted March 1, 2020 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
Posted August 20, 2020 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