Editing Ticket.db

Discussion in '3DS - Flashcards & Custom Firmwares' started by Xenosaiga, Feb 12, 2016.

Thread Status:
Not open for further replies.
  1. Xenosaiga
    OP

    Xenosaiga That one guy that doesn't give a shit anymore

    Member
    1,478
    838
    Oct 9, 2015
    United States
    The Shadows
    I'm just curious if anybody has found out any way to edit the ticket.db?

    I know that it can be done, I'm just not sure how. If anybody has any idea I would like to know. Thanks for any ideas!
     


  2. Syphurith

    Syphurith Beginner

    Member
    641
    222
    Mar 8, 2013
    Switzerland
    Xi'an, Shaanxi Province
    This is now an obstacle for some devs. Unfortunately there isn't any present.
    The DB files, including title.db, and others, aren't that clear in their structure.
    If you have patience you may open up a thread/conversation to experiment.. to contribute to reveal that.
    Good luck if you want so, and you may contact @d0k3 for tips.
    Dump. Check CIA ticket. Install. Dump. Revert Old. Check CIA. Install another. Dump. Compare.
     
  3. ayanekochan

    ayanekochan GBAtemp Regular

    Member
    197
    18
    Aug 6, 2015
    United States
    Can tickets be deleted for certain cia games? Or is it even more complicated than that?
     
  4. Xenosaiga
    OP

    Xenosaiga That one guy that doesn't give a shit anymore

    Member
    1,478
    838
    Oct 9, 2015
    United States
    The Shadows
    That's what I was asking about
     
  5. ayanekochan

    ayanekochan GBAtemp Regular

    Member
    197
    18
    Aug 6, 2015
    United States
    Did you buy/install legit dlc and now you have to reinstall a cia dlc pack for it every time you access nnid services? Cause that's what happened to me...
     
  6. Xenosaiga
    OP

    Xenosaiga That one guy that doesn't give a shit anymore

    Member
    1,478
    838
    Oct 9, 2015
    United States
    The Shadows
    No. I'm literally just curious about editing the ticket.db and how I could go about doing so.
     
    klear likes this.
  7. d0k3

    d0k3 3DS Homebrew Legend

    Member
    2,600
    2,621
    Dec 3, 2004
    Gambia, The
    No, not yet. I'll give you a starting point and some remarks, though.

    Seconding that :).

    You'd have a lot of work ahead. You need a hardmod, and you need to do a ton of (possibly unsuccessful) experiments. Take a look at this GitHub repo. Also get informed on 3Dbrew.

    titledb-get is 100% not perfect. It is buggy and the code is ugly, but it gives you a good picture of how these databases (title.de, ticket.db) need to be parsed. You'll need to go ahead from there (ie. rewrite the code to actually remove stuff and keep your fingers crossed it works). From 3Dbrew, you'll notice, there are a lot of 'unknown' values, and their description doesn't even encompass the whole file. So, my best bet is, it will most likely never be advisable to edit your databases without a hardmod.

    I hope you prove me wrong, though.
     
  8. Xenosaiga
    OP

    Xenosaiga That one guy that doesn't give a shit anymore

    Member
    1,478
    838
    Oct 9, 2015
    United States
    The Shadows
    @d0k3 well I can go ahead and just cut it short by saying I don't have a hard mod... And I'm gonna leave the experimenting to someone that has coding know how.
     
  9. d0k3

    d0k3 3DS Homebrew Legend

    Member
    2,600
    2,621
    Dec 3, 2004
    Gambia, The
    I don't have one either :). Also, this might be futile, but never say never.
     
  10. Xenosaiga
    OP

    Xenosaiga That one guy that doesn't give a shit anymore

    Member
    1,478
    838
    Oct 9, 2015
    United States
    The Shadows
    Well, if you have any ideas I'm willing to at least try



    Edit: Actually I looked at the stuff you linked in you earlier post and I have no idea what the 3Dbrew page is even saying
     
    Last edited by Xenosaiga, Feb 12, 2016
  11. Mrrraou

    Mrrraou GBAtemp Advanced Maniac

    Member
    1,869
    2,167
    Oct 17, 2015
    France
    If you want to delete tickets, just wait for a FBI update. IIRC Steveice10 reverse-engineered and documented am:net functions about tickets.
     
    klear and Xenosaiga like this.
  12. Xenosaiga
    OP

    Xenosaiga That one guy that doesn't give a shit anymore

    Member
    1,478
    838
    Oct 9, 2015
    United States
    The Shadows
    Well that pretty much does 67% of what I was wanting to do.
     
  13. Mrrraou

    Mrrraou GBAtemp Advanced Maniac

    Member
    1,869
    2,167
    Oct 17, 2015
    France
    What are the other 33% ?
     
  14. Xenosaiga
    OP

    Xenosaiga That one guy that doesn't give a shit anymore

    Member
    1,478
    838
    Oct 9, 2015
    United States
    The Shadows
    Adding titles without having to install to 3ds?
     
    Xenon Hacks likes this.
  15. d0k3

    d0k3 3DS Homebrew Legend

    Member
    2,600
    2,621
    Dec 3, 2004
    Gambia, The
    I'll think about it for a bit, alright? Not sure if I can come up with soemthing, though.
     
    klear and Xenosaiga like this.
  16. VeryCrushed

    VeryCrushed Devious Prorammer

    Member
    451
    402
    Dec 26, 2014
    United States
    The Programmers Den
    I think I'll take a look into it as well, have been meaning to look into it for a while now just haven't gotten to it.
     
    Xenosaiga likes this.
  17. Mrrraou

    Mrrraou GBAtemp Advanced Maniac

    Member
    1,869
    2,167
    Oct 17, 2015
    France
    So, you mean installing tickets ? I think that there are methods for that in am:net too.
     
    Xenosaiga likes this.
  18. Xenosaiga
    OP

    Xenosaiga That one guy that doesn't give a shit anymore

    Member
    1,478
    838
    Oct 9, 2015
    United States
    The Shadows
    This could be a major breakthrough in making a "Universal Ticket" that would go perfectly with GroovyCIA by @Ptrk25.

    A ticket that has all titles!
     
  19. MelonGx

    MelonGx GBAtemp Advanced Maniac

    Member
    1,634
    439
    Jan 8, 2009
    China
    Bump this thread.

    I just found that, if you had ever installed a CIA, even you uninstalled it / formatted NAND, the fake ticket still remained in your ticket.db.
    If you made your EmuNAND in this condition, you can still re-create a brand new emuNAND from SysNAND to vanish all fake tickets.
    If you made your SysNAND in this condition and no backup, those fake tickets would never disappear unless you System Transfer them to another console's emuNAND.
    If you could not do that (e.g. your NAND with many Mii Plaza achievements infected a fake ticket by System Transfer to a target which has fake ticket), you have to wait for someone develop a ticket.db editor.
     
    Last edited by MelonGx, Mar 3, 2016
    thaikhoa likes this.
  20. Suiginou

    Suiginou (null)

    Member
    565
    588
    Jun 26, 2012
    Gambia, The
    pc + 8
    A ticket can only contain data for one title. Also, there's still no way to get titlekeys for arbitrary titles.

    Or you'll have to wait at least until someone makes use of the DeleteTicket am command.
     
Thread Status:
Not open for further replies.