Forums WoW Modding Discussion Miscellaneous [Archive] Localisation questions. Where to find corresponding fields

[Archive] Localisation questions. Where to find corresponding fields

[Archive] Localisation questions. Where to find corresponding fields

rektbyfaith
Administrator
0
11-04-2025, 05:10 PM
#1
Archived author: Feuerdraht • Posted: 2025-11-04T18:10:51.702369
Original source

Hi all.

1st of all: Thanks to all of you, contributing to this nice community!

I have the project of having my cata-Server (only used for me, myself and i) completely localised in German language.

Even though i speak english, french and german fluently, I want to have EVERYTHING in the corresponding language when playing.

So, when i use my german client, i want everything to be in German.

I am using emucoach V12 for my project and i was very happ to find, that most of it is already localised.

But i found some fields, which are not localised or even i dont find the corresponding field in the database...

So perhaps someone from the community can clarify a few things for me [Image: 1f609.png]

A lot of localisation is already inside the db. Thats great. But:

Some fields are not filled and i could not find any translation nowhere in the web, so i decided to do them on my own.

The fields that with missing locales i found until now are:

objectivetext1 in table quest_template (here i cant even find the corresponding field in the locales_quest.)

OfferRewardText_loc3 in table locales_quest

RequestItemsText_loc3 in table locales_quest

text0_0_loc3 , text 1_0_loc3 , text_2_0_loc3 in table locales_npc_text

option_text_loc3 in table locales_gossip_menu_option

text_loc3 in table locales_creature_text ! depends on groupid, id

For some things eG: Innkeeper Belm in Kharanos -> "I'd like to browse your goods" I cant even find the text string nor where to translate it.

Questions:

- Does someone know if somewhere translations for locale 3 (German) for the fields "OfferReardText_loc3" , "RequestItemsText_loc3" , ... (see above) exist?

I have not found anything in the web, but perhaps one of you know better [Image: 1f642.png]

- Does someone know, where the translation / locale for field "objectivetext1" in table quest_template should go to? I could not find a filed [Image: 1f641.png]

When i advance my project, i will be happy to share all the translations, that i did.

A nice day for all of you.

Feuerdraht
rektbyfaith
11-04-2025, 05:10 PM #1

Archived author: Feuerdraht • Posted: 2025-11-04T18:10:51.702369
Original source

Hi all.

1st of all: Thanks to all of you, contributing to this nice community!

I have the project of having my cata-Server (only used for me, myself and i) completely localised in German language.

Even though i speak english, french and german fluently, I want to have EVERYTHING in the corresponding language when playing.

So, when i use my german client, i want everything to be in German.

I am using emucoach V12 for my project and i was very happ to find, that most of it is already localised.

But i found some fields, which are not localised or even i dont find the corresponding field in the database...

So perhaps someone from the community can clarify a few things for me [Image: 1f609.png]

A lot of localisation is already inside the db. Thats great. But:

Some fields are not filled and i could not find any translation nowhere in the web, so i decided to do them on my own.

The fields that with missing locales i found until now are:

objectivetext1 in table quest_template (here i cant even find the corresponding field in the locales_quest.)

OfferRewardText_loc3 in table locales_quest

RequestItemsText_loc3 in table locales_quest

text0_0_loc3 , text 1_0_loc3 , text_2_0_loc3 in table locales_npc_text

option_text_loc3 in table locales_gossip_menu_option

text_loc3 in table locales_creature_text ! depends on groupid, id

For some things eG: Innkeeper Belm in Kharanos -> "I'd like to browse your goods" I cant even find the text string nor where to translate it.

Questions:

- Does someone know if somewhere translations for locale 3 (German) for the fields "OfferReardText_loc3" , "RequestItemsText_loc3" , ... (see above) exist?

I have not found anything in the web, but perhaps one of you know better [Image: 1f642.png]

- Does someone know, where the translation / locale for field "objectivetext1" in table quest_template should go to? I could not find a filed [Image: 1f641.png]

When i advance my project, i will be happy to share all the translations, that i did.

A nice day for all of you.

Feuerdraht

rektbyfaith
Administrator
0
11-04-2025, 05:10 PM
#2
Archived author: Feuerdraht • Posted: 2025-11-04T18:10:51.702369
Original source

Hey, i can't help you directly, but as a base it may help to look at this one: German Trinity DataBase download | SourceForge.net

it's old, the structure may have changed, but it's a start
rektbyfaith
11-04-2025, 05:10 PM #2

Archived author: Feuerdraht • Posted: 2025-11-04T18:10:51.702369
Original source

Hey, i can't help you directly, but as a base it may help to look at this one: German Trinity DataBase download | SourceForge.net

it's old, the structure may have changed, but it's a start

rektbyfaith
Administrator
0
11-04-2025, 05:10 PM
#3
Archived author: Feuerdraht • Posted: 2025-11-04T18:10:51.702369
Original source

Hey. Thanks for the hint. I already found GTDB and it contains a lot of good localisation.

To be honest: Emucoach (in my case V12) does also already contain a lot of good localisation. *thumbsup*

