Page 1 of 2

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

Posted: Thu May 17, 2012 9:55 am
by lostprophet
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.

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

Posted: Fri May 18, 2012 6:56 pm
by Gruselgurke
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.

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

Posted: Sat May 19, 2012 9:54 am
by lostprophet
The files are in the AGOTGame/Content/Localization directory. I haven't seen .db files used in an U3 engine game.

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

Posted: Sat May 19, 2012 1:30 pm
by Ekey
I no have game but you can send me main executable with all modules and simple DB file.

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

Posted: Sun May 20, 2012 3:00 pm
by dubh
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.

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

Posted: Mon May 21, 2012 8:02 am
by Haoose
Game texts in DB-files
I created program-converter from the DB to TXT and back. But it is still being tested. =)

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

Posted: Mon May 21, 2012 9:22 am
by lostprophet
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:

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

Posted: Tue May 22, 2012 9:56 am
by dubh
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.

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

Posted: Tue May 22, 2012 10:21 am
by Haoose
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

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

Posted: Tue May 22, 2012 1:56 pm
by dubh
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?

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

Posted: Fri Jun 01, 2012 9:23 am
by dubh
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);
}

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

Posted: Fri Jun 01, 2012 10:41 am
by Haoose
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

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

Posted: Sat Jun 09, 2012 11:21 am
by quattro65
tnx haoose
or you can ask subtiles? RUS/PL AGOTGame/Content

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

Posted: Sun Jun 10, 2012 3:30 pm
by Haoose
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

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

Posted: Sun Jul 01, 2012 10:52 pm
by WederX
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