I wrote this command line tool to do simple table comparisons between two PostgreSQL databases. Web based database applications generally, from time to time, get schema changes. If your application doesn’t use an abstraction layer than automates such schema changes, then a tool such as this can come in handy. A similar web-based and much more advanced tool exists called pgdiff. I needed a command line tool that operated only on tables that’s why I wrote this. You can download it here if you’re interested.
This release adds support to extract sounds files from theme files. The sound files appear to be encoded in the VAG audio format. Some details about this format can be found here.
The previous release, 0.10, fixed an issue with padding in GIM files. Some icons, whose width were not a multiple of 4, were being extracted “skewed” due to the fact that they were being read incorrectly. Thanks to FluBBa for pointing this out.
This is basically a bug fix release. Under Windows, dragging and dropping theme files on the executable now extracts them correctly (thanks to Matt Endersby for reporting the issue).
In addition, I changed the default extraction path to include the theme filename so that multiple theme files can be dragged and dropped from the same directory and each one will be extracted into its own directory.
Developers using this program: Please note the change of the default extraction path.
Fixed a bug reported by h9z3zzj02. The name of the XML file being generated had the wrong prefix prepended to it.
It looks like many people have found the extractor to be useful. As of now, the web server has logged a total of 3.5G of downloads since I released it. It has been linked from many sites, two of which are:
PS3-Themes.com
PS3 Theme Extractor Tutorial
It is also being used by other programs as an external app for extracting p3t files.
I reverse engineered the PS3 theme file format (p3t). I managed to write an extractor for it. It is a “compiled” XML, i.e. an XML file converted to binary format using headers, offsets, etc. The background images in the P3T files are stored as JPEGs whereas the icons are stored in Sony’s GIM format, which seems to be a format optimized for texture loading. Since it wasn’t too complicated I wrote a parser in the extractor to convert GIMs to PNGs.