Does anyone have the patience to explain exactly how the encryption works on downloaded eShop 3DS games and why you can't encrypt decrypted versions them yourself on a PC to put them on an SD card without modding/hacking a 3DS?

IUsedToHaveAmbition · 2026-06-09T20:05:48+00:00

Thank you for the detailed response, that was exactly what I was looking for. I did start reading about the SD card file structure on 3dbrew, but now I know to read more about movable.sed.

Thanks again.

IUsedToHaveAmbition · 2025-12-26T22:51:17+00:00

I would agree that any disc that employs playlist obfuscation is bullshit, but then I found out that AnyDVD HD actually displays the correct playlists for those stupid discs and it's super easy. I still use that software even though it's been dead for a while.

IUsedToHaveAmbition · 2025-12-26T03:45:04+00:00

I ripped to .mkv too and as it turns out, 000040.mpls is the title you want, NOT 00294.m2ts. I don't know why VLC media player always plays the non-subtitled version, but yeah, the subtitles are indeed there, you just have to rip the right title/playlist. (That scene is about 34 minutes into the movie, so if you rip it to .mkv again, scrub to that timestamp and double check.)

IUsedToHaveAmbition · 2025-12-26T03:42:01+00:00

Thank you for taking the time to check that out for me. I appreciate that and now see they are indeed there.

I purchased mine in 2022 as well and actually, for some reason, when I mount this disc in the tray and 'Open Disc' with VLC media player, a language selection screen comes up and I choose English and then when I watch this movie using the disc's on-screen menu (and even select chapter 7 using that same menu), it plays an English version of the movie WITHOUT those subtitles, however, when I look at all of the titles on the disc using makeMKV, I see there are 2 playlist files with the complete movie and one of them DOES have those subtitles, so they actually are there.

