mangos zero Diferent locales languajes support

[Locario]

Hi all.

I have compiled this core -> https://github.com/elysium-project/server i know, this is not MaNGOS Core.

When i start a new char, i can see items in my client language, in this case esES client, also i can read the quest in Spanish!!!

What need to be done in MaNGOS Core for this feature too?

Thanks all.

 

 

[Talendrys]

Hello, text database needs to be translated.

[Locario]

Hello, i found this, can this info help?:

https://github.com/elysium-project/server/pull/66

 

 

 

[Talendrys]

The answer is: it depends.

Some of the info is loaded from the DBC, this info is used client side and the server has no impact on the text there (I'm thinking of Maps, Cities, Dungeons, Spells, ..). Some others are directly retrieved from database, such as quests texts, creatures names, .. 

So, to support several locales, a slight code updates need to happen (provide the right locale text to the client) and a huge DB work needs to happen (translating every text of the database in fact) to internationalize mangos.

 

Not an easy task but you can participate if you wish

Tal'

[Locario]

It's possible that someone have ported that db texts and items names from another wow version?

I will try to learn how this ppl have quests and items translated.

[Talendrys]

Yeah, everything is possible  Just need to translate text btw

[Locario]

how i merge elysium db with mangos db locales? they have traslated many things

[Talendrys]

Mangos doesn't support multiple locale at this moment. You need to replace every string into the mangos world database schema to have it translated.

 

Tal'.

[Locario]

What tablets are necessary to work with it?

Thanks

[Talendrys]

I would say that I don't know. You need to go into the "World" schema database and check table by table.

I think that Creature tables, Gossip tables, Quests tables, are the first ones I've in mind but others may contained localized text too.

[Locario]

Ok.

I have found some texts, all in locales_* and more text only in English, in tables locales_* here is some rows : locale1, locale2 etc, each locale is one language.

I would port that info to MaNGOS DB, but if any another client connect to this "server" or "db" only will see one language if uses MaNGOS db.

Would be nice if MaNGOS copy that idea, let have locales for chinese, russian, french, english and spanish

 

 

 

 

 

[Talendrys]

Actually, Mangos has that in mind:

The only issue is that the size of t he DB will grow and that's a challenge. But you can learn and participate to that challenge

Tal'

[Locario]

Where i can start?

 

[Talendrys]

I think you understood the principle of the DB structure. You need to add extra-fields for multi-locale support (like you found on Elysium database) into the mangos database and propose back these queries to Mangos.

[Locario]

Ok, i will try to do that, many thanks!

EDIT : Do you know a good SQL Editor? HeidiSQL and SQLyog limits 1000 rows per table :-S

[Talendrys]

i do use Mysql workbench but it isnt the best tool I have ever seen.

[Locario]

Ok, i think i can export SQL files from Elysium db to populate MaNGOS db with locales work already done, seems easy but i need to learn how to do without mistakes. There is some tables with missing Spanish text as locale_npc_text each others.

I'm trying to figure out how to populate that Spanish info without be madness in a few minutes, if almost i have English texts peharps i have a chance.

[Talendrys]

Sorry, I'm editing this because writing from phone isn't easy

If you compare table by table and merge the records (the text part) based on the primary keys, you should be able to end-up with the content you need.

It's not a matter of minutes of work sadly

 

Tal'

[Locario]

2 hours ago, Talendrys said:

Sorry, I'm editing this because writing from phone isn't easy

If you compare table by table and merge the records (the text part) based on the primary keys, you should be able to end-up with the content you need.

It's not a matter of minutes of work sadly

 

Tal'

Hehe, i know.

I will try to have fun meanwhile, and my time let me do!