Join also our Discord channel! Click here.

Game of Thrones [Unreal 3 Engine and .db files]

The Original Forum. Game archives, full of resources. How to open them? Get help here.
User avatar
lostprophet
mega-veteran
mega-veteran
Posts: 198
Joined: Wed Apr 07, 2010 7:38 pm
Has thanked: 35 times
Been thanked: 5 times

Game of Thrones [Unreal 3 Engine and .db files]

Post by lostprophet » Thu May 17, 2012 9:55 am

So the game is available now, and as far as I know it stores the texts in .db files. I tried it with SQLite Browser, but this extension differs from other .db files.
I have the game, so if anyone would like to check these files, please drop a PM and I'll send it to you.
Hungarian translator and member of Indies4indies.com | Previous translations: http://lostprophet.hu

Gruselgurke
advanced
Posts: 73
Joined: Fri Mar 30, 2012 6:15 pm
Has thanked: 21 times
Been thanked: 2 times

Re: Game of Thrones [Unreal 3 Engine and .db files]

Post by Gruselgurke » Fri May 18, 2012 6:56 pm

It doesn't look like there are any other file types than the standard UE3 ones. I would check other threads about UE3 games, I'm sure you will find some scripts or tool to extract the .db files.

User avatar
lostprophet
mega-veteran
mega-veteran
Posts: 198
Joined: Wed Apr 07, 2010 7:38 pm
Has thanked: 35 times
Been thanked: 5 times

Re: Game of Thrones [Unreal 3 Engine and .db files]

Post by lostprophet » Sat May 19, 2012 9:54 am

The files are in the AGOTGame/Content/Localization directory. I haven't seen .db files used in an U3 engine game.
Hungarian translator and member of Indies4indies.com | Previous translations: http://lostprophet.hu

Ekey
M-M-M-Monster veteran
M-M-M-Monster veteran
Posts: 1737
Joined: Wed Mar 31, 2010 6:54 am
Has thanked: 85 times
Been thanked: 944 times

Re: Game of Thrones [Unreal 3 Engine and .db files]

Post by Ekey » Sat May 19, 2012 1:30 pm

I no have game but you can send me main executable with all modules and simple DB file.

dubh
n00b
Posts: 13
Joined: Mon May 23, 2011 9:34 am
Been thanked: 1 time

Re: Game of Thrones [Unreal 3 Engine and .db files]

Post by dubh » Sun May 20, 2012 3:00 pm

The .db and .cpl files are unique to this game. I believe the developers call them DataSheets.

You can decompress/extract the Unreal files (.u, .upk) with Gildor's decompress/extract tools.

You can also view decompressed Unreal files with UE Explorer.

AGOTGame.u in "\AGOTGame\CookedPC" seems to contain all of the DataSheet classes, which may help with figuring out the .db and .cpl files.

I believe the .db and .cpl files are what we need to be able to edit in order to mod the game.

User avatar
Haoose
mega-veteran
mega-veteran
Posts: 281
Joined: Tue Mar 01, 2011 9:34 pm
Has thanked: 70 times
Been thanked: 188 times
Contact:

Re: Game of Thrones [Unreal 3 Engine and .db files]

Post by Haoose » Mon May 21, 2012 8:02 am

Game texts in DB-files
I created program-converter from the DB to TXT and back. But it is still being tested. =)
-= GP-team =-
Image

User avatar
lostprophet
mega-veteran
mega-veteran
Posts: 198
Joined: Wed Apr 07, 2010 7:38 pm
Has thanked: 35 times
Been thanked: 5 times

Re: Game of Thrones [Unreal 3 Engine and .db files]

Post by lostprophet » Mon May 21, 2012 9:22 am

Haoose wrote:Game texts in DB-files
I created program-converter from the DB to TXT and back. But it is still being tested. =)
:up:
Hungarian translator and member of Indies4indies.com | Previous translations: http://lostprophet.hu

dubh
n00b
Posts: 13
Joined: Mon May 23, 2011 9:34 am
Been thanked: 1 time

Re: Game of Thrones [Unreal 3 Engine and .db files]

Post by dubh » Tue May 22, 2012 9:56 am

Haoose wrote:Game texts in DB-files
I created program-converter from the DB to TXT and back. But it is still being tested. =)
Can you release the .db to .txt converter? I don't need to convert back again yet.

