I've added my own version of WinterSnowfall's download version mismatch table at https://www.gogdb.org/user/version_mismatch
(with his approval). It will be better integrated into the site later.
Ah, now I can finally retire and grab that margarita on a tropical island somewhere :P. Glad to see this up and running and thank you for your work. It looks better part of GOG DB, gotta say :).
However, it does look like you're capturing more data that you should be (at least compared to my current code), mostly due to the following:
- I simply skip comparisons for any offline installer that matches on .*(gog-.*)$ - this is because they're legacy versioned installers that are most likely in sync with Galaxy and haven't been updated in literal years anyway
- I don't collect any build versions from named branches (such as "dev" or "beta") - those won't ever get offline installers so the discrepancies will be artificial. It was first brought to my attention by mrkgnao but matches my observations anyway.
- there are some that will be blatantly false positives (like The Little Acre) - having a manual way of ignoring those in the backend and not listing them in the table is useful and what I'm also using at the moment for some entries. I can provide what I've currently marked as manually invalid based on user reports so far, if you're interested - though you could also keep them in the table as they are essentially versioning problems GOG should fix, even if the content is in sync.