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

[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.

[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.

[lostprophet]

The files are in the AGOTGame/Content/Localization directory. I haven't seen .db files used in an U3 engine game.

[Ekey]

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

[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.

[Haoose]

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

[lostprophet]

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

[dubh]

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.

[Haoose]

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

[dubh]

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]

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);
}

[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

[quattro65]

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

[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>...

[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


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


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