The download link for the main file (the music) isn't working for me either. I am not a new user and I was able to just download while not even logged in for over a year now. Media Fire says that the file doesn't exist.
Maybe I'm misremembering, but I think the address in the link/URL looked different. The posted URLs may have somehow changes. I was able to download the music a just month ago.
To be clear, usually I did get an error about "you don't have access to this file." I would just close, wait a moment, and open the link again and it would work. Now it says they don't exist and nothing I try gets them to show.
I tried the link for your patch too and that link doesn't work not either.
A total shot in the dark here: if its not and Media Fire's end, I think a forum update may have messed up the URLs (because I 'think' I remember the addresses being different). Maybe try to post the URLs as plain text and let us copy-paste?
https://www.mediafire.com/file/70xfl74ry0cyfn4/Sword_of_Geddon_Soundtrack_Mod.rar/file
EDIT: I have always used the Media Fire links directly. Getting the links via the attached files still works. I guess Media Fire did some update to their direct URL links.
EDIT 2: I'm brain dead today. I can download the patches because they're hosted on civfanatics, but the actual mod on Media Fire is gone.