User avatar
Haoose
mega-veteran
mega-veteran
Posts: 281
Joined: Tue Mar 01, 2011 9:34 pm
Has thanked: 70 times
Been thanked: 188 times
Contact:

Re: Game of Thrones [Unreal 3 Engine and .db files]

Post by Haoose » Tue May 22, 2012 10:21 am

dubh wrote:
Haoose wrote:Game texts in DB-files
I created program-converter from the DB to TXT and back. But it is still being tested. =)
Can you release the .db to .txt converter? I don't need to convert back again yet.
English Texts - http://www.mediafire.com/?51fkfk09a89de2g
-= GP-team =-
Image

dubh
n00b
Posts: 13
Joined: Mon May 23, 2011 9:34 am
Been thanked: 1 time

Re: Game of Thrones [Unreal 3 Engine and .db files]

Post by dubh » Tue May 22, 2012 1:56 pm

Haoose wrote:
dubh wrote:
Haoose wrote:Game texts in DB-files
I created program-converter from the DB to TXT and back. But it is still being tested. =)
Can you release the .db to .txt converter? I don't need to convert back again yet.
English Texts - http://www.mediafire.com/?51fkfk09a89de2g
How about the .db files in \AGOTGame\Content\DataSheets?

dubh
n00b
Posts: 13
Joined: Mon May 23, 2011 9:34 am
Been thanked: 1 time

Re: Game of Thrones [Unreal 3 Engine and .db files]

Post by dubh » Fri Jun 01, 2012 9:23 am

To mod the game, you need to be able to hook into UnrealScript, or recompile *.uc scripts and repackage AGOTGame.u.

For example, here's the function in the DataSheet_EntityPlayer.uc script that sets attribute minimums and maximums:

Code: Select all

function InitializePlayerCharacs(PawnEntity pPawn)
{
    local GameplayPlayer pPlayer;

    super.InitializePlayerCharacs(pPawn);

    pPlayer = pPawn.m_pGameplayPlayer;
    //Init MinMax Values
    pPlayer.m_aPlayerCharacs[Charac_Strength].fMin = 1;
    pPlayer.m_aPlayerCharacs[Charac_Strength].fMax = 15;
    pPlayer.m_aPlayerCharacs[Charac_Agility].fMin = 1;
    pPlayer.m_aPlayerCharacs[Charac_Agility].fMax = 15;
    pPlayer.m_aPlayerCharacs[Charac_Luck].fMin = 1;
    pPlayer.m_aPlayerCharacs[Charac_Luck].fMax = 15;
    pPlayer.m_aPlayerCharacs[Charac_Endurance].fMin = 1;
    pPlayer.m_aPlayerCharacs[Charac_Endurance].fMax = 15;
    pPlayer.m_aPlayerCharacs[Charac_Intelligence].fMin = 1;
    pPlayer.m_aPlayerCharacs[Charac_Intelligence].fMax = 15;

    pPlayer.ResetOriginalPlayerCharac(Charac_Strength,m_fStrength);
    pPlayer.ResetOriginalPlayerCharac(Charac_Agility,m_fAgility);
    pPlayer.ResetOriginalPlayerCharac(Charac_Luck,m_fChance);
    pPlayer.ResetOriginalPlayerCharac(Charac_Endurance,m_fEndurance);
    pPlayer.ResetOriginalPlayerCharac(Charac_Intelligence,m_fIntelligence);
}

User avatar
Haoose
mega-veteran
mega-veteran
Posts: 281
Joined: Tue Mar 01, 2011 9:34 pm
Has thanked: 70 times
Been thanked: 188 times
Contact:

Re: Game of Thrones [Unreal 3 Engine and .db files]

Post by Haoose » Fri Jun 01, 2012 10:41 am

Game of Thrones DB to TXT / TXT to DB Converter by Haoose
http://games-gen.com/soft/GT_DB_Converter.rar

Put the folder with the db-files
It supports only English and Russian alphabet!

