What would you use to re-do this?

[WaterTight]

And what would you say that bit of soil pipe is made of just before the tiled wall? It looks more like lead than iron to me. I did recently have some lead someone had made up as a sort of adaptor between some cast iron soil and the pan connector he used. It was a nightmare to work with. And that one looks like it wouldn't take much disturbing to get it leaking. Obviously it needs supporting underneath better too. If your honest answer is you'd not fancy it because it looks like a pig, let me know!
Thanks

 

[ShaunCorbs]

Dc1
Street 45 x 2
Socket socket 45 just encase
110mm clips
Con 8 e

 

[Harvest Fields]

It would be better if there is space to move the toilet to the wall on the right? Could get rid of a lot of that pipework then. Is this an option?

Just an idea?

 

[turnpin]

Place a magnet on the part protruding part through the tile if it sticks it will be cast iron and ok to adapt or it maybe lead if you gently scrape with a file it will be soft and shiney More trickey but still doable let us know.....regards Turnpin