zNSFW

Anyone know what type of pipe this is called or where I could get one? It's kind of important as it's my best friends and I broke it!