[Archive] Quest Language???
[Archive] Quest Language???
Original source
How can I translate quest to another language? spanish :innocent:
rektbyfaith
11-04-2025, 05:14 PM #1Archived author: Zotto • Posted: 2025-11-04T18:14:42.982502
Original source
How can I translate quest to another language? spanish :innocent:
Original source
Quote:Zotto said:I could be wrong on this, as I've never done this before, but I have an idea, and it seems fairly easy.
How can I translate quest to another language? spanish :innocent:
Click to expand...
Make sure you have a Database editing program, such as HeidiSQL.
Open your server, then open HeidiSQL and log in, then under the 'world' database (I can't remember the full name in the v7 repack, just whatever has 'World' in it) look for the table: 'quest_template'
Find the columns 'OfferRewardText', 'RequestItemsText', 'CompletedText'
That's all you need to edit to translate a quest, I believe.
Just translate whatever needs to be translated, but make sure to keep specific parts, such as "$N" or "$B" or "$C", etc. Those refer to specific names, such as your character name, and item name, that NPC's name, or something similar.
rektbyfaith
11-04-2025, 05:14 PM #2Archived author: Zotto • Posted: 2025-11-04T18:14:42.982502
Original source
Quote:Zotto said:I could be wrong on this, as I've never done this before, but I have an idea, and it seems fairly easy.
How can I translate quest to another language? spanish :innocent:
Click to expand...
Make sure you have a Database editing program, such as HeidiSQL.
Open your server, then open HeidiSQL and log in, then under the 'world' database (I can't remember the full name in the v7 repack, just whatever has 'World' in it) look for the table: 'quest_template'
Find the columns 'OfferRewardText', 'RequestItemsText', 'CompletedText'
That's all you need to edit to translate a quest, I believe.
Just translate whatever needs to be translated, but make sure to keep specific parts, such as "$N" or "$B" or "$C", etc. Those refer to specific names, such as your character name, and item name, that NPC's name, or something similar.
Original source
I thought the locales tables had the translations to other languages in them? First I would make sure that my locale is set in the conf files. So the server knows its supposed to use spanish. Then test and see what happens.
rektbyfaith
11-04-2025, 05:14 PM #3Archived author: Zotto • Posted: 2025-11-04T18:14:42.982502
Original source
I thought the locales tables had the translations to other languages in them? First I would make sure that my locale is set in the conf files. So the server knows its supposed to use spanish. Then test and see what happens.
Original source
Quote:eyerobot said:I thought that was just the client's translations, meaning only text in the login screen, settings/interface, etc.
I thought the locales tables had the translations to other languages in them? First I would make sure that my locale is set in the conf files. So the server knows its supposed to use spanish. Then test and see what happens.
Click to expand...
I say this because I don't think the client contains all the quest text in it. I'm pretty sure it's set up somewhere in the database, if not where I suggested in my previous post. Else how would you make custom quests with custom text?
rektbyfaith
11-04-2025, 05:14 PM #4Archived author: Zotto • Posted: 2025-11-04T18:14:42.982502
Original source
Quote:eyerobot said:I thought that was just the client's translations, meaning only text in the login screen, settings/interface, etc.
I thought the locales tables had the translations to other languages in them? First I would make sure that my locale is set in the conf files. So the server knows its supposed to use spanish. Then test and see what happens.
Click to expand...
I say this because I don't think the client contains all the quest text in it. I'm pretty sure it's set up somewhere in the database, if not where I suggested in my previous post. Else how would you make custom quests with custom text?
Original source
I have no idea, If that's true then the only easy option would be to find a repack that's already translated, Or copy their quest text into your database.
rektbyfaith
11-04-2025, 05:14 PM #5Archived author: Zotto • Posted: 2025-11-04T18:14:42.982502
Original source
I have no idea, If that's true then the only easy option would be to find a repack that's already translated, Or copy their quest text into your database.
Original source
It is easy the translation is done in the table locales_quest.
The fields 6 and 7 are the ones used for Spanish, one is for esES and the other for esMX, check in your client which of the 2 is the one you have.
Examples:
Title_loc6
Details_loc7
Objectives_loc7
rektbyfaith
11-04-2025, 05:14 PM #6Archived author: Zotto • Posted: 2025-11-04T18:14:42.982502
Original source
It is easy the translation is done in the table locales_quest.
The fields 6 and 7 are the ones used for Spanish, one is for esES and the other for esMX, check in your client which of the 2 is the one you have.
Examples:
Title_loc6
Details_loc7
Objectives_loc7
1 Guest(s)
1 Guest(s)