It's kind of like Steam for mods. So it'll start downloading, and if the download fails it should be able to tell and resume from wherever you were when it failed. It's part of the same company that runs ModDB, so it's all integrated.
http://www.desura.com/mods/thrawns-revenge