artesprosoul, posted Sun Apr 10, 2022 10:29 am (71002)

---

s2006004 wrote:

The text seem stored in EFGame_Extra\ClientData\TableData\EFTable_GameMsg.db, you can check it by notepad.

There's no such directory as EFGame_Extra in Steam client. Only EFGame.

s2006004, posted Sun Apr 10, 2022 3:58 pm (71024)

---

artesprosoul wrote:

s2006004 wrote:

The text seem stored in EFGame_Extra\ClientData\TableData\EFTable_GameMsg.db, you can check it by notepad.

There's no such directory as EFGame_Extra in Steam client. Only EFGame.

you have to decrypt the lpk file.
you can find the method on page 7 in this post.

elegos wrote:

Hello!

I'm new to game client hacking and I'm a little confused.

What I want to achieve: extract bitmaps (skills, maps etc), data info (skill names and props, item names and props, mob names etc) from the Lost Ark game
What I've done so far: I've downloaded and unarchived QuickBMS, downloaded the bms file on page 6 and tried the following command:

Code:

.\quickbms.exe .\scripts\lpk_extract_v2_fix.bms 'C:\Program Files (x86)\Steam\steamapps\common\Lost Ark\EFGame\ReleasePC\Packages' "C:\LostArk_packages"

The result:

Code:

QuickBMS generic files extractor and reimporter 0.11.0
by Luigi Auriemma
e-mail: [email protected]
web:    aluigi.org
        (Apr  5 2021 - 13:56:34)

                          quickbms.com  Homepage
                            zenhax.com  ZenHAX Forum
                     @zenhax @quickbms  Twitter & Scripts

- start the scanning of the input folder: C:\Program Files (x86)\Steam\steamapps\common\Lost Ark\EFGame\ReleasePC\Packages
- open input file C:\Program Files (x86)\Steam\steamapps\common\Lost Ark\EFGame\ReleasePC\Packages\.\07F8Q0K8X0JS8DCXQ6WK8XX0CM5JYDYE40.upk
- open script .\scripts\lpk_extract_v2_fix.bms
- set output folder C:\LostArk_packages
- the folder doesn't exist, do you want to create it (y/N)?:
  y

  offset   filesize   filename
--------------------------------------

Error: incomplete input file 0: C:\Program Files (x86)\Steam\steamapps\common\Lost Ark\EFGame\ReleasePC\Packages\07F8Q0K8X0JS8DCXQ6WK8XX0CM5JYDYE40.upk
       Can't read 934261218 bytes from offset 00000c32.
       Anyway don't worry, it's possible that the BMS script has been written
       to exit in this way if it's reached the end of the archive so check it
       or contact its author or verify that all the files have been extracted.
       Please check the following coverage information to know if it's ok.

  coverage file 0   100%   3122       3122       . offset 00000c32

Last script line before the error or that produced the error:
  15  log MEMORY_FILE 4 SIZE

- OFFSET       0x00000004
- SIZE         0x37afbe10
  coverage file 0   100%   3122       3122       . offset 00000c32

What am I doing wrong? I saw someone suggesting to use umodel, but isn't it a tool to view 3d models?

Thanks

EDIT: actually I just manually selected all the lpk files and it worked fine. Now the question is: how to read the db files? According to the header it's a standard SQLite3 file, but with 16 reserved bytes at each page, which means they're using some kind of extension (not excluded an encrypting one). Also there are no bitmaps, but "loa" and "epf" files. Do you have any clue on what they are?

artesprosoul, posted Sun Apr 10, 2022 4:40 pm (71026)

---

s2006004 wrote:

you have to decrypt the lpk file.
you can find the method on page 7 in this post.

Oh, so it's impossible to just copy and paste encrypted language packages from RU client to Steam client due to different encryption method or something?

spiritovod, posted Sun Apr 10, 2022 5:21 pm (71032)

---