Only a few fields (like eg OfferReardText_loc3 , RequestItemsText_loc3) and some gossip does not have any other locale than EN.

And for some fields I cant find a field to put the locale in, like objectivetext1... and i dont want to just overwrite the EN...

Thanks again for mentioning GTDB. I already took some out of it...

Have great day.
rektbyfaith
11-04-2025, 05:10 PM #3

Archived author: Feuerdraht • Posted: 2025-11-04T18:10:51.702369
Original source

Hey. Thanks for the hint. I already found GTDB and it contains a lot of good localisation.

To be honest: Emucoach (in my case V12) does also already contain a lot of good localisation. *thumbsup*

Only a few fields (like eg OfferReardText_loc3 , RequestItemsText_loc3) and some gossip does not have any other locale than EN.

And for some fields I cant find a field to put the locale in, like objectivetext1... and i dont want to just overwrite the EN...

Thanks again for mentioning GTDB. I already took some out of it...

Have great day.

rektbyfaith
Administrator
0
11-04-2025, 05:10 PM
#4
Archived author: Feuerdraht • Posted: 2025-11-04T18:10:51.702369
Original source

Hi@all. I am still working on my "German Localisation" Project and i am advancing slowly, but advancing [Image: 1f609.png]

When there is more to share, i will share my DB , if anybody wants to play in German language [Image: 1f609.png]

I have still not figured out, why there seems to be no field for locale/translation of database-field : objectivetext1 ....

So if someone know where to translate this field (insted of overwriting ) ... any hint would be highly appreciated.

Greetz
rektbyfaith
11-04-2025, 05:10 PM #4

Archived author: Feuerdraht • Posted: 2025-11-04T18:10:51.702369
Original source

Hi@all. I am still working on my "German Localisation" Project and i am advancing slowly, but advancing [Image: 1f609.png]

When there is more to share, i will share my DB , if anybody wants to play in German language [Image: 1f609.png]

I have still not figured out, why there seems to be no field for locale/translation of database-field : objectivetext1 ....

So if someone know where to translate this field (insted of overwriting ) ... any hint would be highly appreciated.

Greetz

rektbyfaith
Administrator
0
11-04-2025, 05:10 PM
#5
Archived author: Feuerdraht • Posted: 2025-11-04T18:10:51.702369
Original source

Quote:Feuerdraht said:

Hi@all. I am still working on my "German Localisation" Project and i am advancing slowly, but advancing [Image: 1f609.png]

When there is more to share, i will share my DB , if anybody wants to play in German language [Image: 1f609.png]

I have still not figured out, why there seems to be no field for locale/translation of database-field : objectivetext1 ....

So if someone know where to translate this field (insted of overwriting ) ... any hint would be highly appreciated.

Greetz

Click to expand...
Hello! Same problem. I have still not figured out, why there seems to be no field for locale/translation of database-field : objectivetext1

Have you solved the problem? Did you know where to look? Thank you.
rektbyfaith
11-04-2025, 05:10 PM #5

Archived author: Feuerdraht • Posted: 2025-11-04T18:10:51.702369
Original source

Quote:Feuerdraht said:

Hi@all. I am still working on my "German Localisation" Project and i am advancing slowly, but advancing [Image: 1f609.png]

When there is more to share, i will share my DB , if anybody wants to play in German language [Image: 1f609.png]

I have still not figured out, why there seems to be no field for locale/translation of database-field : objectivetext1 ....

So if someone know where to translate this field (insted of overwriting ) ... any hint would be highly appreciated.

Greetz

Click to expand...
Hello! Same problem. I have still not figured out, why there seems to be no field for locale/translation of database-field : objectivetext1

Have you solved the problem? Did you know where to look? Thank you.

rektbyfaith
Administrator
0
11-04-2025, 05:10 PM
#6
Archived author: Feuerdraht • Posted: 2025-11-04T18:10:51.702369
Original source

Quote:Feuerdraht said:

Hi@all. I am still working on my "German Localisation" Project and i am advancing slowly, but advancing [Image: 1f609.png]

When there is more to share, i will share my DB , if anybody wants to play in German language [Image: 1f609.png]

I have still not figured out, why there seems to be no field for locale/translation of database-field : objectivetext1 ....

So if someone know where to translate this field (insted of overwriting ) ... any hint would be highly appreciated.

Greetz

Click to expand...
Something new information?
rektbyfaith
11-04-2025, 05:10 PM #6

Archived author: Feuerdraht • Posted: 2025-11-04T18:10:51.702369
Original source

Quote:Feuerdraht said:

Hi@all. I am still working on my "German Localisation" Project and i am advancing slowly, but advancing [Image: 1f609.png]

When there is more to share, i will share my DB , if anybody wants to play in German language [Image: 1f609.png]

I have still not figured out, why there seems to be no field for locale/translation of database-field : objectivetext1 ....

So if someone know where to translate this field (insted of overwriting ) ... any hint would be highly appreciated.

Greetz

Click to expand...
Something new information?

Recently Browsing
 1 Guest(s)
Recently Browsing
 1 Guest(s)