Is there anyway to get compact.sqlite3 from AA in english ?

[Rostol]

I extracted it from the game.pak and decrypted it , but everyting (the texts that i wanted the dump for!) are all in korean



Or getting a Db that has, skill id, skill name, skill desc, effect (bleeding, lightning, etc)

 

[etb12345]

google trad

 

[Rostol]

LOL, yeah its how i got the DB ... but doing it field by field? ughh

But i could do it with a small routine IF google translate has an api, also the translations sucks:

"The decision to launch by sharp changes in energy
Give magic damage [Damage] decision raises a hallmark effect of death
When using the continuous damage of the blade increases vitality and will increase by 3% up to 30%
The technique uses technology faster reuse time not used automatically, press and hold"

 

[Out]

Install python.

Here script for python

import sqlite3
import sys
 
if (len(sys.argv) < 2):
	print("usage dblocale.py locale(ko|ru|other in db) <dbname default gamedb.sqlite3>")
	sys.exit()
 
 
dbname = "gamedb.sqlite3"
if (len(sys.argv) >= 3):
	dbname = sys.argv[2]
 
print("connect to: %s" % dbname)
conn = sqlite3.connect(dbname)
cur_tbname = conn.cursor()
print("begin tranzaction")
conn.execute('BEGIN TRANSACTION')
print("select table names")
cur_tbname.execute('SELECT tbl_name from localized_texts GROUP BY tbl_name')
cur_fieldname = conn.cursor()
cur_data = conn.cursor()
for record in cur_tbname:
	print("process table %s" % record[0])
	param = (record[0],)
	cur_fieldname.execute('SELECT tbl_column_name from localized_texts WHERE tbl_name = ? GROUP BY tbl_column_name', record)
	for field_rec in cur_fieldname:	
		print ("\t%s"% field_rec[0])
		cur_data.execute('SELECT %s, idx FROM localized_texts WHERE tbl_name="%s" AND tbl_column_name="%s"' % (sys.argv[1], record[0], field_rec[0]))
		query = 'UPDATE %s SET %s = ? WHERE id = ?' %(record[0], field_rec[0])
		for text_rec in cur_data:
			try:
				conn.execute(query, text_rec)
			except sqlite3.OperationalError:
				print ("bad query: %s; params: (%s, %s)" % (query, record[0], field_rec[0]))
 
print("COMMIT")
conn.execute('COMMIT')
print("end all operate")

Here example how to use this from console (path to python exe, path to this script in file, locale (can be en_us, de, fr,ru) and path to db file name):
C:\Python33>python.exe script.txt en_us en.db

 

[Rostol]

Out: you are awesome.

this is great. thanks

Edit: It worked perfectly, thanks Out.
If anyone needs/wants an unecrypted english db let me know and i'll put it up somewhere

 

[kietaxx]

Out: you are awesome.

this is great. thanks

Edit: It worked perfectly, thanks Out.
If anyone needs/wants an unecrypted english db let me know and i'll put it up somewhere

I would very much appreciate that! Or a short tutorial on how to decrypt the file (I got an error saying it's encrypted or not a db when running the python code)

 

[cheese321]

Did you find anything usefull in the db that can be modified and is not server sided?

 

[Rostol]

Sorry guys didnt see your replies ...

i'll put it up here: https://dl.dropboxusercontent.com/u/1461723/compact_decrypt.sqlite3

cheese: honestly i got wrapped up doing other things and havent had time to dig into the db.