ROM Hack 3DS Title Key DB Stats Website

What other information should I add to the details page? (hidden on small screens/windows)

  • Retail Availability (Download/Retail/Both)

    Votes: 38 52.1%
  • Publisher

    Votes: 18 24.7%
  • Genre

    Votes: 15 20.5%
  • Rating (ESRB etc)

    Votes: 9 12.3%
  • Star Rating (user ratings)

    Votes: 17 23.3%
  • Release Date (eShop/Retail)

    Votes: 34 46.6%
  • Price (eShop/Retail) - Only available for certain unreleased games it seems

    Votes: 12 16.4%
  • I don't care

    Votes: 5 6.8%
  • it's best the way it is.

    Votes: 3 4.1%

  • Total voters
    73

The Real Jdbye

*is birb*
OP
Member
Joined
Mar 17, 2010
Messages
23,207
Trophies
4
Location
Space
XP
13,733
Country
Norway
A couple of days ago I made this:
http://3ds.jdbye.com/

It's a tool to list the overall completion of the 3DS title key database, as well as list the games in the database and games missing from the database. Both for curiosity and for those wanting to know how the title key/ticket method of installing games compares to the other methods of downloading 3DS games.
I figured it fits under utilities, but if it doesn't, then mods feel free to move this.

I'll paste the FAQ here just for information:
3DS Title Key DB - FAQ
This page was made to list information about the completion of the 3DS Title Key Database website at any given time. It is automatically updated once a day and so will always have up to date information.
Still not sure what all of this is for? Read below.

What is all this about title keys? What are they and what do they do?
Title keys, put simply, are a way to download games directly from Nintendo's servers and install them to your hacked 3DS, without having purchased them. This includes downloading from eShop and using other tools that download from Nintendo's servers. Doing this requires generating tickets, which can be generated using nothing but the title key.
All you need to do this is a tool that supports title keys directly and automates most of the process (CIAngel or TIKDevil for example), or a tool that can generate tickets (.tik files) from them that you can install with FBI. There are multiple tools for generating tickets.
As long as you have the correct ticket installed to your system and you are using CFW then you can download the games from eShop without any other homebrew or programs. Installing these tickets does require homebrew though.

FBI can install these tickets for you so you can download the game using the eShop app, or it can download the game directly from Nintendo's servers and install it, without using the eShop app, both from .tik files and already installed tickets.
CIAngel uses the title key website directly, and so it doesn't require pre-generated tickets. It can download and install games directly from Nintendo's servers without using the eShop app. and you don't need any other programs or homebrew other than CFW to use it.
TIKDevil is the counterpart to this, it also uses the title key website and can generate and install tickets for all known title keys giving you the ability to download most popular titles and a lot of less popular titles directly from the eShop app. The installed tickets can also be used with FBI to download the game from Nintendo's servers without using the eShop app.

A few PC-side programs also exist that can generate these .tik files for you as well, for use with FBI.

I don't get it. What's the point of this website?
The purpose of this website is to serve as a tool for people to check if the games they own are already in the list or not, so missing games can be submitted to the title key website more easily, and to provide statistics on overall completion for the curious and as a way to compare the usefulness of the title key database compared to other methods of obtaining 3DS games. It also serves as a convenient and easy to use way to tell you exactly what you'll be able to download with these tools, and what games are missing.

How does it work?
Once a day, the JSON file (json_enc) from the title key website is downloaded.
Then Nintendo's servers are parsed for all listed and released downloadable games, in other words, games not currently listed on the eShop, unreleased games or games only available at retail are not listed. Updates and DLC are also not listed on this website, since they are part of the game and aren't listed as separate entries.
The results are compared and stored into a JSON file containing all listed eShop titles and whether their title keys are already dumped.

All this website does is display those results in an easily accessible and readable way.

Currently, localized games (Spanish, French, German etc.) are not listed, nor are Korean, Taiwanese or Chinese titles. Only titles released in Great Britain, United States and Japan are listed. This could be changed however, if there is a demand.

