Misc Fast TitleDB Lookup Tool

[Slluxx]

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

 

[binkinator]

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]

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)

Spoiler: 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
    }
}

 

[SodaSoba]

Super quick, great work certainly a handy tool

 

[Yoremu]

Nice tool for looking games id

 

[Slluxx]

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)

 

[masagrator]

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.

 

[Slluxx]

I'll take a look. I'm sure I can easily add it

 

[SodaSoba]

I'll take a look. I'm sure I can easily add it

Is there any way to just pull up the latest 20 titles?

 

[Slluxx]

Is there any way to just pull up the latest 20 titles?

yeah. but i guess i have to rewrite my quick and dirty site to something actually somewhat decent if more of those kind of requests come in

 

[SodaSoba]

yeah. but i guess i have to rewrite my quick and dirty site to something actually somewhat decent if more of those kind of requests come in

What if we search tid 0100 and sort by date or have date ranges?

 

[Slluxx]

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]

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]

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

 

[Slluxx]

i guess this is acceptable

 

[Slluxx]

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

 

[SodaSoba]

(@SodaSoba here are your date ranges)

Cool beans I'll have a test later on this evening

 

[Slluxx]

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).

 

[masagrator]

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.

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.

 

[SodaSoba]

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.