2007 Audi A4 Body & Structure Problems

SO I OPENED UP THE SUNROOF, TOOK A LONG WIRE AND STARTED POKING. I ALSO REMOVED THE WHEEL ARCH AND CLEANED OUT THE OUTLET. I POURED A BUCKET OF WATER THRU AND IT CAME OUT OF THE BOTTOM NICELY. ALL WELL I THOUGHT. TODAY IT RAINED FOR THE FIRST TIME SINCE THEN, AND I WAS VERY UNPLEASANTLY SURPRISED TO FEEL WATERDROPS DRIPPING FROM THE HOOD OPENING GRIP NEXT TO MY FEET. SINCE MY CAR IS ALWAYS OUTSIDE AND NOT COVERED AGAINST THE RAIN, I HAD TO DEAL WITH IT RIGHT AWAY. I STRIPPED THE A PILLAR COVER AND SAW IT HAD SERIOUS WATER MARKS. OBVIOUSLY THE WATER HAD BEEN DRIPPING SLOWLY FOR MANY MONTHS ALREADY. IT JUST NEVER GOT WORSE ENOUGH AS YOU CAN SEE IN THE PICTURE THE GREEN HOSE IS THE DRAIN, AND IT HAS A BROWN STRIPE DOWN THE BOTTOM FROM LONG TIME DRIPPING. THE LEAK SEEMED TO COME FROM ALL THE WAY UP TO WHERE IT IS CONNECTED TO THE SUNROOF DRAIN PIPE. I PULLED IT LOOSE AND THE HOSE IS FITTED TO THE PIPE WITH SOFT PLASTIC CONNECTOR. THE CONNECTOR SLIDES OVER THE PIPE, BUT THE HOSE IS GLUED TO IT. NOW THE GLUE IS EXACTLY WHAT CAUSED THE PROBLEM! THE GLUE HAD GOTTEN BRITTLE AND HAD CRACKED, IT SEEMS LIKE AUDI USED THE WRONG GLUE FOR THIS HOSE. I CLEANED IT , GLUED IT BACK TOGETHER AND POURED ANOTHER BUCKET OF WATER THRU, BUT NOW WHILE THE LINING WAS STILL OPEN AND THE HOSE FULLY EXPOSED. NO DRIP AT ALL! I MUST SAY, THIS PROBLEM WAS A VERY NASTY ONE, IT REALLY BUGGED ME VERY MUCH TO GET WATER IN THE CAR, ESPECIALLY BECAUSE IT CAN DO SO MUCH DAMAGE. ATTACHED IS A PICTURE WHERE YOU SEE THE ROOF AIRBAG WHICH WAS TOTALLY WET ALSO. A PICTURE WHERE YOU SEE THE GREEN HOSE WITH THE DRIP MARKS, AND A PICTURE WHICH SHOWS THE LEFT SIDE OF THE DASHBOARD WITH THE FUSE BOX EXPOSED, IF YOU LOOK CLOSELY, YOU SEE THE STEEL IS RUSTED, SINCE THE SUNROOF WATER DRAINING IS A VERY WIDE SPREAD Q7 PROBLEM I WOULD ADVISE ALL OWNERS TO CHECK THE FUSE BOX.