This topic was archived here:

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

CriticalError, posted Fri Jul 03, 2015 11:32 am (6081)

---

Hello guys, well today I found interesting game, so I wanna study this, format stored in .db3 and .status, sure they are connected so maybe someone can take a look? I checked the files and .db3 contain in the header "SQLite format", I read something about that and is an embedded SQL database engine, ok anyway hope it helps, many thanks.

https://cloud.mail.ru/public/BhZT/uSb4rrLA1

aluigi, posted Fri Jul 03, 2015 11:36 am (6082)

---

You linkedin the DarkEden files.
Anyway try this:
http://www.yunqa.de/delphi/doku.php/pro ... espy/index

CriticalError, posted Fri Jul 03, 2015 12:29 pm (6084)

---

aluigi wrote:

You linkedin the DarkEden files.
Anyway try this:
http://www.yunqa.de/delphi/doku.php/pro ... espy/index

thanks for report, I fix link now, anyway I checking what you give me.

CriticalError, posted Fri Jul 03, 2015 8:35 pm (6093)

---

sorry for dump topic again luigi, but what suppose I do with them? I can only see database, and what about data of game? I mean, textures, models,animations,etc?

aluigi, posted Sat Jul 04, 2015 2:09 am (6096)

---

There are for sure better ways but let's try some stdin pipe fun via command-line:

Code:

# How to use:
#   download https://www.sqlite.org/2015/sqlite-shell-win32-x86-3081002.zip
#   md output
#   sqlite3 12_asset_data.db3 .dump | quickbms script.bms - output
#
# (script optimized for stdin)

for
    getct CMD string ' '
    if CMD == "INSERT"
        do
            get TMP byte
        while TMP != ','
        getct SIZE string ','
        getct DUMMY string ','
        get TMP byte    # X
        get TMP byte    # '
        getct DATA binary '\''
        strlen SIZE DATA
        log MEMORY_FILE2 0 0
        put DATA string MEMORY_FILE2
        goto 0 MEMORY_FILE2
        comtype hex
        clog MEMORY_FILE 0 SIZE SIZE MEMORY_FILE2
        get SIZE asize MEMORY_FILE
        getvarchr TMP MEMORY_FILE 0 short
        if TMP == 0x8b1f
            comtype gzip
            clog "" 0 SIZE SIZE MEMORY_FILE
        else
            log "" 0 SIZE MEMORY_FILE
        endif
    endif
    get TMP line
next

CriticalError, posted Sat Jul 04, 2015 8:22 am (6102)

---

many thanks luigi, it worked very well, now my question, the file names are generated random? because I only got numbers, now after unpacking I got this.

aluigi, posted Sat Jul 04, 2015 10:59 am (6104)

---

Unfortunately there are no filenames saved in the database

CriticalError, posted Sat Jul 04, 2015 7:07 pm (6122)

---

so exist some way to make unpacker for get hash? in this case any typs from where can begin? because the unpacker no work at all, just unpack few files and after that got error, and .dat files generated by scricpt are wrong extention, because some files are gr2 meshes files (Granny) and others are from animations,etc.

aluigi, posted Sat Jul 04, 2015 8:25 pm (6126)

---

That's strange that it doesn't work because here I extract all the almost 400 files correctly.
You can also try to not use the pipe and go with the > output.txt and then open it with quickbms to extract it.

Quickbms tries to guess the extension of lot of files but textual files like lua scripts and meshes cannot be guessed.