I had a moderator spaz out and delete one of the most important threads I've ever had on my site.
Is there any way at all to restore it?
Not really. If you or your host has mysql backups, you may be able to find it and restore it. I can help you out with this, if you do have backups.