Latest revision as of 03:32, 14 April 2020

telara.db

telara.db is an encrypted SQLite3 database stored within the RIFT Assets and consists of 3 tables, only 2 are used by program.

It can be decrypted using sqlite3-dbx and the appropriate encryption key.

Alternately, the file can be decrypted without using sqlite3 because the DB is encrypted using a simple 128-AES block cipher. See SQLite Encryption Extension Documentation for more information.

The only caveat is that bytes 16-23 on the first page are NOT encrypted. See: Database File Format for the exact purpose of these bytes. The only one you really need is the first 2 bytes at offset 16 which contain the pagesize, which is the amount of bytes you have to feed into the decryption routine.

Dataset Info

dataset

Contains 6 columns. The most useful are "datasetID", "datasetKey" and "value". The ID and Key together point to a unique entry. Most of the entries are COMPRESSED and have to be decompressed to be read.

Each entry starts with a LEB128 to indicate decompressed size, followed by compressed DAT_Format data.

dataset_compression

This table contains 2 columns, "datasetId" and "frequencies" and contains the 1024 byte Huffman table frequencies to build a Huffman tree to decompress the dataset entries.

See here for an implementation in C#.

Dataset Summary