Okay, I got it, now where can I find these title keys?
Unfortunately, I can't link to them here, as that would be akin to linking to ROMs directly, and for obvious reasons that's not something I want to risk.
The website is fairly well known, however, so you shouldn't have much trouble finding it.

Edit:

I'm also planning to add a graph so everyone can see how things improve over time. In fact the database functionality for this is already implemented, it just needs to be added to the website.

I might also add more information to the details page.
I have all of this information available:
Retail Availability (Download/Retail/Both), Publisher, Genre, Rating (ESRB etc), Star Rating (ratings by users), Release Date (eShop/Retail), Price eShop/Retail (Only available for certain unreleased titles it seems)

Anyone think I should add any of this information to the details page and if so which ones?
They would be hidden if the screen/window is too small, so don't worry about the page getting too cluttered on mobile phones or tablets.
 
Last edited by The Real Jdbye,

The Real Jdbye

*is birb*
OP
Member
Joined
Mar 17, 2010
Messages
23,207
Trophies
4
Location
Space
XP
13,733
Country
Norway
For the record, yesterday US was at ~41% and today it's at about 44%, so things are definitely improving.
I'm also planning to add a graph so everyone can see how things improve over time. In fact the database functionality for this is already implemented, it just needs to be added to the website.

I might also add more information to the details page.
I have all of this information available:
Retail Availability (Download/Retail/Both), Publisher, Genre, Rating (ESRB etc), Star Rating (ratings by users), Release Date (eShop/Retail), Price eShop/Retail (Only available for certain unreleased titles it seems)

Anyone think I should add any of this information to the details page and if so which ones?
They would be hidden if the screen/window is too small, so don't worry about the page getting too cluttered on mobile phones or tablets.
 
Last edited by The Real Jdbye,

The Real Jdbye

*is birb*
OP
Member
Joined
Mar 17, 2010
Messages
23,207
Trophies
4
Location
Space
XP
13,733
Country
Norway
Nice, looking forward to more JP-Region title dumps ^_^"

But wow, almost at 50% for US-Region games !

Programs like Freeshop are sure making this popular
I was thinking I'd add freeShop to the FAQ page once it can download title keys automatically, because without that feature it's kind of a pain in the ass compared to CIAngel and TIKDevil :P
 
  • Like
Reactions: breaktemp

cearp

瓜老外
Developer
Joined
May 26, 2008
Messages
8,721
Trophies
2
XP
8,471
Country
Tuvalu
how do you find all the titles in existance for a given region?
there is a way to get all the ids for every release on the jp, usa etc store? cool.
 
D

Deleted User

Guest
Oh wow! Thank you so much for this! :D

--------------------- MERGED ---------------------------

Wow they're a lot of tickets missing! :O like Chibi Robo Ziplash for USA!
 

zoogie

playing around in the end of life
Developer
Joined
Nov 30, 2014
Messages
8,560
Trophies
2
XP
14,998
Country
Micronesia, Federated States of
This is great, @The Real Jdbye :)

Is it possible to include dsiware and be able to separate titles that are dual retail/download? Those titles are already taken care of by the scene (at least in EU/US).
 

The Real Jdbye

*is birb*
OP
Member
Joined
Mar 17, 2010
Messages
23,207
Trophies
4
Location
Space
XP
13,733
Country
Norway
This is great, @The Real Jdbye :)

Is it possible to include dsiware and be able to separate titles that are dual retail/download? Those titles are already taken care of by the scene (at least in EU/US).
DSiWare isn't included on the Nintendo servers I'm grabbing info from. Wii U is included though, and now that a title key website for Wii U exists I will probably add support for that as well.
Sure, separating retail/download and download only is a simple matter.
 

FF777

人を呪わば穴二つ
Member
Joined
Nov 22, 2006
Messages
145
Trophies
0
XP
548
Country
United States
I have some questions:

1: What is the difference between titlekey and ticket?.. Do you need both to download from eshop? or just a ticket?

