Great, thanks! Appreciate the fast response.
And no, I haven't mentioned anything about hashes.
Search found 17 matches
- Sat Jan 26, 2019 8:28 pm
- Forum: Support
- Topic: Incorrect updates
- Replies: 3
- Views: 3197
- Sat Jan 26, 2019 6:32 pm
- Forum: Support
- Topic: Incorrect updates
- Replies: 3
- Views: 3197
Incorrect updates
The update with edit_id 71441 says that game 60230 (Hotline Miami) should have publisher 2250. No such publisher exists in the database, but a developer with that ID exists and is the correct developer for Hotline Miami. As far as I can tell the update should've said type: "developers", no...
- Wed Aug 15, 2018 5:24 am
- Forum: Support
- Topic: How do I get a list of all platforms?
- Replies: 2
- Views: 3011
Re: How do I get a list of all platforms?
I'm trying to get the basic list of all Platforms available so that I can display it in a list, I am new to using API's in general and so maybe I'm just being dumb but I figure that someone here can answer my question. I tried using this but that just gave me the HTML of the api documentation, any ...
- Sat Aug 11, 2018 9:21 pm
- Forum: Support
- Topic: API response encoding
- Replies: 13
- Views: 14430
Re: API response encoding
Checked out some more games today on the "old" vs "new" pages and it still looks like this'll fix the issue.
Let me know when you implement it and then I can do the same on my end and re-enable update.
Let me know when you implement it and then I can do the same on my end and re-enable update.
- Sat Aug 11, 2018 12:26 am
- Forum: Support
- Topic: API response encoding
- Replies: 13
- Views: 14430
Re: API response encoding
Looks good to me! I've had a decent amount of gin though, will take a closer look tomorrow and let you know if anything looks wrong. And yeah, you probably wanna run that on every text field to be sure (overview, title, alternates, ...) Changing the collation to utf8mb4_unicode_ci sounds like a good...
- Fri Aug 10, 2018 1:58 pm
- Forum: Support
- Topic: API response encoding
- Replies: 13
- Views: 14430
Re: API response encoding
[mention]Zer0xFF[/mention] As far as I can tell the problematic characters are all in the C1 control range (0080-009F). I did some googling which seems to support this, as this range is sometimes used for printable characters in ISO-8859 derivatives (even though that's technically not allowed, but w...
- Fri Aug 10, 2018 10:26 am
- Forum: Support
- Topic: API response encoding
- Replies: 13
- Views: 14430
Re: API response encoding
[mention]Zer0xFF[/mention] Thanks for confirming. And yeah, I'd concur with the estimate of about 2700 games being affected. The best course of action would probably be to write a small script to go through your database and replace the invalid characters, at least for games you can't fetch from the...
- Thu Aug 09, 2018 9:57 pm
- Forum: Support
- Topic: API response encoding
- Replies: 13
- Views: 14430
Re: API response encoding
It's intended. See this post about encoding: https://forums.thegamesdb.net/viewtopic.php?f=5&t=115 That post talks about what I assume is HTML entity encoding, which is not the same thing as the character encoding of a document. Entity encoding turns characters not allowed in HTML into HTML ent...
- Thu Aug 09, 2018 4:29 pm
- Forum: Support
- Topic: API response encoding
- Replies: 13
- Views: 14430
API response encoding
I've noticed the overview field in the API reponse for some games contains characters that are not printable in UTF-8. The same games return correct/printable characters when using the old/legacy API. A few examples: Halo 2 (game ID 9) New API: In Halo 2, the saga continues as Master Chief\u0097a ge...
- Mon Aug 06, 2018 2:54 pm
- Forum: Support
- Topic: Deleted games
- Replies: 3
- Views: 3837
Re: Deleted games
Thanks!
*edit* I'm assuming genre is on the way out aswell, in favor of genres? I haven't seen it in any updates, so maybe it's already gone.
*edit* I'm assuming genre is on the way out aswell, in favor of genres? I haven't seen it in any updates, so maybe it's already gone.