Twitch games support [WIP]

[BanCrash]

• [ ] Modify Readme
• [ ] Modify changelog
• [x] Batch file to dump databases with sqlite3
• [ ] Modify Game / Game.moon
• [x] Modify Main / Platforms / Init.moon
• [x] Create Main / Platforms / Twitch.moon
• • [x] Dump databases function
• • [x] Parse Install info function
• • • [x] Scenario when no games are installed right now should be accounted
• • [x] Parse products info function
• • [x] Parse fuel info function
• • [x] All platform common functions
• • [ ] Add tests if possible
• [ ] ¿Modify Main / Slots / Overlay_slots.moon?
• [ ] Modify Main / init.moon
• [ ] Modify Settings / init.moon
• [ ] Create Settings / Pages / twitch.moon
• • [ ] Option for enable or disable platform
• • [ ] Bangs options
• • [ ] AppData folder selection, with standard option as default
• • [ ] ProgramData folder selection, with standard option as default
• [x] Modify Shared / Enums.moon
• [ ] ¿Modify Shared / Library.moon?
• [ ] Modify Shared / Settings.moon
• [ ] Modify Translation / English.txt
• [ ] Modify build_release.py

DONE:

• [x] Investigate all files that should be modified to add full support
• • [x] Filter Folder
• • [x] Game Folder
• • [x] Lib Folder
• • [x] Main Folder
• • [x] NewGame Folder
• • [x] Search Folder
• • [x] Session Folder
• • [x] Settings Folder
• • [x] Shared Folder
• • [x] Sort Folder
• • [x] Translations
• • [x] Root Folder (.gitattributes, etc)

ORIGINAL COMMENT:

Hello! I made an investigation and I think games from Twitch store could be fully supported.

• I found on AppData\Roaming\Twitch\Games\Sql a sql database file named GameProductInfo.sqlite that has all the necessary info about all owned games (only have owned games, not all games like GOG) in a table named "DbSet": ProductIdStr (which is the folder name of the game), ProductTitle (Game name) and various tables about covers. The main cover (named ProductIconUrl) is vertically (example), so I suggest to add Background2 field as cover (example).

• When you choose to install a game, you only can choose in what unit you want to install it, but you can't choose the folder itself.

However, I think it's better to let the user choose games installation folder/s as on blizzard Battle.net, to avoid issues that could arise.

• When you install a game, a folder with ProductIdStr is created on installation folder:

So is easily to know which owned games are installed.

• And to launch a game is easy as: "twitch://fuel-launch/ProductIdStr of the game".

And if you use that command with an uninstalled game, you will get this popup:

Translation: "Game is not installed. Would you like to install it now?"

In resume, sqlite3 could get ProductIdStr, ProductTitle, and Background2 from DbSet on C:\Users\User\AppData\Roaming\Twitch\Games\Sql\GameProductInfo.sqlite, then will check folders placed on games installation folder to see which games are installed, and then games would be launched or installed with twitch://fuel-launch/ProductIdStr.

EDIT; After more research, I found another sql file (C:\ProgramData\Twitch\Games\Sql\GameInstallInfo.sqlite) that has only installed games. Has also previous installed games, but with field "Installed" with 0 instead 1. So will be better than check folders to see if they're installed.

[Kapiainen]

I'm probably not going to implement and maintain support for it for a few reasons: 1) Several games available via the service require Steam anyway. 2) I have not been able to find a free game that I could use to generate the database and test it. 3) Amazon's presence in my country is limited, which means that some regional restrictions apply, and I don't have an account.

Feel free to implement it yourself, but I'm reluctant to do it since I don't use it myself and would be unable to properly maintain support for it.

[BanCrash]

I understand why you're reluctant. I will try to implement to see if I can make it work.

For now I will let this closed until I know if I'm capable to do so.

[BanCrash]

I'm working on this and I have a doubt about the actual code. I'm using gog galaxy code as basis, and I found that on function OnDumpedDBs there is a call to: cachePath = STATE.PLATFORM_QUEUE[1]\getCachePath().

I see the gog galaxy platform file, but in the actual development3 version there isn't any function named "getCachePath()". However, in the master version yes there is. That function was moved to other part? I can't find it.

[Kapiainen]

The definition for that method can be found here in the Platform class that all platforms extend.

[BanCrash]

Ah, perfect then, thanks you!

[BanCrash]

I have to polish things and fix stuff, but right now uninstalled games are detected and have their banners dowloaded:

I see on your TODO list that you are making a refactor, so I will wait until that is done to make this PR for adapt the code to that refactor.