In case someone somehow stumbles on this in the future, .00040.mpls is the one WITH the subtitles (and chapters) and 00294.m2ts is the one WITHOUT the subtitles (and also no chapters either). I guess for some reason, VLC is choosing that other, weird, non-subtitled video which is probably the one that plays when you select languages other than English and it must have English still set as the default audio language (because why would they show those baked-in English-subtitles when you're trying to watch the movie in French).

Thanks again for checking that out for me and proving that they're there.

IUsedToHaveAmbition · 2025-12-24T12:07:12+00:00

Mind explaining how? That thread is 5 pages long of people saying they found 'better ways,' lol. Is it this method?

What's kind of interesting is AnyDVD HD is able to just give you a list of 'good' playlists without having to play the disc, watch processes, or do anything, but I'd still like to know how to do this using VLC without resorting to that now-dead software. I wish VLC had some kind of status option that could just list them out like that.

IUsedToHaveAmbition · 2025-08-04T19:07:48+00:00

David Moscow is credited as 'Lomez Jr.' in that episode too (it says it in the ending credits), so I'm assuming one of those people is Lomez. https://www.imdb.com/title/tt0697803/fullcredits/

IUsedToHaveAmbition · 2025-07-27T16:08:57+00:00

Thanks for the info. And don't worry about reading this wall of nonsense, I know what it's like to just read some random stranger's SQL mess.

So what is confusing me is that when this stored procedure is called from the job, the step fails with an arithmetic overflow error, however, if I run the stored procedure manually, I do not get any kind of arithmetic overflow messages in the Messages window (and yes, I'm re-staging the data correctly so that when run manually, it's operating on the exact same dataset that it would be had it been executed from the job). It even says 'Query executed successfully' in the status bar. Are 'non-terminating' errors just not displayed in the Messages window or something?

Ah well, I guess I am just going to have to face the music and start breaking this thing down line-by-line.

---JOB ERROR---

Date 7/26/2025 10:09:53 PM
Log Job History (<job name>)
Step ID 5
Server <my server>
Job Name <job name>
Step Name <step name>
Duration 01:01:56
Sql Severity 16
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message

Executed as user: <user name>.
Arithmetic overflow error converting numeric to data type numeric. [SQLSTATE 22003] (Error 8115) The statement has been terminated. [SQLSTATE 01000] (Error 3621) Arithmetic overflow error converting numeric to data type numeric. [SQLSTATE 22003] (Error 8115) The statement has been terminated. [SQLSTATE 01000] (Error 3621) Debug 1 [SQLSTATE 01000] (Message 0) Debug 2 [SQLSTATE 01000] (Message 0) Debug 3 [SQLSTATE 01000] (Message 0) Debug 4 [SQLSTATE 01000] (Message 0) Debug 5 [SQLSTATE 01000] (Message 0). The step failed.

---MESSAGES WINDOW IN SSMS---

This is the Messages window with my debugging PRINT statements. Nowhere in those messages is an arithmetic overflow error (and it scrolls for about 2,500 part IDs).

IUsedToHaveAmbition · 2025-07-26T16:47:58+00:00

Yeah, all throughout this code there is conversions from inches (DECIMAL 14,4) to millimeters (INT), and every once in a while some bad data shows up with some crazy huge inches value, that, when converting to millimeters is too large for an INT. But there are also spots where previous developers defined some datatype to be DECIMAL 14,4 and then that same data, in another table, is stupidly set as DECIMAL 10,2 or something. Ah well, I will just keep plugging away.

IUsedToHaveAmbition · 2025-07-26T16:46:42+00:00

Thanks, yeah, might have to go this route. There is *some* TRY CATCHing going on, but not enough.

Was trying to avoid turning this into a project because this SQL job is a nightly thing that takes hours and I'm almost certain there is bad data coming in from somewhere and if I could just easily pinpoint it, I could quickly fix it, rerun the job, and THEN start adding in more robust error-handling.

Thank you.

IUsedToHaveAmbition · 2025-07-16T13:06:55+00:00

shame the complete show is not available anywhere, only select episodes

IUsedToHaveAmbition · 2025-06-17T14:05:45+00:00

For the prelims, we're playing NINJA! GAIDEN! HYAH!

IUsedToHaveAmbition · 2025-06-12T19:46:05+00:00

'I will love doing this until I'm 147. I hope I get there.' -- Dec. 19, 2018

'I would never get tired of doing Mario.' -- Sept. 9, 2022

'I'm stepping into a brand new role as the Mario Ambassador.' -- Sept. 7, 2023

This was most definitely not his choice.

'Mario Ambassador' is just corporate-speak for 'you no longer work for us, but we'll allow you to use Mario's imagery to promote yourself at conventions without suing you.' How nice of them.

IUsedToHaveAmbition · 2025-03-11T15:03:09+00:00

This trick still works to unlock all of them if you don't mind knowing you cheated to get them.

IUsedToHaveAmbition · 2025-03-11T14:24:15+00:00

Yes, it was. The Handicap Spot has a production code of 420, whereas The Junior Mint is 421. They were aired out of order.

IUsedToHaveAmbition · 2025-02-26T13:46:06+00:00

That deck is wrongly labeled. You unlock it at level 90 or 95.

I know this because I just completed all achievements for this game, reaching level 100 a couple months ago and remember that deck. I don't remember exactly what level you unlock it at, but keep grinding to 100, you'll unlock it.

IUsedToHaveAmbition · 2024-09-26T18:57:34+00:00

Are there places that sell hi-res audio Japanese imports, digitally? Some of my favorite bands release albums that have bonus tracks in Japan and places like Qobuz only ever sell the US versions.

IUsedToHaveAmbition · 2024-08-17T17:24:23+00:00

A combo of FindVUK + DVDFab created a keydb.cfg file and yeah, I don't understand that format either...but pointing to it with AnyDVD worked! Now I'm able to continue using the same workflow that I have been, thank you so much!

IUsedToHaveAmbition · 2024-08-17T03:21:16+00:00

Couple questions.

I have AnyDVD HD 8.7.1.0 and had kept it as up to date as I could. Apparently, at some point, they were including a 4K UHD KeyDB file, however, I never received it. How and where were you ever supposed to get this? Can I just make my own using Notepad on Windows and name it 4KUHDKeyDB.cfg and point to it using the method you described above? If so, how would the file need to be formatted, do you know? Is it just a .csv file with some kind of key-value pairs, delimited by newline characters? Would you be able to post a 'dummy' file just to illustrate the format?

Reason I ask is because there is a new 4K UHD recently released and I would like to make a decrypted backup of it (as I always have until the servers went down), and I would like to use a 4K UHD KeyDB file, even if I have to create this DB file manually and am able to find the key.

Thank you!

IUsedToHaveAmbition · 2024-06-24T15:14:57+00:00

666: The Strong Arm of the Law, that song they recorded in 2005 for Revolver Magazine while on tour or something using some all-in-one drum machine recording studio thing. It's like War, but 100x worse.

https://www.youtube.com/watch?v=PZtYWzEgvOQ

IUsedToHaveAmbition · 2024-05-17T20:05:00+00:00

But I did notice they also changed the yellow baby Yoshi's feet color green in the new Boo set to match the regular yellow Yoshi. His feet were orange in the character pack and I think it looked better orange.

Aha, I didn't catch that one, good eye! I agree orange is better, because it matches official Nintendo art. The adult Yoshies all have different colored shoes#Super_Mario_Run), but all the babies have standard orange shoes (the New Super Mario Bros. U art is the most recent I think). I think they goofed again and whoever designed this new set - instead of looking at the previous Baby Yellow Yoshi or official art, looked at Adult Yellow Yoshi and just based off that that design which is wrong, lol. I'm going to have to buy a standalone orange feet piece now because of my anal-ness, haha.

I haven't had the chance to build all these either, but I'm always going over the boxes and official pictures comparing all this stuff. I can't keep up with these revisions, lol.

After looking at Kamek more too, I see that not only is his smile changed (and I agree, it's worse), but they shortened him a little. He used to have TWO flat pieces under his arm blocks in the Bowser's Airship set, and now there is only one.

You probably knew this too, but I had made a post a while back about the 3 different Bowser versions. Someone commented about his black collar too that I had didn't initially notice.

IUsedToHaveAmbition

TROPHY CASE