I fixed it myself!

I went to Home Depot and got an entirely new pipe thingie and instead of securing it to the wall pipe with duct tape, I used a rubber tube thing with metal rings on either end. I even bought myself a real screwdriver to tighten it with!

Yay me!!!