Catching up with this (although a bit OT). Well done for completing the 117km ride.
May I suggest you consider joining in on one of the
Cycle Chat monthly challenges. Warm up on one for the next 2 months and then start one in earnest in January, and persist through the year. Various distances available: 50km, 50 miles, 100km, 100 miles, plus lunacy options. Making the effort for those will get you out there, and when March comes round you'll find riding 100km+ a piece of (dairy free) cake.
I suggest you consider drinking less immediately before and during your ride (briefly discussed on another thread). Provided you need to stop for such with 'normal' regularity (ie same as at home/uni) you will be sufficiently hydrated. Over drinking is to be avoided (and in extremis fatal). The sports drinks manufacturers have pushed the 'hydrate or die' mantra for commercial purposes. Just drink steadily (max 200ml at a time, ideally) and to thirst.