ok so im going to go and order a new sunroof drain from the stealership tomrrow. im tired of trying to seal it and it just keep leaking and my floor is soaked so im gonna break down and spend $14 on a new drain hose. is looks easy to swap out anything i should be aware of? is gonna be easy? (it looks easy)

which sunfoof drain....front or back

The drains don't usually have sealing issues. They usually get something in them and clog. Many have used a compressor and blown then out with air or tried to snake something down them to clear the clogs.

front passenger side.

and their is a hole in the hose right above the dash. ive seen the water drip out he hole when u pour water down drain. so i know its leaking their for sure. im not sure how the hole got their but im guessing i bought the car that way cuz i havent messed around with it at all.

well then looks like a new drain might be in your future....