Home
News Highlights
Older News
FFXI Guides
Items
Armor
Weapons
Food
Conquest Points
Furniture
Abjuration
Advanced Search


Quests
Missions
Mini-Quests


Mobs
NM Guide


NPC/Merchant
Merchants Guide
Regional Merchants


Zones
ENM
BCNM
FFXI Map Locations
Chests & Coffers
Guild Recipes
Recipes by Guild
Gardening
Chocobo Digging
Fishing
Excavating
Harvesting
Logging
Mining


Spells
Display by Job


Weaponskills
Skill Limits
Fame Tips and Titles
FFXI Links
Submit Feedback
About
User Account


Total: 405168205
Today: 23014
Yesterday: 12912

Items: 9505
Mobs: 4024
Recipes: 3285
NPCs: 2066
Quests: 570

Final Fantasy XI Discussion BoardDiscussion Boards -> Site Comments, Updates, and Corrections

Serious project : multi-language items

From: Pulsahr
Registered User

Posted: 2007-03-10 04:51:32
Reply
Quote
It's been nearly one year i'm playing FFXI, and it is useless to say how much Somepage helped me getting info for items, npc, quest, and so on...

Since the last update, i'm glad to see all npc's chat in french, so i don't have to make an effort to understand. But all items, quest, and everything are also translated, and it is a problem when you're looking for special quest item, or anything like that.

What i am about to submit, is something about translating items on somepage. I can provide many translations in french,but let me explain technically how i thought about this :

For example, when you search for an item, your search return a list of items, what about opening a second list below the first, with the result of search in french items ?


What i thought about database :
I suppose you have IDs for each item in your database, so i thought about creating a new table (let's call it fr_items) for french names and description, where id field is the same as in the existing table.

This can be useful in many ways : in a description item (or even in the list search result), there can be a link like [fr], which the result link is defined with a left join on the fr_items table (left join because i suppose that not all items will have their translation).


That's how i thought about all this. I hope my english is good enough for you to understand what i'm trying to explain ^^;


Of course, i'm not asking for an acess to your database, how could you trust someone you don't know at all? So i thought about a basic form, that could fill the french table items, quest, and all.

If you think this project is worth a try, or want to know more about me, feel free to email me, or add me to msn contacts. My email is pulsahr at hotmail dot com.


Stephane, 30 years old, student in computer science.
From: Cuer
Administrator

Posted: 2007-03-11 21:44:55
Reply
Quote
Thanks for the suggestion; it is a very good one, and something we'd like to look at down the road.
Sponsors

Order: Final Fantasy XI Online: Wings of the Goddess Expansion Pack (PC)(PS2)(XBOX 360)
somepage.com privacy policy
All original content and graphics © 2004-2010 Somepage.com, Inc.. All FFXI content and images © 2002-2010 SQUARE ENIX CO., LTD. FINAL FANTASY is a registered trademark of Square Enix Co., Ltd..