#
#
# NOTICE!
# This script is NOT written by the emuferal devs!
#
# Tbh im not sure where its from anymore its been too long,
# if anyone knows who owns this please contact us so we can credit them.
#
#

import sqlite3
import sys
import base64
import operator

if len(sys.argv) == 1:
    sys.exit("example usage: ChartDecrypt.py charts_bundles_osx.2c85d195b6b8128088fc2da9a0c5e5e61ce7e7a4.db feral Prod _v0_2_14 osx")

chartPath = "file:" + sys.argv[1] + "?mode=ro"
chartDecryptPath = sys.argv[1] + ".decrypted.db"

chart = sqlite3.connect(chartPath, uri=True)
chartDecrypt = sqlite3.connect(chartDecryptPath)
chart.backup(chartDecrypt)
chartDecrypt.row_factory = sqlite3.Row

chartCur = chart.cursor()
chartDecryptCur = chartDecrypt.cursor()

chartDecryptCur.execute('SELECT * FROM sqlite_sequence')
sqlResults = chartDecryptCur.fetchall()
tableNames = []

#server lookup table
FeralProd = 'https://game-assets.fer.al/'
FeralStage = 'https://stage-game-assets.fer.al/'
CinderProd = 'https://game-assets.cinder.io/'

for i in sqlResults:
    tableNames.append(i[0])

for i in tableNames:
    chartDecryptCur.execute('SELECT * FROM ' + i)
    sqlResults = chartDecryptCur.fetchall()
    print(str(i) + " has " + str(len(sqlResults)) + " rows")
    print("Attempting to modify " + str(i))
    if str(i) == "DBSettings":
        chartDecryptCur.execute('UPDATE DBSettings SET data = \'false\' WHERE defId = \'encrypted\'')
        chartDecrypt.commit()
        continue
    for y in sqlResults:
        defIdKey = bytearray('key_id','ascii')
        defIdEnc = bytearray(base64.b64decode(y[2]))
        defId = ''
        defByte = 0
        for z in defIdEnc:
            defId = defId + chr(operator.xor(z, defIdKey[defByte % len(defIdKey)]))
            defByte = defByte + 1
        #print('defId = ' + defId)
        chartDecryptCur.execute('UPDATE ' + str(i) + ' SET defId = \'' + defId + '\' WHERE defId = \'' + y[2] + '\'')
        chartDecrypt.commit()
        dataKeyGen = 'key_' + defId
        dataKey = bytearray(dataKeyGen,'ascii')
        dataEnc = bytearray(base64.b64decode(y[0]))
        data = ''
        dataByte = 0
        for x in dataEnc:
            data = data + chr(operator.xor(x, dataKey[dataByte % len(dataKey)]))
            dataByte = dataByte + 1
        #print('data = ' + data)
        chartDecryptCur.execute('UPDATE ' + str(i) + ' SET data = :data WHERE data = \'' + y[0] + '\'', {'data':data})
        chartDecrypt.commit()
        if str(i) == "ManifestChart":
            ManifestExportFilename = sys.argv[2] + '-' + sys.argv[3] + sys.argv[4] + '-' + sys.argv[5] + '-game-assets.txt'
            ManifestExport = open(ManifestExportFilename, 'a')
            RebuiltURL = ''
            dataSplit = data.split(",")
            if sys.argv[2] == 'feral':
                if sys.argv[3] == 'Prod':
                    RebuiltURL = FeralProd + sys.argv[3] + sys.argv[4] + '/assetBundles/' + sys.argv[5] + '/' + dataSplit[0] + '.' + dataSplit[1] + '.unity3d\n'
                    print(FeralProd + sys.argv[3] + sys.argv[4] + '/assetBundles/' + sys.argv[5] + '/' + dataSplit[0] + '.' + dataSplit[1] + '.unity3d')
                    ManifestExport.write(RebuiltURL)
                if sys.argv[3] == 'Stage':
                    RebuiltURL = FeralStage + sys.argv[3] + sys.argv[4] + '/assetBundles/' + sys.argv[5] + '/' + dataSplit[0] + '.' + dataSplit[1] + '.unity3d\n'
                    print(FeralStage + sys.argv[3] + sys.argv[4] + '/assetBundles/' + sys.argv[5] + '/' + dataSplit[0] + '.' + dataSplit[1] + '.unity3d')
                    ManifestExport.write(RebuiltURL)
            if sys.argv[2] == 'cinder':
                RebuiltURL = CinderProd + sys.argv[3] + sys.argv[4] + '/assetBundles/' + sys.argv[5] + '/' + dataSplit[0] + '.' + dataSplit[1] + '.unity3d\n'
                ManifestExport.write(RebuiltURL)
        if len(y) == 4:
            if y[3] is not None:
                templateEnc = bytearray(base64.b64decode(y[3]))
                template = ''
                templateByte = 0
                for a in templateEnc:
                    template = template + chr(operator.xor(a, dataKey[templateByte % len(dataKey)]))
                    templateByte = templateByte + 1
                chartDecryptCur.execute('UPDATE ' + str(i) + ' SET template = :template WHERE template = \'' + y[3] + '\'', {'template':template})
                chartDecrypt.commit()
