Search found 17 matches

by freelancer
Sat Jan 26, 2019 8:28 pm
Forum: Support
Topic: Incorrect updates
Replies: 3
Views: 3062

Re: Incorrect updates

Great, thanks! Appreciate the fast response.

And no, I haven't mentioned anything about hashes.
by freelancer
Sat Jan 26, 2019 6:32 pm
Forum: Support
Topic: Incorrect updates
Replies: 3
Views: 3062

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...
by freelancer
Wed Aug 15, 2018 5:24 am
Forum: Support
Topic: How do I get a list of all platforms?
Replies: 2
Views: 2931

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 ...
by freelancer
Sat Aug 11, 2018 9:21 pm
Forum: Support
Topic: API response encoding
Replies: 13
Views: 14198

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.
by freelancer
Sat Aug 11, 2018 12:26 am
Forum: Support
Topic: API response encoding
Replies: 13
Views: 14198

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...
by freelancer
Fri Aug 10, 2018 1:58 pm
Forum: Support
Topic: API response encoding
Replies: 13
Views: 14198

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...
by freelancer
Fri Aug 10, 2018 10:26 am
Forum: Support
Topic: API response encoding
Replies: 13
Views: 14198

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...
by freelancer
Thu Aug 09, 2018 9:57 pm
Forum: Support
Topic: API response encoding
Replies: 13
Views: 14198

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...
by freelancer
Thu Aug 09, 2018 4:29 pm
Forum: Support
Topic: API response encoding
Replies: 13
Views: 14198

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...
by freelancer
Mon Aug 06, 2018 2:54 pm
Forum: Support
Topic: Deleted games
Replies: 3
Views: 3754

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.