This topic was archived here:

https://web.archive.org/web/20230000000000fw_/https://www.zenhax.com/viewtopic.php?t=1336

ploxasarus, posted Mon Sep 07, 2015 1:28 am (7248)

---

I am having a hard time decompressing the main database file (compact.sqlite)
It is rather simple to get this file encrytion key, but since 2.0 they compressed the database file and I can't find a way to de-compress it. Maybe one of you could help us?
Original file size should be around ~150mb
Thanks

https://mega.nz/#!5RhFEa5J!JOzWkZtkvu3agj_4Lw9duFcd1-C7eEOab3cPq0J3IeA

aluigi, posted Mon Sep 07, 2015 2:14 am (7249)

---

It's still encrypted in my opinion, the last 3 unaligned bytes are in not encrypted.

ploxasarus, posted Mon Sep 07, 2015 2:36 am (7251)

---

Previously, the key was hidden in archeage.exe - it look like it's no longer there ( I don't know much about this, I am just guessing, as the decrypter we previously used no longer find it)

Ekey, posted Mon Sep 07, 2015 8:23 am (7258)

---

They changed encryption and format.

1) Sqlite file encrypted with double rounds by AES with small modification XOR. You can't find aes key and xor key because it generated from 4 secret constants.
2) DataBase is a zip archive. Inside it is divided to 8 chunks. (see screenshot)
3) DataBase for now not SQLite format 3 - now it binary data with custom structure

lels, posted Wed Sep 09, 2015 9:09 am (7336)

---

well looks someone already decrypt on reddit archeage
"So as you probably don't know, 2.0 changed the encryption as well as the file format of the database in game. It took me a few days to solve"
i am interested in database aswell if someone manage to decrypt post a link here

Ekey, posted Wed Sep 09, 2015 10:13 am (7337)

---

[RU PTS Base]: here
[US PTS Base]: here

ploxasarus, posted Thu Sep 10, 2015 3:50 am (7368)

---

Ekey, could you explain how you do it please?

Thanks

Ekey, posted Thu Sep 10, 2015 10:16 am (7371)

---

ploxasarus wrote:

Ekey, could you explain how you do it please?

Thanks

Memory dump

ploxasarus, posted Fri Sep 11, 2015 1:46 am (7394)

---

Ekey wrote:

ploxasarus wrote:

Ekey, could you explain how you do it please?

Thanks

Memory dump

So there is no "method" to "recrypt" it.

Thanks