That happened a lot when I was a wee lad, especially playing Majora's Mask (the game also made me cry for other reasons tho). :P
As I grew up, these things started to happen less frequently. Now it simply doesn't happen anymore. As for my longest gaming session, it was probably when Twilight Princess came out and I started playing it with my cousin. We spent like 12h in a row. Something similar happened when Resident Evil 4 came out.
Bet with Teeqoz for 2 weeks of avatar and sig control that Super Mario Odyssey would ship more than 7m on its first 2 months. The game shipped 9.07m, so I won








