Get another pipe.
Super Glue contains a Cyanide compound... NEVER use it on your pieces, especially in an area that gets hot and causes it to off-gas fumes. MMMM cyanoacrylate ftw! My fave!
:dead:

Also scraping resin is giving you... well, a lot of nasty tar and unburned plant material for the tiny amount of psychoactives you get. It's really bad for you, like all the nasty shit in bong water concentrated to smokeable form, with greasy shit stuck tot eh sides of the bong added for good measure.