search

AB1908 / GOG-Galaxy-Export-Script

Export your list of games from GOG Galaxy
MIT License
149 stars 27 forks source link

How to link the platform to releaseKey from the DB file? #27

Closed aravindpanil closed 4 years ago

aravindpanil commented 4 years ago

I have been taking a look at the code and want to write a simpler version for myself from scratch with the final objective of generating a random game picker.

After looking through the db file, I have a rough idea on how to get the Title of the game, the tags, release date etc. I do not know how to get the platform. Is there a field in any of the tables that links the platform to the releaseKey? Or are you figuring out the platform using the first few characters of the Release Key?

AB1908 commented 4 years ago

You may want to go back 3 commits to 900dc18 to a simpler version of the script.

As for obtaining the platform, I'm using the latter. The releaseKey often is of the type platform_gameID so I did a simple check for it. You also may want to look at the wiki if you need more info on the queries that I have used. There may be better ways of doing this but this was all the info I could scrap together.

aravindpanil commented 4 years ago

Thanks. The wiki Query page is very useful. Helped me a lot. I would suggest moving the platform variable to a text file and reading it from there. Might seem more complicated but it would be easier to add newer platforms and increases modularity.

AB1908 commented 4 years ago

Fair point. I'll make that improvement sometime. Thanks for the feedback.

AB1908 commented 4 years ago

You may also want to use a random picker another user created here:

https://github.com/zooglea/GOG-Galaxy-Export-Script

Note that it is several commits behind and you may have to pull commits from my repo. I never accepted this into the repo as I felt it was unnecessary.