I created a tool to simplify the installation of custom themes in our app.db
Features:
-Written in JAVA, so compatible with any OS that supports a JVM (Windows, Linux, Mac...)
-Removed the need to use any external program (like SQLite Browser) and to find and edit SQL tables/records manually: all you need to do is to pass an app.db and your theme info, the program will write records automatically in your DB file at the correct table.
-Support for SQL blobs: this means that you can insert even a title and an author/provider for your custom theme that will appear in PSVita Theme Settings page. In this way there will be really no difference between an official PSVita theme and your custom theme, like you can view from these screenshots https://www.dropbox.com/sc/mlx08owshhkn ... jsuY6qAZga
-Basic and easy to use GUI:
-Application's window resizable by the user so as to fit any screen resolutions
-Tooltips with explanations on every field:
-Support for drag & drop in the input app.db text field
-The program will check if a record with the same UNIQUE key is already existing so as avoiding SQL errors.
-Ability to insert all params about your theme info, such as version, last mod date, size, etc...
-Ability to calculate the size of your theme automatically (by passing the main folder of your theme the program will calculate automatically the full size)
-Ability to set the last modified date to now automatically
-Ability to create a backup of your app.db automatically before writing changes
-Ability to quickly fill all text fields with default values:
-Ability to import a theme.xml file and get data (if any) from it. In this way filling in the various text fields, especially those related to the theme's file paths, should be even faster!
-English, French and Italian translations
That's all, I hope this will improve your relationship with custom themes
EDIT:
v1.1 released, the changelog is the following:
EDIT 2:v1.1:
-Added a function to import a theme.xml file and get data (if any) from it. In this way filling in the various text fields, especially those related to the theme's file paths, should be even faster now!
-Slightly remodelled the GUI
-Now the option to do a backup of the app.db file before writing is enabled by default
-Added the French translation by Yattoz
-Fixed a spelling error in the English translation (thanks to HarmfulMushroom for reporting this)
v1.2 released, the changelog is the following:
Download here: http://redsquirrel87.com/PSVitaDBThemeInstaller.phpv1.2:
-Added a function to clean and compact the database (using the SQL command VACUUM). This will reduce the size of your app.db, especially if it is very old, deleting all obsolete tables and records.
-Added a button near every text field that will open a new dialog with a preview screenshot of where the string will appear on PSVita.
-Changed and improved the explanation about the "Main Folder Path" parameter since it seems that was not very clear.
-Opened a collaborative translation project on OneSkyApp, so if you wish to contribute with a translation for the program now you can do it.
