If everything was as easy as searching the internet. I searched for an old first person fantasy shooter whose name I couldn't remember. So I typed into the oracle: shooter fantasy wizard. Et voilà the game is called The Catacomb Abyss.

Really astonishing what google can do with so little information.