Misc Fast TitleDB Lookup Tool

Slluxx

GBATemp Mayor
OP
Developer
Joined
Jul 17, 2019
Messages
346
Trophies
0
XP
1,054
Country
Germany
TitleDB lookup, an easy tool to look up games, dlc's, demos & updates in all languages.

Search for titles by either:
  • TitleId
  • Name
  • NsuId
And then filter them by:
  • Number of Players (min/max)
  • Age Rating (min/max)
  • Releasedate (min/max)
  • Size (min/max)
  • isDemo
 

Attachments

  • Screenshot 2022-02-21 14.23.23.png
    Screenshot 2022-02-21 14.23.23.png
    442.4 KB · Views: 33
  • Screenshot 2022-02-21 14.23.36.png
    Screenshot 2022-02-21 14.23.36.png
    31.1 KB · Views: 43
Last edited by Slluxx,

binkinator

Garfield’s Fitness Coach
Member
GBAtemp Patron
Joined
Mar 29, 2021
Messages
2,599
Trophies
2
XP
1,819
Country
United States
Here is an easy way to lookup games by TitleID, NsuId or name: TitleDB lookup

Its a very quick and very dirty written website. I didnt gave it much thought and its very unpolished.
It works by downloading the selected file from Blawars github repo and then spits out results based on your filter & input.

Ive created it in a few hours because i was annoyed at how long it took me to browse his repository, open the raw file and
STRG+F for whatever i was searching for. Allthough i created it mainly for myself, some else might find it useful too.

Yeah, the tinfoil website can do the same but that was even slower on my end.

If someone would like me to add data or filters, i can do that too ofc.

This is very cool!

How did you associate the Title on your page with the CDN graphics?
https://img-eshop.cdn.nintendo.net/...0075ead01a84f02dfe55b87876268409f6ccc0304.jpg
 

Slluxx

GBATemp Mayor
OP
Developer
Joined
Jul 17, 2019
Messages
346
Trophies
0
XP
1,054
Country
Germany
This is very cool!

How did you associate the Title on your page with the CDN graphics?
https://img-eshop.cdn.nintendo.net/...0075ead01a84f02dfe55b87876268409f6ccc0304.jpg
Thanks :)
Blawars TitleDB includes (sometimes) icon, banner and (sometimes) screenshot urls. For example, DLCs usually dont have Icons but a banner that is used to display on nintendos website somewhere. Here is an example of the data i get by downloading the json file (this one is german though)

JSON:
{
    "70010000000023": {
        "id": "01007EF00011E000",
        "rightsId": "01007EF00011E0000000000000000000",
        "name": "The Legend of Zelda\u2122: Breath of the Wild",
        "version": null,
        "key": null,
        "isDemo": false,
        "region": null,
        "releaseDate": 20170303,
        "nsuId": 70010000000023,
        "category": [
            "Action",
            "Adventure"
        ],
        "ratingContent": [],
        "numberOfPlayers": 1,
        "rating": 12,
        "developer": null,
        "publisher": "Nintendo",
        "frontBoxArt": null,
        "iconUrl": "https://img-eshop.cdn.nintendo.net/i/16259342084f704aa52da956cf1b1a9c2ad1f88b3de6c3e263c350813e7ccd1f.jpg",
        "screenshots": [
            "https://img-eshop.cdn.nintendo.net/i/44b2e287590e7d4eb0f37276957b301c528bd2d5672e37e848397f38ff74b2d5.jpg",
            "https://img-eshop.cdn.nintendo.net/i/61484f00ca97642ef2d53317423f091969dd4e6063827053c8e2278796d0eadc.jpg",
            "https://img-eshop.cdn.nintendo.net/i/4fae6c8b937eba525ee9db1ca47ba23ea20b086d9690573b2f3c4f7af2b85361.jpg",
            "https://img-eshop.cdn.nintendo.net/i/de2f0c3058bf4730ee8118dd4d87af5666fa7927c13a6dcad9ff39c1c7b95aad.jpg",
            "https://img-eshop.cdn.nintendo.net/i/8cc629e17264aeaae0b4c75ae822f8ed25ecb4f0f793878147d62268048d71b3.jpg",
            "https://img-eshop.cdn.nintendo.net/i/ca07fab95ef4964983d7a8ec798ef2085934476cb99feb5b708f70dd518da37a.jpg"
        ],
        "bannerUrl": "https://img-eshop.cdn.nintendo.net/i/7c8f2e897c9e025649f97d4c9d5e1f92497bd6217bd442d6de8de17c46142e78.jpg",
        "intro": "Kein K\u00f6nigreich. Keine Erinnerungen.\nNach einem hundertj\u00e4hrigen Schlaf blieb ihm nur die Hoffnung...",
        "description": "Begib dich in eine Welt voller Abenteuer\n\nVergiss, was du bisher \u00fcber \u201eThe Legend of Zelda\u201c wei\u00dft! Begib dich in eine neue Welt voller Abenteuer und Entdeckungen in \u201eThe Legend of Zelda: Breath of the Wild\u201c, einem innovativen neuen Spiel in der beliebten Reihe. Reise \u00fcber Felder, durch W\u00e4lder und auf Berggipfel, und finde im Laufe dieses mitrei\u00dfenden Abenteuers heraus, was aus dem zerst\u00f6rten K\u00f6nigreich von Hyrule geworden ist.\n\nUnter amiibo.nintendo.eu findest du eine Liste kompatibler amiibo\u2122 und aktuelle Informationen.",
        "languages": [
            "ja",
            "en",
            "es",
            "fr",
            "de",
            "it",
            "nl",
            "ru",
            "ko",
            "zh",
            "zh"
        ],
        "size": 15483273216
    }
}
 
  • Like
