Misc Fast TitleDB Lookup Tool

Slluxx

GBATemp Mayor
OP
Developer
Joined
Jul 17, 2019
Messages
607
Trophies
0
XP
2,150
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: 218
  • Screenshot 2022-02-21 14.23.36.png
    Screenshot 2022-02-21 14.23.36.png
    31.1 KB · Views: 220
Last edited by Slluxx,

binkinator

Garfield’s Fitness Coach
Member
GBAtemp Patron
Joined
Mar 29, 2021
Messages
6,511
Trophies
2
XP
6,157
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
607
Trophies
0
XP
2,150
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
607
Trophies
0
XP
2,150
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
Developer
Joined
Oct 14, 2018
Messages
6,315
Trophies
3
XP
12,119
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
607
Trophies
0
XP
2,150
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
645
Trophies
0
Location
Barstow, on the edge of the desert
XP
1,881
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
607
Trophies
0
XP
2,150
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
607
Trophies
0
XP
2,150
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
607
Trophies
0
XP
2,150
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
Developer
Joined
Oct 14, 2018
Messages
6,315
Trophies
3
XP
12,119
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
645
Trophies
0
Location
Barstow, on the edge of the desert
XP
1,881
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.
 

Site & Scene News

Popular threads in this forum

General chit-chat
Help Users
  • BakerMan @ BakerMan:
    you go bro
    +1
  • BakerMan @ BakerMan:
    i know, i know, i'm late
  • Sicklyboy @ Sicklyboy:
    @BigOnYa, I'll rip a bag off my Volcano to that, brother
    +2
  • a_username_that_is_cool @ a_username_that_is_cool:
    DDDS . Dual Developer Dedede System :)
    +1
  • BakerMan @ BakerMan:
    also happy birthday @Xdqwerty
    +1
  • BigOnYa @ BigOnYa:
    Is it me you're looking for?
  • MysticStarlight @ MysticStarlight:
    'Cause I wonder where you are
  • MysticStarlight @ MysticStarlight:
    wait I got the lyrics mixed up
    +1
  • BigOnYa @ BigOnYa:
    And I wonder what you do...Lol
  • BigOnYa @ BigOnYa:
    Its all good, I'm here to talk to you.
  • BigOnYa @ BigOnYa:
    Hello
  • BigOnYa @ BigOnYa:
    I've been playing fallout4 all day, I went into a elevator and it kept going, never stopped, waited 5 minutes, must of been a bug. How bout you, whatcha do today?
    +1
  • MysticStarlight @ MysticStarlight:
    I'm wondering why a stray tuxedo cat has a cloudy eye
  • MysticStarlight @ MysticStarlight:
    I've been playing TOTK all day also
    +1
  • MysticStarlight @ MysticStarlight:
    Oh you reminded me of those elevator nightmares
  • BigOnYa @ BigOnYa:
    Awesome game, fun how they force you to build, but you can build as you want
  • MysticStarlight @ MysticStarlight:
    It is super fun, I actually prefer it over BoTW
    +1
  • BigOnYa @ BigOnYa:
    The guy holding the sign always cracked me up, esp when you fail, and it falls
  • MysticStarlight @ MysticStarlight:
    Ah yes, that guy lol. I still need to find all his signs. The game has a lot to do though so I don't know what to finish first
  • MysticStarlight @ MysticStarlight:
    I'm 120 hours in and am still like 44.4% done
    +1
  • BigOnYa @ BigOnYa:
    Good times. Building is starting to get good around now for you. You making me want to make run thru again.
  • BigOnYa @ BigOnYa:
    Ok good chatting, enjoy your gaming, and avoid the lightning, or put your sword away. Good night.
    Veho @ Veho: https://i.imgur.com/E1U7Nlt.mp4 +1