Item tracking for getting Perfection in Stardew Valley
There are more instructions on the Github wiki, but basically...
- You'll need to load the .sql file into a database. (I've run this in PostgreSQL, and MySQL. And Postgres is better... there... I said it.)
- Update the config.php file to target your database, and run a webserver with PHP support to view the files. (I've done it on Linux (lighttpd and PostgreSQL), OpenBSD (httpd and PostgreSQL), and I've done it on Windows with Ultra Web Server (and UniServz, a long time ago.)
- Pray.
Full Disclosure: This is my first-ever LAMP stack project (or, in my case a "OHPP" project, since I made it in OpenBSD, and used the built-in web server, and Postgres), I have no idea what I'm doing, and if this breaks or blows up your computer, the best help I'll be able to offer is to point you to Google.
More Full Disclosure: This is also my first project on Github, so... yeah.
UPDATES
2026-February 9 - Added php for the different database connection types, added a .sql specifically for mysql/mariadb, and added a .csv for the gamelist table (probably overkill, but meh). Also added some instructions to the wiki page on how to get it running on a Windows machine using Ultra Web Server. And updated the readme.
2024-March 28 - Fixed the carrot, summer squash, powdermelon, and Mystic Syrup to track blah blah blah. (Yikes.)
2024-March 27 - Fixed the broccoli to track like the rest of the crops. (You'd think I hadn't done this in a while or something.)
2024-March 26 - Fixed the new jellies to track like the rest of the fish.
2024-March 24 - Updated for 1.6. (And screw the Statue of Blessings...)
2024-January 14 - Yep, made it worse. Caviar was right in the first place.
2024-January 11 - Made caviar a "craftable" item, just for clarity. It's been a while since I changed anything, so I have no idea if that's made things better, or worse.
2022-April-25 - Added the walnut puzzle quests (Gourmand Frog (my guy), the mermaid puzzle, and the Banana Shrine).
2022-January-6 - I had Oil listed as a cooking recipe for some reason? Weird.
2021-December-30 - Renamed Willy's Boat to "Willy's Boat," broke out the three items (not standard, but whatevs), and moved it to Quests instead of Crafting.
2021-June-7 - Added the csv files containing all the item and recipe data (in case you want to database-ify it yourself).
2021-June-1 - Updated an error in the recipes table (who knew the iron transmute bar needed THREE copper bars?!?)
F*AQ
Q. Why didn't you make it a desktop app so it's not such a faff to use? A. What's the matter, don't have your own dedicated web server running on a computer in a closet next to your desk so you can run stuff like this? What's that? You don't? Well, check out ol' Normal McNormalson over here!
*literally no one has asked me this