Reactions: binkinator

Slluxx

GBATemp Mayor
OP
Developer
Joined
Jul 17, 2019
Messages
346
Trophies
0
XP
1,054
Country
Germany
Fixed a bug which stopped titles to show if the value of the json-key is null
Fixed a bug which broke 'search by nsuId'
And added placeholder images for games that dont have banner (mainly demos and dlcs)
 
  • Like
Reactions: binkinator

masagrator

The patches guy
Member
Joined
Oct 14, 2018
Messages
4,990
Trophies
2
XP
8,697
Country
Poland
I had issue with tinfoil.io since it seems it doesn't support non English titles, so searching for example Japanese only games using kanji and kana always gives no results in search.
So your site is better since it supports more than English titles.

Would be nice to include info about updates. versions.json stores info about updates assigned to titleid and when each one was released.
 
Last edited by masagrator,
  • Like
Reactions: mathew77 and Slluxx

Slluxx

GBATemp Mayor
OP
Developer
Joined
Jul 17, 2019
Messages
346
Trophies
0
XP
1,054
Country
Germany
What if we search tid 0100 and sort by date or have date ranges?
i can hack that in or i do it properly so i (or others) know how to work on it in a year. Im already redoing stuff and adding a proper filter (basically you can filter everything but categories)
 

SodaSoba

‿︵‿︵‿︵ヽ(°□° )ノ‿︵‿︵‿︵‿
Member
Joined
May 28, 2018
Messages
544
Trophies
0
Location
Barstow, on the edge of the desert
XP
1,264
Country
United Kingdom
i can hack that in or i do it properly so i (or others) know how to work on it in a year. Im already redoing stuff and adding a proper filter (basically you can filter everything but categories)
Well it's excellent work in my opinion and way faster than tinfoil.io or using other methods of looking up tids.
 

Slluxx

GBATemp Mayor
OP
Developer
Joined
Jul 17, 2019
Messages
346
Trophies
0
XP
1,054
Country
Germany
Its not pretty but i guess something like this should meet almost all criteria, except categorys and other array based fields.
Id really appreciate if someone can draw me a nicer layout for this. Desining any kind of form was never my strong point

Unbenannt.PNG
 
Last edited by Slluxx,

Slluxx

GBATemp Mayor
OP
Developer
Joined
Jul 17, 2019
Messages
346
Trophies
0
XP
1,054
Country
Germany
New version of the site is up. You can now filter games based on numberOfPlayers, rating, releaseDate, isDemo & size. you can also limit your results and ignore when titles have a NULL value somewhere (which quite a few do).
(@SodaSoba here are your date ranges)

The next update will include a list of updates, as suggested by @masagrator
 

Slluxx

GBATemp Mayor
OP
Developer
Joined
Jul 17, 2019
Messages
346
Trophies
0
XP
1,054
Country
Germany
Hey @masagrator ,
i feel like the versions.json may be outdated / not completed. i cant tell for sure but i thought some games should have updates that are not listed. Could you try for yourself and report back?

Edit: i realized that, for whatever reason, the titleIds inside versions.json are mixed lower and uppercase. now more, if not all titles with updates should display them (hopefully).

Screenshot 2022-02-22 00.17.20.png
 
Last edited by Slluxx,
  • Like
Reactions: masagrator

masagrator

The patches guy
Member
Joined
Oct 14, 2018
Messages
4,990
Trophies
2
XP
8,697
Country
Poland
Hey @masagrator ,
i feel like the versions.json may be outdated / not completed. i cant tell for sure but i thought some games should have updates that are not listed. Could you try for yourself and report back?

Edit: i realized that, for whatever reason, the titleIds inside versions.json are mixed lower and uppercase. now more, if not all titles with updates should display them (hopefully).

View attachment 299085
Checked recent games and it looks fine. Thanks. Now this is a proper alternative to tinfoil.io for me. :P

And maybe next idea, but I guess it may be out of scope for this site - list of updates sorted by newest date with titles and titleids next to it.
As someone who is maintaining my many translation mods, having bot that was on ReSwitched that was printing newest game updates was very convenient, but it doesn't work for many months now and I'm struggling with following last updates. Would be nice to have alternative to that.
 
Last edited by masagrator,

SodaSoba

‿︵‿︵‿︵ヽ(°□° )ノ‿︵‿︵‿︵‿
Member
Joined
May 28, 2018
Messages
544
Trophies
0
Location
Barstow, on the edge of the desert
XP
1,264
Country
United Kingdom
Input from myself.

Doesn't work on mobile browser (doesn't matter but that's how I was testing last night)

Inputting date ranges is a little clunky
But it does work.

I used search by TID "0100" and date from 20220201 - 20230101.

I had to figure that part out it wasn't natural feeling.
It does still work and still seems fast, not sure if you are able to make tags based on tid? (DLC, update) but for my needs so far so good a sorting method would be brilliant but it's not important.

I would love a clearer input date method but I can work with it as is.
 
General chit-chat
Help Users
  • No one is chatting at the moment.
    Dark_Phoras @ Dark_Phoras: Good morning! Today I managed to wake up in the morning. It is a welcome step