so I have a bit of a problem, I managed to piss off both the guild of light and the guild of dark in MM8, is there any way to fix this so I can do the main quest? the map already reset and it didn't help.

If you mean the leaders will not co-operate, then I don't know--- or how you managed it.
If you mean the guards, then try to kill the one's who get in the way completing the task.

the throne rooms for both are locked, even after the map resetting

What did Dyson Leland say when you picked him up

Make sure you have him in your party when you try to turn in the quest. If you've angered the guards, then try murdering all of them in the entire building and then try again.