2: If some one hypothetically had a .cia file of a title that is on the "missing" list, could they extract the titlekey or ticket from it? Or do .cias not contain that information?..

3: If some one purchased a title from the eshop, what steps would they hypothetically need to take to have it added to the titlekeys list website?..

Also, you might consider adding text to your site that says "Last Updated Date:" so that people know your site is showing recent stats and didn't blow up..
 

The Real Jdbye

*is birb*
OP
Member
Joined
Mar 17, 2010
Messages
23,207
Trophies
4
Location
Space
XP
13,733
Country
Norway
I have some questions:

1: What is the difference between titlekey and ticket?.. Do you need both to download from eshop? or just a ticket?

2: If some one hypothetically had a .cia file of a title that is on the "missing" list, could they extract the titlekey or ticket from it? Or do .cias not contain that information?..

3: If some one purchased a title from the eshop, what steps would they hypothetically need to take to have it added to the titlekeys list website?..

Also, you might consider adding text to your site that says "Last Updated Date:" so that people know your site is showing recent stats and didn't blow up..
1. Tickets are generated from title keys.

2. If the CIA was made with a proper tool (for example FunkyCIA and its derivatives/alternatives) then it will contain the title key. No guarantees with other tools.

3. Dump your decTitleKeys.bin with Decrypt9 and upload it to the title key DB.

I'll definitely look into adding that :)
 

FF777

人を呪わば穴二つ
Member
Joined
Nov 22, 2006
Messages
145
Trophies
0
XP
548
Country
United States
Thanks for your help.. I have a couple more questions too if you happen to know the answers..

1: You said in an other thread that titlekeys can be verified IF they are decrypted, which is probably why titlekeys site only lets you upload decrypted.. Which tool(s) do you use to verify with? decrypt9 some how? I'd like to weed out any invalid titles on my 3DS if possible..

2: Does encTitleKeys.bin contain titlekeys AND tickets? Or is the ticket(s) generated only after you install the titlekey(s) on to your 3DS?.. (The ticket has to be unique to your console doesn't it? Or else eshop won't let you download it?)
 
D

Deleted User

Guest
This is pretty sweet, is there anyway we could get the titlekeys and lessen the number of missing titles?
 

FF777

人を呪わば穴二つ
Member
Joined
Nov 22, 2006
Messages
145
Trophies
0
XP
548
Country
United States
This is pretty sweet, is there anyway we could get the titlekeys and lessen the number of missing titles?
As far as I know (which isn't a lot), most .cia files don't have a valid titlekey, especially from that iso site.. Recently "FunkyCIA" was created, which can supposedly create legit/good .cias I think (which means that the titlekey inside of the .cia should be valid and be able to be added to the titlekey database).. But most .cias haven't been created with it so far..
This is why I want to be able to verify my installed titlekeys some how, so that I can see if I have any games from the "missing" list on the titlekey database..

People can still install illegit/bad .cias, but that means they won't work with the eshop (like, maybe updates won't work? And you can't redownload it from eshop if you delete the title)..
Also, I hacked some girl's 3DS for her and installed freeshop on her 3DS, but installing .cias is too complicated for her, so if a game she wants isn't on the freeshop, I have to borrow her 3DS and install it manually for her.. If a titlekey is on the "missing" list, it won't be in freeshop..

I am disappointed at the low percentage that the titlekeys database is at (especially the japanese games).. When spring/summer come, I want to try to spend loads of money to purchase some eshop games (especially japanese ones).. (I don't make income during the winter..)
My friend plays english games on her 3DS, but I play the japanese ones, and always aggravates me in freeshop when I see a game available for USA but the jap version is missing, especially when it is a game that was made in japan.. If no one else in the world is going to purchase some of these eshop games, then I will..
 

Site & Scene News

Popular threads in this forum

General chit-chat
Help Users
  • No one is chatting at the moment.
    LeoTCK @ LeoTCK: yes for nearly a month i was officially a wanted fugitive, until yesterday when it ended