fprettydb is a fpclib powered tool to fix and get metadata for Flashpoint's database. The basic usage is to move an updated Flashpoint's sqlite to the script's folder and run dbfix.py. Most site definitions including fpcurator.py are shortened from fpcurator.
v2.0 lets you send edits to FPFSS if you have the Editor role or above in Flashpoint's server; to do so, add your FPFSS authorization token and Discord user ID in .env.
The FPFSS auth token is obtained in the launcher through Developer tools (Ctrl+Shift+I), by looking at an API request in the network tab:
Will scan all entries and do these fixes, besides dumping a changelog at the end:
- No leading/trailing spaces and break lines from fields
- Fixes the release date format (YYYY-MM-DD) from dates without zeroes
- Streamlines the names of devs/publishers
- Fixes incomplete sources based on launch command and streamlines Wayback mentions
- Fetches missing developer, release date and original description from the source
To run, use python dbfix.py. dbfix_legacy is for versions 11 and below. You'll prob need to run python -m pip install fpclib on the first time.
It is setup to iterate through the whole db, but you can comment its last lines to use fixSpecific() instead.
Todo organize this code better