i couldnt get the code but I spent hours looking for the ring. its in the fountain near a grating and you have to use it after the purple and before the yellow other wise it wont work

to find the code just write "help sorcerer's red ring" and the code will appear. If the red ring is not functionning use additem to add a second one in your inventory. This one should work.