@artesprosoul: Yes, steam version and versions for other regions (ru, kr, jp) are using different encryption keys, even though the scheme is the same. In the same time, I suppose decrypted databases are cross-compatible between different versions, because tools like LaoTranslation are doing exactly that.

========================================

Here is test script for packing files into lpk.
Edit: Script and notes are moved to the original post: viewtopic.php?f=9&t=2969&p=69954#p69954

spiritovod, posted Mon Apr 25, 2022 1:36 am (71272)

---

Updated script for repacking lpk is added to the original post: viewtopic.php?f=9&t=2969&p=69954#p69954

Read notes in that post for more info.

a652311, posted Mon Apr 25, 2022 6:12 am (71278)

---

spiritovod wrote:

Updated script for repacking lpk is added to the original post: viewtopic.php?f=9&t=2969&p=69954#p69954

Read notes in that post for more info. It's still not tested with actual game though.

Thank you for your big work:), but for me, repack bms v1 and v2 not working. I using ru version.

update: Sorry, I am a rookie for this, it should be i don't have aligned to 0x100 for database.

Also, I trying to decrypt the EFTable_GameMsg.db, Someone can give me some advice or hints?

spiritovod, posted Mon Apr 25, 2022 4:11 pm (71288)

---

Just tested the updated repacking script on ru client - simple re-import of unmodified files works fine and modified archive doesn't break or corrupt the game, which means script is producing compatible archives. The rest depends on particular files, for example, databases seems to have internal integrity checks.

It's highly recommended to always import into original archive to avoid possible issues with re-re-import stuff - though it's fine if you're importing different files each time.

JonnyPhaminator, posted Thu Apr 28, 2022 5:31 pm (71330)

---

Does anyone know how to extract the BNK files? I want to be able to extract voice files from the Beserker class and i can't find a proper extractor that extracts these files...

spiritovod, posted Thu Apr 28, 2022 6:37 pm (71333)

---

@JonnyPhaminator: You need latest LAUTool from page 6, decrypted files should be playable with latest foobar vgmstream.

Supamiu, posted Sun May 08, 2022 3:56 pm (71462)

---

Hi there, thanks to the amazing scripts you provided, I managed to extract the .db files but they are encrypted with an unknown SQLite3 plugin, did anyone manage to decrypt them or find the plugin/key combination?

I kind of expect it to be in the exe somewhere, but that's about it :/

prixone, posted Tue May 10, 2022 6:51 am (71478)

---

Would some one be so kind to help me out extracting the steam files for Lost Ark?

I have used LAUTool to decrypt the files, no error were shown, I placed all the dec files in a separated folder than I tried running the lpk_extract_v2_fix.bms and I still get this error:

Code:

Error: incomplete input file 0: decrypted\07F8Q0K8X0JS8DCXQ6WK8XX0CM5JYDYE40.upk.dec
       Can't read 641769814 bytes from offset 00000c2e.
       Anyway don't worry, it's possible that the BMS script has been written
       to exit in this way if it's reached the end of the archive so check it
       or contact its author or verify that all the files have been extracted.
       Please check the following coverage information to know if it's ok.

What am I missing here to extract the files or if u could provide a step by step I would appreciate, thanks.

spiritovod, posted Tue May 17, 2022 2:59 pm (71590)

---

@prixone: LAUTool is for audio files only. For graphics use specific umodel build from this topic.

---------------------------------------------------------------------------

Archive with LAUTool is updated with version for jp client. Also, both lpk scripts are updated with support for jp version as well.

zjqyf, posted Wed Sep 07, 2022 2:05 pm (73371)

---

hello
Can you elaborate on the use of repackaging scripts? I want pack \EFGame_Extra\ClientData\TableData\EFTable_ Gamemsg.db into font.lpk to achieve some localization work
Thank you in advance

zjqyf, posted Thu Sep 08, 2022 1:40 am (73380)

---

one more question
After I unzipped the LPK, the EFTable_GameMsg.db seemed to be corrupted, and I could not open it with SQLiteStudio