List db-files:
  • Castlewood_zone_loc_INT.db
    Characters_loc_INT.db
    ClassesPostures_loc_INT.db
    Codex_loc_INT.db
    CombatItems_loc_INT.db
    CombatSystem_loc_INT.db
    Consoles_loc_INT.db
    Credits_loc_INT.db
    Default_loc_INT.db
    Global_loc_INT.db
    Items_loc_INT.db
    KingsLanding_zone_loc_INT.db
    Mole_zone_loc_INT.db
    Q01_ReturnCastleBlack_loc_INT.db
    Q02_ZomanDream_loc_INT.db
    Q03_MeetSerath_loc_INT.db
    Q04_RoyalHearing_loc_INT.db
    Q05_CrownsHounds_loc_INT.db
    Q06_RencontreJeyne_loc_INT.db
    Q07_EscapeWall_loc_INT.db
    Q08_MeetHarlton_loc_INT.db
    Q09_SpringwaterUnderworld_loc_INT.db
    Q10_MorsCapture_loc_INT.db
    Q11_Allester_Mors_loc_INT.db
    Q12_DownToAshes_loc_INT.db
    Q13_SpringBack_loc_INT.db
    Q14_SaveJeyne_loc_INT.db
    Q15_DownwardSpiral_loc_INT.db
    Q16_FinalDuel_loc_INT.db
    Q17_End_loc_INT.db
    QA_Arena_loc_INT.db
    QB_Newbies_loc_INT.db
    QC_Collector_loc_INT.db
    QD_WestfordMurder_loc_INT.db
    QE_SelfMadeGirl_loc_INT.db
    QF_Seven_loc_INT.db
    QG_SisterAct_loc_INT.db
    QH_NotSoWild_loc_INT.db
    QI_SerialKiller_loc_INT.db
    QJ_Events_loc_INT.db
    QL_Training_loc_INT.db
    Quests_loc_INT.db
    Sewers_zone_loc_INT.db
    SpringWater_zone_loc_INT.db
    TEST_loc_INT.db
    ThroneRoom_zone_loc_INT.db
    Tutorial_loc_INT.db
    Unique_Entities_loc_INT.db
    Wall_zone_loc_INT.db
    Zones_loc_INT.db
-= GP-team =-
Image

quattro65
beginner
Posts: 34
Joined: Sat Jan 21, 2012 4:23 pm
Has thanked: 2 times

Re: Game of Thrones [Unreal 3 Engine and .db files]

Post by quattro65 » Sat Jun 09, 2012 11:21 am

tnx haoose
or you can ask subtiles? RUS/PL AGOTGame/Content

User avatar
Haoose
mega-veteran
mega-veteran
Posts: 281
Joined: Tue Mar 01, 2011 9:34 pm
Has thanked: 70 times
Been thanked: 188 times
Contact:

Re: Game of Thrones [Unreal 3 Engine and .db files]

Post by Haoose » Sun Jun 10, 2012 3:30 pm

About format:
Pos: 0x51 - 4 bytes = "K"
K/8 = number of strings (Ex. in TEST_loc_INT.db: 0x51=>00 00 00 E8=>232 /8 = 29 strings)
Pos: 0xK+93 - start block with sizes of strings (Ex. in TEST_loc_INT.db: 232+93=>0x145)
Block sizes of strings (Size of block: 4 bytes*(K/8) )
Size block with strings (UTF-format) (4 bytes)
String1<00 00>String2<00 00>String3<00 00>...
Image
-= GP-team =-
Image

WederX
ultra-n00b
Posts: 2
Joined: Thu Jun 21, 2012 2:15 am
Has thanked: 3 times

Re: Game of Thrones [Unreal 3 Engine and .db files]

Post by WederX » Sun Jul 01, 2012 10:52 pm

hello, thanks for the tool made by you and shared in the forum. Is to upgrade the tool to accept caracters of the Portuguese of Brazil? the caracters :

á â ã à é ê í ó õ ô ú ü ç and Á Â Ã À É Ê Í Ó Õ Ô Ú Ü Ç

I'm translating the game for the Portuguese of Brazil, but without the accents caracters, translation impossible.

See how the file O AGOTGame.int

Image
http://i45.tinypic.com/auzjpw.png
Image

See how the file Q01_ReturnCastleBlack_loc_INT.txt

http://i47.tinypic.com/qxp28k.png
http://i47.tinypic.com/e3k2t.png
http://i47.tinypic.com/zspyeh.png

I'm translating the game A Game of Thrones: Genesis for the Portuguese of Brazil

http://i42.tinypic.com/15zrr49.png
http://i42.tinypic.com/11kuzo9.png
http://i46.tinypic.com/2w7k121.png

Download translation
http://www.mediafire.com/?01f7qpybpp4z0h7
Last edited by WederX on Tue Jul 10, 2012 3:12 am, edited 1 time in total.

Post Reply