Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
I'm having some trouble with the submission text... I keep getting an error "failed: " Cannot add or update a child row: a foreign key constraint fails (`nesvideos_site/submission`, CONSTRAINT `submission_ibfk_2` FOREIGN KEY (`systemid`) REFERENCES `system` (`id`) ON UPDATE CASCADE) "
SQLERROR"
Can anybody tell me what's wrong? I'm using * to denote bullet points, but nothing else.
Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
The run is now finished... Statistics:
Time: 1:14:26
Frame Count: 267939
Re-records: 19288
I'll be writing up the submission text and submitting it shortly.
Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
The problem is that I would have to go through another start menu to get the heart that way. A start menu switch takes about 2 seconds; I don't think 2 seconds are saved from this trick.
About the suit change enemies: 1. It doesn't take much time to kill them (like 1-1.5 seconds). 2. I would have to switch to feather (2 second menu). And no, I couldn't lump it with the next time I use the feather, since I have to switch to power bracelet anyway. 3. It's faster to do one hookshot all the way across then to jump/hookshot multiple times across.
I hope this makes things a bit more clear...
Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
Can you shoot the fire rod diagonally? I didn't know that. What are the button combinations? I tested, and this was the fastest regular way to kill him; a jump and horizontal flame wouldn't have reached him, and I hit him at the earliest chance with a vertical flame.
Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
Well, then you're going to be surprised :) Through dungeon 7:
http://dehacked.2y.net/microstorage.php/info/1666/Through%207th%20dungeon.vbm
Here's a walkthough for when I knock down the last two pillars:
a) Kill the suit-changing monsters with the ball, throw it up across the pit
b) Go up and around to the long thin passageway, and push blocks the way I did
c) Use the u+d bombarrows (they start about two squares below you and move diagonally up/right) to blast the lower wall, normal bombarrow the upper wall
d) Switch to hookshot, glitch through lower block, hookshot across pit in next room, destroy pillar in next room
e*) Jump and pick up the ball at the same time, throw it across pit, hookshot glitch/jump across pit
f) Go up two rooms, smash second pillar
*This was the part where I had the most trouble. No matter how hard I tried, I couldn't just throw the ball across the pit; it would fall down. So I had to invent a new trick (or maybe it's old, I don't know). I jumped and picked up the ball on the same frame, into the pit, where I was able to throw it over safely. Then, of course, I needed to actually get across the pit, so I used the hookshot trick again. It worked really well, only side effect is the large number of menus I have to go through (like 3 or 4).
Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
That would require a total of three pegasus boots charges. One to go right, one to go diagonally, one to go down. My way, I just go one right and one down, walking diagonally in between.
Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
I found that Mambo-ing back was faster, since I would have to take some wierd detours if I just jumped off the cliffs and ran back. Anyway, here's the run up to dungeon 7:
http://dehacked.2y.net/microstorage.php/info/1653/To%207th%20dungeon.vbm
I'm pretty sure this route is fastest. It's pretty straightforward, so I'll be starting on the actual dungeon shortly.
Spocky: hehe, I timed my start menu switch so that people would notice it more easily :) It's one of those wierd sprite glitches with l+r.
Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
Guess what? 8th dungeon done.
http://dehacked.2y.net/microstorage.php/info/1643/Through%208th%20dungeon.vbm
I now officially HATE the boss of this dungeon. I spent about two hours figuring out how to beat him quickly... In my first version, I was flaming him as fast as possible, but I noticed something was wrong when I had hit him over 30 times and he hadn't slowed down. Watching your movie, Tompa, I though that it was necessary to wait for him to jump out of the lava a second time, but that also failed. Then, I managed to kill him at 50% speed on his first leap out of the lava, but I couldn't replicate it with frame advance until just now (Aargh). It seems that either the boss can be manipulated into being vulnerable (as opposed to just bouncing across the room and me not able to kill him) or that it just requires extreme precision to do it on the first jump.
Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
Redone up to the 8th dungeon:
http://dehacked.2y.net/microstorage.php/info/1638/To%208th%20dungeon.vbm
I saved 300 frames... I find it amazing that so much time can be saved simply by redoing certain parts of the movie. Thanks, Tompa, for all your helpful nudges to redo parts!
I had completed this segment earlier, but then I realized I forgot to get the bird key... Oh, well, I just redid it again.
Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
I would probably need to be above the block to glitch through it that way. I will be doing some testing, though, for other possible hookshot-glitch ways of getting through there.
Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
Well, the glitch only works when there's only one block below you, otherwise the hookshot won't attach and pull you over. There might be some other places, but its use is pretty limited.
Edit: By the way, switching to hookshot for the sign in the maze doesn't waste time. If I jump using the boots, I have to switch from feather to bracelet to lift the rock, then switch back to feather (2 menu's). If I switch to hookshot and bracelet, then switch the hookshot for the boots, then I have the same number of menus (2). No problem there.
Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
Yeah, you press all four directions at once. Only a few keyboards can do that, so I usually just have VBA hold down some keys for me... An alternative is to remap the four directions to the same key. Here's a video:
http://dehacked.2y.net/microstorage.php/info/1636/D8%20glitch.vbm
Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
Alright, I'll redo the sign part... Anyway, I found a big timesaver in dungeon 8! In the room right before the mini-boss, instead of visiting the mini-boss, I just glitched across one of the blocks. I did u+d+l+r+hookshoot, which pulled me across the single block, and let me jump to the other side. This saves a great deal of time, maybe 20-30 seconds? I'll post a video a later.
Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
Up to Turtle Rock:
http://dehacked.2y.net/microstorage.php/info/1633/Testrun3.vbm
Mambo-ing once the 6th dungeon is done allows me to skip another owl speech, in case anybody was wondering. Nothing much to note about this segment, although the hookshot/feather method over pits works well :)
I didn't see Tompa's last edit until I had already reached dungeon 8, but I did notice it in time before I posted this. Taking the shortcut is about 300 frames faster than otherwise.
Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
I tried for about 20 minutes and couldn't collect the key without it bouncing. It might not be possible under the circumstances I had.
Maur, I just thought of something else; if I S&Q after getting the boots, I lose my PoP. This would eliminate the extra walking speed and make my boss battle much slower. So, the extra seconds taken by walking back are worth it in the end.
Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
Fabian, you have created a work of art. That was easily one of the best TAS's I've ever seen.
My favorite levels were Awesome and Donut Plains 2. I think you're at your best when you're on the ground hopping, yet still find ways to glitch a P-switch into the floor and hop on shells the whole way. Obvious yes vote from me.
Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
Let me just make it clear that up to (about) the 4th dungeon, I was still not that great at route planning (even now I still get confused, hehe). If I ever want to make an updated version after I submit this, I'll take into account every mistake people note. So I really do appreciate criticism! I'll try to address a couple of these:
Unless you're referring to a time when I had the feather, I'm pretty sure it was faster to just walk through rather than around.
Hitting the Moldorm with a charge attack was slower because I had to avoid accidentally stabbing him. But I don't remember hitting any boss twice with the same spin attack... I think for the hinox it just looked like I did because I was slashing so fast.
A slower Moblin boss fight means an additional 5-10 (roughly) seconds of waiting. A PoP, besides giving faster walking speed, would save maybe a second on the hinox and 5-6 seconds on the genie. Maybe it is faster... but it would also throw off my PoP for dungeon 3.
More importantly, I think S&Q erases the counts on PoP's and GA's. I say this because I don't remember seeing any of those since dungeon 3, and I really started S&Qing a lot after dungeon 3. So saving the PoP for dungeon 2 would only work if I never S&Qed.
This is like 10-15 seconds out of the way to get. You mention one way to use it, but there aren't really any other good warps that you can't do in a better or more convenient way (that I can think of, at least).
EDIT: Whoops, I forgot that you can just look at the warp to be able to use it. Probably only takes a couple seconds, then.
Yep, should have done both of those.
Requires swimming back and going through a cave. I would estimate at least 15 seconds are spent doing this, not to mention the time you would need to spend getting the warp hole in the first place. I would carefully say that Mambo-ing back and dashing down would be faster.
EDIT: Okay, so using the mambo seems to take more time, according to Tompa. Again, I'll take all this into account if I update this run.
Read the last few pages of the topic... Tompa and I (mostly Tompa :) ) have been figuring out more sequence breaks. You don't actually need the rooster.
I also appreciate your compliments, thanks!
Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
Redone 6th dungeon:
http://dehacked.2y.net/microstorage.php/info/1603/Testrun3.vbm
The changes account for a total of 1317 frames (22 seconds) saved. I hope you still like my battles :) This dungeon was easy to optimize, but it isn't really that interesting... very few parts with action. Oh, and I'm up to 15,000 rerecords.
I was reading you bomb and arrow tracking table, and I noticed that you said I would have some arrows left over after beating the game. I counted, and I couldn't see any arrows left over at the end. Is that comment just something you overlooked last time?
Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
Through the 6th dungeon:
http://dehacked.2y.net/microstorage.php/info/1595/Through%206th%20dungeon.vbm
Notes:
a) I end the dungeon with 25 bombs and 25 arrows.
b) I managed to destroy the boss before he says his opening text, although it was really close (I had to redo the battle several times, and even then I made it only by one or two frames)
c) I make heavy abuse of the bomb glitches, notably with the Dodongos and the face boss :)
Editor, Experienced Forum User, Published Author, Active player
(467)
Joined: 5/23/2006
Posts: 361
Location: Washington, United States
You know, I thought it was pretty crazy that I could use the hookshot from a pit. But clearing every pit with it? This game has too many glitch exploits :)
I also found that u/d/l/r + hookshot will shoot it about two squares below you, and it will slowly move up and back to you. I've used it to glitch through some one-square thick walls that are below me, but I haven't found a really good use for it yet.