So I consumed 16 bottles of skooma all at once. It was cool, I could run really fast and carry loads of stuff.
But after the effects of the drug had subsided, I no longer had any magicka. It's because my intelligence is at 0. And with no previous save to revert to, I am stuck.
Sorry, it's kinda funny that you would go do something extreme, with no save. You need to get restore Intelligence potions. Either make your own, or purchase at alchemy shops. There is an alchemy shop in every town, (2 in the Imperial City) as well as an alchemical counter in every mages' guild hall. Save more often. I have about ten hard saves, not including the autosave. I save before I go into a hole in the ground, do something important, start a new quest, go on a wild killing spree, etc. Make a new save, delete the oldest. It only takes about 15 seconds to make a new save... IIRC, each potion should cost about 250 gold, making your own will be cheaper.
Edit: ninja'd.