These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Japanese item descriptions?

Author
Blips Creeps
Doomheim
#1 - 2013-01-23 05:45:46 UTC
Not sure where to put this, but I guess maybe this is the right place? I was hoping to get together a bit Japanese text file to grep through for example sentences and Eve seemed like a natural choice, since, to the best of my knowledge, the description for every item in the game has been translated and CCP isn't strict about the usage of the text from the game. One such example, Autotrophs:

日本語:食物連鎖の最下層にあり、上位の生命体が消費する炭水化物、タンパク質、脂質を生成する独立栄養生物。適切に収集して整えると、工業繊維に加工し、高度な素材テクノロジーに適用することもできる。

English:At the very bottom of the food chain are autotrophs, those organisms that produce carbohydrates, proteins, and fats for higher life forms to consume. When properly gathered and ordered, they can be plied into industrial fibers, which then go on to contribute to advanced material technologies.

The above one I copied from the Japanese client. For the bottom one, I used:

SELECT [typeName]
,[description]
FROM [RetributionDB].[dbo].[invTypes]
where typeName like '%Autotrophs%'

The following returns no results sadly:

SELECT [text]
FROM [RetributionDB].[dbo].[trnTranslations]
where languageID = 'JA' and text like '%炭水化物%'

So is there a way to gather this text short of copying and pasting(Shocked) each of the thousands of item descriptions from the client? Is there a similar column to [description] for the other languages?

Thank you for your time!