niemasd / GameDB-GC

Nintendo GameCube (GC)
GNU General Public License v3.0
3 stars 0 forks source link

Missing a *lot* of release dates #1

Open niemasd opened 11 months ago

niemasd commented 11 months ago

I couldn't find a structured website that has GameCube games + release dates. I manually added the release dates of the Super Smash Bros. Melee releases just to have at least 1 date so that the release dates visualization script can run, but I need to find a good way to bulk-add them

niemasd commented 9 months ago

Added a bunch of dates from MobyGames in https://github.com/niemasd/GameDB-GC/commit/2007667ac74673205cba88283ff36446be08f8b9 (need to keep going with MobyGames)

for serial in $(echo $(ls && ls */release_date.txt) | tr ' ' '\n' | cut -d'/' -f1 | sort | uniq -c | rev | cut -d' ' -f1-2 | rev | grep -v "^2 " | cut -d' ' -f2) ; do echo -n "$serial " && cat $serial/title.txt && ~/GameDB/helper/search_mobygames.py -k API_KEY -t "$(cat $serial/title.txt)" -p GC | cut -f2 | grep -v "^Release Date" | head -1 > $serial/release_date.txt && sleep 1.5 ; done
niemasd commented 8 months ago

I finished adding all of the missing dates from Mobygames in this commit: https://github.com/niemasd/GameDB-GC/commit/b25b09c6487040ceb35e9143c599fe09e65e1197

However, lots of games failed to find release dates using my Mobygames script, so they have 0-byte release_date.txt files. The list of such games can be found as follows (from the games folder):

ll */release_date.txt | grep " 0 " | rev | cut -d' ' -f1 | rev

To print the contents of the first result:

serial=$(ll */release_date.txt | grep " 0 " | rev | cut -d' ' -f1 | rev | cut -d'/' -f1 | head -1) && echo $serial &&
cat $serial/*