[Request] Implement locale : db_translation_version

[Auntie Mangos]

http://getmangos.eu/community/showthread.php?p=74241#post74241

[yad02]

Is it possible to add a new table in world (and probably later scriptdev2) database ?

A new table "db_translation_version"

`loc1`

`loc2`

`loc3`

`loc4`

`loc5`

`loc6`

`loc7`

`loc8`

And if is it possible to implement it at mangosd loading...

It is just an idea

[XTZGZoReX]

Uhm... What is a traduction...?

[yad02]

Oh sorry : translation

[XTZGZoReX]

Ah. So a localized db_version it is?

[VladimirMangos]

Yes, what meaning: version of translation or translation of version

[yad02]

Yes, what meaning: version of translation or translation of version

In fact something like (in SQL with french translation)

For file (release) : UDBFR_0.0.6_MaNGOS_7685.sql

UPDATE db_translation_version SET loc2 = 'UDBFR 0.0.6 Rev 28';

For file (update) : 029_mangos_7714.sql

UPDATE db_translation_version SET loc2 = 'UDBFR 0.0.6 Rev 29';

etc...

At mangos loading : something like 'Loc2 Translation is : UDBFR 0.0.6 Rev 29' (if loc2 isn't empty)

It can be interesting to have all locX.

However does all translation project use a version number ?

Reference to UDB is just for example

Note : french use loc2

[XTZGZoReX]

I suggest only show the current server global locale used.

[yad02]

I'm agree, however does the multilinguage servers exist ?

If I can create a server with a multilanguage support, is it normal to store all version in db and to show all language revision number at loading.

Else just a new column in db_version table is needed

[XTZGZoReX]

If we want localization, we should at least do it properly and use all locales columns.

[yad02]

Another question :

These fields `loc1``loc2``loc3``loc4``loc5``loc6``loc7``loc8` must get a new table (db_translation_version) or they can be added to already existed table : db_version ?

[yad02]

Any news ?

Do I post a cleanup code with all features in "under review" section ?