well here it is... test run says it works, makes the right sound and everything seems to be in working order... now i just need some dank to put in it :]

I used a dremel tool to drill a hole through the glass and made it big enough i could put a straw thru it. then i fitted a metal piece from an air compressor unit into one end of the straw and fed the straw thru the hole into the bottom of the vase. i also applied some plumbers tape around the tip of the straw where it touches the hole in the glass to ensure a good air tight seal.wish me luck guys, lets hope it works. ill post pics from the first smoke with it.