doomslayer, posted Mon Oct 03, 2022 4:06 pm (73670)

---

..

RichardCaq, posted Thu Oct 06, 2022 11:44 pm (73708)

---

i have lost ark KR version bnk audio files and nothing works anyone extracted the bnk files ??

doomslayer, posted Tue Oct 11, 2022 11:10 pm (73785)

---

..

kloruklass, posted Tue Oct 18, 2022 5:01 pm (73859)

---

Any scripts to extract the UPK files?

junyi163, posted Mon Dec 05, 2022 7:18 am (74462)

---

Where is the player model in that file?

phpbb2233, posted Tue Jan 03, 2023 6:31 am (74843)

---

spiritovod wrote:

Here is script for unpacking lpk files from steam (default option), ru and jp versions of the game. Credits to Brouznouf for algorithm.

Update: Script is updated to properly decrypt databases from lpk files.

===========================================

Test script for repacking is appending modified file to archive, which should be specified in the script (read included comment), and invalidating existing entry. Both modified file and archive should be placed in the same folder and the script is used on modified file. Simple re-import without modifying extracted file doesn't break the game and everything works fine, which means script is producing compatible with the game archives. The rest depends on particular files, for example, databases seems to have internal integrity checks.

Update: Updated script should work with all files from lpk. Note that size of any database should be aligned to 0x100 before re-importing, that's how they're originally built.

The new severs in TAIWAN are published could you update the bms for Taiwan severs?

spiritovod, posted Fri Jan 06, 2023 5:42 pm (74893)

---

@phpbb2233: I've updated both scripts and also LAUTool with support for tw client. They are available in original posts at page 6 now. Note that default option for scripts is steam version, you need to edit them manually to set required region.

b193, posted Fri Jan 06, 2023 10:39 pm (74897)

---

spiritovod wrote:

@phpbb2233: I've updated both scripts and also LAUTool with support for tw client. They are available in original posts at page 6 now. Note that default option for scripts is steam version, you need to edit them manually to set required region.

tyvm for updating. im trying to make localization of the Taiwan version to english so far extracted the encrypted EFTable_GameMsg.db not sure how to decrypt it.
tried to translate some strings with notepad but then unable to repack (idk how 0x100 aligned size work)
I'm assuming people that used to make loatranslator for ru/jp stopped updating since Steam version launch.
I'd be very grateful if anyone could help

phpbb2233, posted Sun Jan 08, 2023 6:47 am (74920)

---

spiritovod wrote:

@phpbb2233: I've updated both scripts and also LAUTool with support for tw client. They are available in original posts at page 6 now. Note that default option for scripts is steam version, you need to edit them manually to set required region.

Thank you for all your help

doomslayer, posted Fri Feb 03, 2023 6:20 pm (75276)

---

brekkez wrote:

spiritovod wrote:

@brekkez: To simplify things, there are only 3 versions of the game at the moment: steam (regardless of the region), korean and russian. And most tools/scripts are divided accordingly. If you mean the script above, it's compatible with both steam (by default) and ru versions - to switch between them you simply need to edit bms script in any text editor according to included comments.

It worked!. It's so hard to find the model I'm looking for lmao. I managed to find a costume and a head. I'm still trying to find the missing textures .

How do you find this model? It looks like player character. All .upk only contain NPC (I check them all).

doomslayer, posted Tue Feb 07, 2023 11:38 pm (75333)

---

Ekey wrote:

Ok, fixed problem with WEM files. For convert to playable Ogg format you need two additional tools > ww2ogg and revorb:

How to

Decrypt

Code:

LAUTool -d 395891.wem 395891.wem.dec

Convert decrypted Wem file to raw Ogg

Code:

ww2ogg --pcb packed_codebooks_aoTuV_603.bin 395891.wem.dec

Fix raw Ogg to playable format

Code:

revorb 395891.wem.ogg 395891.ogg

@Ekey Do you have the source code for this program? I would like to update it for US version of the game.